|
Package px_record_of_employment
This package provides the common business interface for the Canadian Record of Employment API (PX_RECORD_OF_EMPLOYMENT).
|
M_ENTITY_NAME
M_ENTITY_NAME CONSTANT VARCHAR2(20) := 'RECORD_OF_EMPLOYMENT';
Business Entity Name
M_BASE_TABLE_NAME
M_BASE_TABLE_NAME CONSTANT VARCHAR2(7) := 'PXRROEC';
Base table name
record_of_employment_rec
TYPE record_of_employment_rec IS RECORD (
r_pidm pxrroec.pxrroec_pidm%TYPE,
r_seq_no pxrroec.pxrroec_seq_no%TYPE,
r_pict_code pxrroec.pxrroec_pict_code%TYPE,
r_empr_code pxrroec.pxrroec_empr_code%TYPE,
r_empr_fed_ein pxrroec.pxrroec_empr_fed_ein%TYPE,
r_print_ind pxrroec.pxrroec_print_ind%TYPE,
r_reprint_ind pxrroec.pxrroec_reprint_ind%TYPE,
r_serial_no pxrroec.pxrroec_serial_no%TYPE,
r_amends_serial_no pxrroec.pxrroec_amends_serial_no%TYPE,
r_language_ind pxrroec.pxrroec_language_ind%TYPE,
r_issue_date pxrroec.pxrroec_issue_date%TYPE,
r_reference_number pxrroec.pxrroec_reference_number%TYPE,
r_sin pxrroec.pxrroec_sin%TYPE,
r_job_title pxrroec.pxrroec_job_title%TYPE,
r_first_day_worked pxrroec.pxrroec_first_day_worked%TYPE,
r_last_day_worked pxrroec.pxrroec_last_day_worked%TYPE,
r_final_pay_date pxrroec.pxrroec_final_pay_date%TYPE,
r_recall_ind pxrroec.pxrroec_recall_ind%TYPE,
r_recall_date pxrroec.pxrroec_recall_date%TYPE,
r_roec_code pxrroec.pxrroec_roec_code%TYPE,
r_total_hrs pxrroec.pxrroec_total_hrs%TYPE,
r_total_grs pxrroec.pxrroec_total_grs%TYPE,
r_1996_weeks pxrroec.pxrroec_1996_weeks%TYPE,
r_1996_earnings pxrroec.pxrroec_1996_earnings%TYPE,
r_contact_pidm pxrroec.pxrroec_contact_pidm%TYPE,
r_contact_tele_area_code pxrroec.pxrroec_contact_tele_area_code%TYPE,
r_contact_tele_number pxrroec.pxrroec_contact_tele_number%TYPE,
r_contact_tele_ext pxrroec.pxrroec_contact_tele_ext%TYPE,
r_issuing_pidm pxrroec.pxrroec_issuing_pidm%TYPE,
r_issuing_tele_area_code pxrroec.pxrroec_issuing_tele_area_code%TYPE,
r_issuing_tele_number pxrroec.pxrroec_issuing_tele_number%TYPE,
r_issusing_tele_ext pxrroec.pxrroec_issusing_tele_ext%TYPE,
r_earn_code_vac pxrroec.pxrroec_earn_code_vac%TYPE,
r_vac_grs pxrroec.pxrroec_vac_grs%TYPE,
r_stat_hol_earn_code1 pxrroec.pxrroec_stat_hol_earn_code1%TYPE,
r_stat_hol_date1 pxrroec.pxrroec_stat_hol_date1%TYPE,
r_stat_hol_grs1 pxrroec.pxrroec_stat_hol_grs1%TYPE,
r_stat_hol_earn_code2 pxrroec.pxrroec_stat_hol_earn_code2%TYPE,
r_stat_hol_date2 pxrroec.pxrroec_stat_hol_date2%TYPE,
r_stat_hol_grs2 pxrroec.pxrroec_stat_hol_grs2%TYPE,
r_stat_hol_earn_code3 pxrroec.pxrroec_stat_hol_earn_code3%TYPE,
r_stat_hol_date3 pxrroec.pxrroec_stat_hol_date3%TYPE,
r_stat_hol_grs3 pxrroec.pxrroec_stat_hol_grs3%TYPE,
r_other_earn_code1 pxrroec.pxrroec_other_earn_code1%TYPE,
r_other_earn_code1_grs pxrroec.pxrroec_other_earn_code1_grs%TYPE,
r_other_earn_code2 pxrroec.pxrroec_other_earn_code2%TYPE,
r_other_earn_code2_grs pxrroec.pxrroec_other_earn_code2_grs%TYPE,
r_other_earn_code3 pxrroec.pxrroec_other_earn_code3%TYPE,
r_other_earn_code3_grs pxrroec.pxrroec_other_earn_code3_grs%TYPE,
r_benefit_ind pxrroec.pxrroec_benefit_ind%TYPE,
r_benefit_grs pxrroec.pxrroec_benefit_grs%TYPE,
r_benefit_start_date pxrroec.pxrroec_benefit_start_date%TYPE,
r_benefit_day_week_ind pxrroec.pxrroec_benefit_day_week_ind%TYPE,
r_pp1_payno pxrroec.pxrroec_pp1_payno%TYPE,
r_pp1_grs pxrroec.pxrroec_pp1_grs%TYPE,
r_pp2_payno pxrroec.pxrroec_pp2_payno%TYPE,
r_pp2_grs pxrroec.pxrroec_pp2_grs%TYPE,
r_pp3_payno pxrroec.pxrroec_pp3_payno%TYPE,
r_pp3_grs pxrroec.pxrroec_pp3_grs%TYPE,
r_pp4_payno pxrroec.pxrroec_pp4_payno%TYPE,
r_pp4_grs pxrroec.pxrroec_pp4_grs%TYPE,
r_pp5_payno pxrroec.pxrroec_pp5_payno%TYPE,
r_pp5_grs pxrroec.pxrroec_pp5_grs%TYPE,
r_pp6_payno pxrroec.pxrroec_pp6_payno%TYPE,
r_pp6_grs pxrroec.pxrroec_pp6_grs%TYPE,
r_pp7_payno pxrroec.pxrroec_pp7_payno%TYPE,
r_pp7_grs pxrroec.pxrroec_pp7_grs%TYPE,
r_pp8_payno pxrroec.pxrroec_pp8_payno%TYPE,
r_pp8_grs pxrroec.pxrroec_pp8_grs%TYPE,
r_pp9_payno pxrroec.pxrroec_pp9_payno%TYPE,
r_pp9_grs pxrroec.pxrroec_pp9_grs%TYPE,
r_pp10_payno pxrroec.pxrroec_pp10_payno%TYPE,
r_pp10_grs pxrroec.pxrroec_pp10_grs%TYPE,
r_pp11_payno pxrroec.pxrroec_pp11_payno%TYPE,
r_pp11_grs pxrroec.pxrroec_pp11_grs%TYPE,
r_pp12_payno pxrroec.pxrroec_pp12_payno%TYPE,
r_pp12_grs pxrroec.pxrroec_pp12_grs%TYPE,
r_pp13_payno pxrroec.pxrroec_pp13_payno%TYPE,
r_pp13_grs pxrroec.pxrroec_pp13_grs%TYPE,
r_pp14_payno pxrroec.pxrroec_pp14_payno%TYPE,
r_pp14_grs pxrroec.pxrroec_pp14_grs%TYPE,
r_pp15_payno pxrroec.pxrroec_pp15_payno%TYPE,
r_pp15_grs pxrroec.pxrroec_pp15_grs%TYPE,
r_pp16_payno pxrroec.pxrroec_pp16_payno%TYPE,
r_pp16_grs pxrroec.pxrroec_pp16_grs%TYPE,
r_pp17_payno pxrroec.pxrroec_pp17_payno%TYPE,
r_pp17_grs pxrroec.pxrroec_pp17_grs%TYPE,
r_pp18_payno pxrroec.pxrroec_pp18_payno%TYPE,
r_pp18_grs pxrroec.pxrroec_pp18_grs%TYPE,
r_pp19_payno pxrroec.pxrroec_pp19_payno%TYPE,
r_pp19_grs pxrroec.pxrroec_pp19_grs%TYPE,
r_pp20_payno pxrroec.pxrroec_pp20_payno%TYPE,
r_pp20_grs pxrroec.pxrroec_pp20_grs%TYPE,
r_pp21_payno pxrroec.pxrroec_pp21_payno%TYPE,
r_pp21_grs pxrroec.pxrroec_pp21_grs%TYPE,
r_pp22_payno pxrroec.pxrroec_pp22_payno%TYPE,
r_pp22_grs pxrroec.pxrroec_pp22_grs%TYPE,
r_pp23_payno pxrroec.pxrroec_pp23_payno%TYPE,
r_pp23_grs pxrroec.pxrroec_pp23_grs%TYPE,
r_pp24_payno pxrroec.pxrroec_pp24_payno%TYPE,
r_pp24_grs pxrroec.pxrroec_pp24_grs%TYPE,
r_pp25_payno pxrroec.pxrroec_pp25_payno%TYPE,
r_pp25_grs pxrroec.pxrroec_pp25_grs%TYPE,
r_pp26_payno pxrroec.pxrroec_pp26_payno%TYPE,
r_pp26_grs pxrroec.pxrroec_pp26_grs%TYPE,
r_pp27_payno pxrroec.pxrroec_pp27_payno%TYPE,
r_pp27_grs pxrroec.pxrroec_pp27_grs%TYPE,
r_comment_line1 pxrroec.pxrroec_comment_line1%TYPE,
r_comment_line2 pxrroec.pxrroec_comment_line2%TYPE,
r_comment_line3 pxrroec.pxrroec_comment_line3%TYPE,
r_comment_line4 pxrroec.pxrroec_comment_line4%TYPE,
r_comment_line5 pxrroec.pxrroec_comment_line5%TYPE,
r_comment_line6 pxrroec.pxrroec_comment_line6%TYPE,
r_user_id pxrroec.pxrroec_user_id%TYPE,
r_money_type1 pxrroec.pxrroec_money_type1%TYPE,
r_money_type2 pxrroec.pxrroec_money_type2%TYPE,
r_money_type3 pxrroec.pxrroec_money_type3%TYPE,
r_pp28_payno pxrroec.pxrroec_pp28_payno%TYPE,
r_pp28_grs pxrroec.pxrroec_pp28_grs%TYPE,
r_pp29_payno pxrroec.pxrroec_pp29_payno%TYPE,
r_pp29_grs pxrroec.pxrroec_pp29_grs%TYPE,
r_pp30_payno pxrroec.pxrroec_pp30_payno%TYPE,
r_pp30_grs pxrroec.pxrroec_pp30_grs%TYPE,
r_pp31_payno pxrroec.pxrroec_pp31_payno%TYPE,
r_pp31_grs pxrroec.pxrroec_pp31_grs%TYPE,
r_pp32_payno pxrroec.pxrroec_pp32_payno%TYPE,
r_pp32_grs pxrroec.pxrroec_pp32_grs%TYPE,
r_pp33_payno pxrroec.pxrroec_pp33_payno%TYPE,
r_pp33_grs pxrroec.pxrroec_pp33_grs%TYPE,
r_pp34_payno pxrroec.pxrroec_pp34_payno%TYPE,
r_pp34_grs pxrroec.pxrroec_pp34_grs%TYPE,
r_pp35_payno pxrroec.pxrroec_pp35_payno%TYPE,
r_pp35_grs pxrroec.pxrroec_pp35_grs%TYPE,
r_pp36_payno pxrroec.pxrroec_pp36_payno%TYPE,
r_pp36_grs pxrroec.pxrroec_pp36_grs%TYPE,
r_pp37_payno pxrroec.pxrroec_pp37_payno%TYPE,
r_pp37_grs pxrroec.pxrroec_pp37_grs%TYPE,
r_pp38_payno pxrroec.pxrroec_pp38_payno%TYPE,
r_pp38_grs pxrroec.pxrroec_pp38_grs%TYPE,
r_pp39_payno pxrroec.pxrroec_pp39_payno%TYPE,
r_pp39_grs pxrroec.pxrroec_pp39_grs%TYPE,
r_pp40_payno pxrroec.pxrroec_pp40_payno%TYPE,
r_pp40_grs pxrroec.pxrroec_pp40_grs%TYPE,
r_pp41_payno pxrroec.pxrroec_pp41_payno%TYPE,
r_pp41_grs pxrroec.pxrroec_pp41_grs%TYPE,
r_pp42_payno pxrroec.pxrroec_pp42_payno%TYPE,
r_pp42_grs pxrroec.pxrroec_pp42_grs%TYPE,
r_pp43_payno pxrroec.pxrroec_pp43_payno%TYPE,
r_pp43_grs pxrroec.pxrroec_pp43_grs%TYPE,
r_pp44_payno pxrroec.pxrroec_pp44_payno%TYPE,
r_pp44_grs pxrroec.pxrroec_pp44_grs%TYPE,
r_pp45_payno pxrroec.pxrroec_pp45_payno%TYPE,
r_pp45_grs pxrroec.pxrroec_pp45_grs%TYPE,
r_pp46_payno pxrroec.pxrroec_pp46_payno%TYPE,
r_pp46_grs pxrroec.pxrroec_pp46_grs%TYPE,
r_pp47_payno pxrroec.pxrroec_pp47_payno%TYPE,
r_pp47_grs pxrroec.pxrroec_pp47_grs%TYPE,
r_pp48_payno pxrroec.pxrroec_pp48_payno%TYPE,
r_pp48_grs pxrroec.pxrroec_pp48_grs%TYPE,
r_pp49_payno pxrroec.pxrroec_pp49_payno%TYPE,
r_pp49_grs pxrroec.pxrroec_pp49_grs%TYPE,
r_pp50_payno pxrroec.pxrroec_pp50_payno%TYPE,
r_pp50_grs pxrroec.pxrroec_pp50_grs%TYPE,
r_pp51_payno pxrroec.pxrroec_pp51_payno%TYPE,
r_pp51_grs pxrroec.pxrroec_pp51_grs%TYPE,
r_pp52_payno pxrroec.pxrroec_pp52_payno%TYPE,
r_pp52_grs pxrroec.pxrroec_pp52_grs%TYPE,
r_pp53_payno pxrroec.pxrroec_pp53_payno%TYPE,
r_pp53_grs pxrroec.pxrroec_pp53_grs%TYPE,
r_data_origin pxrroec.pxrroec_data_origin%TYPE,
r_pp1_hrs pxrroec.pxrroec_pp1_hrs%TYPE,
r_pp2_hrs pxrroec.pxrroec_pp2_hrs%TYPE,
r_pp3_hrs pxrroec.pxrroec_pp3_hrs%TYPE,
r_pp4_hrs pxrroec.pxrroec_pp4_hrs%TYPE,
r_pp5_hrs pxrroec.pxrroec_pp5_hrs%TYPE,
r_pp6_hrs pxrroec.pxrroec_pp6_hrs%TYPE,
r_pp7_hrs pxrroec.pxrroec_pp7_hrs%TYPE,
r_pp8_hrs pxrroec.pxrroec_pp8_hrs%TYPE,
r_pp9_hrs pxrroec.pxrroec_pp9_hrs%TYPE,
r_pp10_hrs pxrroec.pxrroec_pp10_hrs%TYPE,
r_pp11_hrs pxrroec.pxrroec_pp11_hrs%TYPE,
r_pp12_hrs pxrroec.pxrroec_pp12_hrs%TYPE,
r_pp13_hrs pxrroec.pxrroec_pp13_hrs%TYPE,
r_pp14_hrs pxrroec.pxrroec_pp14_hrs%TYPE,
r_pp15_hrs pxrroec.pxrroec_pp15_hrs%TYPE,
r_pp16_hrs pxrroec.pxrroec_pp16_hrs%TYPE,
r_pp17_hrs pxrroec.pxrroec_pp17_hrs%TYPE,
r_pp18_hrs pxrroec.pxrroec_pp18_hrs%TYPE,
r_pp19_hrs pxrroec.pxrroec_pp19_hrs%TYPE,
r_pp20_hrs pxrroec.pxrroec_pp20_hrs%TYPE,
r_pp21_hrs pxrroec.pxrroec_pp21_hrs%TYPE,
r_pp22_hrs pxrroec.pxrroec_pp22_hrs%TYPE,
r_pp23_hrs pxrroec.pxrroec_pp23_hrs%TYPE,
r_pp24_hrs pxrroec.pxrroec_pp24_hrs%TYPE,
r_pp25_hrs pxrroec.pxrroec_pp25_hrs%TYPE,
r_pp26_hrs pxrroec.pxrroec_pp26_hrs%TYPE,
r_pp27_hrs pxrroec.pxrroec_pp27_hrs%TYPE,
r_pp28_hrs pxrroec.pxrroec_pp28_hrs%TYPE,
r_pp29_hrs pxrroec.pxrroec_pp29_hrs%TYPE,
r_pp30_hrs pxrroec.pxrroec_pp30_hrs%TYPE,
r_pp31_hrs pxrroec.pxrroec_pp31_hrs%TYPE,
r_pp32_hrs pxrroec.pxrroec_pp32_hrs%TYPE,
r_pp33_hrs pxrroec.pxrroec_pp33_hrs%TYPE,
r_pp34_hrs pxrroec.pxrroec_pp34_hrs%TYPE,
r_pp35_hrs pxrroec.pxrroec_pp35_hrs%TYPE,
r_pp36_hrs pxrroec.pxrroec_pp36_hrs%TYPE,
r_pp37_hrs pxrroec.pxrroec_pp37_hrs%TYPE,
r_pp38_hrs pxrroec.pxrroec_pp38_hrs%TYPE,
r_pp39_hrs pxrroec.pxrroec_pp39_hrs%TYPE,
r_pp40_hrs pxrroec.pxrroec_pp40_hrs%TYPE,
r_pp41_hrs pxrroec.pxrroec_pp41_hrs%TYPE,
r_pp42_hrs pxrroec.pxrroec_pp42_hrs%TYPE,
r_pp43_hrs pxrroec.pxrroec_pp43_hrs%TYPE,
r_pp44_hrs pxrroec.pxrroec_pp44_hrs%TYPE,
r_pp45_hrs pxrroec.pxrroec_pp45_hrs%TYPE,
r_pp46_hrs pxrroec.pxrroec_pp46_hrs%TYPE,
r_pp47_hrs pxrroec.pxrroec_pp47_hrs%TYPE,
r_pp48_hrs pxrroec.pxrroec_pp48_hrs%TYPE,
r_pp49_hrs pxrroec.pxrroec_pp49_hrs%TYPE,
r_pp50_hrs pxrroec.pxrroec_pp50_hrs%TYPE,
r_pp51_hrs pxrroec.pxrroec_pp51_hrs%TYPE,
r_pp52_hrs pxrroec.pxrroec_pp52_hrs%TYPE,
r_pp53_hrs pxrroec.pxrroec_pp53_hrs%TYPE,
r_bulk_file_name pxrroec.pxrroec_bulk_file_name%TYPE,
r_vac_roev_code pxrroec.pxrroec_vac_roev_code%TYPE,
r_vac_start_date pxrroec.pxrroec_vac_start_date%TYPE,
r_vac_end_date pxrroec.pxrroec_vac_end_date%TYPE,
r_stat_hol_earn_code4 pxrroec.pxrroec_stat_hol_earn_code4%TYPE,
r_stat_hol_date4 pxrroec.pxrroec_stat_hol_date4%TYPE,
r_stat_hol_grs4 pxrroec.pxrroec_stat_hol_grs4%TYPE,
r_stat_hol_earn_code5 pxrroec.pxrroec_stat_hol_earn_code5%TYPE,
r_stat_hol_date5 pxrroec.pxrroec_stat_hol_date5%TYPE,
r_stat_hol_grs5 pxrroec.pxrroec_stat_hol_grs5%TYPE,
r_other_start_date1 pxrroec.pxrroec_other_start_date1%TYPE,
r_other_end_date1 pxrroec.pxrroec_other_end_date1%TYPE,
r_other_start_date2 pxrroec.pxrroec_other_start_date2%TYPE,
r_other_end_date2 pxrroec.pxrroec_other_end_date2%TYPE,
r_other_start_date3 pxrroec.pxrroec_other_start_date3%TYPE,
r_other_end_date3 pxrroec.pxrroec_other_end_date3%TYPE,
r_benefit_roes_code pxrroec.pxrroec_benefit_roes_code%TYPE,
r_benefit_end_date pxrroec.pxrroec_benefit_end_date%TYPE,
r_benefit_roes_code2 pxrroec.pxrroec_benefit_roes_code2%TYPE,
r_benefit_grs2 pxrroec.pxrroec_benefit_grs2%TYPE,
r_benefit_start_date2 pxrroec.pxrroec_benefit_start_date2%TYPE,
r_benefit_end_date2 pxrroec.pxrroec_benefit_end_date2%TYPE,
r_benefit_day_week_ind2 pxrroec.pxrroec_benefit_day_week_ind2%TYPE,
r_benefit_roes_code3 pxrroec.pxrroec_benefit_roes_code3%TYPE,
r_benefit_grs3 pxrroec.pxrroec_benefit_grs3%TYPE,
r_benefit_start_date3 pxrroec.pxrroec_benefit_start_date3%TYPE,
r_benefit_end_date3 pxrroec.pxrroec_benefit_end_date3%TYPE,
r_benefit_day_week_ind3 pxrroec.pxrroec_benefit_day_week_ind3%TYPE,
r_benefit_roes_code4 pxrroec.pxrroec_benefit_roes_code4%TYPE,
r_benefit_grs4 pxrroec.pxrroec_benefit_grs4%TYPE,
r_benefit_start_date4 pxrroec.pxrroec_benefit_start_date4%TYPE,
r_benefit_end_date4 pxrroec.pxrroec_benefit_end_date4%TYPE,
r_benefit_day_week_ind4 pxrroec.pxrroec_benefit_day_week_ind4%TYPE,
r_internal_record_id gb_common.internal_record_id_type);
Business Entity record type
record_of_employment_ref
TYPE record_of_employment_ref IS REF CURSOR RETURN record_of_employment_rec;
Entity cursor variable type
record_of_employment_tab
TYPE record_of_employment_tab IS TABLE OF record_of_employment_rec INDEX BY BINARY_INTEGER;
Entity table type
f_api_version
Function f_api_version RETURN PLS_INTEGER
Returns the API version number.
|
|
Version of the API signature. Changes only when the signature changes.
|
f_exists
Function f_exists(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_valid_empr_code
Function f_valid_empr_code(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE)
RETURN VARCHAR2
Checks if a valid employer code record exists.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
f_printed_roe_exists
Function f_printed_roe_exists(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a printed record exists.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_pict_code_exists
Function f_pict_code_exists(p_code ptrpict.ptrpict_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_empr_code_exists
Function f_empr_code_exists(p_code ptrempr.ptrempr_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Employer code. VARCHAR2(4) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_empr_fed_ein_exists
Function f_empr_fed_ein_exists(p_code ptrempr.ptrempr_code%TYPE,
p_empr_fed_ein ptrempr.ptrempr_fed_ein%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Employer code. VARCHAR2(4) Required Key
|
|
|
p_empr_fed_ein
|
Revenue Canada Business Number. VARCHAR2(15) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_roec_code_exists
Function f_roec_code_exists(p_code ptvroer.ptvroer_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Reason for employer issuing this ROE. VARCHAR2(1) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_roev_code_exists
Function f_roev_code_exists(p_code ptvroev.ptvroev_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Vacation for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_roem_code_exists
Function f_roem_code_exists(p_code ptvroem.ptvroem_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Reason for employer issuing this ROEM. VARCHAR2(3) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_roes_code_exists
Function f_roes_code_exists(p_code ptvroes.ptvroes_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Reason for employer issuing this ROEM. VARCHAR2(5) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_roep_code_exists
Function f_roep_code_exists(p_code ptrroep.ptrroep_code%TYPE,
P_type ptrroep.ptrroep_type%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Reason for employer issuing this ROEP. VARCHAR2(1) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_roep_amnt_mandatory
Function f_roep_amnt_mandatory(p_code ptrroep.ptrroep_code%TYPE,
p_type ptrroep.ptrroep_type%TYPE,
p_vac_grs pxrroec.pxrroec_vac_grs%TYPE)
RETURN VARCHAR2
Checks vacation amount mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
p_vac_grs
|
vaction for employer issuing this ROEV. NUMBER Required Key
|
|
|
p_type
|
pay type code, VARCHAR2(1) Required Key.
|
f_roep_amnt_notmandatory
Function f_roep_amnt_notmandatory(p_code ptrroep.ptrroep_code%TYPE,
p_type ptrroep.ptrroep_type%TYPE,
p_vac_grs pxrroec.pxrroec_vac_grs%TYPE)
RETURN VARCHAR2
Checks vacation amount mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
p_vac_grs
|
vaction for employer issuing this ROEV. NUMBER Required Key
|
|
|
p_type
|
pay type code, VARCHAR2(1) Required Key.
|
f_roep_sdate_mandatory
Function f_roep_sdate_mandatory(p_code ptrroep.ptrroep_code%TYPE,
p_type ptrroep.ptrroep_type%TYPE,
p_date pxrroec.pxrroec_vac_start_date%TYPE)
RETURN VARCHAR2
Checks vacation amount mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
p_type
|
pay type code, VARCHAR2(1) Required Key.
|
|
|
p_vac_start_date
|
vaction for employer issuing this ROEV. DATE Required Key
|
f_roep_sdate_notmandatory
Function f_roep_sdate_notmandatory(p_code ptrroep.ptrroep_code%TYPE,
p_type ptrroep.ptrroep_type%TYPE,
p_date pxrroec.pxrroec_vac_start_date%TYPE)
RETURN VARCHAR2
Checks vacation amount mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
p_type
|
pay type code, VARCHAR2(1) Required Key.
|
|
|
pxrroec_vac_start_date
|
vaction for employer issuing this ROEV. DATE Required Key
|
f_roep_edate_mandatory
Function f_roep_edate_mandatory(p_code ptrroep.ptrroep_code%TYPE,
p_type ptrroep.ptrroep_type%TYPE,
p_date pxrroec.pxrroec_vac_start_date%TYPE)
RETURN VARCHAR2
Checks vacation amount mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
p_type
|
pay type code, VARCHAR2(1) Required Key.
|
|
|
p_vac_start_date
|
vaction for employer issuing this ROEV. DATE Required Key
|
f_roep_edate_notmandatory
Function f_roep_edate_notmandatory(p_code ptrroep.ptrroep_code%TYPE,
p_type ptrroep.ptrroep_type%TYPE,
p_date pxrroec.pxrroec_vac_start_date%TYPE)
RETURN VARCHAR2
Checks vacation amount mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
p_type
|
pay type code, VARCHAR2(1) Required Key.
|
|
|
pxrroec_vac_start_date
|
vaction for employer issuing this ROEV. DATE Required Key
|
f_roep_speriod_mandatory
Function f_roep_speriod_mandatory(p_code ptrroep.ptrroep_code%TYPE,
p_period pxrroec.pxrroec_benefit_day_week_ind4%TYPE)
RETURN VARCHAR2
Checks vacation period mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
pxrroec_benefit_day_week_ind4
|
vaction for employer issuing this ROEV. period Required Key
|
f_roep_speriod_notmandatory
Function f_roep_speriod_notmandatory(p_code ptrroep.ptrroep_code%TYPE,
p_period pxrroec.pxrroec_benefit_day_week_ind4%TYPE)
RETURN VARCHAR2
Checks vacation period mandatory or not.
|
|
p_code
|
vaction for employer issuing this ROEV. VARCHAR2(1) Required Key
|
|
|
pxrroec_benefit_day_week_ind4
|
vaction for employer issuing this ROEV. period Required Key
|
f_earn_code_exists
Function f_earn_code_exists(p_code ptrearn.ptrearn_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_code
|
Earn code. VARCHAR2(1) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_employee_exists
Function f_employee_exists(p_pidm pebempl.pebempl_pidm%TYPE)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_pidm
|
Person Identification. NUMBER(8) Required Key
|
f_employee_deceased
Function f_employee_deceased(p_pidm spbpers.spbpers_pidm%TYPE)
RETURN VARCHAR2
Checks if a record exists.
|
|
p_pidm
|
Person Identification. NUMBER(8) Required Key
|
f_sin_exists
Function f_sin_exists(p_pidm spbpers.spbpers_pidm%TYPE,
p_sin spbpers.spbpers_ssn%TYPE) RETURN VARCHAR2
Checks if a Employee Social Insurance Number exists.
|
|
p_pidm
|
Person Identification. NUMBER(8) Required Key
|
|
|
p_sin
|
Person Social Insurance Number. VARCHAR2(9) Required Key
|
f_job_exists
Function f_job_exists(p_pidm nbrjobs.nbrjobs_pidm%TYPE,
p_pict_code nbrjobs.nbrjobs_pict_code%TYPE)
RETURN VARCHAR2
Checks if a Job exists exists.
|
|
p_pidm
|
Person Identification. NUMBER(8) Required Key
|
|
|
p_pict_code
|
Employer ID. VARCHAR2(2) Required Key
|
f_get_non_default_total_earn
Function f_get_non_default_total_earn(p_pict_code ptrpict.ptrpict_code%TYPE,
p_pp1_grs pxrroec.pxrroec_pp1_grs%TYPE DEFAULT NULL,
p_pp2_grs pxrroec.pxrroec_pp2_grs%TYPE DEFAULT NULL,
p_pp3_grs pxrroec.pxrroec_pp3_grs%TYPE DEFAULT NULL,
p_pp4_grs pxrroec.pxrroec_pp4_grs%TYPE DEFAULT NULL,
p_pp5_grs pxrroec.pxrroec_pp5_grs%TYPE DEFAULT NULL,
p_pp6_grs pxrroec.pxrroec_pp6_grs%TYPE DEFAULT NULL,
p_pp7_grs pxrroec.pxrroec_pp7_grs%TYPE DEFAULT NULL,
p_pp8_grs pxrroec.pxrroec_pp8_grs%TYPE DEFAULT NULL,
p_pp9_grs pxrroec.pxrroec_pp9_grs%TYPE DEFAULT NULL,
p_pp10_grs pxrroec.pxrroec_pp10_grs%TYPE DEFAULT NULL,
p_pp11_grs pxrroec.pxrroec_pp11_grs%TYPE DEFAULT NULL,
p_pp12_grs pxrroec.pxrroec_pp12_grs%TYPE DEFAULT NULL,
p_pp13_grs pxrroec.pxrroec_pp13_grs%TYPE DEFAULT NULL,
p_pp14_grs pxrroec.pxrroec_pp14_grs%TYPE DEFAULT NULL,
p_pp15_grs pxrroec.pxrroec_pp15_grs%TYPE DEFAULT NULL,
p_pp16_grs pxrroec.pxrroec_pp16_grs%TYPE DEFAULT NULL,
p_pp17_grs pxrroec.pxrroec_pp17_grs%TYPE DEFAULT NULL,
p_pp18_grs pxrroec.pxrroec_pp18_grs%TYPE DEFAULT NULL,
p_pp19_grs pxrroec.pxrroec_pp19_grs%TYPE DEFAULT NULL,
p_pp20_grs pxrroec.pxrroec_pp20_grs%TYPE DEFAULT NULL,
p_pp21_grs pxrroec.pxrroec_pp21_grs%TYPE DEFAULT NULL,
p_pp22_grs pxrroec.pxrroec_pp22_grs%TYPE DEFAULT NULL,
p_pp23_grs pxrroec.pxrroec_pp23_grs%TYPE DEFAULT NULL,
p_pp24_grs pxrroec.pxrroec_pp24_grs%TYPE DEFAULT NULL,
p_pp25_grs pxrroec.pxrroec_pp25_grs%TYPE DEFAULT NULL,
p_pp26_grs pxrroec.pxrroec_pp26_grs%TYPE DEFAULT NULL,
p_pp27_grs pxrroec.pxrroec_pp27_grs%TYPE DEFAULT NULL,
p_pp28_grs pxrroec.pxrroec_pp28_grs%TYPE DEFAULT NULL,
p_pp29_grs pxrroec.pxrroec_pp29_grs%TYPE DEFAULT NULL,
p_pp30_grs pxrroec.pxrroec_pp30_grs%TYPE DEFAULT NULL,
p_pp31_grs pxrroec.pxrroec_pp31_grs%TYPE DEFAULT NULL,
p_pp32_grs pxrroec.pxrroec_pp32_grs%TYPE DEFAULT NULL,
p_pp33_grs pxrroec.pxrroec_pp33_grs%TYPE DEFAULT NULL,
p_pp34_grs pxrroec.pxrroec_pp34_grs%TYPE DEFAULT NULL,
p_pp35_grs pxrroec.pxrroec_pp35_grs%TYPE DEFAULT NULL,
p_pp36_grs pxrroec.pxrroec_pp36_grs%TYPE DEFAULT NULL,
p_pp37_grs pxrroec.pxrroec_pp37_grs%TYPE DEFAULT NULL,
p_pp38_grs pxrroec.pxrroec_pp38_grs%TYPE DEFAULT NULL,
p_pp39_grs pxrroec.pxrroec_pp39_grs%TYPE DEFAULT NULL,
p_pp40_grs pxrroec.pxrroec_pp40_grs%TYPE DEFAULT NULL,
p_pp41_grs pxrroec.pxrroec_pp41_grs%TYPE DEFAULT NULL,
p_pp42_grs pxrroec.pxrroec_pp42_grs%TYPE DEFAULT NULL,
p_pp43_grs pxrroec.pxrroec_pp43_grs%TYPE DEFAULT NULL,
p_pp44_grs pxrroec.pxrroec_pp44_grs%TYPE DEFAULT NULL,
p_pp45_grs pxrroec.pxrroec_pp45_grs%TYPE DEFAULT NULL,
p_pp46_grs pxrroec.pxrroec_pp46_grs%TYPE DEFAULT NULL,
p_pp47_grs pxrroec.pxrroec_pp47_grs%TYPE DEFAULT NULL,
p_pp48_grs pxrroec.pxrroec_pp48_grs%TYPE DEFAULT NULL,
p_pp49_grs pxrroec.pxrroec_pp49_grs%TYPE DEFAULT NULL,
p_pp50_grs pxrroec.pxrroec_pp50_grs%TYPE DEFAULT NULL,
p_pp51_grs pxrroec.pxrroec_pp51_grs%TYPE DEFAULT NULL,
p_pp52_grs pxrroec.pxrroec_pp52_grs%TYPE DEFAULT NULL,
p_pp53_grs pxrroec.pxrroec_pp53_grs%TYPE DEFAULT NULL)
RETURN NUMBER
summing pay earnings for preset amount of pay periods.
|
|
p_pp1_grs
|
Pay period amount breakdown number 1. NUMBER(11,2)
|
|
|
p_pp2_grs
|
Pay period amount breakdown number 2. NUMBER
|
|
|
p_pp3_grs
|
Pay period amount breakdown number 3. NUMBER
|
|
|
p_pp4_grs
|
Pay period amount breakdown number 4. NUMBER
|
|
|
p_pp5_grs
|
Pay period amount breakdown number 5. NUMBER
|
|
|
p_pp6_grs
|
Pay period amount breakdown number 6. NUMBER
|
|
|
p_pp8_grs
|
Pay period amount breakdown number 8. NUMBER
|
|
|
p_pp9_grs
|
Pay period amount breakdown number 9. NUMBER
|
|
|
p_pp10_grs
|
Pay period amount breakdown number 10. NUMBER
|
|
|
p_pp11_grs
|
Pay period amount breakdown number 11. NUMBER
|
|
|
p_pp12_grs
|
Pay period amount breakdown number 12. NUMBER
|
|
|
p_pp13_grs
|
Pay period amount breakdown number 13. NUMBER
|
|
|
p_pp14_grs
|
Pay period amount breakdown number 14. NUMBER
|
|
|
p_pp15_grs
|
Pay period amount breakdown number 15. NUMBER
|
|
|
p_pp16_grs
|
Pay period amount breakdown number 16. NUMBER
|
|
|
p_pp17_grs
|
Pay period amount breakdown number 17. NUMBER
|
|
|
p_pp18_grs
|
Pay period amount breakdown number 18. NUMBER
|
|
|
p_pp19_grs
|
Pay period amount breakdown number 19. NUMBER
|
|
|
p_pp20_grs
|
Pay period amount breakdown number 20. NUMBER
|
|
|
p_pp21_grs
|
Pay period amount breakdown number 21. NUMBER
|
|
|
p_pp22_grs
|
Pay period amount breakdown number 22. NUMBER
|
|
|
p_pp23_grs
|
Pay period amount breakdown number 23. NUMBER
|
|
|
p_pp24_grs
|
Pay period amount breakdown number 24. NUMBER
|
|
|
p_pp25_grs
|
Pay period amount breakdown number 25. NUMBER
|
|
|
p_pp26_grs
|
Pay period amount breakdown number 26. NUMBER
|
|
|
p_pp27_grs
|
Pay period amount breakdown number 27. NUMBER
|
|
|
p_pp28_grs
|
Pay period amount breakdown number 28. NUMBER(9,2)
|
|
|
p_pp29_grs
|
Pay period amount breakdown number 29. NUMBER(9,2)
|
|
|
p_pp30_grs
|
Pay period amount breakdown number 30. NUMBER(9,2)
|
|
|
p_pp31_grs
|
Pay period amount breakdown number 31. NUMBER(9,2)
|
|
|
p_pp32_grs
|
Pay period amount breakdown number 32. NUMBER(9,2)
|
|
|
p_pp33_grs
|
Pay period amount breakdown number 33. NUMBER(9,2)
|
|
|
p_pp34_grs
|
Pay period amount breakdown number 34. NUMBER(9,2)
|
|
|
p_pp35_grs
|
Pay period amount breakdown number 35. NUMBER(9,2)
|
|
|
p_pp36_grs
|
Pay period amount breakdown number 36. NUMBER(9,2)
|
|
|
p_pp37_grs
|
Pay period amount breakdown number 37. NUMBER(9,2)
|
|
|
p_pp38_grs
|
Pay period amount breakdown number 38. NUMBER(9,2)
|
|
|
p_pp39_grs
|
Pay period amount breakdown number 39. NUMBER(9,2)
|
|
|
p_pp40_grs
|
Pay period amount breakdown number 40. NUMBER(9,2)
|
|
|
p_pp41_grs
|
Pay period amount breakdown number 41. NUMBER(9,2)
|
|
|
p_pp42_grs
|
Pay period amount breakdown number 42. NUMBER(9,2)
|
|
|
p_pp43_grs
|
Pay period amount breakdown number 43. NUMBER(9,2)
|
|
|
p_pp44_grs
|
Pay period amount breakdown number 44. NUMBER(9,2)
|
|
|
p_pp45_grs
|
Pay period amount breakdown number 45. NUMBER(9,2)
|
|
|
p_pp46_grs
|
Pay period amount breakdown number 46. NUMBER(9,2)
|
|
|
p_pp47_grs
|
Pay period amount breakdown number 47. NUMBER(9,2)
|
|
|
p_pp48_grs
|
Pay period amount breakdown number 48. NUMBER(9,2)
|
|
|
p_pp49_grs
|
Pay period amount breakdown number 49. NUMBER(9,2)
|
|
|
p_pp50_grs
|
Pay period amount breakdown number 50. NUMBER(9,2)
|
|
|
p_pp51_grs
|
Pay period amount breakdown number 51. NUMBER(9,2)
|
|
|
p_pp52_grs
|
Pay period amount breakdown number 52. NUMBER(9,2)
|
|
|
p_pp53_grs
|
Pay period amount breakdown number 53. NUMBER(9,2) Return Totals of tha the Pay period amount
|
f_record_updated
Function f_record_updated(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_empr_fed_ein pxrroec.pxrroec_empr_fed_ein%TYPE,
p_print_ind pxrroec.pxrroec_print_ind%TYPE,
p_reprint_ind pxrroec.pxrroec_reprint_ind%TYPE,
p_serial_no pxrroec.pxrroec_serial_no%TYPE DEFAULT NULL,
p_amends_serial_no pxrroec.pxrroec_amends_serial_no%TYPE DEFAULT NULL,
p_language_ind pxrroec.pxrroec_language_ind%TYPE,
p_issue_date pxrroec.pxrroec_issue_date%TYPE,
p_reference_number pxrroec.pxrroec_reference_number%TYPE DEFAULT NULL,
p_sin pxrroec.pxrroec_sin%TYPE,
p_job_title pxrroec.pxrroec_job_title%TYPE DEFAULT NULL,
p_first_day_worked pxrroec.pxrroec_first_day_worked%TYPE,
p_last_day_worked pxrroec.pxrroec_last_day_worked%TYPE,
p_final_pay_date pxrroec.pxrroec_final_pay_date%TYPE,
p_recall_ind pxrroec.pxrroec_recall_ind%TYPE DEFAULT NULL,
p_recall_date pxrroec.pxrroec_recall_date%TYPE DEFAULT NULL,
p_roec_code pxrroec.pxrroec_roec_code%TYPE,
p_total_hrs pxrroec.pxrroec_total_hrs%TYPE,
p_total_grs pxrroec.pxrroec_total_grs%TYPE DEFAULT NULL,
p_1996_weeks pxrroec.pxrroec_1996_weeks%TYPE DEFAULT NULL,
p_1996_earnings pxrroec.pxrroec_1996_earnings%TYPE DEFAULT NULL,
p_contact_pidm pxrroec.pxrroec_contact_pidm%TYPE,
p_contact_tele_area_code pxrroec.pxrroec_contact_tele_area_code%TYPE,
p_contact_tele_number pxrroec.pxrroec_contact_tele_number%TYPE,
p_contact_tele_ext pxrroec.pxrroec_contact_tele_ext%TYPE DEFAULT NULL,
p_issuing_pidm pxrroec.pxrroec_issuing_pidm%TYPE,
p_issuing_tele_area_code pxrroec.pxrroec_issuing_tele_area_code%TYPE,
p_issuing_tele_number pxrroec.pxrroec_issuing_tele_number%TYPE,
p_issusing_tele_ext pxrroec.pxrroec_issusing_tele_ext%TYPE DEFAULT NULL,
p_earn_code_vac pxrroec.pxrroec_earn_code_vac%TYPE DEFAULT NULL,
p_vac_grs pxrroec.pxrroec_vac_grs%TYPE DEFAULT NULL,
p_stat_hol_earn_code1 pxrroec.pxrroec_stat_hol_earn_code1%TYPE DEFAULT NULL,
p_stat_hol_date1 pxrroec.pxrroec_stat_hol_date1%TYPE DEFAULT NULL,
p_stat_hol_grs1 pxrroec.pxrroec_stat_hol_grs1%TYPE DEFAULT NULL,
p_stat_hol_earn_code2 pxrroec.pxrroec_stat_hol_earn_code2%TYPE DEFAULT NULL,
p_stat_hol_date2 pxrroec.pxrroec_stat_hol_date2%TYPE DEFAULT NULL,
p_stat_hol_grs2 pxrroec.pxrroec_stat_hol_grs2%TYPE DEFAULT NULL,
p_stat_hol_earn_code3 pxrroec.pxrroec_stat_hol_earn_code3%TYPE DEFAULT NULL,
p_stat_hol_date3 pxrroec.pxrroec_stat_hol_date3%TYPE DEFAULT NULL,
p_stat_hol_grs3 pxrroec.pxrroec_stat_hol_grs3%TYPE DEFAULT NULL,
p_other_earn_code1 pxrroec.pxrroec_other_earn_code1%TYPE DEFAULT NULL,
p_other_earn_code1_grs pxrroec.pxrroec_other_earn_code1_grs%TYPE DEFAULT NULL,
p_other_earn_code2 pxrroec.pxrroec_other_earn_code2%TYPE DEFAULT NULL,
p_other_earn_code2_grs pxrroec.pxrroec_other_earn_code2_grs%TYPE DEFAULT NULL,
p_other_earn_code3 pxrroec.pxrroec_other_earn_code3%TYPE DEFAULT NULL,
p_other_earn_code3_grs pxrroec.pxrroec_other_earn_code3_grs%TYPE DEFAULT NULL,
p_benefit_ind pxrroec.pxrroec_benefit_ind%TYPE,
p_benefit_grs pxrroec.pxrroec_benefit_grs%TYPE DEFAULT NULL,
p_benefit_start_date pxrroec.pxrroec_benefit_start_date%TYPE DEFAULT NULL,
p_benefit_day_week_ind pxrroec.pxrroec_benefit_day_week_ind%TYPE DEFAULT NULL,
p_pp1_payno pxrroec.pxrroec_pp1_payno%TYPE DEFAULT NULL,
p_pp1_grs pxrroec.pxrroec_pp1_grs%TYPE DEFAULT NULL,
p_pp2_payno pxrroec.pxrroec_pp2_payno%TYPE DEFAULT NULL,
p_pp2_grs pxrroec.pxrroec_pp2_grs%TYPE DEFAULT NULL,
p_pp3_payno pxrroec.pxrroec_pp3_payno%TYPE DEFAULT NULL,
p_pp3_grs pxrroec.pxrroec_pp3_grs%TYPE DEFAULT NULL,
p_pp4_payno pxrroec.pxrroec_pp4_payno%TYPE DEFAULT NULL,
p_pp4_grs pxrroec.pxrroec_pp4_grs%TYPE DEFAULT NULL,
p_pp5_payno pxrroec.pxrroec_pp5_payno%TYPE DEFAULT NULL,
p_pp5_grs pxrroec.pxrroec_pp5_grs%TYPE DEFAULT NULL,
p_pp6_payno pxrroec.pxrroec_pp6_payno%TYPE DEFAULT NULL,
p_pp6_grs pxrroec.pxrroec_pp6_grs%TYPE DEFAULT NULL,
p_pp7_payno pxrroec.pxrroec_pp7_payno%TYPE DEFAULT NULL,
p_pp7_grs pxrroec.pxrroec_pp7_grs%TYPE DEFAULT NULL,
p_pp8_payno pxrroec.pxrroec_pp8_payno%TYPE DEFAULT NULL,
p_pp8_grs pxrroec.pxrroec_pp8_grs%TYPE DEFAULT NULL,
p_pp9_payno pxrroec.pxrroec_pp9_payno%TYPE DEFAULT NULL,
p_pp9_grs pxrroec.pxrroec_pp9_grs%TYPE DEFAULT NULL,
p_pp10_payno pxrroec.pxrroec_pp10_payno%TYPE DEFAULT NULL,
p_pp10_grs pxrroec.pxrroec_pp10_grs%TYPE DEFAULT NULL,
p_pp11_payno pxrroec.pxrroec_pp11_payno%TYPE DEFAULT NULL,
p_pp11_grs pxrroec.pxrroec_pp11_grs%TYPE DEFAULT NULL,
p_pp12_payno pxrroec.pxrroec_pp12_payno%TYPE DEFAULT NULL,
p_pp12_grs pxrroec.pxrroec_pp12_grs%TYPE DEFAULT NULL,
p_pp13_payno pxrroec.pxrroec_pp13_payno%TYPE DEFAULT NULL,
p_pp13_grs pxrroec.pxrroec_pp13_grs%TYPE DEFAULT NULL,
p_pp14_payno pxrroec.pxrroec_pp14_payno%TYPE DEFAULT NULL,
p_pp14_grs pxrroec.pxrroec_pp14_grs%TYPE DEFAULT NULL,
p_pp15_payno pxrroec.pxrroec_pp15_payno%TYPE DEFAULT NULL,
p_pp15_grs pxrroec.pxrroec_pp15_grs%TYPE DEFAULT NULL,
p_pp16_payno pxrroec.pxrroec_pp16_payno%TYPE DEFAULT NULL,
p_pp16_grs pxrroec.pxrroec_pp16_grs%TYPE DEFAULT NULL,
p_pp17_payno pxrroec.pxrroec_pp17_payno%TYPE DEFAULT NULL,
p_pp17_grs pxrroec.pxrroec_pp17_grs%TYPE DEFAULT NULL,
p_pp18_payno pxrroec.pxrroec_pp18_payno%TYPE DEFAULT NULL,
p_pp18_grs pxrroec.pxrroec_pp18_grs%TYPE DEFAULT NULL,
p_pp19_payno pxrroec.pxrroec_pp19_payno%TYPE DEFAULT NULL,
p_pp19_grs pxrroec.pxrroec_pp19_grs%TYPE DEFAULT NULL,
p_pp20_payno pxrroec.pxrroec_pp20_payno%TYPE DEFAULT NULL,
p_pp20_grs pxrroec.pxrroec_pp20_grs%TYPE DEFAULT NULL,
p_pp21_payno pxrroec.pxrroec_pp21_payno%TYPE DEFAULT NULL,
p_pp21_grs pxrroec.pxrroec_pp21_grs%TYPE DEFAULT NULL,
p_pp22_payno pxrroec.pxrroec_pp22_payno%TYPE DEFAULT NULL,
p_pp22_grs pxrroec.pxrroec_pp22_grs%TYPE DEFAULT NULL,
p_pp23_payno pxrroec.pxrroec_pp23_payno%TYPE DEFAULT NULL,
p_pp23_grs pxrroec.pxrroec_pp23_grs%TYPE DEFAULT NULL,
p_pp24_payno pxrroec.pxrroec_pp24_payno%TYPE DEFAULT NULL,
p_pp24_grs pxrroec.pxrroec_pp24_grs%TYPE DEFAULT NULL,
p_pp25_payno pxrroec.pxrroec_pp25_payno%TYPE DEFAULT NULL,
p_pp25_grs pxrroec.pxrroec_pp25_grs%TYPE DEFAULT NULL,
p_pp26_payno pxrroec.pxrroec_pp26_payno%TYPE DEFAULT NULL,
p_pp26_grs pxrroec.pxrroec_pp26_grs%TYPE DEFAULT NULL,
p_pp27_payno pxrroec.pxrroec_pp27_payno%TYPE DEFAULT NULL,
p_pp27_grs pxrroec.pxrroec_pp27_grs%TYPE DEFAULT NULL,
p_comment_line1 pxrroec.pxrroec_comment_line1%TYPE DEFAULT NULL,
p_comment_line2 pxrroec.pxrroec_comment_line2%TYPE DEFAULT NULL,
p_comment_line3 pxrroec.pxrroec_comment_line3%TYPE DEFAULT NULL,
p_comment_line4 pxrroec.pxrroec_comment_line4%TYPE DEFAULT NULL,
p_comment_line5 pxrroec.pxrroec_comment_line5%TYPE DEFAULT NULL,
p_comment_line6 pxrroec.pxrroec_comment_line6%TYPE DEFAULT NULL,
p_user_id pxrroec.pxrroec_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_money_type1 pxrroec.pxrroec_money_type1%TYPE DEFAULT NULL,
p_money_type2 pxrroec.pxrroec_money_type2%TYPE DEFAULT NULL,
p_money_type3 pxrroec.pxrroec_money_type3%TYPE DEFAULT NULL,
p_pp28_payno pxrroec.pxrroec_pp28_payno%TYPE DEFAULT NULL,
p_pp28_grs pxrroec.pxrroec_pp28_grs%TYPE DEFAULT NULL,
p_pp29_payno pxrroec.pxrroec_pp29_payno%TYPE DEFAULT NULL,
p_pp29_grs pxrroec.pxrroec_pp29_grs%TYPE DEFAULT NULL,
p_pp30_payno pxrroec.pxrroec_pp30_payno%TYPE DEFAULT NULL,
p_pp30_grs pxrroec.pxrroec_pp30_grs%TYPE DEFAULT NULL,
p_pp31_payno pxrroec.pxrroec_pp31_payno%TYPE DEFAULT NULL,
p_pp31_grs pxrroec.pxrroec_pp31_grs%TYPE DEFAULT NULL,
p_pp32_payno pxrroec.pxrroec_pp32_payno%TYPE DEFAULT NULL,
p_pp32_grs pxrroec.pxrroec_pp32_grs%TYPE DEFAULT NULL,
p_pp33_payno pxrroec.pxrroec_pp33_payno%TYPE DEFAULT NULL,
p_pp33_grs pxrroec.pxrroec_pp33_grs%TYPE DEFAULT NULL,
p_pp34_payno pxrroec.pxrroec_pp34_payno%TYPE DEFAULT NULL,
p_pp34_grs pxrroec.pxrroec_pp34_grs%TYPE DEFAULT NULL,
p_pp35_payno pxrroec.pxrroec_pp35_payno%TYPE DEFAULT NULL,
p_pp35_grs pxrroec.pxrroec_pp35_grs%TYPE DEFAULT NULL,
p_pp36_payno pxrroec.pxrroec_pp36_payno%TYPE DEFAULT NULL,
p_pp36_grs pxrroec.pxrroec_pp36_grs%TYPE DEFAULT NULL,
p_pp37_payno pxrroec.pxrroec_pp37_payno%TYPE DEFAULT NULL,
p_pp37_grs pxrroec.pxrroec_pp37_grs%TYPE DEFAULT NULL,
p_pp38_payno pxrroec.pxrroec_pp38_payno%TYPE DEFAULT NULL,
p_pp38_grs pxrroec.pxrroec_pp38_grs%TYPE DEFAULT NULL,
p_pp39_payno pxrroec.pxrroec_pp39_payno%TYPE DEFAULT NULL,
p_pp39_grs pxrroec.pxrroec_pp39_grs%TYPE DEFAULT NULL,
p_pp40_payno pxrroec.pxrroec_pp40_payno%TYPE DEFAULT NULL,
p_pp40_grs pxrroec.pxrroec_pp40_grs%TYPE DEFAULT NULL,
p_pp41_payno pxrroec.pxrroec_pp41_payno%TYPE DEFAULT NULL,
p_pp41_grs pxrroec.pxrroec_pp41_grs%TYPE DEFAULT NULL,
p_pp42_payno pxrroec.pxrroec_pp42_payno%TYPE DEFAULT NULL,
p_pp42_grs pxrroec.pxrroec_pp42_grs%TYPE DEFAULT NULL,
p_pp43_payno pxrroec.pxrroec_pp43_payno%TYPE DEFAULT NULL,
p_pp43_grs pxrroec.pxrroec_pp43_grs%TYPE DEFAULT NULL,
p_pp44_payno pxrroec.pxrroec_pp44_payno%TYPE DEFAULT NULL,
p_pp44_grs pxrroec.pxrroec_pp44_grs%TYPE DEFAULT NULL,
p_pp45_payno pxrroec.pxrroec_pp45_payno%TYPE DEFAULT NULL,
p_pp45_grs pxrroec.pxrroec_pp45_grs%TYPE DEFAULT NULL,
p_pp46_payno pxrroec.pxrroec_pp46_payno%TYPE DEFAULT NULL,
p_pp46_grs pxrroec.pxrroec_pp46_grs%TYPE DEFAULT NULL,
p_pp47_payno pxrroec.pxrroec_pp47_payno%TYPE DEFAULT NULL,
p_pp47_grs pxrroec.pxrroec_pp47_grs%TYPE DEFAULT NULL,
p_pp48_payno pxrroec.pxrroec_pp48_payno%TYPE DEFAULT NULL,
p_pp48_grs pxrroec.pxrroec_pp48_grs%TYPE DEFAULT NULL,
p_pp49_payno pxrroec.pxrroec_pp49_payno%TYPE DEFAULT NULL,
p_pp49_grs pxrroec.pxrroec_pp49_grs%TYPE DEFAULT NULL,
p_pp50_payno pxrroec.pxrroec_pp50_payno%TYPE DEFAULT NULL,
p_pp50_grs pxrroec.pxrroec_pp50_grs%TYPE DEFAULT NULL,
p_pp51_payno pxrroec.pxrroec_pp51_payno%TYPE DEFAULT NULL,
p_pp51_grs pxrroec.pxrroec_pp51_grs%TYPE DEFAULT NULL,
p_pp52_payno pxrroec.pxrroec_pp52_payno%TYPE DEFAULT NULL,
p_pp52_grs pxrroec.pxrroec_pp52_grs%TYPE DEFAULT NULL,
p_pp53_payno pxrroec.pxrroec_pp53_payno%TYPE DEFAULT NULL,
p_pp53_grs pxrroec.pxrroec_pp53_grs%TYPE DEFAULT NULL,
p_data_origin pxrroec.pxrroec_data_origin%TYPE DEFAULT NULL,
p_pp1_hrs pxrroec.pxrroec_pp1_hrs%TYPE DEFAULT NULL,
p_pp2_hrs pxrroec.pxrroec_pp2_hrs%TYPE DEFAULT NULL,
p_pp3_hrs pxrroec.pxrroec_pp3_hrs%TYPE DEFAULT NULL,
p_pp4_hrs pxrroec.pxrroec_pp4_hrs%TYPE DEFAULT NULL,
p_pp5_hrs pxrroec.pxrroec_pp5_hrs%TYPE DEFAULT NULL,
p_pp6_hrs pxrroec.pxrroec_pp6_hrs%TYPE DEFAULT NULL,
p_pp7_hrs pxrroec.pxrroec_pp7_hrs%TYPE DEFAULT NULL,
p_pp8_hrs pxrroec.pxrroec_pp8_hrs%TYPE DEFAULT NULL,
p_pp9_hrs pxrroec.pxrroec_pp9_hrs%TYPE DEFAULT NULL,
p_pp10_hrs pxrroec.pxrroec_pp10_hrs%TYPE DEFAULT NULL,
p_pp11_hrs pxrroec.pxrroec_pp11_hrs%TYPE DEFAULT NULL,
p_pp12_hrs pxrroec.pxrroec_pp12_hrs%TYPE DEFAULT NULL,
p_pp13_hrs pxrroec.pxrroec_pp13_hrs%TYPE DEFAULT NULL,
p_pp14_hrs pxrroec.pxrroec_pp14_hrs%TYPE DEFAULT NULL,
p_pp15_hrs pxrroec.pxrroec_pp15_hrs%TYPE DEFAULT NULL,
p_pp16_hrs pxrroec.pxrroec_pp16_hrs%TYPE DEFAULT NULL,
p_pp17_hrs pxrroec.pxrroec_pp17_hrs%TYPE DEFAULT NULL,
p_pp18_hrs pxrroec.pxrroec_pp18_hrs%TYPE DEFAULT NULL,
p_pp19_hrs pxrroec.pxrroec_pp19_hrs%TYPE DEFAULT NULL,
p_pp20_hrs pxrroec.pxrroec_pp20_hrs%TYPE DEFAULT NULL,
p_pp21_hrs pxrroec.pxrroec_pp21_hrs%TYPE DEFAULT NULL,
p_pp22_hrs pxrroec.pxrroec_pp22_hrs%TYPE DEFAULT NULL,
p_pp23_hrs pxrroec.pxrroec_pp23_hrs%TYPE DEFAULT NULL,
p_pp24_hrs pxrroec.pxrroec_pp24_hrs%TYPE DEFAULT NULL,
p_pp25_hrs pxrroec.pxrroec_pp25_hrs%TYPE DEFAULT NULL,
p_pp26_hrs pxrroec.pxrroec_pp26_hrs%TYPE DEFAULT NULL,
p_pp27_hrs pxrroec.pxrroec_pp27_hrs%TYPE DEFAULT NULL,
p_pp28_hrs pxrroec.pxrroec_pp28_hrs%TYPE DEFAULT NULL,
p_pp29_hrs pxrroec.pxrroec_pp29_hrs%TYPE DEFAULT NULL,
p_pp30_hrs pxrroec.pxrroec_pp30_hrs%TYPE DEFAULT NULL,
p_pp31_hrs pxrroec.pxrroec_pp31_hrs%TYPE DEFAULT NULL,
p_pp32_hrs pxrroec.pxrroec_pp32_hrs%TYPE DEFAULT NULL,
p_pp33_hrs pxrroec.pxrroec_pp33_hrs%TYPE DEFAULT NULL,
p_pp34_hrs pxrroec.pxrroec_pp34_hrs%TYPE DEFAULT NULL,
p_pp35_hrs pxrroec.pxrroec_pp35_hrs%TYPE DEFAULT NULL,
p_pp36_hrs pxrroec.pxrroec_pp36_hrs%TYPE DEFAULT NULL,
p_pp37_hrs pxrroec.pxrroec_pp37_hrs%TYPE DEFAULT NULL,
p_pp38_hrs pxrroec.pxrroec_pp38_hrs%TYPE DEFAULT NULL,
p_pp39_hrs pxrroec.pxrroec_pp39_hrs%TYPE DEFAULT NULL,
p_pp40_hrs pxrroec.pxrroec_pp40_hrs%TYPE DEFAULT NULL,
p_pp41_hrs pxrroec.pxrroec_pp41_hrs%TYPE DEFAULT NULL,
p_pp42_hrs pxrroec.pxrroec_pp42_hrs%TYPE DEFAULT NULL,
p_pp43_hrs pxrroec.pxrroec_pp43_hrs%TYPE DEFAULT NULL,
p_pp44_hrs pxrroec.pxrroec_pp44_hrs%TYPE DEFAULT NULL,
p_pp45_hrs pxrroec.pxrroec_pp45_hrs%TYPE DEFAULT NULL,
p_pp46_hrs pxrroec.pxrroec_pp46_hrs%TYPE DEFAULT NULL,
p_pp47_hrs pxrroec.pxrroec_pp47_hrs%TYPE DEFAULT NULL,
p_pp48_hrs pxrroec.pxrroec_pp48_hrs%TYPE DEFAULT NULL,
p_pp49_hrs pxrroec.pxrroec_pp49_hrs%TYPE DEFAULT NULL,
p_pp50_hrs pxrroec.pxrroec_pp50_hrs%TYPE DEFAULT NULL,
p_pp51_hrs pxrroec.pxrroec_pp51_hrs%TYPE DEFAULT NULL,
p_pp52_hrs pxrroec.pxrroec_pp52_hrs%TYPE DEFAULT NULL,
p_pp53_hrs pxrroec.pxrroec_pp53_hrs%TYPE DEFAULT NULL,
p_bulk_file_name pxrroec.pxrroec_bulk_file_name%TYPE DEFAULT NULL,
p_vac_roev_code pxrroec.pxrroec_vac_roev_code%TYPE DEFAULT NULL,
p_vac_start_date pxrroec.pxrroec_vac_start_date%TYPE DEFAULT NULL,
p_vac_end_date pxrroec.pxrroec_vac_end_date%TYPE DEFAULT NULL,
p_stat_hol_earn_code4 pxrroec.pxrroec_stat_hol_earn_code4%TYPE DEFAULT NULL,
p_stat_hol_date4 pxrroec.pxrroec_stat_hol_date4%TYPE DEFAULT NULL,
p_stat_hol_grs4 pxrroec.pxrroec_stat_hol_grs4%TYPE DEFAULT NULL,
p_stat_hol_earn_code5 pxrroec.pxrroec_stat_hol_earn_code5%TYPE DEFAULT NULL,
p_stat_hol_date5 pxrroec.pxrroec_stat_hol_date5%TYPE DEFAULT NULL,
p_stat_hol_grs5 pxrroec.pxrroec_stat_hol_grs5%TYPE DEFAULT NULL,
p_other_start_date1 pxrroec.pxrroec_other_start_date1%TYPE DEFAULT NULL,
p_other_end_date1 pxrroec.pxrroec_other_end_date1%TYPE DEFAULT NULL,
p_other_start_date2 pxrroec.pxrroec_other_start_date2%TYPE DEFAULT NULL,
p_other_end_date2 pxrroec.pxrroec_other_end_date2%TYPE DEFAULT NULL,
p_other_start_date3 pxrroec.pxrroec_other_start_date3%TYPE DEFAULT NULL,
p_other_end_date3 pxrroec.pxrroec_other_end_date3%TYPE DEFAULT NULL,
p_benefit_roes_code pxrroec.pxrroec_benefit_roes_code%TYPE DEFAULT NULL,
p_benefit_end_date pxrroec.pxrroec_benefit_end_date%TYPE DEFAULT NULL,
p_benefit_roes_code2 pxrroec.pxrroec_benefit_roes_code2%TYPE DEFAULT NULL,
p_benefit_grs2 pxrroec.pxrroec_benefit_grs2%TYPE DEFAULT NULL,
p_benefit_start_date2 pxrroec.pxrroec_benefit_start_date2%TYPE DEFAULT NULL,
p_benefit_end_date2 pxrroec.pxrroec_benefit_end_date2%TYPE DEFAULT NULL,
p_benefit_day_week_ind2 pxrroec.pxrroec_benefit_day_week_ind2%TYPE DEFAULT NULL,
p_benefit_roes_code3 pxrroec.pxrroec_benefit_roes_code3%TYPE DEFAULT NULL,
p_benefit_grs3 pxrroec.pxrroec_benefit_grs3%TYPE DEFAULT NULL,
p_benefit_start_date3 pxrroec.pxrroec_benefit_start_date3%TYPE DEFAULT NULL,
p_benefit_end_date3 pxrroec.pxrroec_benefit_end_date3%TYPE DEFAULT NULL,
p_benefit_day_week_ind3 pxrroec.pxrroec_benefit_day_week_ind3%TYPE DEFAULT NULL,
p_benefit_roes_code4 pxrroec.pxrroec_benefit_roes_code4%TYPE DEFAULT NULL,
p_benefit_grs4 pxrroec.pxrroec_benefit_grs4%TYPE DEFAULT NULL,
p_benefit_start_date4 pxrroec.pxrroec_benefit_start_date4%TYPE DEFAULT NULL,
p_benefit_end_date4 pxrroec.pxrroec_benefit_end_date4%TYPE DEFAULT NULL,
p_benefit_day_week_ind4 pxrroec.pxrroec_benefit_day_week_ind4%TYPE DEFAULT NULL)
RETURN VARCHAR2
checks if the reocrd has been updated if it is printed. Only Serial Number is updatable.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_empr_fed_ein
|
Revenue Canada Business Number. VARCHAR2(15) Required
|
|
|
p_print_ind
|
Ready to print indicator. VARCHAR2(1) Required
|
|
|
p_reprint_ind
|
Reprint amend indicator. VARCHAR2(1) Required
|
|
|
p_serial_no
|
Serial number of ROE record. VARCHAR2(9)
|
|
|
p_amends_serial_no
|
Amended serial number of ROE amended or replaced. VARCHAR2(12)
|
|
|
p_language_ind
|
The preferred language indicator of the issuing employer. VARCHAR2(1) Required
|
|
|
p_issue_date
|
Issued Date of the ROE record. DATE Required
|
|
|
p_reference_number
|
Reference Number used by the employer to identify the employee. VARCHAR2(12)
|
|
|
p_sin
|
The Employee social insurance number. VARCHAR2(9) Required
|
|
|
p_job_title
|
Employee job title. VARCHAR2(40)
|
|
|
p_first_day_worked
|
Employee first worked date. DATE Required
|
|
|
p_last_day_worked
|
Employee last worked date. DATE Required
|
|
|
p_final_pay_date
|
Employee final paid date. DATE Required
|
|
|
p_recall_ind
|
The employee return to active employment indicator. VARCHAR2(1)
|
|
|
p_recall_date
|
The expected date of the employee return to active employment. DATE
|
|
|
p_roec_code
|
Reason of the employer issuing this ROE. VARCHAR2(3) Required
|
|
|
p_total_hrs
|
The total insurable hours worked by the employee in the last 52 weeks. NUMBER(11,2) Required
|
|
|
p_total_grs
|
The sum of applicable gross of all EI deduction records in the last 52 weeks. NUMBER(11,2)
|
|
|
p_1996_weeks
|
1996 Employment history insurable weeks. NUMBER(,)
|
|
|
p_1996_earnings
|
1996 Employment history insurable earnings. NUMBER(,)
|
|
|
p_contact_pidm
|
Employee Identification number to be contacted. NUMBER(8) Required
|
|
|
p_contact_tele_area_code
|
Employee phone number area code to be contacted. VARCHAR2(3) Required
|
|
|
p_contact_tele_number
|
Employee phone number to be contacted. VARCHAR2(7) Required
|
|
|
p_contact_tele_ext
|
Employee phone number extention to be contacted. VARCHAR2(4)
|
|
|
p_issuing_pidm
|
Issuing person identification number. NUMBER(8) Required
|
|
|
p_issuing_tele_area_code
|
Issuing person telephone number area code. VARCHAR2(3) Required
|
|
|
p_issuing_tele_number
|
Issuing person telephone number. VARCHAR2(7) Required
|
|
|
p_issusing_tele_ext
|
Issuing person telephone number extention. VARCHAR2(4)
|
|
|
p_earn_code_vac
|
Vacation pay earnings code. VARCHAR2(3)
|
|
|
p_vac_grs
|
Vacation pay amount. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code1
|
Statutory holiday pay earnings code 1. VARCHAR2(3)
|
|
|
p_stat_hol_date1
|
Statutory holiday date 1. DATE
|
|
|
p_stat_hol_grs1
|
Statutory holiday pay amount 1. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code2
|
Statutory holiday pay earnings code 2. VARCHAR2(3)
|
|
|
p_stat_hol_date2
|
Statutory holiday date 2. DATE
|
|
|
p_stat_hol_grs2
|
Statutory holiday pay amount 2. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code3
|
Statutory holiday pay earnings code 3. VARCHAR2(3)
|
|
|
p_stat_hol_date3
|
Statutory holiday date 3. DATE
|
|
|
p_stat_hol_grs3
|
Statutory holiday pay amount 3. NUMBER(11,2)
|
|
|
p_other_earn_code1
|
Other monies earning code 1. VARCHAR2(3)
|
|
|
p_other_earn_code1_grs
|
Other monies earning amount 1. NUMBER(11,2)
|
|
|
p_other_earn_code2
|
Other monies earning code 2. VARCHAR2(3)
|
|
|
p_other_earn_code2_grs
|
Other monies earning amount 2. NUMBER(11,2)
|
|
|
p_other_earn_code3
|
Other monies earning code 3. VARCHAR2(3)
|
|
|
p_other_earn_code3_grs
|
Other monies earning amount 3. NUMBER(11,2)
|
|
|
p_benefit_ind
|
Will the employee be receiving benefit indicator. VARCHAR2(1) Required
|
|
|
p_benefit_grs
|
The amount the employee will receive for benefit. NUMBER(11,2)
|
|
|
p_benefit_start_date
|
Start date of the employee receive benefit. DATE
|
|
|
p_benefit_day_week_ind
|
The benefit payment period indicator. VARCHAR2(1)
|
|
|
p_pp1_payno
|
Pay period breakdown number 1. VARCHAR2(3)
|
|
|
p_pp1_grs
|
Pay period amount breakdown number 1. NUMBER(11,2)
|
|
|
p_pp2_payno
|
Pay period breakdown number 2. VARCHAR2(3)
|
|
|
p_pp2_grs
|
Pay period amount breakdown number 2. NUMBER(,)
|
|
|
p_pp3_payno
|
Pay period breakdown number 3. VARCHAR2(3)
|
|
|
p_pp3_grs
|
Pay period amount breakdown number 3. NUMBER(,)
|
|
|
p_pp4_payno
|
Pay period breakdown number 4. VARCHAR2(3)
|
|
|
p_pp4_grs
|
Pay period amount breakdown number 4. NUMBER(,)
|
|
|
p_pp5_payno
|
Pay period breakdown number 5. VARCHAR2(3)
|
|
|
p_pp5_grs
|
Pay period amount breakdown number 5. NUMBER(,)
|
|
|
p_pp6_payno
|
Pay period breakdown number 6. VARCHAR2(3)
|
|
|
p_pp6_grs
|
Pay period amount breakdown number 6. NUMBER(,)
|
|
|
p_pp7_payno
|
Pay period breakdown number 7. VARCHAR2(3)
|
|
|
p_pp7_grs
|
Pay period amount breakdown number 7. NUMBER(,)
|
|
|
p_pp8_payno
|
Pay period breakdown number 8. VARCHAR2(3)
|
|
|
p_pp8_grs
|
Pay period amount breakdown number 8. NUMBER(,)
|
|
|
p_pp9_payno
|
Pay period breakdown number 9. VARCHAR2(3)
|
|
|
p_pp9_grs
|
Pay period amount breakdown number 9. NUMBER(,)
|
|
|
p_pp10_payno
|
Pay period breakdown number 10. VARCHAR2(3)
|
|
|
p_pp10_grs
|
Pay period amount breakdown number 10. NUMBER(,)
|
|
|
p_pp11_payno
|
Pay period breakdown number 11. VARCHAR2(3)
|
|
|
p_pp11_grs
|
Pay period amount breakdown number 11. NUMBER(,)
|
|
|
p_pp12_payno
|
Pay period breakdown number 12. VARCHAR2(3)
|
|
|
p_pp12_grs
|
Pay period amount breakdown number 12. NUMBER(,)
|
|
|
p_pp13_payno
|
Pay period breakdown number 13. VARCHAR2(3)
|
|
|
p_pp13_grs
|
Pay period amount breakdown number 13. NUMBER(,)
|
|
|
p_pp14_payno
|
Pay period breakdown number 14. VARCHAR2(3)
|
|
|
p_pp14_grs
|
Pay period amount breakdown number 14. NUMBER(,)
|
|
|
p_pp15_payno
|
Pay period breakdown number 15. VARCHAR2(3)
|
|
|
p_pp15_grs
|
Pay period amount breakdown number 15. NUMBER(,)
|
|
|
p_pp16_payno
|
Pay period breakdown number 16. VARCHAR2(3)
|
|
|
p_pp16_grs
|
Pay period amount breakdown number 16. NUMBER(,)
|
|
|
p_pp17_payno
|
Pay period breakdown number 17. VARCHAR2(3)
|
|
|
p_pp17_grs
|
Pay period amount breakdown number 17. NUMBER(,)
|
|
|
p_pp18_payno
|
Pay period breakdown number 18. VARCHAR2(3)
|
|
|
p_pp18_grs
|
Pay period amount breakdown number 18. NUMBER(,)
|
|
|
p_pp19_payno
|
Pay period breakdown number 19. VARCHAR2(3)
|
|
|
p_pp19_grs
|
Pay period amount breakdown number 19. NUMBER(,)
|
|
|
p_pp20_payno
|
Pay period breakdown number 20. VARCHAR2(3)
|
|
|
p_pp20_grs
|
Pay period amount breakdown number 20. NUMBER(,)
|
|
|
p_pp21_payno
|
Pay period breakdown number 21. VARCHAR2(3)
|
|
|
p_pp21_grs
|
Pay period amount breakdown number 21. NUMBER(,)
|
|
|
p_pp22_payno
|
Pay period breakdown number 22. VARCHAR2(3)
|
|
|
p_pp22_grs
|
Pay period amount breakdown number 22. NUMBER(,)
|
|
|
p_pp23_payno
|
Pay period breakdown number 23. VARCHAR2(3)
|
|
|
p_pp23_grs
|
Pay period amount breakdown number 23. NUMBER(,)
|
|
|
p_pp24_payno
|
Pay period breakdown number 24. VARCHAR2(3)
|
|
|
p_pp24_grs
|
Pay period amount breakdown number 24. NUMBER(,)
|
|
|
p_pp25_payno
|
Pay period breakdown number 25. VARCHAR2(3)
|
|
|
p_pp25_grs
|
Pay period amount breakdown number 25. NUMBER(,)
|
|
|
p_pp26_payno
|
Pay period breakdown number 26. VARCHAR2(3)
|
|
|
p_pp26_grs
|
Pay period amount breakdown number 26. NUMBER(,)
|
|
|
p_pp27_payno
|
Pay period breakdown number 27. VARCHAR2(3)
|
|
|
p_pp27_grs
|
Pay period amount breakdown number 27. NUMBER(,)
|
|
|
p_comment_line1
|
Comment of the record line 1. VARCHAR2(38)
|
|
|
p_comment_line2
|
Comment of the record line 2. VARCHAR2(38)
|
|
|
p_comment_line3
|
Comment of the record line 3. VARCHAR2(38)
|
|
|
p_comment_line4
|
Comment of the record line 4. VARCHAR2(38)
|
|
|
p_comment_line5
|
Comment of the record line 5. VARCHAR2(38)
|
|
|
p_comment_line6
|
Comment of the record line 6. VARCHAR2(38)
|
|
|
p_user_id
|
VARCHAR2(30) Required
|
|
|
p_money_type1
|
PXRROEC_MONEY_TYPE1 This field indicates Canadian ROE Types of Other Money1. VARCHAR2(1)
|
|
|
p_money_type2
|
PXRROEC_MONEY_TYPE2 This field indicates Canadian ROE Types of Other Money2. VARCHAR2(1)
|
|
|
p_money_type3
|
PXRROEC_MONEY_TYPE3 This field indicates Canadian ROE Types of Other Money3. VARCHAR2(1)
|
|
|
p_pp28_payno
|
Pay period breakdown number 28. NUMBER(9,2)
|
|
|
p_pp28_grs
|
Pay period amount breakdown number 28. NUMBER(9,2)
|
|
|
p_pp29_payno
|
Pay period breakdown number 29. NUMBER(9,2)
|
|
|
p_pp29_grs
|
Pay period amount breakdown number 29. NUMBER(9,2)
|
|
|
p_pp30_payno
|
Pay period breakdown number 30. NUMBER(9,2)
|
|
|
p_pp30_grs
|
Pay period amount breakdown number 30. NUMBER(9,2)
|
|
|
p_pp31_payno
|
Pay period breakdown number 31. NUMBER(9,2)
|
|
|
p_pp31_grs
|
Pay period amount breakdown number 31. NUMBER(9,2)
|
|
|
p_pp32_payno
|
Pay period breakdown number 32. NUMBER(9,2)
|
|
|
p_pp32_grs
|
Pay period amount breakdown number 32. NUMBER(9,2)
|
|
|
p_pp33_payno
|
Pay period breakdown number 33. NUMBER(9,2)
|
|
|
p_pp33_grs
|
Pay period amount breakdown number 33. NUMBER(9,2)
|
|
|
p_pp34_payno
|
Pay period breakdown number 34. NUMBER(9,2)
|
|
|
p_pp34_grs
|
Pay period amount breakdown number 34. NUMBER(9,2)
|
|
|
p_pp35_payno
|
Pay period breakdown number 35. NUMBER(9,2)
|
|
|
p_pp35_grs
|
Pay period amount breakdown number 35. NUMBER(9,2)
|
|
|
p_pp36_payno
|
Pay period breakdown number 36. NUMBER(9,2)
|
|
|
p_pp36_grs
|
Pay period amount breakdown number 36. NUMBER(9,2)
|
|
|
p_pp37_payno
|
Pay period breakdown number 37. NUMBER(9,2)
|
|
|
p_pp37_grs
|
Pay period amount breakdown number 37. NUMBER(9,2)
|
|
|
p_pp38_payno
|
Pay period breakdown number 38. NUMBER(9,2)
|
|
|
p_pp38_grs
|
Pay period amount breakdown number 38. NUMBER(9,2)
|
|
|
p_pp39_payno
|
Pay period breakdown number 39. NUMBER(9,2)
|
|
|
p_pp39_grs
|
Pay period amount breakdown number 39. NUMBER(9,2)
|
|
|
p_pp40_payno
|
Pay period breakdown number 40. NUMBER(9,2)
|
|
|
p_pp40_grs
|
Pay period amount breakdown number 40. NUMBER(9,2)
|
|
|
p_pp41_payno
|
Pay period breakdown number 41. NUMBER(9,2)
|
|
|
p_pp41_grs
|
Pay period amount breakdown number 41. NUMBER(9,2)
|
|
|
p_pp42_payno
|
Pay period breakdown number 42. NUMBER(9,2)
|
|
|
p_pp42_grs
|
Pay period amount breakdown number 42. NUMBER(9,2)
|
|
|
p_pp43_payno
|
Pay period breakdown number 43. NUMBER(9,2)
|
|
|
p_pp43_grs
|
Pay period amount breakdown number 43. NUMBER(9,2)
|
|
|
p_pp44_payno
|
Pay period breakdown number 44. NUMBER(9,2)
|
|
|
p_pp44_grs
|
Pay period amount breakdown number 44. NUMBER(9,2)
|
|
|
p_pp45_payno
|
Pay period breakdown number 45. NUMBER(9,2)
|
|
|
p_pp45_grs
|
Pay period amount breakdown number 45. NUMBER(9,2)
|
|
|
p_pp46_payno
|
Pay period breakdown number 46. NUMBER(9,2)
|
|
|
p_pp46_grs
|
Pay period amount breakdown number 46. NUMBER(9,2)
|
|
|
p_pp47_payno
|
Pay period breakdown number 47. NUMBER(9,2)
|
|
|
p_pp47_grs
|
Pay period amount breakdown number 47. NUMBER(9,2)
|
|
|
p_pp48_payno
|
Pay period breakdown number 48. NUMBER(9,2)
|
|
|
p_pp48_grs
|
Pay period amount breakdown number 48. NUMBER(9,2)
|
|
|
p_pp49_payno
|
Pay period breakdown number 49. NUMBER(9,2)
|
|
|
p_pp49_grs
|
Pay period amount breakdown number 49. NUMBER(9,2)
|
|
|
p_pp50_payno
|
Pay period breakdown number 50. NUMBER(9,2)
|
|
|
p_pp50_grs
|
Pay period amount breakdown number 50. NUMBER(9,2)
|
|
|
p_pp51_payno
|
Pay period breakdown number 51. NUMBER(9,2)
|
|
|
p_pp51_grs
|
Pay period amount breakdown number 51. NUMBER(9,2)
|
|
|
p_pp52_payno
|
Pay period breakdown number 52. NUMBER(9,2)
|
|
|
p_pp52_grs
|
Pay period amount breakdown number 52. NUMBER(9,2)
|
|
|
p_pp53_payno
|
Pay period breakdown number 53. NUMBER(9,2)
|
|
|
p_pp53_grs
|
Pay period amount breakdown number 53. NUMBER(9,2)
|
|
|
p_data_origin
|
DATA ORIGIN: Source system that created or updated the row. VARCHAR2(30)
|
|
|
pxrroec_pp1_hrs
|
Insurable Hours of the Pay Period 1. NUMBER(9,2)
|
|
|
pxrroec_pp2_hrs
|
Insurable Hours of the Pay Period 2. NUMBER(9,2)
|
|
|
pxrroec_pp3_hrs
|
Insurable Hours of the Pay Period 3. NUMBER(9,2)
|
|
|
pxrroec_pp4_hrs
|
Insurable Hours of the Pay Period 4. NUMBER(9,2)
|
|
|
pxrroec_pp5_hrs
|
Insurable Hours of the Pay Period 5. NUMBER(9,2)
|
|
|
pxrroec_pp6_hrs
|
Insurable Hours of the Pay Period 6. NUMBER(9,2)
|
|
|
pxrroec_pp7_hrs
|
Insurable Hours of the Pay Period 7. NUMBER(9,2)
|
|
|
pxrroec_pp8_hrs
|
Insurable Hours of the Pay Period 8. NUMBER(9,2)
|
|
|
pxrroec_pp9_hrs
|
Insurable Hours of the Pay Period 9. NUMBER(9,2)
|
|
|
pxrroec_pp10_hrs
|
Insurable Hours of the Pay Period 10. NUMBER(9,2)
|
|
|
pxrroec_pp11_hrs
|
Insurable Hours of the Pay Period 11. NUMBER(9,2)
|
|
|
pxrroec_pp12_hrs
|
Insurable Hours of the Pay Period 12. NUMBER(9,2)
|
|
|
pxrroec_pp13_hrs
|
Insurable Hours of the Pay Period 13. NUMBER(9,2)
|
|
|
pxrroec_pp14_hrs
|
Insurable Hours of the Pay Period 14. NUMBER(9,2)
|
|
|
pxrroec_pp15_hrs
|
Insurable Hours of the Pay Period 15. NUMBER(9,2)
|
|
|
pxrroec_pp16_hrs
|
Insurable Hours of the Pay Period 16. NUMBER(9,2)
|
|
|
pxrroec_pp17_hrs
|
Insurable Hours of the Pay Period 17. NUMBER(9,2)
|
|
|
pxrroec_pp18_hrs
|
Insurable Hours of the Pay Period 18. NUMBER(9,2)
|
|
|
pxrroec_pp19_hrs
|
Insurable Hours of the Pay Period 19. NUMBER(9,2)
|
|
|
pxrroec_pp20_hrs
|
Insurable Hours of the Pay Period 20. NUMBER(9,2)
|
|
|
pxrroec_pp21_hrs
|
Insurable Hours of the Pay Period 21. NUMBER(9,2)
|
|
|
pxrroec_pp22_hrs
|
Insurable Hours of the Pay Period 22. NUMBER(9,2)
|
|
|
pxrroec_pp23_hrs
|
Insurable Hours of the Pay Period 23. NUMBER(9,2)
|
|
|
pxrroec_pp24_hrs
|
Insurable Hours of the Pay Period 24. NUMBER(9,2)
|
|
|
pxrroec_pp25_hrs
|
Insurable Hours of the Pay Period 25. NUMBER(9,2)
|
|
|
pxrroec_pp26_hrs
|
Insurable Hours of the Pay Period 26. NUMBER(9,2)
|
|
|
pxrroec_pp27_hrs
|
Insurable Hours of the Pay Period 27. NUMBER(9,2)
|
|
|
pxrroec_pp28_hrs
|
Insurable Hours of the Pay Period 28. NUMBER(9,2)
|
|
|
pxrroec_pp29_hrs
|
Insurable Hours of the Pay Period 29. NUMBER(9,2)
|
|
|
pxrroec_pp30_hrs
|
Insurable Hours of the Pay Period 30. NUMBER(9,2)
|
|
|
pxrroec_pp31_hrs
|
Insurable Hours of the Pay Period 31. NUMBER(9,2)
|
|
|
pxrroec_pp32_hrs
|
Insurable Hours of the Pay Period 32. NUMBER(9,2)
|
|
|
pxrroec_pp33_hrs
|
Insurable Hours of the Pay Period 33. NUMBER(9,2)
|
|
|
pxrroec_pp34_hrs
|
Insurable Hours of the Pay Period 34. NUMBER(9,2)
|
|
|
pxrroec_pp35_hrs
|
Insurable Hours of the Pay Period 35. NUMBER(9,2)
|
|
|
pxrroec_pp36_hrs
|
Insurable Hours of the Pay Period 36. NUMBER(9,2)
|
|
|
pxrroec_pp37_hrs
|
Insurable Hours of the Pay Period 37. NUMBER(9,2)
|
|
|
pxrroec_pp38_hrs
|
Insurable Hours of the Pay Period 38. NUMBER(9,2)
|
|
|
pxrroec_pp39_hrs
|
Insurable Hours of the Pay Period 39. NUMBER(9,2)
|
|
|
pxrroec_pp40_hrs
|
Insurable Hours of the Pay Period 40. NUMBER(9,2)
|
|
|
pxrroec_pp41_hrs
|
Insurable Hours of the Pay Period 41. NUMBER(9,2)
|
|
|
pxrroec_pp42_hrs
|
Insurable Hours of the Pay Period 42. NUMBER(9,2)
|
|
|
pxrroec_pp43_hrs
|
Insurable Hours of the Pay Period 43. NUMBER(9,2)
|
|
|
pxrroec_pp44_hrs
|
Insurable Hours of the Pay Period 44. NUMBER(9,2)
|
|
|
pxrroec_pp45_hrs
|
Insurable Hours of the Pay Period 45. NUMBER(9,2)
|
|
|
pxrroec_pp46_hrs
|
Insurable Hours of the Pay Period 46. NUMBER(9,2)
|
|
|
pxrroec_pp47_hrs
|
Insurable Hours of the Pay Period 47. NUMBER(9,2)
|
|
|
pxrroec_pp48_hrs
|
Insurable Hours of the Pay Period 48. NUMBER(9,2)
|
|
|
pxrroec_pp49_hrs
|
Insurable Hours of the Pay Period 49. NUMBER(9,2)
|
|
|
pxrroec_pp50_hrs
|
Insurable Hours of the Pay Period 50. NUMBER(9,2)
|
|
|
pxrroec_pp51_hrs
|
Insurable Hours of the Pay Period 51. NUMBER(9,2)
|
|
|
pxrroec_pp52_hrs
|
Insurable Hours of the Pay Period 52. NUMBER(9,2)
|
|
|
pxrroec_pp53_hrs
|
Insurable Hours of the Pay Period 53. NUMBER(9,2)
|
|
|
pxrroec_bulk_file_name
|
ROE bulk transfer file name that is transmitted to Web ROE. VARCHAR2(30)
|
|
|
p_vac_roev_code
|
Canadian ROE vacation pay code. VARCHAR2(1)
|
|
|
p_vac_start_date
|
Start date for this payment. DATE
|
|
|
p_vac_end_date
|
End date for this payment. DATE
|
|
|
p_stat_hol_earn_code4
|
Statutory holiday pay earnings code 4. VARCHAR2(3)
|
|
|
p_stat_hol_date4
|
Statutory holiday date 4. DATE
|
|
|
p_stat_hol_grs4
|
Statutory holiday pay amount 4. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code5
|
Statutory holiday pay earnings code 5. VARCHAR2(3)
|
|
|
p_stat_hol_date5
|
Statutory holiday date 5. DATE
|
|
|
p_stat_hol_grs5
|
Statutory holiday pay amount 5. NUMBER(11,2)
|
|
|
p_other_start_date1
|
Other monies start date for payment 1. DATE
|
|
|
p_other_end_date1
|
Other monies end date for payment 1. DATE
|
|
|
p_other_start_date2
|
Other monies start date for this payment 2. DATE
|
|
|
p_other_end_date2
|
Other monies end date for this payment 2. DATE
|
|
|
p_other_start_date3
|
Other monies start date for this payment 3. DATE
|
|
|
p_other_end_date3
|
Other monies end date for this payment 3. DATE
|
|
|
p_benefit_roes_code
|
Canadian ROE special payment code. VARCHAR2(5)
|
|
|
p_benefit_end_date
|
End date of the employee receive benefit. DATE
|
|
|
p_benefit_roes_code2
|
Canadian ROE special payment code 2. VARCHAR2(5)
|
|
|
p_benefit_grs2
|
The amount the employee will receive for benefit 2. NUMBER(11,2)
|
|
|
p_benefit_start_date2
|
Start date of the employee receive benefit 2. DATE
|
|
|
p_benefit_end_date2
|
End date of the employee receive benefit 2. DATE
|
|
|
p_benefit_day_week_ind2
|
The benefit payment period indicator2. VARCHAR2(1)
|
|
|
p_benefit_roes_code3
|
Canadian ROE special payment code 3. VARCHAR2(5)
|
|
|
p_benefit_grs3
|
The amount the employee will receive for benefit 3. NUMBER(11,2)
|
|
|
p_benefit_start_date3
|
Start date of the employee receive benefit 3. DATE
|
|
|
p_benefit_end_date3
|
End date of the employee receive benefit 3. DATE
|
|
|
p_benefit_day_week_ind3
|
The benefit payment period indicator3. VARCHAR2(1)
|
|
|
p_benefit_roes_code4
|
Canadian ROE special payment code 4. VARCHAR2(5)
|
|
|
p_benefit_grs4
|
The amount the employee will receive for benefit 4. NUMBER(11,2)
|
|
|
p_benefit_start_date4
|
Start date of the employee receive benefit 4. DATE
|
|
|
p_benefit_end_date4
|
End date of the employee receive benefit 4. DATE
|
|
|
p_benefit_day_week_ind4
|
The benefit payment period indicator4. VARCHAR2(1)
|
|
|
U if record is updated, I for inserted otherwise N. Nulls match Nulls.
|
f_isequal
Function f_isequal(rec_one record_of_employment_rec,
rec_two record_of_employment_rec) RETURN VARCHAR2
Compares two records for equality.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.
|
|
Y if all values in records are equal, otherwise N. Nulls match Nulls.
|
f_query_all
Function f_query_all(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE)
RETURN record_of_employment_ref
Selects all records for the entity.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
A cursor variable that will fetch a set of records.
|
f_query_one
Function f_query_one(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE)
RETURN record_of_employment_ref
Selects one record using key.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
A cursor variable that will fetch exactly one record.
|
f_query_by_rowid
Function f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
RETURN record_of_employment_ref
Selects one record using ROWID.
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18) Required
|
|
|
A cursor variable that will fetch exactly one record.
|
f_query_one_lock
Function f_query_one_lock(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN record_of_employment_ref
Selects one record and locks it.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
|
|
A cursor variable for one record, locking the record.
|
p_create
Procedure p_create(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_empr_fed_ein pxrroec.pxrroec_empr_fed_ein%TYPE,
p_print_ind pxrroec.pxrroec_print_ind%TYPE,
p_reprint_ind pxrroec.pxrroec_reprint_ind%TYPE,
p_serial_no pxrroec.pxrroec_serial_no%TYPE DEFAULT NULL,
p_amends_serial_no pxrroec.pxrroec_amends_serial_no%TYPE DEFAULT NULL,
p_language_ind pxrroec.pxrroec_language_ind%TYPE,
p_issue_date pxrroec.pxrroec_issue_date%TYPE,
p_reference_number pxrroec.pxrroec_reference_number%TYPE DEFAULT NULL,
p_sin pxrroec.pxrroec_sin%TYPE,
p_job_title pxrroec.pxrroec_job_title%TYPE DEFAULT NULL,
p_first_day_worked pxrroec.pxrroec_first_day_worked%TYPE,
p_last_day_worked pxrroec.pxrroec_last_day_worked%TYPE,
p_final_pay_date pxrroec.pxrroec_final_pay_date%TYPE,
p_recall_ind pxrroec.pxrroec_recall_ind%TYPE DEFAULT NULL,
p_recall_date pxrroec.pxrroec_recall_date%TYPE DEFAULT NULL,
p_roec_code pxrroec.pxrroec_roec_code%TYPE,
p_total_hrs pxrroec.pxrroec_total_hrs%TYPE,
p_total_grs pxrroec.pxrroec_total_grs%TYPE DEFAULT NULL,
p_1996_weeks pxrroec.pxrroec_1996_weeks%TYPE DEFAULT NULL,
p_1996_earnings pxrroec.pxrroec_1996_earnings%TYPE DEFAULT NULL,
p_contact_pidm pxrroec.pxrroec_contact_pidm%TYPE,
p_contact_tele_area_code pxrroec.pxrroec_contact_tele_area_code%TYPE,
p_contact_tele_number pxrroec.pxrroec_contact_tele_number%TYPE,
p_contact_tele_ext pxrroec.pxrroec_contact_tele_ext%TYPE DEFAULT NULL,
p_issuing_pidm pxrroec.pxrroec_issuing_pidm%TYPE,
p_issuing_tele_area_code pxrroec.pxrroec_issuing_tele_area_code%TYPE,
p_issuing_tele_number pxrroec.pxrroec_issuing_tele_number%TYPE,
p_issusing_tele_ext pxrroec.pxrroec_issusing_tele_ext%TYPE DEFAULT NULL,
p_earn_code_vac pxrroec.pxrroec_earn_code_vac%TYPE DEFAULT NULL,
p_vac_grs pxrroec.pxrroec_vac_grs%TYPE DEFAULT NULL,
p_stat_hol_earn_code1 pxrroec.pxrroec_stat_hol_earn_code1%TYPE DEFAULT NULL,
p_stat_hol_date1 pxrroec.pxrroec_stat_hol_date1%TYPE DEFAULT NULL,
p_stat_hol_grs1 pxrroec.pxrroec_stat_hol_grs1%TYPE DEFAULT NULL,
p_stat_hol_earn_code2 pxrroec.pxrroec_stat_hol_earn_code2%TYPE DEFAULT NULL,
p_stat_hol_date2 pxrroec.pxrroec_stat_hol_date2%TYPE DEFAULT NULL,
p_stat_hol_grs2 pxrroec.pxrroec_stat_hol_grs2%TYPE DEFAULT NULL,
p_stat_hol_earn_code3 pxrroec.pxrroec_stat_hol_earn_code3%TYPE DEFAULT NULL,
p_stat_hol_date3 pxrroec.pxrroec_stat_hol_date3%TYPE DEFAULT NULL,
p_stat_hol_grs3 pxrroec.pxrroec_stat_hol_grs3%TYPE DEFAULT NULL,
p_other_earn_code1 pxrroec.pxrroec_other_earn_code1%TYPE DEFAULT NULL,
p_other_earn_code1_grs pxrroec.pxrroec_other_earn_code1_grs%TYPE DEFAULT NULL,
p_other_earn_code2 pxrroec.pxrroec_other_earn_code2%TYPE DEFAULT NULL,
p_other_earn_code2_grs pxrroec.pxrroec_other_earn_code2_grs%TYPE DEFAULT NULL,
p_other_earn_code3 pxrroec.pxrroec_other_earn_code3%TYPE DEFAULT NULL,
p_other_earn_code3_grs pxrroec.pxrroec_other_earn_code3_grs%TYPE DEFAULT NULL,
p_benefit_ind pxrroec.pxrroec_benefit_ind%TYPE,
p_benefit_grs pxrroec.pxrroec_benefit_grs%TYPE DEFAULT NULL,
p_benefit_start_date pxrroec.pxrroec_benefit_start_date%TYPE DEFAULT NULL,
p_benefit_day_week_ind pxrroec.pxrroec_benefit_day_week_ind%TYPE DEFAULT NULL,
p_pp1_payno pxrroec.pxrroec_pp1_payno%TYPE DEFAULT NULL,
p_pp1_grs pxrroec.pxrroec_pp1_grs%TYPE DEFAULT NULL,
p_pp2_payno pxrroec.pxrroec_pp2_payno%TYPE DEFAULT NULL,
p_pp2_grs pxrroec.pxrroec_pp2_grs%TYPE DEFAULT NULL,
p_pp3_payno pxrroec.pxrroec_pp3_payno%TYPE DEFAULT NULL,
p_pp3_grs pxrroec.pxrroec_pp3_grs%TYPE DEFAULT NULL,
p_pp4_payno pxrroec.pxrroec_pp4_payno%TYPE DEFAULT NULL,
p_pp4_grs pxrroec.pxrroec_pp4_grs%TYPE DEFAULT NULL,
p_pp5_payno pxrroec.pxrroec_pp5_payno%TYPE DEFAULT NULL,
p_pp5_grs pxrroec.pxrroec_pp5_grs%TYPE DEFAULT NULL,
p_pp6_payno pxrroec.pxrroec_pp6_payno%TYPE DEFAULT NULL,
p_pp6_grs pxrroec.pxrroec_pp6_grs%TYPE DEFAULT NULL,
p_pp7_payno pxrroec.pxrroec_pp7_payno%TYPE DEFAULT NULL,
p_pp7_grs pxrroec.pxrroec_pp7_grs%TYPE DEFAULT NULL,
p_pp8_payno pxrroec.pxrroec_pp8_payno%TYPE DEFAULT NULL,
p_pp8_grs pxrroec.pxrroec_pp8_grs%TYPE DEFAULT NULL,
p_pp9_payno pxrroec.pxrroec_pp9_payno%TYPE DEFAULT NULL,
p_pp9_grs pxrroec.pxrroec_pp9_grs%TYPE DEFAULT NULL,
p_pp10_payno pxrroec.pxrroec_pp10_payno%TYPE DEFAULT NULL,
p_pp10_grs pxrroec.pxrroec_pp10_grs%TYPE DEFAULT NULL,
p_pp11_payno pxrroec.pxrroec_pp11_payno%TYPE DEFAULT NULL,
p_pp11_grs pxrroec.pxrroec_pp11_grs%TYPE DEFAULT NULL,
p_pp12_payno pxrroec.pxrroec_pp12_payno%TYPE DEFAULT NULL,
p_pp12_grs pxrroec.pxrroec_pp12_grs%TYPE DEFAULT NULL,
p_pp13_payno pxrroec.pxrroec_pp13_payno%TYPE DEFAULT NULL,
p_pp13_grs pxrroec.pxrroec_pp13_grs%TYPE DEFAULT NULL,
p_pp14_payno pxrroec.pxrroec_pp14_payno%TYPE DEFAULT NULL,
p_pp14_grs pxrroec.pxrroec_pp14_grs%TYPE DEFAULT NULL,
p_pp15_payno pxrroec.pxrroec_pp15_payno%TYPE DEFAULT NULL,
p_pp15_grs pxrroec.pxrroec_pp15_grs%TYPE DEFAULT NULL,
p_pp16_payno pxrroec.pxrroec_pp16_payno%TYPE DEFAULT NULL,
p_pp16_grs pxrroec.pxrroec_pp16_grs%TYPE DEFAULT NULL,
p_pp17_payno pxrroec.pxrroec_pp17_payno%TYPE DEFAULT NULL,
p_pp17_grs pxrroec.pxrroec_pp17_grs%TYPE DEFAULT NULL,
p_pp18_payno pxrroec.pxrroec_pp18_payno%TYPE DEFAULT NULL,
p_pp18_grs pxrroec.pxrroec_pp18_grs%TYPE DEFAULT NULL,
p_pp19_payno pxrroec.pxrroec_pp19_payno%TYPE DEFAULT NULL,
p_pp19_grs pxrroec.pxrroec_pp19_grs%TYPE DEFAULT NULL,
p_pp20_payno pxrroec.pxrroec_pp20_payno%TYPE DEFAULT NULL,
p_pp20_grs pxrroec.pxrroec_pp20_grs%TYPE DEFAULT NULL,
p_pp21_payno pxrroec.pxrroec_pp21_payno%TYPE DEFAULT NULL,
p_pp21_grs pxrroec.pxrroec_pp21_grs%TYPE DEFAULT NULL,
p_pp22_payno pxrroec.pxrroec_pp22_payno%TYPE DEFAULT NULL,
p_pp22_grs pxrroec.pxrroec_pp22_grs%TYPE DEFAULT NULL,
p_pp23_payno pxrroec.pxrroec_pp23_payno%TYPE DEFAULT NULL,
p_pp23_grs pxrroec.pxrroec_pp23_grs%TYPE DEFAULT NULL,
p_pp24_payno pxrroec.pxrroec_pp24_payno%TYPE DEFAULT NULL,
p_pp24_grs pxrroec.pxrroec_pp24_grs%TYPE DEFAULT NULL,
p_pp25_payno pxrroec.pxrroec_pp25_payno%TYPE DEFAULT NULL,
p_pp25_grs pxrroec.pxrroec_pp25_grs%TYPE DEFAULT NULL,
p_pp26_payno pxrroec.pxrroec_pp26_payno%TYPE DEFAULT NULL,
p_pp26_grs pxrroec.pxrroec_pp26_grs%TYPE DEFAULT NULL,
p_pp27_payno pxrroec.pxrroec_pp27_payno%TYPE DEFAULT NULL,
p_pp27_grs pxrroec.pxrroec_pp27_grs%TYPE DEFAULT NULL,
p_comment_line1 pxrroec.pxrroec_comment_line1%TYPE DEFAULT NULL,
p_comment_line2 pxrroec.pxrroec_comment_line2%TYPE DEFAULT NULL,
p_comment_line3 pxrroec.pxrroec_comment_line3%TYPE DEFAULT NULL,
p_comment_line4 pxrroec.pxrroec_comment_line4%TYPE DEFAULT NULL,
p_comment_line5 pxrroec.pxrroec_comment_line5%TYPE DEFAULT NULL,
p_comment_line6 pxrroec.pxrroec_comment_line6%TYPE DEFAULT NULL,
p_user_id pxrroec.pxrroec_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_money_type1 pxrroec.pxrroec_money_type1%TYPE DEFAULT NULL,
p_money_type2 pxrroec.pxrroec_money_type2%TYPE DEFAULT NULL,
p_money_type3 pxrroec.pxrroec_money_type3%TYPE DEFAULT NULL,
p_pp28_payno pxrroec.pxrroec_pp28_payno%TYPE DEFAULT NULL,
p_pp28_grs pxrroec.pxrroec_pp28_grs%TYPE DEFAULT NULL,
p_pp29_payno pxrroec.pxrroec_pp29_payno%TYPE DEFAULT NULL,
p_pp29_grs pxrroec.pxrroec_pp29_grs%TYPE DEFAULT NULL,
p_pp30_payno pxrroec.pxrroec_pp30_payno%TYPE DEFAULT NULL,
p_pp30_grs pxrroec.pxrroec_pp30_grs%TYPE DEFAULT NULL,
p_pp31_payno pxrroec.pxrroec_pp31_payno%TYPE DEFAULT NULL,
p_pp31_grs pxrroec.pxrroec_pp31_grs%TYPE DEFAULT NULL,
p_pp32_payno pxrroec.pxrroec_pp32_payno%TYPE DEFAULT NULL,
p_pp32_grs pxrroec.pxrroec_pp32_grs%TYPE DEFAULT NULL,
p_pp33_payno pxrroec.pxrroec_pp33_payno%TYPE DEFAULT NULL,
p_pp33_grs pxrroec.pxrroec_pp33_grs%TYPE DEFAULT NULL,
p_pp34_payno pxrroec.pxrroec_pp34_payno%TYPE DEFAULT NULL,
p_pp34_grs pxrroec.pxrroec_pp34_grs%TYPE DEFAULT NULL,
p_pp35_payno pxrroec.pxrroec_pp35_payno%TYPE DEFAULT NULL,
p_pp35_grs pxrroec.pxrroec_pp35_grs%TYPE DEFAULT NULL,
p_pp36_payno pxrroec.pxrroec_pp36_payno%TYPE DEFAULT NULL,
p_pp36_grs pxrroec.pxrroec_pp36_grs%TYPE DEFAULT NULL,
p_pp37_payno pxrroec.pxrroec_pp37_payno%TYPE DEFAULT NULL,
p_pp37_grs pxrroec.pxrroec_pp37_grs%TYPE DEFAULT NULL,
p_pp38_payno pxrroec.pxrroec_pp38_payno%TYPE DEFAULT NULL,
p_pp38_grs pxrroec.pxrroec_pp38_grs%TYPE DEFAULT NULL,
p_pp39_payno pxrroec.pxrroec_pp39_payno%TYPE DEFAULT NULL,
p_pp39_grs pxrroec.pxrroec_pp39_grs%TYPE DEFAULT NULL,
p_pp40_payno pxrroec.pxrroec_pp40_payno%TYPE DEFAULT NULL,
p_pp40_grs pxrroec.pxrroec_pp40_grs%TYPE DEFAULT NULL,
p_pp41_payno pxrroec.pxrroec_pp41_payno%TYPE DEFAULT NULL,
p_pp41_grs pxrroec.pxrroec_pp41_grs%TYPE DEFAULT NULL,
p_pp42_payno pxrroec.pxrroec_pp42_payno%TYPE DEFAULT NULL,
p_pp42_grs pxrroec.pxrroec_pp42_grs%TYPE DEFAULT NULL,
p_pp43_payno pxrroec.pxrroec_pp43_payno%TYPE DEFAULT NULL,
p_pp43_grs pxrroec.pxrroec_pp43_grs%TYPE DEFAULT NULL,
p_pp44_payno pxrroec.pxrroec_pp44_payno%TYPE DEFAULT NULL,
p_pp44_grs pxrroec.pxrroec_pp44_grs%TYPE DEFAULT NULL,
p_pp45_payno pxrroec.pxrroec_pp45_payno%TYPE DEFAULT NULL,
p_pp45_grs pxrroec.pxrroec_pp45_grs%TYPE DEFAULT NULL,
p_pp46_payno pxrroec.pxrroec_pp46_payno%TYPE DEFAULT NULL,
p_pp46_grs pxrroec.pxrroec_pp46_grs%TYPE DEFAULT NULL,
p_pp47_payno pxrroec.pxrroec_pp47_payno%TYPE DEFAULT NULL,
p_pp47_grs pxrroec.pxrroec_pp47_grs%TYPE DEFAULT NULL,
p_pp48_payno pxrroec.pxrroec_pp48_payno%TYPE DEFAULT NULL,
p_pp48_grs pxrroec.pxrroec_pp48_grs%TYPE DEFAULT NULL,
p_pp49_payno pxrroec.pxrroec_pp49_payno%TYPE DEFAULT NULL,
p_pp49_grs pxrroec.pxrroec_pp49_grs%TYPE DEFAULT NULL,
p_pp50_payno pxrroec.pxrroec_pp50_payno%TYPE DEFAULT NULL,
p_pp50_grs pxrroec.pxrroec_pp50_grs%TYPE DEFAULT NULL,
p_pp51_payno pxrroec.pxrroec_pp51_payno%TYPE DEFAULT NULL,
p_pp51_grs pxrroec.pxrroec_pp51_grs%TYPE DEFAULT NULL,
p_pp52_payno pxrroec.pxrroec_pp52_payno%TYPE DEFAULT NULL,
p_pp52_grs pxrroec.pxrroec_pp52_grs%TYPE DEFAULT NULL,
p_pp53_payno pxrroec.pxrroec_pp53_payno%TYPE DEFAULT NULL,
p_pp53_grs pxrroec.pxrroec_pp53_grs%TYPE DEFAULT NULL,
p_data_origin pxrroec.pxrroec_data_origin%TYPE DEFAULT NULL,
p_pp1_hrs pxrroec.pxrroec_pp1_hrs%TYPE DEFAULT NULL,
p_pp2_hrs pxrroec.pxrroec_pp2_hrs%TYPE DEFAULT NULL,
p_pp3_hrs pxrroec.pxrroec_pp3_hrs%TYPE DEFAULT NULL,
p_pp4_hrs pxrroec.pxrroec_pp4_hrs%TYPE DEFAULT NULL,
p_pp5_hrs pxrroec.pxrroec_pp5_hrs%TYPE DEFAULT NULL,
p_pp6_hrs pxrroec.pxrroec_pp6_hrs%TYPE DEFAULT NULL,
p_pp7_hrs pxrroec.pxrroec_pp7_hrs%TYPE DEFAULT NULL,
p_pp8_hrs pxrroec.pxrroec_pp8_hrs%TYPE DEFAULT NULL,
p_pp9_hrs pxrroec.pxrroec_pp9_hrs%TYPE DEFAULT NULL,
p_pp10_hrs pxrroec.pxrroec_pp10_hrs%TYPE DEFAULT NULL,
p_pp11_hrs pxrroec.pxrroec_pp11_hrs%TYPE DEFAULT NULL,
p_pp12_hrs pxrroec.pxrroec_pp12_hrs%TYPE DEFAULT NULL,
p_pp13_hrs pxrroec.pxrroec_pp13_hrs%TYPE DEFAULT NULL,
p_pp14_hrs pxrroec.pxrroec_pp14_hrs%TYPE DEFAULT NULL,
p_pp15_hrs pxrroec.pxrroec_pp15_hrs%TYPE DEFAULT NULL,
p_pp16_hrs pxrroec.pxrroec_pp16_hrs%TYPE DEFAULT NULL,
p_pp17_hrs pxrroec.pxrroec_pp17_hrs%TYPE DEFAULT NULL,
p_pp18_hrs pxrroec.pxrroec_pp18_hrs%TYPE DEFAULT NULL,
p_pp19_hrs pxrroec.pxrroec_pp19_hrs%TYPE DEFAULT NULL,
p_pp20_hrs pxrroec.pxrroec_pp20_hrs%TYPE DEFAULT NULL,
p_pp21_hrs pxrroec.pxrroec_pp21_hrs%TYPE DEFAULT NULL,
p_pp22_hrs pxrroec.pxrroec_pp22_hrs%TYPE DEFAULT NULL,
p_pp23_hrs pxrroec.pxrroec_pp23_hrs%TYPE DEFAULT NULL,
p_pp24_hrs pxrroec.pxrroec_pp24_hrs%TYPE DEFAULT NULL,
p_pp25_hrs pxrroec.pxrroec_pp25_hrs%TYPE DEFAULT NULL,
p_pp26_hrs pxrroec.pxrroec_pp26_hrs%TYPE DEFAULT NULL,
p_pp27_hrs pxrroec.pxrroec_pp27_hrs%TYPE DEFAULT NULL,
p_pp28_hrs pxrroec.pxrroec_pp28_hrs%TYPE DEFAULT NULL,
p_pp29_hrs pxrroec.pxrroec_pp29_hrs%TYPE DEFAULT NULL,
p_pp30_hrs pxrroec.pxrroec_pp30_hrs%TYPE DEFAULT NULL,
p_pp31_hrs pxrroec.pxrroec_pp31_hrs%TYPE DEFAULT NULL,
p_pp32_hrs pxrroec.pxrroec_pp32_hrs%TYPE DEFAULT NULL,
p_pp33_hrs pxrroec.pxrroec_pp33_hrs%TYPE DEFAULT NULL,
p_pp34_hrs pxrroec.pxrroec_pp34_hrs%TYPE DEFAULT NULL,
p_pp35_hrs pxrroec.pxrroec_pp35_hrs%TYPE DEFAULT NULL,
p_pp36_hrs pxrroec.pxrroec_pp36_hrs%TYPE DEFAULT NULL,
p_pp37_hrs pxrroec.pxrroec_pp37_hrs%TYPE DEFAULT NULL,
p_pp38_hrs pxrroec.pxrroec_pp38_hrs%TYPE DEFAULT NULL,
p_pp39_hrs pxrroec.pxrroec_pp39_hrs%TYPE DEFAULT NULL,
p_pp40_hrs pxrroec.pxrroec_pp40_hrs%TYPE DEFAULT NULL,
p_pp41_hrs pxrroec.pxrroec_pp41_hrs%TYPE DEFAULT NULL,
p_pp42_hrs pxrroec.pxrroec_pp42_hrs%TYPE DEFAULT NULL,
p_pp43_hrs pxrroec.pxrroec_pp43_hrs%TYPE DEFAULT NULL,
p_pp44_hrs pxrroec.pxrroec_pp44_hrs%TYPE DEFAULT NULL,
p_pp45_hrs pxrroec.pxrroec_pp45_hrs%TYPE DEFAULT NULL,
p_pp46_hrs pxrroec.pxrroec_pp46_hrs%TYPE DEFAULT NULL,
p_pp47_hrs pxrroec.pxrroec_pp47_hrs%TYPE DEFAULT NULL,
p_pp48_hrs pxrroec.pxrroec_pp48_hrs%TYPE DEFAULT NULL,
p_pp49_hrs pxrroec.pxrroec_pp49_hrs%TYPE DEFAULT NULL,
p_pp50_hrs pxrroec.pxrroec_pp50_hrs%TYPE DEFAULT NULL,
p_pp51_hrs pxrroec.pxrroec_pp51_hrs%TYPE DEFAULT NULL,
p_pp52_hrs pxrroec.pxrroec_pp52_hrs%TYPE DEFAULT NULL,
p_pp53_hrs pxrroec.pxrroec_pp53_hrs%TYPE DEFAULT NULL,
p_bulk_file_name pxrroec.pxrroec_bulk_file_name%TYPE DEFAULT NULL,
p_vac_roev_code pxrroec.pxrroec_vac_roev_code%TYPE DEFAULT NULL,
p_vac_start_date pxrroec.pxrroec_vac_start_date%TYPE DEFAULT NULL,
p_vac_end_date pxrroec.pxrroec_vac_end_date%TYPE DEFAULT NULL,
p_stat_hol_earn_code4 pxrroec.pxrroec_stat_hol_earn_code4%TYPE DEFAULT NULL,
p_stat_hol_date4 pxrroec.pxrroec_stat_hol_date4%TYPE DEFAULT NULL,
p_stat_hol_grs4 pxrroec.pxrroec_stat_hol_grs4%TYPE DEFAULT NULL,
p_stat_hol_earn_code5 pxrroec.pxrroec_stat_hol_earn_code5%TYPE DEFAULT NULL,
p_stat_hol_date5 pxrroec.pxrroec_stat_hol_date5%TYPE DEFAULT NULL,
p_stat_hol_grs5 pxrroec.pxrroec_stat_hol_grs5%TYPE DEFAULT NULL,
p_other_start_date1 pxrroec.pxrroec_other_start_date1%TYPE DEFAULT NULL,
p_other_end_date1 pxrroec.pxrroec_other_end_date1%TYPE DEFAULT NULL,
p_other_start_date2 pxrroec.pxrroec_other_start_date2%TYPE DEFAULT NULL,
p_other_end_date2 pxrroec.pxrroec_other_end_date2%TYPE DEFAULT NULL,
p_other_start_date3 pxrroec.pxrroec_other_start_date3%TYPE DEFAULT NULL,
p_other_end_date3 pxrroec.pxrroec_other_end_date3%TYPE DEFAULT NULL,
p_benefit_roes_code pxrroec.pxrroec_benefit_roes_code%TYPE DEFAULT NULL,
p_benefit_end_date pxrroec.pxrroec_benefit_end_date%TYPE DEFAULT NULL,
p_benefit_roes_code2 pxrroec.pxrroec_benefit_roes_code2%TYPE DEFAULT NULL,
p_benefit_grs2 pxrroec.pxrroec_benefit_grs2%TYPE DEFAULT NULL,
p_benefit_start_date2 pxrroec.pxrroec_benefit_start_date2%TYPE DEFAULT NULL,
p_benefit_end_date2 pxrroec.pxrroec_benefit_end_date2%TYPE DEFAULT NULL,
p_benefit_day_week_ind2 pxrroec.pxrroec_benefit_day_week_ind2%TYPE DEFAULT NULL,
p_benefit_roes_code3 pxrroec.pxrroec_benefit_roes_code3%TYPE DEFAULT NULL,
p_benefit_grs3 pxrroec.pxrroec_benefit_grs3%TYPE DEFAULT NULL,
p_benefit_start_date3 pxrroec.pxrroec_benefit_start_date3%TYPE DEFAULT NULL,
p_benefit_end_date3 pxrroec.pxrroec_benefit_end_date3%TYPE DEFAULT NULL,
p_benefit_day_week_ind3 pxrroec.pxrroec_benefit_day_week_ind3%TYPE DEFAULT NULL,
p_benefit_roes_code4 pxrroec.pxrroec_benefit_roes_code4%TYPE DEFAULT NULL,
p_benefit_grs4 pxrroec.pxrroec_benefit_grs4%TYPE DEFAULT NULL,
p_benefit_start_date4 pxrroec.pxrroec_benefit_start_date4%TYPE DEFAULT NULL,
p_benefit_end_date4 pxrroec.pxrroec_benefit_end_date4%TYPE DEFAULT NULL,
p_benefit_day_week_ind4 pxrroec.pxrroec_benefit_day_week_ind4%TYPE DEFAULT NULL,
p_rowid_out OUT gb_common.internal_record_id_type)
Creates a record.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_empr_fed_ein
|
Revenue Canada Business Number. VARCHAR2(15) Required
|
|
|
p_print_ind
|
Ready to print indicator. VARCHAR2(1) Required
|
|
|
p_reprint_ind
|
Reprint amend indicator. VARCHAR2(1) Required
|
|
|
p_serial_no
|
Serial number of ROE record. VARCHAR2(9)
|
|
|
p_amends_serial_no
|
Amended serial number of ROE amended or replaced. VARCHAR2(12)
|
|
|
p_language_ind
|
The preferred language indicator of the issuing employer. VARCHAR2(1) Required
|
|
|
p_issue_date
|
Issued Date of the ROE record. DATE Required
|
|
|
p_reference_number
|
Reference Number used by the employer to identify the employee. VARCHAR2(12)
|
|
|
p_sin
|
The Employee social insurance number. VARCHAR2(9) Required
|
|
|
p_job_title
|
Employee job title. VARCHAR2(40)
|
|
|
p_first_day_worked
|
Employee first worked date. DATE Required
|
|
|
p_last_day_worked
|
Employee last worked date. DATE Required
|
|
|
p_final_pay_date
|
Employee final paid date. DATE Required
|
|
|
p_recall_ind
|
The employee return to active employment indicator. VARCHAR2(1)
|
|
|
p_recall_date
|
The expected date of the employee return to active employment. DATE
|
|
|
p_roec_code
|
Reason of the employer issuing this ROE. VARCHAR2(3) Required
|
|
|
p_total_hrs
|
The total insurable hours worked by the employee in the last 52 weeks. NUMBER(11,2) Required
|
|
|
p_total_grs
|
The sum of applicable gross of all EI deduction records in the last 52 weeks. NUMBER(11,2)
|
|
|
p_1996_weeks
|
1996 Employment history insurable weeks. NUMBER(,)
|
|
|
p_1996_earnings
|
1996 Employment history insurable earnings. NUMBER(,)
|
|
|
p_contact_pidm
|
Employee Identification number to be contacted. NUMBER(8) Required
|
|
|
p_contact_tele_area_code
|
Employee phone number area code to be contacted. VARCHAR2(3) Required
|
|
|
p_contact_tele_number
|
Employee phone number to be contacted. VARCHAR2(7) Required
|
|
|
p_contact_tele_ext
|
Employee phone number extention to be contacted. VARCHAR2(4)
|
|
|
p_issuing_pidm
|
Issuing person identification number. NUMBER(8) Required
|
|
|
p_issuing_tele_area_code
|
Issuing person telephone number area code. VARCHAR2(3) Required
|
|
|
p_issuing_tele_number
|
Issuing person telephone number. VARCHAR2(7) Required
|
|
|
p_issusing_tele_ext
|
Issuing person telephone number extention. VARCHAR2(4)
|
|
|
p_earn_code_vac
|
Vacation pay earnings code. VARCHAR2(3)
|
|
|
p_vac_grs
|
Vacation pay amount. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code1
|
Statutory holiday pay earnings code 1. VARCHAR2(3)
|
|
|
p_stat_hol_date1
|
Statutory holiday date 1. DATE
|
|
|
p_stat_hol_grs1
|
Statutory holiday pay amount 1. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code2
|
Statutory holiday pay earnings code 2. VARCHAR2(3)
|
|
|
p_stat_hol_date2
|
Statutory holiday date 2. DATE
|
|
|
p_stat_hol_grs2
|
Statutory holiday pay amount 2. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code3
|
Statutory holiday pay earnings code 3. VARCHAR2(3)
|
|
|
p_stat_hol_date3
|
Statutory holiday date 3. DATE
|
|
|
p_stat_hol_grs3
|
Statutory holiday pay amount 3. NUMBER(11,2)
|
|
|
p_other_earn_code1
|
Other monies earning code 1. VARCHAR2(3)
|
|
|
p_other_earn_code1_grs
|
Other monies earning amount 1. NUMBER(11,2)
|
|
|
p_other_earn_code2
|
Other monies earning code 2. VARCHAR2(3)
|
|
|
p_other_earn_code2_grs
|
Other monies earning amount 2. NUMBER(11,2)
|
|
|
p_other_earn_code3
|
Other monies earning code 3. VARCHAR2(3)
|
|
|
p_other_earn_code3_grs
|
Other monies earning amount 3. NUMBER(11,2)
|
|
|
p_benefit_ind
|
Will the employee be receiving benefit indicator. VARCHAR2(1) Required
|
|
|
p_benefit_grs
|
The amount the employee will receive for benefit. NUMBER(11,2)
|
|
|
p_benefit_start_date
|
Start date of the employee receive benefit. DATE
|
|
|
p_benefit_day_week_ind
|
The benefit payment period indicator. VARCHAR2(1)
|
|
|
p_pp1_payno
|
Pay period breakdown number 1. VARCHAR2(3)
|
|
|
p_pp1_grs
|
Pay period amount breakdown number 1. NUMBER(11,2)
|
|
|
p_pp2_payno
|
Pay period breakdown number 2. VARCHAR2(3)
|
|
|
p_pp2_grs
|
Pay period amount breakdown number 2. NUMBER(,)
|
|
|
p_pp3_payno
|
Pay period breakdown number 3. VARCHAR2(3)
|
|
|
p_pp3_grs
|
Pay period amount breakdown number 3. NUMBER(,)
|
|
|
p_pp4_payno
|
Pay period breakdown number 4. VARCHAR2(3)
|
|
|
p_pp4_grs
|
Pay period amount breakdown number 4. NUMBER(,)
|
|
|
p_pp5_payno
|
Pay period breakdown number 5. VARCHAR2(3)
|
|
|
p_pp5_grs
|
Pay period amount breakdown number 5. NUMBER(,)
|
|
|
p_pp6_payno
|
Pay period breakdown number 6. VARCHAR2(3)
|
|
|
p_pp6_grs
|
Pay period amount breakdown number 6. NUMBER(,)
|
|
|
p_pp7_payno
|
Pay period breakdown number 7. VARCHAR2(3)
|
|
|
p_pp7_grs
|
Pay period amount breakdown number 7. NUMBER(,)
|
|
|
p_pp8_payno
|
Pay period breakdown number 8. VARCHAR2(3)
|
|
|
p_pp8_grs
|
Pay period amount breakdown number 8. NUMBER(,)
|
|
|
p_pp9_payno
|
Pay period breakdown number 9. VARCHAR2(3)
|
|
|
p_pp9_grs
|
Pay period amount breakdown number 9. NUMBER(,)
|
|
|
p_pp10_payno
|
Pay period breakdown number 10. VARCHAR2(3)
|
|
|
p_pp10_grs
|
Pay period amount breakdown number 10. NUMBER(,)
|
|
|
p_pp11_payno
|
Pay period breakdown number 11. VARCHAR2(3)
|
|
|
p_pp11_grs
|
Pay period amount breakdown number 11. NUMBER(,)
|
|
|
p_pp12_payno
|
Pay period breakdown number 12. VARCHAR2(3)
|
|
|
p_pp12_grs
|
Pay period amount breakdown number 12. NUMBER(,)
|
|
|
p_pp13_payno
|
Pay period breakdown number 13. VARCHAR2(3)
|
|
|
p_pp13_grs
|
Pay period amount breakdown number 13. NUMBER(,)
|
|
|
p_pp14_payno
|
Pay period breakdown number 14. VARCHAR2(3)
|
|
|
p_pp14_grs
|
Pay period amount breakdown number 14. NUMBER(,)
|
|
|
p_pp15_payno
|
Pay period breakdown number 15. VARCHAR2(3)
|
|
|
p_pp15_grs
|
Pay period amount breakdown number 15. NUMBER(,)
|
|
|
p_pp16_payno
|
Pay period breakdown number 16. VARCHAR2(3)
|
|
|
p_pp16_grs
|
Pay period amount breakdown number 16. NUMBER(,)
|
|
|
p_pp17_payno
|
Pay period breakdown number 17. VARCHAR2(3)
|
|
|
p_pp17_grs
|
Pay period amount breakdown number 17. NUMBER(,)
|
|
|
p_pp18_payno
|
Pay period breakdown number 18. VARCHAR2(3)
|
|
|
p_pp18_grs
|
Pay period amount breakdown number 18. NUMBER(,)
|
|
|
p_pp19_payno
|
Pay period breakdown number 19. VARCHAR2(3)
|
|
|
p_pp19_grs
|
Pay period amount breakdown number 19. NUMBER(,)
|
|
|
p_pp20_payno
|
Pay period breakdown number 20. VARCHAR2(3)
|
|
|
p_pp20_grs
|
Pay period amount breakdown number 20. NUMBER(,)
|
|
|
p_pp21_payno
|
Pay period breakdown number 21. VARCHAR2(3)
|
|
|
p_pp21_grs
|
Pay period amount breakdown number 21. NUMBER(,)
|
|
|
p_pp22_payno
|
Pay period breakdown number 22. VARCHAR2(3)
|
|
|
p_pp22_grs
|
Pay period amount breakdown number 22. NUMBER(,)
|
|
|
p_pp23_payno
|
Pay period breakdown number 23. VARCHAR2(3)
|
|
|
p_pp23_grs
|
Pay period amount breakdown number 23. NUMBER(,)
|
|
|
p_pp24_payno
|
Pay period breakdown number 24. VARCHAR2(3)
|
|
|
p_pp24_grs
|
Pay period amount breakdown number 24. NUMBER(,)
|
|
|
p_pp25_payno
|
Pay period breakdown number 25. VARCHAR2(3)
|
|
|
p_pp25_grs
|
Pay period amount breakdown number 25. NUMBER(,)
|
|
|
p_pp26_payno
|
Pay period breakdown number 26. VARCHAR2(3)
|
|
|
p_pp26_grs
|
Pay period amount breakdown number 26. NUMBER(,)
|
|
|
p_pp27_payno
|
Pay period breakdown number 27. VARCHAR2(3)
|
|
|
p_pp27_grs
|
Pay period amount breakdown number 27. NUMBER(,)
|
|
|
p_comment_line1
|
Comment of the record line 1. VARCHAR2(38)
|
|
|
p_comment_line2
|
Comment of the record line 2. VARCHAR2(38)
|
|
|
p_comment_line3
|
Comment of the record line 3. VARCHAR2(38)
|
|
|
p_comment_line4
|
Comment of the record line 4. VARCHAR2(38)
|
|
|
p_comment_line5
|
Comment of the record line 5. VARCHAR2(38)
|
|
|
p_comment_line6
|
Comment of the record line 6. VARCHAR2(38)
|
|
|
p_user_id
|
VARCHAR2(30) Required
|
|
|
p_money_type1
|
PXRROEC_MONEY_TYPE1 This field indicates Canadian ROE Types of Other Money1. VARCHAR2(1)
|
|
|
p_money_type2
|
PXRROEC_MONEY_TYPE2 This field indicates Canadian ROE Types of Other Money2. VARCHAR2(1)
|
|
|
p_money_type3
|
PXRROEC_MONEY_TYPE3 This field indicates Canadian ROE Types of Other Money3. VARCHAR2(1)
|
|
|
p_pp28_payno
|
Pay period breakdown number 28. NUMBER(9,2)
|
|
|
p_pp28_grs
|
Pay period amount breakdown number 28. NUMBER(9,2)
|
|
|
p_pp29_payno
|
Pay period breakdown number 29. NUMBER(9,2)
|
|
|
p_pp29_grs
|
Pay period amount breakdown number 29. NUMBER(9,2)
|
|
|
p_pp30_payno
|
Pay period breakdown number 30. NUMBER(9,2)
|
|
|
p_pp30_grs
|
Pay period amount breakdown number 30. NUMBER(9,2)
|
|
|
p_pp31_payno
|
Pay period breakdown number 31. NUMBER(9,2)
|
|
|
p_pp31_grs
|
Pay period amount breakdown number 31. NUMBER(9,2)
|
|
|
p_pp32_payno
|
Pay period breakdown number 32. NUMBER(9,2)
|
|
|
p_pp32_grs
|
Pay period amount breakdown number 32. NUMBER(9,2)
|
|
|
p_pp33_payno
|
Pay period breakdown number 33. NUMBER(9,2)
|
|
|
p_pp33_grs
|
Pay period amount breakdown number 33. NUMBER(9,2)
|
|
|
p_pp34_payno
|
Pay period breakdown number 34. NUMBER(9,2)
|
|
|
p_pp34_grs
|
Pay period amount breakdown number 34. NUMBER(9,2)
|
|
|
p_pp35_payno
|
Pay period breakdown number 35. NUMBER(9,2)
|
|
|
p_pp35_grs
|
Pay period amount breakdown number 35. NUMBER(9,2)
|
|
|
p_pp36_payno
|
Pay period breakdown number 36. NUMBER(9,2)
|
|
|
p_pp36_grs
|
Pay period amount breakdown number 36. NUMBER(9,2)
|
|
|
p_pp37_payno
|
Pay period breakdown number 37. NUMBER(9,2)
|
|
|
p_pp37_grs
|
Pay period amount breakdown number 37. NUMBER(9,2)
|
|
|
p_pp38_payno
|
Pay period breakdown number 38. NUMBER(9,2)
|
|
|
p_pp38_grs
|
Pay period amount breakdown number 38. NUMBER(9,2)
|
|
|
p_pp39_payno
|
Pay period breakdown number 39. NUMBER(9,2)
|
|
|
p_pp39_grs
|
Pay period amount breakdown number 39. NUMBER(9,2)
|
|
|
p_pp40_payno
|
Pay period breakdown number 40. NUMBER(9,2)
|
|
|
p_pp40_grs
|
Pay period amount breakdown number 40. NUMBER(9,2)
|
|
|
p_pp41_payno
|
Pay period breakdown number 41. NUMBER(9,2)
|
|
|
p_pp41_grs
|
Pay period amount breakdown number 41. NUMBER(9,2)
|
|
|
p_pp42_payno
|
Pay period breakdown number 42. NUMBER(9,2)
|
|
|
p_pp42_grs
|
Pay period amount breakdown number 42. NUMBER(9,2)
|
|
|
p_pp43_payno
|
Pay period breakdown number 43. NUMBER(9,2)
|
|
|
p_pp43_grs
|
Pay period amount breakdown number 43. NUMBER(9,2)
|
|
|
p_pp44_payno
|
Pay period breakdown number 44. NUMBER(9,2)
|
|
|
p_pp44_grs
|
Pay period amount breakdown number 44. NUMBER(9,2)
|
|
|
p_pp45_payno
|
Pay period breakdown number 45. NUMBER(9,2)
|
|
|
p_pp45_grs
|
Pay period amount breakdown number 45. NUMBER(9,2)
|
|
|
p_pp46_payno
|
Pay period breakdown number 46. NUMBER(9,2)
|
|
|
p_pp46_grs
|
Pay period amount breakdown number 46. NUMBER(9,2)
|
|
|
p_pp47_payno
|
Pay period breakdown number 47. NUMBER(9,2)
|
|
|
p_pp47_grs
|
Pay period amount breakdown number 47. NUMBER(9,2)
|
|
|
p_pp48_payno
|
Pay period breakdown number 48. NUMBER(9,2)
|
|
|
p_pp48_grs
|
Pay period amount breakdown number 48. NUMBER(9,2)
|
|
|
p_pp49_payno
|
Pay period breakdown number 49. NUMBER(9,2)
|
|
|
p_pp49_grs
|
Pay period amount breakdown number 49. NUMBER(9,2)
|
|
|
p_pp50_payno
|
Pay period breakdown number 50. NUMBER(9,2)
|
|
|
p_pp50_grs
|
Pay period amount breakdown number 50. NUMBER(9,2)
|
|
|
p_pp51_payno
|
Pay period breakdown number 51. NUMBER(9,2)
|
|
|
p_pp51_grs
|
Pay period amount breakdown number 51. NUMBER(9,2)
|
|
|
p_pp52_payno
|
Pay period breakdown number 52. NUMBER(9,2)
|
|
|
p_pp52_grs
|
Pay period amount breakdown number 52. NUMBER(9,2)
|
|
|
p_pp53_payno
|
Pay period breakdown number 53. NUMBER(9,2)
|
|
|
p_pp53_grs
|
Pay period amount breakdown number 53. NUMBER(9,2)
|
|
|
p_data_origin
|
DATA ORIGIN: Source system that created or updated the row. VARCHAR2(30)
|
|
|
pxrroec_pp1_hrs
|
Insurable Hours of the Pay Period 1. NUMBER(9,2)
|
|
|
pxrroec_pp2_hrs
|
Insurable Hours of the Pay Period 2. NUMBER(9,2)
|
|
|
pxrroec_pp3_hrs
|
Insurable Hours of the Pay Period 3. NUMBER(9,2)
|
|
|
pxrroec_pp4_hrs
|
Insurable Hours of the Pay Period 4. NUMBER(9,2)
|
|
|
pxrroec_pp5_hrs
|
Insurable Hours of the Pay Period 5. NUMBER(9,2)
|
|
|
pxrroec_pp6_hrs
|
Insurable Hours of the Pay Period 6. NUMBER(9,2)
|
|
|
pxrroec_pp7_hrs
|
Insurable Hours of the Pay Period 7. NUMBER(9,2)
|
|
|
pxrroec_pp8_hrs
|
Insurable Hours of the Pay Period 8. NUMBER(9,2)
|
|
|
pxrroec_pp9_hrs
|
Insurable Hours of the Pay Period 9. NUMBER(9,2)
|
|
|
pxrroec_pp10_hrs
|
Insurable Hours of the Pay Period 10. NUMBER(9,2)
|
|
|
pxrroec_pp11_hrs
|
Insurable Hours of the Pay Period 11. NUMBER(9,2)
|
|
|
pxrroec_pp12_hrs
|
Insurable Hours of the Pay Period 12. NUMBER(9,2)
|
|
|
pxrroec_pp13_hrs
|
Insurable Hours of the Pay Period 13. NUMBER(9,2)
|
|
|
pxrroec_pp14_hrs
|
Insurable Hours of the Pay Period 14. NUMBER(9,2)
|
|
|
pxrroec_pp15_hrs
|
Insurable Hours of the Pay Period 15. NUMBER(9,2)
|
|
|
pxrroec_pp16_hrs
|
Insurable Hours of the Pay Period 16. NUMBER(9,2)
|
|
|
pxrroec_pp17_hrs
|
Insurable Hours of the Pay Period 17. NUMBER(9,2)
|
|
|
pxrroec_pp18_hrs
|
Insurable Hours of the Pay Period 18. NUMBER(9,2)
|
|
|
pxrroec_pp19_hrs
|
Insurable Hours of the Pay Period 19. NUMBER(9,2)
|
|
|
pxrroec_pp20_hrs
|
Insurable Hours of the Pay Period 20. NUMBER(9,2)
|
|
|
pxrroec_pp21_hrs
|
Insurable Hours of the Pay Period 21. NUMBER(9,2)
|
|
|
pxrroec_pp22_hrs
|
Insurable Hours of the Pay Period 22. NUMBER(9,2)
|
|
|
pxrroec_pp23_hrs
|
Insurable Hours of the Pay Period 23. NUMBER(9,2)
|
|
|
pxrroec_pp24_hrs
|
Insurable Hours of the Pay Period 24. NUMBER(9,2)
|
|
|
pxrroec_pp25_hrs
|
Insurable Hours of the Pay Period 25. NUMBER(9,2)
|
|
|
pxrroec_pp26_hrs
|
Insurable Hours of the Pay Period 26. NUMBER(9,2)
|
|
|
pxrroec_pp27_hrs
|
Insurable Hours of the Pay Period 27. NUMBER(9,2)
|
|
|
pxrroec_pp28_hrs
|
Insurable Hours of the Pay Period 28. NUMBER(9,2)
|
|
|
pxrroec_pp29_hrs
|
Insurable Hours of the Pay Period 29. NUMBER(9,2)
|
|
|
pxrroec_pp30_hrs
|
Insurable Hours of the Pay Period 30. NUMBER(9,2)
|
|
|
pxrroec_pp31_hrs
|
Insurable Hours of the Pay Period 31. NUMBER(9,2)
|
|
|
pxrroec_pp32_hrs
|
Insurable Hours of the Pay Period 32. NUMBER(9,2)
|
|
|
pxrroec_pp33_hrs
|
Insurable Hours of the Pay Period 33. NUMBER(9,2)
|
|
|
pxrroec_pp34_hrs
|
Insurable Hours of the Pay Period 34. NUMBER(9,2)
|
|
|
pxrroec_pp35_hrs
|
Insurable Hours of the Pay Period 35. NUMBER(9,2)
|
|
|
pxrroec_pp36_hrs
|
Insurable Hours of the Pay Period 36. NUMBER(9,2)
|
|
|
pxrroec_pp37_hrs
|
Insurable Hours of the Pay Period 37. NUMBER(9,2)
|
|
|
pxrroec_pp38_hrs
|
Insurable Hours of the Pay Period 38. NUMBER(9,2)
|
|
|
pxrroec_pp39_hrs
|
Insurable Hours of the Pay Period 39. NUMBER(9,2)
|
|
|
pxrroec_pp40_hrs
|
Insurable Hours of the Pay Period 40. NUMBER(9,2)
|
|
|
pxrroec_pp41_hrs
|
Insurable Hours of the Pay Period 41. NUMBER(9,2)
|
|
|
pxrroec_pp42_hrs
|
Insurable Hours of the Pay Period 42. NUMBER(9,2)
|
|
|
pxrroec_pp43_hrs
|
Insurable Hours of the Pay Period 43. NUMBER(9,2)
|
|
|
pxrroec_pp44_hrs
|
Insurable Hours of the Pay Period 44. NUMBER(9,2)
|
|
|
pxrroec_pp45_hrs
|
Insurable Hours of the Pay Period 45. NUMBER(9,2)
|
|
|
pxrroec_pp46_hrs
|
Insurable Hours of the Pay Period 46. NUMBER(9,2)
|
|
|
pxrroec_pp47_hrs
|
Insurable Hours of the Pay Period 47. NUMBER(9,2)
|
|
|
pxrroec_pp48_hrs
|
Insurable Hours of the Pay Period 48. NUMBER(9,2)
|
|
|
pxrroec_pp49_hrs
|
Insurable Hours of the Pay Period 49. NUMBER(9,2)
|
|
|
pxrroec_pp50_hrs
|
Insurable Hours of the Pay Period 50. NUMBER(9,2)
|
|
|
pxrroec_pp51_hrs
|
Insurable Hours of the Pay Period 51. NUMBER(9,2)
|
|
|
pxrroec_pp52_hrs
|
Insurable Hours of the Pay Period 52. NUMBER(9,2)
|
|
|
pxrroec_pp53_hrs
|
Insurable Hours of the Pay Period 53. NUMBER(9,2)
|
|
|
pxrroec_bulk_file_name
|
ROE bulk transfer file name that is transmitted to Web ROE. VARCHAR2(30)
|
|
|
p_vac_roev_code
|
Canadian ROE vacation pay code. VARCHAR2(1)
|
|
|
p_vac_start_date
|
Start date for this payment. DATE
|
|
|
p_vac_end_date
|
End date for this payment. DATE
|
|
|
p_stat_hol_earn_code4
|
Statutory holiday pay earnings code 4. VARCHAR2(3)
|
|
|
p_stat_hol_date4
|
Statutory holiday date 4. DATE
|
|
|
p_stat_hol_grs4
|
Statutory holiday pay amount 4. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code5
|
Statutory holiday pay earnings code 5. VARCHAR2(3)
|
|
|
p_stat_hol_date5
|
Statutory holiday date 5. DATE
|
|
|
p_stat_hol_grs5
|
Statutory holiday pay amount 5. NUMBER(11,2)
|
|
|
p_other_start_date1
|
Other monies start date for payment 1. DATE
|
|
|
p_other_end_date1
|
Other monies end date for payment 1. DATE
|
|
|
p_other_start_date2
|
Other monies start date for this payment 2. DATE
|
|
|
p_other_end_date2
|
Other monies end date for this payment 2. DATE
|
|
|
p_other_start_date3
|
Other monies start date for this payment 3. DATE
|
|
|
p_other_end_date3
|
Other monies end date for this payment 3. DATE
|
|
|
p_benefit_roes_code
|
Canadian ROE special payment code. VARCHAR2(5)
|
|
|
p_benefit_end_date
|
End date of the employee receive benefit. DATE
|
|
|
p_benefit_roes_code2
|
Canadian ROE special payment code 2. VARCHAR2(5)
|
|
|
p_benefit_grs2
|
The amount the employee will receive for benefit 2. NUMBER(11,2)
|
|
|
p_benefit_start_date2
|
Start date of the employee receive benefit 2. DATE
|
|
|
p_benefit_end_date2
|
End date of the employee receive benefit 2. DATE
|
|
|
p_benefit_day_week_ind2
|
The benefit payment period indicator2. VARCHAR2(1)
|
|
|
p_benefit_roes_code3
|
Canadian ROE special payment code 3. VARCHAR2(5)
|
|
|
p_benefit_grs3
|
The amount the employee will receive for benefit 3. NUMBER(11,2)
|
|
|
p_benefit_start_date3
|
Start date of the employee receive benefit 3. DATE
|
|
|
p_benefit_end_date3
|
End date of the employee receive benefit 3. DATE
|
|
|
p_benefit_day_week_ind3
|
The benefit payment period indicator3. VARCHAR2(1)
|
|
|
p_benefit_roes_code4
|
Canadian ROE special payment code 4. VARCHAR2(5)
|
|
|
p_benefit_grs4
|
The amount the employee will receive for benefit 4. NUMBER(11,2)
|
|
|
p_benefit_start_date4
|
Start date of the employee receive benefit 4. DATE
|
|
|
p_benefit_end_date4
|
End date of the employee receive benefit 4. DATE
|
|
|
p_benefit_day_week_ind4
|
The benefit payment period indicator4. VARCHAR2(1)
|
|
|
p_rowid_out
|
Database ROWID of the record to be created. VARCHAR2(18) Required
|
p_delete
Procedure p_delete(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_user_id pxrroec.pxrroec_user_id%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
Deletes a record.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_user_id
|
VARCHAR2(30) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be deleted. VARCHAR2(18)
|
p_lock
Procedure p_lock(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_rowid_inout IN OUT gb_common.internal_record_id_type)
Locks a record.
If ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_rowid_inout
|
Database ROWID of the record to be locked. VARCHAR2(18) Required
|
p_update
Procedure p_update(p_pidm pxrroec.pxrroec_pidm%TYPE,
p_seq_no pxrroec.pxrroec_seq_no%TYPE,
p_pict_code pxrroec.pxrroec_pict_code%TYPE,
p_empr_code pxrroec.pxrroec_empr_code%TYPE,
p_empr_fed_ein pxrroec.pxrroec_empr_fed_ein%TYPE DEFAULT dml_common.f_unspecified_string,
p_print_ind pxrroec.pxrroec_print_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_reprint_ind pxrroec.pxrroec_reprint_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_serial_no pxrroec.pxrroec_serial_no%TYPE DEFAULT dml_common.f_unspecified_string,
p_amends_serial_no pxrroec.pxrroec_amends_serial_no%TYPE DEFAULT dml_common.f_unspecified_string,
p_language_ind pxrroec.pxrroec_language_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_issue_date pxrroec.pxrroec_issue_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_reference_number pxrroec.pxrroec_reference_number%TYPE DEFAULT dml_common.f_unspecified_string,
p_sin pxrroec.pxrroec_sin%TYPE DEFAULT dml_common.f_unspecified_string,
p_job_title pxrroec.pxrroec_job_title%TYPE DEFAULT dml_common.f_unspecified_string,
p_first_day_worked pxrroec.pxrroec_first_day_worked%TYPE DEFAULT dml_common.f_unspecified_date,
p_last_day_worked pxrroec.pxrroec_last_day_worked%TYPE DEFAULT dml_common.f_unspecified_date,
p_final_pay_date pxrroec.pxrroec_final_pay_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_recall_ind pxrroec.pxrroec_recall_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_recall_date pxrroec.pxrroec_recall_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_roec_code pxrroec.pxrroec_roec_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_total_hrs pxrroec.pxrroec_total_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_total_grs pxrroec.pxrroec_total_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_1996_weeks pxrroec.pxrroec_1996_weeks%TYPE DEFAULT dml_common.f_unspecified_number,
p_1996_earnings pxrroec.pxrroec_1996_earnings%TYPE DEFAULT dml_common.f_unspecified_number,
p_contact_pidm pxrroec.pxrroec_contact_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
p_contact_tele_area_code pxrroec.pxrroec_contact_tele_area_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_contact_tele_number pxrroec.pxrroec_contact_tele_number%TYPE DEFAULT dml_common.f_unspecified_string,
p_contact_tele_ext pxrroec.pxrroec_contact_tele_ext%TYPE DEFAULT dml_common.f_unspecified_string,
p_issuing_pidm pxrroec.pxrroec_issuing_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
p_issuing_tele_area_code pxrroec.pxrroec_issuing_tele_area_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_issuing_tele_number pxrroec.pxrroec_issuing_tele_number%TYPE DEFAULT dml_common.f_unspecified_string,
p_issusing_tele_ext pxrroec.pxrroec_issusing_tele_ext%TYPE DEFAULT dml_common.f_unspecified_string,
p_earn_code_vac pxrroec.pxrroec_earn_code_vac%TYPE DEFAULT dml_common.f_unspecified_string,
p_vac_grs pxrroec.pxrroec_vac_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_stat_hol_earn_code1 pxrroec.pxrroec_stat_hol_earn_code1%TYPE DEFAULT dml_common.f_unspecified_string,
p_stat_hol_date1 pxrroec.pxrroec_stat_hol_date1%TYPE DEFAULT dml_common.f_unspecified_date,
p_stat_hol_grs1 pxrroec.pxrroec_stat_hol_grs1%TYPE DEFAULT dml_common.f_unspecified_number,
p_stat_hol_earn_code2 pxrroec.pxrroec_stat_hol_earn_code2%TYPE DEFAULT dml_common.f_unspecified_string,
p_stat_hol_date2 pxrroec.pxrroec_stat_hol_date2%TYPE DEFAULT dml_common.f_unspecified_date,
p_stat_hol_grs2 pxrroec.pxrroec_stat_hol_grs2%TYPE DEFAULT dml_common.f_unspecified_number,
p_stat_hol_earn_code3 pxrroec.pxrroec_stat_hol_earn_code3%TYPE DEFAULT dml_common.f_unspecified_string,
p_stat_hol_date3 pxrroec.pxrroec_stat_hol_date3%TYPE DEFAULT dml_common.f_unspecified_date,
p_stat_hol_grs3 pxrroec.pxrroec_stat_hol_grs3%TYPE DEFAULT dml_common.f_unspecified_number,
p_other_earn_code1 pxrroec.pxrroec_other_earn_code1%TYPE DEFAULT dml_common.f_unspecified_string,
p_other_earn_code1_grs pxrroec.pxrroec_other_earn_code1_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_other_earn_code2 pxrroec.pxrroec_other_earn_code2%TYPE DEFAULT dml_common.f_unspecified_string,
p_other_earn_code2_grs pxrroec.pxrroec_other_earn_code2_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_other_earn_code3 pxrroec.pxrroec_other_earn_code3%TYPE DEFAULT dml_common.f_unspecified_string,
p_other_earn_code3_grs pxrroec.pxrroec_other_earn_code3_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_benefit_ind pxrroec.pxrroec_benefit_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_benefit_grs pxrroec.pxrroec_benefit_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_benefit_start_date pxrroec.pxrroec_benefit_start_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_day_week_ind pxrroec.pxrroec_benefit_day_week_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp1_payno pxrroec.pxrroec_pp1_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp1_grs pxrroec.pxrroec_pp1_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp2_payno pxrroec.pxrroec_pp2_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp2_grs pxrroec.pxrroec_pp2_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp3_payno pxrroec.pxrroec_pp3_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp3_grs pxrroec.pxrroec_pp3_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp4_payno pxrroec.pxrroec_pp4_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp4_grs pxrroec.pxrroec_pp4_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp5_payno pxrroec.pxrroec_pp5_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp5_grs pxrroec.pxrroec_pp5_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp6_payno pxrroec.pxrroec_pp6_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp6_grs pxrroec.pxrroec_pp6_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp7_payno pxrroec.pxrroec_pp7_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp7_grs pxrroec.pxrroec_pp7_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp8_payno pxrroec.pxrroec_pp8_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp8_grs pxrroec.pxrroec_pp8_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp9_payno pxrroec.pxrroec_pp9_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp9_grs pxrroec.pxrroec_pp9_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp10_payno pxrroec.pxrroec_pp10_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp10_grs pxrroec.pxrroec_pp10_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp11_payno pxrroec.pxrroec_pp11_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp11_grs pxrroec.pxrroec_pp11_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp12_payno pxrroec.pxrroec_pp12_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp12_grs pxrroec.pxrroec_pp12_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp13_payno pxrroec.pxrroec_pp13_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp13_grs pxrroec.pxrroec_pp13_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp14_payno pxrroec.pxrroec_pp14_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp14_grs pxrroec.pxrroec_pp14_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp15_payno pxrroec.pxrroec_pp15_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp15_grs pxrroec.pxrroec_pp15_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp16_payno pxrroec.pxrroec_pp16_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp16_grs pxrroec.pxrroec_pp16_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp17_payno pxrroec.pxrroec_pp17_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp17_grs pxrroec.pxrroec_pp17_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp18_payno pxrroec.pxrroec_pp18_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp18_grs pxrroec.pxrroec_pp18_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp19_payno pxrroec.pxrroec_pp19_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp19_grs pxrroec.pxrroec_pp19_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp20_payno pxrroec.pxrroec_pp20_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp20_grs pxrroec.pxrroec_pp20_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp21_payno pxrroec.pxrroec_pp21_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp21_grs pxrroec.pxrroec_pp21_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp22_payno pxrroec.pxrroec_pp22_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp22_grs pxrroec.pxrroec_pp22_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp23_payno pxrroec.pxrroec_pp23_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp23_grs pxrroec.pxrroec_pp23_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp24_payno pxrroec.pxrroec_pp24_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp24_grs pxrroec.pxrroec_pp24_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp25_payno pxrroec.pxrroec_pp25_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp25_grs pxrroec.pxrroec_pp25_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp26_payno pxrroec.pxrroec_pp26_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp26_grs pxrroec.pxrroec_pp26_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp27_payno pxrroec.pxrroec_pp27_payno%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp27_grs pxrroec.pxrroec_pp27_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_comment_line1 pxrroec.pxrroec_comment_line1%TYPE DEFAULT dml_common.f_unspecified_string,
p_comment_line2 pxrroec.pxrroec_comment_line2%TYPE DEFAULT dml_common.f_unspecified_string,
p_comment_line3 pxrroec.pxrroec_comment_line3%TYPE DEFAULT dml_common.f_unspecified_string,
p_comment_line4 pxrroec.pxrroec_comment_line4%TYPE DEFAULT dml_common.f_unspecified_string,
p_comment_line5 pxrroec.pxrroec_comment_line5%TYPE DEFAULT dml_common.f_unspecified_string,
p_comment_line6 pxrroec.pxrroec_comment_line6%TYPE DEFAULT dml_common.f_unspecified_string,
p_user_id pxrroec.pxrroec_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_money_type1 pxrroec.pxrroec_money_type1%TYPE DEFAULT dml_common.f_unspecified_string,
p_money_type2 pxrroec.pxrroec_money_type2%TYPE DEFAULT dml_common.f_unspecified_string,
p_money_type3 pxrroec.pxrroec_money_type3%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp28_payno pxrroec.pxrroec_pp28_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp28_grs pxrroec.pxrroec_pp28_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp29_payno pxrroec.pxrroec_pp29_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp29_grs pxrroec.pxrroec_pp29_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp30_payno pxrroec.pxrroec_pp30_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp30_grs pxrroec.pxrroec_pp30_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp31_payno pxrroec.pxrroec_pp31_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp31_grs pxrroec.pxrroec_pp31_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp32_payno pxrroec.pxrroec_pp32_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp32_grs pxrroec.pxrroec_pp32_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp33_payno pxrroec.pxrroec_pp33_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp33_grs pxrroec.pxrroec_pp33_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp34_payno pxrroec.pxrroec_pp34_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp34_grs pxrroec.pxrroec_pp34_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp35_payno pxrroec.pxrroec_pp35_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp35_grs pxrroec.pxrroec_pp35_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp36_payno pxrroec.pxrroec_pp36_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp36_grs pxrroec.pxrroec_pp36_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp37_payno pxrroec.pxrroec_pp37_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp37_grs pxrroec.pxrroec_pp37_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp38_payno pxrroec.pxrroec_pp38_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp38_grs pxrroec.pxrroec_pp38_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp39_payno pxrroec.pxrroec_pp39_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp39_grs pxrroec.pxrroec_pp39_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp40_payno pxrroec.pxrroec_pp40_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp40_grs pxrroec.pxrroec_pp40_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp41_payno pxrroec.pxrroec_pp41_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp41_grs pxrroec.pxrroec_pp41_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp42_payno pxrroec.pxrroec_pp42_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp42_grs pxrroec.pxrroec_pp42_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp43_payno pxrroec.pxrroec_pp43_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp43_grs pxrroec.pxrroec_pp43_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp44_payno pxrroec.pxrroec_pp44_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp44_grs pxrroec.pxrroec_pp44_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp45_payno pxrroec.pxrroec_pp45_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp45_grs pxrroec.pxrroec_pp45_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp46_payno pxrroec.pxrroec_pp46_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp46_grs pxrroec.pxrroec_pp46_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp47_payno pxrroec.pxrroec_pp47_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp47_grs pxrroec.pxrroec_pp47_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp48_payno pxrroec.pxrroec_pp48_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp48_grs pxrroec.pxrroec_pp48_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp49_payno pxrroec.pxrroec_pp49_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp49_grs pxrroec.pxrroec_pp49_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp50_payno pxrroec.pxrroec_pp50_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp50_grs pxrroec.pxrroec_pp50_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp51_payno pxrroec.pxrroec_pp51_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp51_grs pxrroec.pxrroec_pp51_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp52_payno pxrroec.pxrroec_pp52_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp52_grs pxrroec.pxrroec_pp52_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp53_payno pxrroec.pxrroec_pp53_payno%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp53_grs pxrroec.pxrroec_pp53_grs%TYPE DEFAULT dml_common.f_unspecified_number,
p_data_origin pxrroec.pxrroec_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
p_pp1_hrs pxrroec.pxrroec_pp1_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp2_hrs pxrroec.pxrroec_pp2_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp3_hrs pxrroec.pxrroec_pp3_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp4_hrs pxrroec.pxrroec_pp4_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp5_hrs pxrroec.pxrroec_pp5_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp6_hrs pxrroec.pxrroec_pp6_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp7_hrs pxrroec.pxrroec_pp7_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp8_hrs pxrroec.pxrroec_pp8_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp9_hrs pxrroec.pxrroec_pp9_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp10_hrs pxrroec.pxrroec_pp10_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp11_hrs pxrroec.pxrroec_pp11_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp12_hrs pxrroec.pxrroec_pp12_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp13_hrs pxrroec.pxrroec_pp13_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp14_hrs pxrroec.pxrroec_pp14_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp15_hrs pxrroec.pxrroec_pp15_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp16_hrs pxrroec.pxrroec_pp16_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp17_hrs pxrroec.pxrroec_pp17_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp18_hrs pxrroec.pxrroec_pp18_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp19_hrs pxrroec.pxrroec_pp19_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp20_hrs pxrroec.pxrroec_pp20_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp21_hrs pxrroec.pxrroec_pp21_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp22_hrs pxrroec.pxrroec_pp22_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp23_hrs pxrroec.pxrroec_pp23_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp24_hrs pxrroec.pxrroec_pp24_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp25_hrs pxrroec.pxrroec_pp25_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp26_hrs pxrroec.pxrroec_pp26_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp27_hrs pxrroec.pxrroec_pp27_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp28_hrs pxrroec.pxrroec_pp28_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp29_hrs pxrroec.pxrroec_pp29_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp30_hrs pxrroec.pxrroec_pp30_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp31_hrs pxrroec.pxrroec_pp31_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp32_hrs pxrroec.pxrroec_pp32_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp33_hrs pxrroec.pxrroec_pp33_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp34_hrs pxrroec.pxrroec_pp34_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp35_hrs pxrroec.pxrroec_pp35_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp36_hrs pxrroec.pxrroec_pp36_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp37_hrs pxrroec.pxrroec_pp37_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp38_hrs pxrroec.pxrroec_pp38_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp39_hrs pxrroec.pxrroec_pp39_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp40_hrs pxrroec.pxrroec_pp40_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp41_hrs pxrroec.pxrroec_pp41_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp42_hrs pxrroec.pxrroec_pp42_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp43_hrs pxrroec.pxrroec_pp43_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp44_hrs pxrroec.pxrroec_pp44_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp45_hrs pxrroec.pxrroec_pp45_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp46_hrs pxrroec.pxrroec_pp46_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp47_hrs pxrroec.pxrroec_pp47_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp48_hrs pxrroec.pxrroec_pp48_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp49_hrs pxrroec.pxrroec_pp49_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp50_hrs pxrroec.pxrroec_pp50_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp51_hrs pxrroec.pxrroec_pp51_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp52_hrs pxrroec.pxrroec_pp52_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_pp53_hrs pxrroec.pxrroec_pp53_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
p_bulk_file_name pxrroec.pxrroec_bulk_file_name%TYPE DEFAULT dml_common.f_unspecified_string,
p_vac_roev_code pxrroec.pxrroec_vac_roev_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_vac_start_date pxrroec.pxrroec_vac_start_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_vac_end_date pxrroec.pxrroec_vac_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_stat_hol_earn_code4 pxrroec.pxrroec_stat_hol_earn_code4%TYPE DEFAULT dml_common.f_unspecified_string,
p_stat_hol_date4 pxrroec.pxrroec_stat_hol_date4%TYPE DEFAULT dml_common.f_unspecified_date,
p_stat_hol_grs4 pxrroec.pxrroec_stat_hol_grs4%TYPE DEFAULT dml_common.f_unspecified_number,
p_stat_hol_earn_code5 pxrroec.pxrroec_stat_hol_earn_code5%TYPE DEFAULT dml_common.f_unspecified_string,
p_stat_hol_date5 pxrroec.pxrroec_stat_hol_date5%TYPE DEFAULT dml_common.f_unspecified_date,
p_stat_hol_grs5 pxrroec.pxrroec_stat_hol_grs5%TYPE DEFAULT dml_common.f_unspecified_number,
p_other_start_date1 pxrroec.pxrroec_other_start_date1%TYPE DEFAULT dml_common.f_unspecified_date,
p_other_end_date1 pxrroec.pxrroec_other_end_date1%TYPE DEFAULT dml_common.f_unspecified_date,
p_other_start_date2 pxrroec.pxrroec_other_start_date2%TYPE DEFAULT dml_common.f_unspecified_date,
p_other_end_date2 pxrroec.pxrroec_other_end_date2%TYPE DEFAULT dml_common.f_unspecified_date,
p_other_start_date3 pxrroec.pxrroec_other_start_date3%TYPE DEFAULT dml_common.f_unspecified_date,
p_other_end_date3 pxrroec.pxrroec_other_end_date3%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_roes_code pxrroec.pxrroec_benefit_roes_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_benefit_end_date pxrroec.pxrroec_benefit_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_roes_code2 pxrroec.pxrroec_benefit_roes_code2%TYPE DEFAULT dml_common.f_unspecified_string,
p_benefit_grs2 pxrroec.pxrroec_benefit_grs2%TYPE DEFAULT dml_common.f_unspecified_number,
p_benefit_start_date2 pxrroec.pxrroec_benefit_start_date2%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_end_date2 pxrroec.pxrroec_benefit_end_date2%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_day_week_ind2 pxrroec.pxrroec_benefit_day_week_ind2%TYPE DEFAULT dml_common.f_unspecified_string,
p_benefit_roes_code3 pxrroec.pxrroec_benefit_roes_code3%TYPE DEFAULT dml_common.f_unspecified_string,
p_benefit_grs3 pxrroec.pxrroec_benefit_grs3%TYPE DEFAULT dml_common.f_unspecified_number,
p_benefit_start_date3 pxrroec.pxrroec_benefit_start_date3%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_end_date3 pxrroec.pxrroec_benefit_end_date3%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_day_week_ind3 pxrroec.pxrroec_benefit_day_week_ind3%TYPE DEFAULT dml_common.f_unspecified_string,
p_benefit_roes_code4 pxrroec.pxrroec_benefit_roes_code4%TYPE DEFAULT dml_common.f_unspecified_string,
p_benefit_grs4 pxrroec.pxrroec_benefit_grs4%TYPE DEFAULT dml_common.f_unspecified_number,
p_benefit_start_date4 pxrroec.pxrroec_benefit_start_date4%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_end_date4 pxrroec.pxrroec_benefit_end_date4%TYPE DEFAULT dml_common.f_unspecified_date,
p_benefit_day_week_ind4 pxrroec.pxrroec_benefit_day_week_ind4%TYPE DEFAULT dml_common.f_unspecified_string,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
Updates a record.
|
|
p_pidm
|
Employee Identification Number. NUMBER(8) Required Key
|
|
|
p_seq_no
|
Record Sequence Number. NUMBER(2) Required Key
|
|
|
p_pict_code
|
Payroll ID. VARCHAR2(2) Required Key
|
|
|
p_empr_code
|
Employer Code. VARCHAR2(4) Required Key
|
|
|
p_empr_fed_ein
|
Revenue Canada Business Number. VARCHAR2(15) Required
|
|
|
p_print_ind
|
Ready to print indicator. VARCHAR2(1) Required
|
|
|
p_reprint_ind
|
Reprint amend indicator. VARCHAR2(1) Required
|
|
|
p_serial_no
|
Serial number of ROE record. VARCHAR2(9)
|
|
|
p_amends_serial_no
|
Amended serial number of ROE amended or replaced. VARCHAR2(12)
|
|
|
p_language_ind
|
The preferred language indicator of the issuing employer. VARCHAR2(1) Required
|
|
|
p_issue_date
|
Issued Date of the ROE record. DATE Required
|
|
|
p_reference_number
|
Reference Number used by the employer to identify the employee. VARCHAR2(12)
|
|
|
p_sin
|
The Employee social insurance number. VARCHAR2(9) Required
|
|
|
p_job_title
|
Employee job title. VARCHAR2(40)
|
|
|
p_first_day_worked
|
Employee first worked date. DATE Required
|
|
|
p_last_day_worked
|
Employee last worked date. DATE Required
|
|
|
p_final_pay_date
|
Employee final paid date. DATE Required
|
|
|
p_recall_ind
|
The employee return to active employment indicator. VARCHAR2(1)
|
|
|
p_recall_date
|
The expected date of the employee return to active employment. DATE
|
|
|
p_roec_code
|
Reason of the employer issuing this ROE. VARCHAR2(3) Required
|
|
|
p_total_hrs
|
The total insurable hours worked by the employee in the last 52 weeks. NUMBER(11,2) Required
|
|
|
p_total_grs
|
The sum of applicable gross of all EI deduction records in the last 52 weeks. NUMBER(11,2)
|
|
|
p_1996_weeks
|
1996 Employment history insurable weeks. NUMBER(,)
|
|
|
p_1996_earnings
|
1996 Employment history insurable earnings. NUMBER(,)
|
|
|
p_contact_pidm
|
Employee Identification number to be contacted. NUMBER(8) Required
|
|
|
p_contact_tele_area_code
|
Employee phone number area code to be contacted. VARCHAR2(3) Required
|
|
|
p_contact_tele_number
|
Employee phone number to be contacted. VARCHAR2(7) Required
|
|
|
p_contact_tele_ext
|
Employee phone number extention to be contacted. VARCHAR2(4)
|
|
|
p_issuing_pidm
|
Issuing person identification number. NUMBER(8) Required
|
|
|
p_issuing_tele_area_code
|
Issuing person telephone number area code. VARCHAR2(3) Required
|
|
|
p_issuing_tele_number
|
Issuing person telephone number. VARCHAR2(7) Required
|
|
|
p_issusing_tele_ext
|
Issuing person telephone number extention. VARCHAR2(4)
|
|
|
p_earn_code_vac
|
Vacation pay earnings code. VARCHAR2(3)
|
|
|
p_vac_grs
|
Vacation pay amount. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code1
|
Statutory holiday pay earnings code 1. VARCHAR2(3)
|
|
|
p_stat_hol_date1
|
Statutory holiday date 1. DATE
|
|
|
p_stat_hol_grs1
|
Statutory holiday pay amount 1. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code2
|
Statutory holiday pay earnings code 2. VARCHAR2(3)
|
|
|
p_stat_hol_date2
|
Statutory holiday date 2. DATE
|
|
|
p_stat_hol_grs2
|
Statutory holiday pay amount 2. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code3
|
Statutory holiday pay earnings code 3. VARCHAR2(3)
|
|
|
p_stat_hol_date3
|
Statutory holiday date 3. DATE
|
|
|
p_stat_hol_grs3
|
Statutory holiday pay amount 3. NUMBER(11,2)
|
|
|
p_other_earn_code1
|
Other monies earning code 1. VARCHAR2(3)
|
|
|
p_other_earn_code1_grs
|
Other monies earning amount 1. NUMBER(11,2)
|
|
|
p_other_earn_code2
|
Other monies earning code 2. VARCHAR2(3)
|
|
|
p_other_earn_code2_grs
|
Other monies earning amount 2. NUMBER(11,2)
|
|
|
p_other_earn_code3
|
Other monies earning code 3. VARCHAR2(3)
|
|
|
p_other_earn_code3_grs
|
Other monies earning amount 3. NUMBER(11,2)
|
|
|
p_benefit_ind
|
Will the employee be receiving benefit indicator. VARCHAR2(1) Required
|
|
|
p_benefit_grs
|
The amount the employee will receive for benefit. NUMBER(11,2)
|
|
|
p_benefit_start_date
|
Start date of the employee receive benefit. DATE
|
|
|
p_benefit_day_week_ind
|
The benefit payment period indicator. VARCHAR2(1)
|
|
|
p_pp1_payno
|
Pay period breakdown number 1. VARCHAR2(3)
|
|
|
p_pp1_grs
|
Pay period amount breakdown number 1. NUMBER(11,2)
|
|
|
p_pp2_payno
|
Pay period breakdown number 2. VARCHAR2(3)
|
|
|
p_pp2_grs
|
Pay period amount breakdown number 2. NUMBER(,)
|
|
|
p_pp3_payno
|
Pay period breakdown number 3. VARCHAR2(3)
|
|
|
p_pp3_grs
|
Pay period amount breakdown number 3. NUMBER(,)
|
|
|
p_pp4_payno
|
Pay period breakdown number 4. VARCHAR2(3)
|
|
|
p_pp4_grs
|
Pay period amount breakdown number 4. NUMBER(,)
|
|
|
p_pp5_payno
|
Pay period breakdown number 5. VARCHAR2(3)
|
|
|
p_pp5_grs
|
Pay period amount breakdown number 5. NUMBER(,)
|
|
|
p_pp6_payno
|
Pay period breakdown number 6. VARCHAR2(3)
|
|
|
p_pp6_grs
|
Pay period amount breakdown number 6. NUMBER(,)
|
|
|
p_pp7_payno
|
Pay period breakdown number 7. VARCHAR2(3)
|
|
|
p_pp7_grs
|
Pay period amount breakdown number 7. NUMBER(,)
|
|
|
p_pp8_payno
|
Pay period breakdown number 8. VARCHAR2(3)
|
|
|
p_pp8_grs
|
Pay period amount breakdown number 8. NUMBER(,)
|
|
|
p_pp9_payno
|
Pay period breakdown number 9. VARCHAR2(3)
|
|
|
p_pp9_grs
|
Pay period amount breakdown number 9. NUMBER(,)
|
|
|
p_pp10_payno
|
Pay period breakdown number 10. VARCHAR2(3)
|
|
|
p_pp10_grs
|
Pay period amount breakdown number 10. NUMBER(,)
|
|
|
p_pp11_payno
|
Pay period breakdown number 11. VARCHAR2(3)
|
|
|
p_pp11_grs
|
Pay period amount breakdown number 11. NUMBER(,)
|
|
|
p_pp12_payno
|
Pay period breakdown number 12. VARCHAR2(3)
|
|
|
p_pp12_grs
|
Pay period amount breakdown number 12. NUMBER(,)
|
|
|
p_pp13_payno
|
Pay period breakdown number 13. VARCHAR2(3)
|
|
|
p_pp13_grs
|
Pay period amount breakdown number 13. NUMBER(,)
|
|
|
p_pp14_payno
|
Pay period breakdown number 14. VARCHAR2(3)
|
|
|
p_pp14_grs
|
Pay period amount breakdown number 14. NUMBER(,)
|
|
|
p_pp15_payno
|
Pay period breakdown number 15. VARCHAR2(3)
|
|
|
p_pp15_grs
|
Pay period amount breakdown number 15. NUMBER(,)
|
|
|
p_pp16_payno
|
Pay period breakdown number 16. VARCHAR2(3)
|
|
|
p_pp16_grs
|
Pay period amount breakdown number 16. NUMBER(,)
|
|
|
p_pp17_payno
|
Pay period breakdown number 17. VARCHAR2(3)
|
|
|
p_pp17_grs
|
Pay period amount breakdown number 17. NUMBER(,)
|
|
|
p_pp18_payno
|
Pay period breakdown number 18. VARCHAR2(3)
|
|
|
p_pp18_grs
|
Pay period amount breakdown number 18. NUMBER(,)
|
|
|
p_pp19_payno
|
Pay period breakdown number 19. VARCHAR2(3)
|
|
|
p_pp19_grs
|
Pay period amount breakdown number 19. NUMBER(,)
|
|
|
p_pp20_payno
|
Pay period breakdown number 20. VARCHAR2(3)
|
|
|
p_pp20_grs
|
Pay period amount breakdown number 20. NUMBER(,)
|
|
|
p_pp21_payno
|
Pay period breakdown number 21. VARCHAR2(3)
|
|
|
p_pp21_grs
|
Pay period amount breakdown number 21. NUMBER(,)
|
|
|
p_pp22_payno
|
Pay period breakdown number 22. VARCHAR2(3)
|
|
|
p_pp22_grs
|
Pay period amount breakdown number 22. NUMBER(,)
|
|
|
p_pp23_payno
|
Pay period breakdown number 23. VARCHAR2(3)
|
|
|
p_pp23_grs
|
Pay period amount breakdown number 23. NUMBER(,)
|
|
|
p_pp24_payno
|
Pay period breakdown number 24. VARCHAR2(3)
|
|
|
p_pp24_grs
|
Pay period amount breakdown number 24. NUMBER(,)
|
|
|
p_pp25_payno
|
Pay period breakdown number 25. VARCHAR2(3)
|
|
|
p_pp25_grs
|
Pay period amount breakdown number 25. NUMBER(,)
|
|
|
p_pp26_payno
|
Pay period breakdown number 26. VARCHAR2(3)
|
|
|
p_pp26_grs
|
Pay period amount breakdown number 26. NUMBER(,)
|
|
|
p_pp27_payno
|
Pay period breakdown number 27. VARCHAR2(3)
|
|
|
p_pp27_grs
|
Pay period amount breakdown number 27. NUMBER(,)
|
|
|
p_comment_line1
|
Comment of the record line 1. VARCHAR2(38)
|
|
|
p_comment_line2
|
Comment of the record line 2. VARCHAR2(38)
|
|
|
p_comment_line3
|
Comment of the record line 3. VARCHAR2(38)
|
|
|
p_comment_line4
|
Comment of the record line 4. VARCHAR2(38)
|
|
|
p_comment_line5
|
Comment of the record line 5. VARCHAR2(38)
|
|
|
p_comment_line6
|
Comment of the record line 6. VARCHAR2(38)
|
|
|
p_user_id
|
VARCHAR2(30) Required
|
|
|
p_money_type1
|
PXRROEC_MONEY_TYPE1 This field indicates Canadian ROE Types of Other Money1. VARCHAR2(1)
|
|
|
p_money_type2
|
PXRROEC_MONEY_TYPE2 This field indicates Canadian ROE Types of Other Money2. VARCHAR2(1)
|
|
|
p_money_type3
|
PXRROEC_MONEY_TYPE3 This field indicates Canadian ROE Types of Other Money3. VARCHAR2(1)
|
|
|
p_pp28_payno
|
Pay period breakdown number 28. NUMBER(9,2)
|
|
|
p_pp28_grs
|
Pay period amount breakdown number 28. NUMBER(9,2)
|
|
|
p_pp29_payno
|
Pay period breakdown number 29. NUMBER(9,2)
|
|
|
p_pp29_grs
|
Pay period amount breakdown number 29. NUMBER(9,2)
|
|
|
p_pp30_payno
|
Pay period breakdown number 30. NUMBER(9,2)
|
|
|
p_pp30_grs
|
Pay period amount breakdown number 30. NUMBER(9,2)
|
|
|
p_pp31_payno
|
Pay period breakdown number 31. NUMBER(9,2)
|
|
|
p_pp31_grs
|
Pay period amount breakdown number 31. NUMBER(9,2)
|
|
|
p_pp32_payno
|
Pay period breakdown number 32. NUMBER(9,2)
|
|
|
p_pp32_grs
|
Pay period amount breakdown number 32. NUMBER(9,2)
|
|
|
p_pp33_payno
|
Pay period breakdown number 33. NUMBER(9,2)
|
|
|
p_pp33_grs
|
Pay period amount breakdown number 33. NUMBER(9,2)
|
|
|
p_pp34_payno
|
Pay period breakdown number 34. NUMBER(9,2)
|
|
|
p_pp34_grs
|
Pay period amount breakdown number 34. NUMBER(9,2)
|
|
|
p_pp35_payno
|
Pay period breakdown number 35. NUMBER(9,2)
|
|
|
p_pp35_grs
|
Pay period amount breakdown number 35. NUMBER(9,2)
|
|
|
p_pp36_payno
|
Pay period breakdown number 36. NUMBER(9,2)
|
|
|
p_pp36_grs
|
Pay period amount breakdown number 36. NUMBER(9,2)
|
|
|
p_pp37_payno
|
Pay period breakdown number 37. NUMBER(9,2)
|
|
|
p_pp37_grs
|
Pay period amount breakdown number 37. NUMBER(9,2)
|
|
|
p_pp38_payno
|
Pay period breakdown number 38. NUMBER(9,2)
|
|
|
p_pp38_grs
|
Pay period amount breakdown number 38. NUMBER(9,2)
|
|
|
p_pp39_payno
|
Pay period breakdown number 39. NUMBER(9,2)
|
|
|
p_pp39_grs
|
Pay period amount breakdown number 39. NUMBER(9,2)
|
|
|
p_pp40_payno
|
Pay period breakdown number 40. NUMBER(9,2)
|
|
|
p_pp40_grs
|
Pay period amount breakdown number 40. NUMBER(9,2)
|
|
|
p_pp41_payno
|
Pay period breakdown number 41. NUMBER(9,2)
|
|
|
p_pp41_grs
|
Pay period amount breakdown number 41. NUMBER(9,2)
|
|
|
p_pp42_payno
|
Pay period breakdown number 42. NUMBER(9,2)
|
|
|
p_pp42_grs
|
Pay period amount breakdown number 42. NUMBER(9,2)
|
|
|
p_pp43_payno
|
Pay period breakdown number 43. NUMBER(9,2)
|
|
|
p_pp43_grs
|
Pay period amount breakdown number 43. NUMBER(9,2)
|
|
|
p_pp44_payno
|
Pay period breakdown number 44. NUMBER(9,2)
|
|
|
p_pp44_grs
|
Pay period amount breakdown number 44. NUMBER(9,2)
|
|
|
p_pp45_payno
|
Pay period breakdown number 45. NUMBER(9,2)
|
|
|
p_pp45_grs
|
Pay period amount breakdown number 45. NUMBER(9,2)
|
|
|
p_pp46_payno
|
Pay period breakdown number 46. NUMBER(9,2)
|
|
|
p_pp46_grs
|
Pay period amount breakdown number 46. NUMBER(9,2)
|
|
|
p_pp47_payno
|
Pay period breakdown number 47. NUMBER(9,2)
|
|
|
p_pp47_grs
|
Pay period amount breakdown number 47. NUMBER(9,2)
|
|
|
p_pp48_payno
|
Pay period breakdown number 48. NUMBER(9,2)
|
|
|
p_pp48_grs
|
Pay period amount breakdown number 48. NUMBER(9,2)
|
|
|
p_pp49_payno
|
Pay period breakdown number 49. NUMBER(9,2)
|
|
|
p_pp49_grs
|
Pay period amount breakdown number 49. NUMBER(9,2)
|
|
|
p_pp50_payno
|
Pay period breakdown number 50. NUMBER(9,2)
|
|
|
p_pp50_grs
|
Pay period amount breakdown number 50. NUMBER(9,2)
|
|
|
p_pp51_payno
|
Pay period breakdown number 51. NUMBER(9,2)
|
|
|
p_pp51_grs
|
Pay period amount breakdown number 51. NUMBER(9,2)
|
|
|
p_pp52_payno
|
Pay period breakdown number 52. NUMBER(9,2)
|
|
|
p_pp52_grs
|
Pay period amount breakdown number 52. NUMBER(9,2)
|
|
|
p_pp53_payno
|
Pay period breakdown number 53. NUMBER(9,2)
|
|
|
p_pp53_grs
|
Pay period amount breakdown number 53. NUMBER(9,2)
|
|
|
p_data_origin
|
DATA ORIGIN: Source system that created or updated the row. VARCHAR2(30)
|
|
|
pxrroec_pp1_hrs
|
Insurable Hours of the Pay Period 1. NUMBER(9,2)
|
|
|
pxrroec_pp2_hrs
|
Insurable Hours of the Pay Period 2. NUMBER(9,2)
|
|
|
pxrroec_pp3_hrs
|
Insurable Hours of the Pay Period 3. NUMBER(9,2)
|
|
|
pxrroec_pp4_hrs
|
Insurable Hours of the Pay Period 4. NUMBER(9,2)
|
|
|
pxrroec_pp5_hrs
|
Insurable Hours of the Pay Period 5. NUMBER(9,2)
|
|
|
pxrroec_pp6_hrs
|
Insurable Hours of the Pay Period 6. NUMBER(9,2)
|
|
|
pxrroec_pp7_hrs
|
Insurable Hours of the Pay Period 7. NUMBER(9,2)
|
|
|
pxrroec_pp8_hrs
|
Insurable Hours of the Pay Period 8. NUMBER(9,2)
|
|
|
pxrroec_pp9_hrs
|
Insurable Hours of the Pay Period 9. NUMBER(9,2)
|
|
|
pxrroec_pp10_hrs
|
Insurable Hours of the Pay Period 10. NUMBER(9,2)
|
|
|
pxrroec_pp11_hrs
|
Insurable Hours of the Pay Period 11. NUMBER(9,2)
|
|
|
pxrroec_pp12_hrs
|
Insurable Hours of the Pay Period 12. NUMBER(9,2)
|
|
|
pxrroec_pp13_hrs
|
Insurable Hours of the Pay Period 13. NUMBER(9,2)
|
|
|
pxrroec_pp14_hrs
|
Insurable Hours of the Pay Period 14. NUMBER(9,2)
|
|
|
pxrroec_pp15_hrs
|
Insurable Hours of the Pay Period 15. NUMBER(9,2)
|
|
|
pxrroec_pp16_hrs
|
Insurable Hours of the Pay Period 16. NUMBER(9,2)
|
|
|
pxrroec_pp17_hrs
|
Insurable Hours of the Pay Period 17. NUMBER(9,2)
|
|
|
pxrroec_pp18_hrs
|
Insurable Hours of the Pay Period 18. NUMBER(9,2)
|
|
|
pxrroec_pp19_hrs
|
Insurable Hours of the Pay Period 19. NUMBER(9,2)
|
|
|
pxrroec_pp20_hrs
|
Insurable Hours of the Pay Period 20. NUMBER(9,2)
|
|
|
pxrroec_pp21_hrs
|
Insurable Hours of the Pay Period 21. NUMBER(9,2)
|
|
|
pxrroec_pp22_hrs
|
Insurable Hours of the Pay Period 22. NUMBER(9,2)
|
|
|
pxrroec_pp23_hrs
|
Insurable Hours of the Pay Period 23. NUMBER(9,2)
|
|
|
pxrroec_pp24_hrs
|
Insurable Hours of the Pay Period 24. NUMBER(9,2)
|
|
|
pxrroec_pp25_hrs
|
Insurable Hours of the Pay Period 25. NUMBER(9,2)
|
|
|
pxrroec_pp26_hrs
|
Insurable Hours of the Pay Period 26. NUMBER(9,2)
|
|
|
pxrroec_pp27_hrs
|
Insurable Hours of the Pay Period 27. NUMBER(9,2)
|
|
|
pxrroec_pp28_hrs
|
Insurable Hours of the Pay Period 28. NUMBER(9,2)
|
|
|
pxrroec_pp29_hrs
|
Insurable Hours of the Pay Period 29. NUMBER(9,2)
|
|
|
pxrroec_pp30_hrs
|
Insurable Hours of the Pay Period 30. NUMBER(9,2)
|
|
|
pxrroec_pp31_hrs
|
Insurable Hours of the Pay Period 31. NUMBER(9,2)
|
|
|
pxrroec_pp32_hrs
|
Insurable Hours of the Pay Period 32. NUMBER(9,2)
|
|
|
pxrroec_pp33_hrs
|
Insurable Hours of the Pay Period 33. NUMBER(9,2)
|
|
|
pxrroec_pp34_hrs
|
Insurable Hours of the Pay Period 34. NUMBER(9,2)
|
|
|
pxrroec_pp35_hrs
|
Insurable Hours of the Pay Period 35. NUMBER(9,2)
|
|
|
pxrroec_pp36_hrs
|
Insurable Hours of the Pay Period 36. NUMBER(9,2)
|
|
|
pxrroec_pp37_hrs
|
Insurable Hours of the Pay Period 37. NUMBER(9,2)
|
|
|
pxrroec_pp38_hrs
|
Insurable Hours of the Pay Period 38. NUMBER(9,2)
|
|
|
pxrroec_pp39_hrs
|
Insurable Hours of the Pay Period 39. NUMBER(9,2)
|
|
|
pxrroec_pp40_hrs
|
Insurable Hours of the Pay Period 40. NUMBER(9,2)
|
|
|
pxrroec_pp41_hrs
|
Insurable Hours of the Pay Period 41. NUMBER(9,2)
|
|
|
pxrroec_pp42_hrs
|
Insurable Hours of the Pay Period 42. NUMBER(9,2)
|
|
|
pxrroec_pp43_hrs
|
Insurable Hours of the Pay Period 43. NUMBER(9,2)
|
|
|
pxrroec_pp44_hrs
|
Insurable Hours of the Pay Period 44. NUMBER(9,2)
|
|
|
pxrroec_pp45_hrs
|
Insurable Hours of the Pay Period 45. NUMBER(9,2)
|
|
|
pxrroec_pp46_hrs
|
Insurable Hours of the Pay Period 46. NUMBER(9,2)
|
|
|
pxrroec_pp47_hrs
|
Insurable Hours of the Pay Period 47. NUMBER(9,2)
|
|
|
pxrroec_pp48_hrs
|
Insurable Hours of the Pay Period 48. NUMBER(9,2)
|
|
|
pxrroec_pp49_hrs
|
Insurable Hours of the Pay Period 49. NUMBER(9,2)
|
|
|
pxrroec_pp50_hrs
|
Insurable Hours of the Pay Period 50. NUMBER(9,2)
|
|
|
pxrroec_pp51_hrs
|
Insurable Hours of the Pay Period 51. NUMBER(9,2)
|
|
|
pxrroec_pp52_hrs
|
Insurable Hours of the Pay Period 52. NUMBER(9,2)
|
|
|
pxrroec_pp53_hrs
|
Insurable Hours of the Pay Period 53. NUMBER(9,2)
|
|
|
pxrroec_bulk_file_name
|
ROE bulk transfer file name that is transmitted to Web ROE. VARCHAR2(30)
|
|
|
p_vac_roev_code
|
Canadian ROE vacation pay code. VARCHAR2(1)
|
|
|
p_vac_start_date
|
Start date for this payment. DATE
|
|
|
p_vac_end_date
|
End date for this payment. DATE
|
|
|
p_stat_hol_earn_code4
|
Statutory holiday pay earnings code 4. VARCHAR2(3)
|
|
|
p_stat_hol_date4
|
Statutory holiday date 4. DATE
|
|
|
p_stat_hol_grs4
|
Statutory holiday pay amount 4. NUMBER(11,2)
|
|
|
p_stat_hol_earn_code5
|
Statutory holiday pay earnings code 5. VARCHAR2(3)
|
|
|
p_stat_hol_date5
|
Statutory holiday date 5. DATE
|
|
|
p_stat_hol_grs5
|
Statutory holiday pay amount 5. NUMBER(11,2)
|
|
|
p_other_start_date1
|
Other monies start date for payment 1. DATE
|
|
|
p_other_end_date1
|
Other monies end date for payment 1. DATE
|
|
|
p_other_start_date2
|
Other monies start date for this payment 2. DATE
|
|
|
p_other_end_date2
|
Other monies end date for this payment 2. DATE
|
|
|
p_other_start_date3
|
Other monies start date for this payment 3. DATE
|
|
|
p_other_end_date3
|
Other monies end date for this payment 3. DATE
|
|
|
p_benefit_roes_code
|
Canadian ROE special payment code. VARCHAR2(5)
|
|
|
p_benefit_end_date
|
End date of the employee receive benefit. DATE
|
|
|
p_benefit_roes_code2
|
Canadian ROE special payment code 2. VARCHAR2(5)
|
|
|
p_benefit_grs2
|
The amount the employee will receive for benefit 2. NUMBER(11,2)
|
|
|
p_benefit_start_date2
|
Start date of the employee receive benefit 2. DATE
|
|
|
p_benefit_end_date2
|
End date of the employee receive benefit 2. DATE
|
|
|
p_benefit_day_week_ind2
|
The benefit payment period indicator2. VARCHAR2(1)
|
|
|
p_benefit_roes_code3
|
Canadian ROE special payment code 3. VARCHAR2(5)
|
|
|
p_benefit_grs3
|
The amount the employee will receive for benefit 3. NUMBER(11,2)
|
|
|
p_benefit_start_date3
|
Start date of the employee receive benefit 3. DATE
|
|
|
p_benefit_end_date3
|
End date of the employee receive benefit 3. DATE
|
|
|
p_benefit_day_week_ind3
|
The benefit payment period indicator3. VARCHAR2(1)
|
|
|
p_benefit_roes_code4
|
Canadian ROE special payment code 4. VARCHAR2(5)
|
|
|
p_benefit_grs4
|
The amount the employee will receive for benefit 4. NUMBER(11,2)
|
|
|
p_benefit_start_date4
|
Start date of the employee receive benefit 4. DATE
|
|
|
p_benefit_end_date4
|
End date of the employee receive benefit 4. DATE
|
|
|
p_benefit_day_week_ind4
|
The benefit payment period indicator4. VARCHAR2(1)
|
|
|
p_rowid
|
Database ROWID of the record to be updated. VARCHAR2(18)
|