eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_ARCHIVE dependencies on PAY_CA_ARCHIVE

Line 1: package body pay_ca_archive as

1: package body pay_ca_archive as
2: /* $Header: pycaarch.pkb 120.8 2007/10/31 11:22:56 sapalani noship $ */
3: -- /************************************************************************
4: --
5: -- Description : Package and procedure to build sql for payroll processes.

Line 734: pay_ca_archive.box17c_bal_table(1).code := 'A';

730: declare
731:
732: begin
733:
734: pay_ca_archive.box17c_bal_table(1).code := 'A';
735: pay_ca_archive.box17c_bal_table(1).balance_name
736: := 'ROE Other Monies Anniversary Payout';
737:
738: pay_ca_archive.box17c_bal_table(2).code := 'B';

Line 735: pay_ca_archive.box17c_bal_table(1).balance_name

731:
732: begin
733:
734: pay_ca_archive.box17c_bal_table(1).code := 'A';
735: pay_ca_archive.box17c_bal_table(1).balance_name
736: := 'ROE Other Monies Anniversary Payout';
737:
738: pay_ca_archive.box17c_bal_table(2).code := 'B';
739: pay_ca_archive.box17c_bal_table(2).balance_name

Line 738: pay_ca_archive.box17c_bal_table(2).code := 'B';

734: pay_ca_archive.box17c_bal_table(1).code := 'A';
735: pay_ca_archive.box17c_bal_table(1).balance_name
736: := 'ROE Other Monies Anniversary Payout';
737:
738: pay_ca_archive.box17c_bal_table(2).code := 'B';
739: pay_ca_archive.box17c_bal_table(2).balance_name
740: := 'ROE Other Monies Bonus';
741:
742: pay_ca_archive.box17c_bal_table(3).code := 'E';

Line 739: pay_ca_archive.box17c_bal_table(2).balance_name

735: pay_ca_archive.box17c_bal_table(1).balance_name
736: := 'ROE Other Monies Anniversary Payout';
737:
738: pay_ca_archive.box17c_bal_table(2).code := 'B';
739: pay_ca_archive.box17c_bal_table(2).balance_name
740: := 'ROE Other Monies Bonus';
741:
742: pay_ca_archive.box17c_bal_table(3).code := 'E';
743: pay_ca_archive.box17c_bal_table(3).balance_name

Line 742: pay_ca_archive.box17c_bal_table(3).code := 'E';

738: pay_ca_archive.box17c_bal_table(2).code := 'B';
739: pay_ca_archive.box17c_bal_table(2).balance_name
740: := 'ROE Other Monies Bonus';
741:
742: pay_ca_archive.box17c_bal_table(3).code := 'E';
743: pay_ca_archive.box17c_bal_table(3).balance_name
744: := 'ROE Other Monies Severance Pay';
745:
746: pay_ca_archive.box17c_bal_table(4).code := 'G';

Line 743: pay_ca_archive.box17c_bal_table(3).balance_name

739: pay_ca_archive.box17c_bal_table(2).balance_name
740: := 'ROE Other Monies Bonus';
741:
742: pay_ca_archive.box17c_bal_table(3).code := 'E';
743: pay_ca_archive.box17c_bal_table(3).balance_name
744: := 'ROE Other Monies Severance Pay';
745:
746: pay_ca_archive.box17c_bal_table(4).code := 'G';
747: pay_ca_archive.box17c_bal_table(4).balance_name

Line 746: pay_ca_archive.box17c_bal_table(4).code := 'G';

742: pay_ca_archive.box17c_bal_table(3).code := 'E';
743: pay_ca_archive.box17c_bal_table(3).balance_name
744: := 'ROE Other Monies Severance Pay';
745:
746: pay_ca_archive.box17c_bal_table(4).code := 'G';
747: pay_ca_archive.box17c_bal_table(4).balance_name
748: := 'ROE Other Monies Gratuities';
749:
750: pay_ca_archive.box17c_bal_table(5).code := 'H';

Line 747: pay_ca_archive.box17c_bal_table(4).balance_name

743: pay_ca_archive.box17c_bal_table(3).balance_name
744: := 'ROE Other Monies Severance Pay';
745:
746: pay_ca_archive.box17c_bal_table(4).code := 'G';
747: pay_ca_archive.box17c_bal_table(4).balance_name
748: := 'ROE Other Monies Gratuities';
749:
750: pay_ca_archive.box17c_bal_table(5).code := 'H';
751: pay_ca_archive.box17c_bal_table(5).balance_name

Line 750: pay_ca_archive.box17c_bal_table(5).code := 'H';

746: pay_ca_archive.box17c_bal_table(4).code := 'G';
747: pay_ca_archive.box17c_bal_table(4).balance_name
748: := 'ROE Other Monies Gratuities';
749:
750: pay_ca_archive.box17c_bal_table(5).code := 'H';
751: pay_ca_archive.box17c_bal_table(5).balance_name
752: := 'ROE Other Monies Honorariums';
753:
754: pay_ca_archive.box17c_bal_table(6).code := 'I';

Line 751: pay_ca_archive.box17c_bal_table(5).balance_name

747: pay_ca_archive.box17c_bal_table(4).balance_name
748: := 'ROE Other Monies Gratuities';
749:
750: pay_ca_archive.box17c_bal_table(5).code := 'H';
751: pay_ca_archive.box17c_bal_table(5).balance_name
752: := 'ROE Other Monies Honorariums';
753:
754: pay_ca_archive.box17c_bal_table(6).code := 'I';
755: pay_ca_archive.box17c_bal_table(6).balance_name

Line 754: pay_ca_archive.box17c_bal_table(6).code := 'I';

750: pay_ca_archive.box17c_bal_table(5).code := 'H';
751: pay_ca_archive.box17c_bal_table(5).balance_name
752: := 'ROE Other Monies Honorariums';
753:
754: pay_ca_archive.box17c_bal_table(6).code := 'I';
755: pay_ca_archive.box17c_bal_table(6).balance_name
756: := 'ROE Other Monies Sick Leave Credit';
757:
758: pay_ca_archive.box17c_bal_table(7).code := 'N';

Line 755: pay_ca_archive.box17c_bal_table(6).balance_name

751: pay_ca_archive.box17c_bal_table(5).balance_name
752: := 'ROE Other Monies Honorariums';
753:
754: pay_ca_archive.box17c_bal_table(6).code := 'I';
755: pay_ca_archive.box17c_bal_table(6).balance_name
756: := 'ROE Other Monies Sick Leave Credit';
757:
758: pay_ca_archive.box17c_bal_table(7).code := 'N';
759: pay_ca_archive.box17c_bal_table(7).balance_name

Line 758: pay_ca_archive.box17c_bal_table(7).code := 'N';

754: pay_ca_archive.box17c_bal_table(6).code := 'I';
755: pay_ca_archive.box17c_bal_table(6).balance_name
756: := 'ROE Other Monies Sick Leave Credit';
757:
758: pay_ca_archive.box17c_bal_table(7).code := 'N';
759: pay_ca_archive.box17c_bal_table(7).balance_name
760: := 'ROE Other Monies Pensions';
761:
762: pay_ca_archive.box17c_bal_table(8).code := 'O';

Line 759: pay_ca_archive.box17c_bal_table(7).balance_name

755: pay_ca_archive.box17c_bal_table(6).balance_name
756: := 'ROE Other Monies Sick Leave Credit';
757:
758: pay_ca_archive.box17c_bal_table(7).code := 'N';
759: pay_ca_archive.box17c_bal_table(7).balance_name
760: := 'ROE Other Monies Pensions';
761:
762: pay_ca_archive.box17c_bal_table(8).code := 'O';
763: pay_ca_archive.box17c_bal_table(8).balance_name

Line 762: pay_ca_archive.box17c_bal_table(8).code := 'O';

758: pay_ca_archive.box17c_bal_table(7).code := 'N';
759: pay_ca_archive.box17c_bal_table(7).balance_name
760: := 'ROE Other Monies Pensions';
761:
762: pay_ca_archive.box17c_bal_table(8).code := 'O';
763: pay_ca_archive.box17c_bal_table(8).balance_name
764: := 'ROE Other Monies Other';
765:
766: pay_ca_archive.box17c_bal_table(9).code := 'R';

Line 763: pay_ca_archive.box17c_bal_table(8).balance_name

759: pay_ca_archive.box17c_bal_table(7).balance_name
760: := 'ROE Other Monies Pensions';
761:
762: pay_ca_archive.box17c_bal_table(8).code := 'O';
763: pay_ca_archive.box17c_bal_table(8).balance_name
764: := 'ROE Other Monies Other';
765:
766: pay_ca_archive.box17c_bal_table(9).code := 'R';
767: pay_ca_archive.box17c_bal_table(9).balance_name

Line 766: pay_ca_archive.box17c_bal_table(9).code := 'R';

762: pay_ca_archive.box17c_bal_table(8).code := 'O';
763: pay_ca_archive.box17c_bal_table(8).balance_name
764: := 'ROE Other Monies Other';
765:
766: pay_ca_archive.box17c_bal_table(9).code := 'R';
767: pay_ca_archive.box17c_bal_table(9).balance_name
768: := 'ROE Other Monies Retirement Leave Credits';
769:
770: pay_ca_archive.box17c_bal_table(10).code := 'S';

Line 767: pay_ca_archive.box17c_bal_table(9).balance_name

763: pay_ca_archive.box17c_bal_table(8).balance_name
764: := 'ROE Other Monies Other';
765:
766: pay_ca_archive.box17c_bal_table(9).code := 'R';
767: pay_ca_archive.box17c_bal_table(9).balance_name
768: := 'ROE Other Monies Retirement Leave Credits';
769:
770: pay_ca_archive.box17c_bal_table(10).code := 'S';
771: pay_ca_archive.box17c_bal_table(10).balance_name

Line 770: pay_ca_archive.box17c_bal_table(10).code := 'S';

766: pay_ca_archive.box17c_bal_table(9).code := 'R';
767: pay_ca_archive.box17c_bal_table(9).balance_name
768: := 'ROE Other Monies Retirement Leave Credits';
769:
770: pay_ca_archive.box17c_bal_table(10).code := 'S';
771: pay_ca_archive.box17c_bal_table(10).balance_name
772: := 'ROE Other Monies Settlement or Labour Arb Award';
773:
774: pay_ca_archive.box17c_bal_table(11).code := 'U';

Line 771: pay_ca_archive.box17c_bal_table(10).balance_name

767: pay_ca_archive.box17c_bal_table(9).balance_name
768: := 'ROE Other Monies Retirement Leave Credits';
769:
770: pay_ca_archive.box17c_bal_table(10).code := 'S';
771: pay_ca_archive.box17c_bal_table(10).balance_name
772: := 'ROE Other Monies Settlement or Labour Arb Award';
773:
774: pay_ca_archive.box17c_bal_table(11).code := 'U';
775: pay_ca_archive.box17c_bal_table(11).balance_name

Line 774: pay_ca_archive.box17c_bal_table(11).code := 'U';

770: pay_ca_archive.box17c_bal_table(10).code := 'S';
771: pay_ca_archive.box17c_bal_table(10).balance_name
772: := 'ROE Other Monies Settlement or Labour Arb Award';
773:
774: pay_ca_archive.box17c_bal_table(11).code := 'U';
775: pay_ca_archive.box17c_bal_table(11).balance_name
776: := 'ROE Other Monies Supplementary Unemployment Benefits';
777:
778: pay_ca_archive.box17c_bal_table(12).code := 'Y';

Line 775: pay_ca_archive.box17c_bal_table(11).balance_name

771: pay_ca_archive.box17c_bal_table(10).balance_name
772: := 'ROE Other Monies Settlement or Labour Arb Award';
773:
774: pay_ca_archive.box17c_bal_table(11).code := 'U';
775: pay_ca_archive.box17c_bal_table(11).balance_name
776: := 'ROE Other Monies Supplementary Unemployment Benefits';
777:
778: pay_ca_archive.box17c_bal_table(12).code := 'Y';
779: pay_ca_archive.box17c_bal_table(12).balance_name

Line 778: pay_ca_archive.box17c_bal_table(12).code := 'Y';

774: pay_ca_archive.box17c_bal_table(11).code := 'U';
775: pay_ca_archive.box17c_bal_table(11).balance_name
776: := 'ROE Other Monies Supplementary Unemployment Benefits';
777:
778: pay_ca_archive.box17c_bal_table(12).code := 'Y';
779: pay_ca_archive.box17c_bal_table(12).balance_name
780: := 'ROE Other Monies Pay in Lieu of Notice';
781:
782: end;

Line 779: pay_ca_archive.box17c_bal_table(12).balance_name

775: pay_ca_archive.box17c_bal_table(11).balance_name
776: := 'ROE Other Monies Supplementary Unemployment Benefits';
777:
778: pay_ca_archive.box17c_bal_table(12).code := 'Y';
779: pay_ca_archive.box17c_bal_table(12).balance_name
780: := 'ROE Other Monies Pay in Lieu of Notice';
781:
782: end;
783:

Line 1152: hr_utility.set_location('pay_ca_archive.cur_amend', 10);

1148: -- So it is an amend issue.
1149:
1150: close cur_amend;
1151:
1152: hr_utility.set_location('pay_ca_archive.cur_amend', 10);
1153:
1154: hr_utility.set_message(801,'PAY_74024_ROE_AMEND_RECORD');
1155: hr_utility.set_message_token('PERSON',l_full_name);
1156: --hr_utility.raise_error;

Line 1164: hr_utility.set_location('pay_ca_archive.cur_amend', 20);

1160:
1161: -- Record not found, so it is a
1162: -- Retry Issue
1163:
1164: hr_utility.set_location('pay_ca_archive.cur_amend', 20);
1165: hr_utility.set_message(801,'PAY_74023_ROE_RETRY_RECORD');
1166: hr_utility.set_message_token('PERSON',l_full_name);
1167: --hr_utility.raise_error;
1168: RETURN FALSE;

Line 1175: hr_utility.set_location('pay_ca_archive.cur_retry', 10);

1171:
1172: else
1173:
1174: close cur_retry;
1175: hr_utility.set_location('pay_ca_archive.cur_retry', 10);
1176: RETURN TRUE;
1177:
1178: end if;
1179:

Line 1186: hr_utility.set_location('Package pay_ca_archive...action creation',1);

1182: end; -- End check_retry_amend
1183:
1184: begin
1185:
1186: hr_utility.set_location('Package pay_ca_archive...action creation',1);
1187:
1188: open cur_payroll_actions;
1189: fetch cur_payroll_actions
1190: into

Line 3071: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,

3067: for tot_no_bal in 1..12 loop
3068:
3069: l_value := '0';
3070: if balance_feed_exists(
3071: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3072: l_business_group_id) then
3073:
3074: l_defined_balance_id := get_defined_balance_id(
3075: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,

Line 3075: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,

3071: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3072: l_business_group_id) then
3073:
3074: l_defined_balance_id := get_defined_balance_id(
3075: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3076: 'Assignment within Government Reporting Entity Period to Date',
3077: l_business_group_id);
3078:
3079: hr_utility.trace('Box 17C l_defined_balance_id = ' ||

Line 3106: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name || ' = '

3102: l_latest_aaid),0);
3103: end if;
3104:
3105: hr_utility.trace(
3106: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name || ' = '
3107: || l_value);
3108:
3109: hr_utility.trace('Box 17C l_final_pay_period_end_date = ' ||
3110: to_char(l_final_pay_period_end_date));

Line 3161: l_temp_code1 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;

3157: l_temp_code3 := l_temp_code2;
3158: l_temp_value2 := l_temp_value1;
3159: l_temp_code2 := l_temp_code1;
3160: l_temp_value1 := to_number(l_value);
3161: l_temp_code1 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3162: else
3163: if to_number(l_value) >= l_temp_value2 then
3164: l_temp_value3 := l_temp_value2;
3165: l_temp_code3 := l_temp_code2;

Line 3167: l_temp_code2 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;

3163: if to_number(l_value) >= l_temp_value2 then
3164: l_temp_value3 := l_temp_value2;
3165: l_temp_code3 := l_temp_code2;
3166: l_temp_value2 := to_number(l_value);
3167: l_temp_code2 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3168: else
3169: l_temp_value3 := to_number(l_value);
3170: l_temp_code3 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3171: end if;

Line 3170: l_temp_code3 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;

3166: l_temp_value2 := to_number(l_value);
3167: l_temp_code2 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3168: else
3169: l_temp_value3 := to_number(l_value);
3170: l_temp_code3 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3171: end if;
3172: end if;
3173:
3174: end if; -- End if l_value > 0

Line 3415: pay_ca_archive.delete_asg_set_records(l_asg_set_name,

3411: -- _set_amendments.
3412:
3413: IF l_assignment_set_id IS NOT NULL THEN
3414:
3415: pay_ca_archive.delete_asg_set_records(l_asg_set_name,
3416: l_assignment_id,
3417: l_business_group_id);
3418: ELSE
3419:

Line 3424: pay_ca_archive.delete_asg_set_records('LOA_ASG_SET',

3420: -- If it's a Record of Employment for a sigle employee then
3421: -- we need to delete the assignment from the assignment sets.
3422: -- from both the assignment sets.
3423:
3424: pay_ca_archive.delete_asg_set_records('LOA_ASG_SET',
3425: l_assignment_id,
3426: l_business_group_id);
3427:
3428: pay_ca_archive.delete_asg_set_records('TERMINATION_ASG_SET',

Line 3428: pay_ca_archive.delete_asg_set_records('TERMINATION_ASG_SET',

3424: pay_ca_archive.delete_asg_set_records('LOA_ASG_SET',
3425: l_assignment_id,
3426: l_business_group_id);
3427:
3428: pay_ca_archive.delete_asg_set_records('TERMINATION_ASG_SET',
3429: l_assignment_id,
3430: l_business_group_id);
3431:
3432: END IF;

Line 3590: hr_utility.trace(' Begin pay_ca_archive.delete_asg_set_records');

3586: l_dummy VARCHAR2(1);
3587: --
3588: begin
3589: --
3590: hr_utility.trace(' Begin pay_ca_archive.delete_asg_set_records');
3591:
3592: OPEN cur_asg_set_id;
3593: FETCH cur_asg_set_id
3594: INTO l_assignment_set_id;

Line 3658: end pay_ca_archive;

3654: END;
3655: --
3656: end delete_asg_set_records;
3657: --
3658: end pay_ca_archive;