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.12010000.2 2009/02/04 12:18:04 aneghosh ship $ */
3: -- /************************************************************************
4: --
5: -- Description : Package and procedure to build sql for payroll processes.

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

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

Line 739: pay_ca_archive.box17c_bal_table(1).balance_name

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

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

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

Line 743: pay_ca_archive.box17c_bal_table(2).balance_name

739: pay_ca_archive.box17c_bal_table(1).balance_name
740: := 'ROE Other Monies Anniversary Payout';
741:
742: pay_ca_archive.box17c_bal_table(2).code := 'B';
743: pay_ca_archive.box17c_bal_table(2).balance_name
744: := 'ROE Other Monies Bonus';
745:
746: pay_ca_archive.box17c_bal_table(3).code := 'E';
747: pay_ca_archive.box17c_bal_table(3).balance_name

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

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

Line 747: pay_ca_archive.box17c_bal_table(3).balance_name

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

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

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

Line 751: pay_ca_archive.box17c_bal_table(4).balance_name

747: pay_ca_archive.box17c_bal_table(3).balance_name
748: := 'ROE Other Monies Severance Pay';
749:
750: pay_ca_archive.box17c_bal_table(4).code := 'G';
751: pay_ca_archive.box17c_bal_table(4).balance_name
752: := 'ROE Other Monies Gratuities';
753:
754: pay_ca_archive.box17c_bal_table(5).code := 'H';
755: pay_ca_archive.box17c_bal_table(5).balance_name

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

750: pay_ca_archive.box17c_bal_table(4).code := 'G';
751: pay_ca_archive.box17c_bal_table(4).balance_name
752: := 'ROE Other Monies Gratuities';
753:
754: pay_ca_archive.box17c_bal_table(5).code := 'H';
755: pay_ca_archive.box17c_bal_table(5).balance_name
756: := 'ROE Other Monies Honorariums';
757:
758: pay_ca_archive.box17c_bal_table(6).code := 'I';

Line 755: pay_ca_archive.box17c_bal_table(5).balance_name

751: pay_ca_archive.box17c_bal_table(4).balance_name
752: := 'ROE Other Monies Gratuities';
753:
754: pay_ca_archive.box17c_bal_table(5).code := 'H';
755: pay_ca_archive.box17c_bal_table(5).balance_name
756: := 'ROE Other Monies Honorariums';
757:
758: pay_ca_archive.box17c_bal_table(6).code := 'I';
759: pay_ca_archive.box17c_bal_table(6).balance_name

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

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

Line 759: pay_ca_archive.box17c_bal_table(6).balance_name

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

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

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

Line 763: pay_ca_archive.box17c_bal_table(7).balance_name

759: pay_ca_archive.box17c_bal_table(6).balance_name
760: := 'ROE Other Monies Sick Leave Credit';
761:
762: pay_ca_archive.box17c_bal_table(7).code := 'N';
763: pay_ca_archive.box17c_bal_table(7).balance_name
764: := 'ROE Other Monies Pensions';
765:
766: pay_ca_archive.box17c_bal_table(8).code := 'O';
767: pay_ca_archive.box17c_bal_table(8).balance_name

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

762: pay_ca_archive.box17c_bal_table(7).code := 'N';
763: pay_ca_archive.box17c_bal_table(7).balance_name
764: := 'ROE Other Monies Pensions';
765:
766: pay_ca_archive.box17c_bal_table(8).code := 'O';
767: pay_ca_archive.box17c_bal_table(8).balance_name
768: := 'ROE Other Monies Other';
769:
770: pay_ca_archive.box17c_bal_table(9).code := 'R';

Line 767: pay_ca_archive.box17c_bal_table(8).balance_name

763: pay_ca_archive.box17c_bal_table(7).balance_name
764: := 'ROE Other Monies Pensions';
765:
766: pay_ca_archive.box17c_bal_table(8).code := 'O';
767: pay_ca_archive.box17c_bal_table(8).balance_name
768: := 'ROE Other Monies Other';
769:
770: pay_ca_archive.box17c_bal_table(9).code := 'R';
771: pay_ca_archive.box17c_bal_table(9).balance_name

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

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

Line 771: pay_ca_archive.box17c_bal_table(9).balance_name

767: pay_ca_archive.box17c_bal_table(8).balance_name
768: := 'ROE Other Monies Other';
769:
770: pay_ca_archive.box17c_bal_table(9).code := 'R';
771: pay_ca_archive.box17c_bal_table(9).balance_name
772: := 'ROE Other Monies Retirement Leave Credits';
773:
774: pay_ca_archive.box17c_bal_table(10).code := 'S';
775: pay_ca_archive.box17c_bal_table(10).balance_name

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

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

Line 775: pay_ca_archive.box17c_bal_table(10).balance_name

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

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

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

Line 779: pay_ca_archive.box17c_bal_table(11).balance_name

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

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

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

Line 783: pay_ca_archive.box17c_bal_table(12).balance_name

779: pay_ca_archive.box17c_bal_table(11).balance_name
780: := 'ROE Other Monies Supplementary Unemployment Benefits';
781:
782: pay_ca_archive.box17c_bal_table(12).code := 'Y';
783: pay_ca_archive.box17c_bal_table(12).balance_name
784: := 'ROE Other Monies Pay in Lieu of Notice';
785:
786: end;
787:

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

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

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

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

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

1175:
1176: else
1177:
1178: close cur_retry;
1179: hr_utility.set_location('pay_ca_archive.cur_retry', 10);
1180: RETURN TRUE;
1181:
1182: end if;
1183:

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

1186: end; -- End check_retry_amend
1187:
1188: begin
1189:
1190: hr_utility.set_location('Package pay_ca_archive...action creation',1);
1191:
1192: open cur_payroll_actions;
1193: fetch cur_payroll_actions
1194: into

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

3088: for tot_no_bal in 1..12 loop
3089:
3090: l_value := '0';
3091: if balance_feed_exists(
3092: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3093: l_business_group_id) then
3094:
3095: l_defined_balance_id := get_defined_balance_id(
3096: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,

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

3092: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3093: l_business_group_id) then
3094:
3095: l_defined_balance_id := get_defined_balance_id(
3096: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name,
3097: 'Assignment within Government Reporting Entity Period to Date',
3098: l_business_group_id);
3099:
3100: hr_utility.trace('Box 17C l_defined_balance_id = ' ||

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

3123: l_latest_aaid),0);
3124: end if;
3125:
3126: hr_utility.trace(
3127: pay_ca_archive.box17c_bal_table(tot_no_bal).balance_name || ' = '
3128: || l_value);
3129:
3130: hr_utility.trace('Box 17C l_final_pay_period_end_date = ' ||
3131: to_char(l_final_pay_period_end_date));

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

3178: l_temp_code3 := l_temp_code2;
3179: l_temp_value2 := l_temp_value1;
3180: l_temp_code2 := l_temp_code1;
3181: l_temp_value1 := to_number(l_value);
3182: l_temp_code1 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3183: else
3184: if to_number(l_value) >= l_temp_value2 then
3185: l_temp_value3 := l_temp_value2;
3186: l_temp_code3 := l_temp_code2;

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

3184: if to_number(l_value) >= l_temp_value2 then
3185: l_temp_value3 := l_temp_value2;
3186: l_temp_code3 := l_temp_code2;
3187: l_temp_value2 := to_number(l_value);
3188: l_temp_code2 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3189: else
3190: l_temp_value3 := to_number(l_value);
3191: l_temp_code3 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3192: end if;

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

3187: l_temp_value2 := to_number(l_value);
3188: l_temp_code2 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3189: else
3190: l_temp_value3 := to_number(l_value);
3191: l_temp_code3 := pay_ca_archive.box17c_bal_table(tot_no_bal).code;
3192: end if;
3193: end if;
3194:
3195: end if; -- End if l_value > 0

Line 3436: pay_ca_archive.delete_asg_set_records(l_asg_set_name,

3432: -- _set_amendments.
3433:
3434: IF l_assignment_set_id IS NOT NULL THEN
3435:
3436: pay_ca_archive.delete_asg_set_records(l_asg_set_name,
3437: l_assignment_id,
3438: l_business_group_id);
3439: ELSE
3440:

Line 3445: pay_ca_archive.delete_asg_set_records('LOA_ASG_SET',

3441: -- If it's a Record of Employment for a sigle employee then
3442: -- we need to delete the assignment from the assignment sets.
3443: -- from both the assignment sets.
3444:
3445: pay_ca_archive.delete_asg_set_records('LOA_ASG_SET',
3446: l_assignment_id,
3447: l_business_group_id);
3448:
3449: pay_ca_archive.delete_asg_set_records('TERMINATION_ASG_SET',

Line 3449: pay_ca_archive.delete_asg_set_records('TERMINATION_ASG_SET',

3445: pay_ca_archive.delete_asg_set_records('LOA_ASG_SET',
3446: l_assignment_id,
3447: l_business_group_id);
3448:
3449: pay_ca_archive.delete_asg_set_records('TERMINATION_ASG_SET',
3450: l_assignment_id,
3451: l_business_group_id);
3452:
3453: END IF;

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

3607: l_dummy VARCHAR2(1);
3608: --
3609: begin
3610: --
3611: hr_utility.trace(' Begin pay_ca_archive.delete_asg_set_records');
3612:
3613: OPEN cur_asg_set_id;
3614: FETCH cur_asg_set_id
3615: INTO l_assignment_set_id;

Line 3679: end pay_ca_archive;

3675: END;
3676: --
3677: end delete_asg_set_records;
3678: --
3679: end pay_ca_archive;