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_T4AEOY_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 51: ** pay_action_information table.

47: ** cur_non_box_mesg cursor and code
48: ** in procedure eoy_archive_data.
49: ** The T4A Nonbox footnotes are
50: ** archived into
51: ** pay_action_information table.
52: ** 25-JUL-2002 SSattini 115.21 changed the balance name from
53: ** 'T4A_BOX32' to 'T4A_BOX34'
54: ** to open c_reg_balance_feed_info
55: ** cursor for bugfix:2408456.

Line 137: ** in pay_action_information table

133: ** transmitter GRE is not found.
134: **
135: ** 30-OCT-2003 SSattini 115.35 2696309 Added functionality to archive
136: ** Pension Plan Registration Numbers
137: ** in pay_action_information table
138: ** to be reported in T4A Summary
139: ** record (Employer Level).
140: ** 02-FEB-2004 SSattini 115.38 Tuned c_eoy_gre cursor in
141: ** action_creation procedure to fix

Line 1099: from pay_action_information

1095:
1096: cursor c_get_nonbox_footnote(cp_asg_act_id number) is
1097: select action_information4,
1098: action_information5
1099: from pay_action_information
1100: where action_context_id = cp_asg_act_id
1101: and action_information_category = 'CA FOOTNOTES'
1102: and action_context_type = 'AAP'
1103: and action_information6 = 'T4A'

Line 2084: from pay_action_information

2080: ,cp_payroll_action_id number
2081: ,cp_reg_no varchar2
2082: ,cp_eff_date date) IS
2083: select action_information4,to_number(action_information5)
2084: from pay_action_information
2085: where action_context_id = cp_payroll_action_id
2086: and effective_date = cp_eff_date
2087: AND tax_unit_id = cp_tax_unit_id
2088: and action_information_category = 'CAEOY PENSION PLAN INFO'

Line 2639: hr_utility.trace('in reg1 pay_action_information');

2635: /* Bug fix#2696309, Employer level Pension Plan Register Number */
2636: hr_utility.trace('Start of Employer Level PP Reg no ');
2637:
2638: if old_l_registration_no is not null and old_l_value >0 then
2639: hr_utility.trace('in reg1 pay_action_information');
2640: hr_utility.trace('in old_l_value = ' || to_char(old_l_value));
2641: hr_utility.trace('in old_l_reg = ' || old_l_registration_no);
2642:
2643: open c_get_emplr_reg_no(to_char(l_tax_unit_id),

Line 2653: update pay_action_information

2649: hr_utility.trace('in ln_emplr_regamt new = ' || to_char(ln_emplr_regamt));
2650:
2651: ln_emplr_regamt := ln_emplr_regamt + old_l_value;
2652:
2653: update pay_action_information
2654: set action_information5 = to_char(ln_emplr_regamt)
2655: where action_context_id = l_payroll_action_id
2656: and tax_unit_id = l_tax_unit_id
2657: and effective_date = p_effective_date

Line 2664: hr_utility.trace('in reg1 new insert pay_action_information');

2660:
2661:
2662: else
2663:
2664: hr_utility.trace('in reg1 new insert pay_action_information');
2665: -- insert a new record into pay_action_information
2666:
2667: pay_action_information_api.create_action_information(
2668: p_action_information_id => l_action_information_id_1,

Line 2665: -- insert a new record into pay_action_information

2661:
2662: else
2663:
2664: hr_utility.trace('in reg1 new insert pay_action_information');
2665: -- insert a new record into pay_action_information
2666:
2667: pay_action_information_api.create_action_information(
2668: p_action_information_id => l_action_information_id_1,
2669: p_object_version_number => l_object_version_number_1,

Line 2667: pay_action_information_api.create_action_information(

2663:
2664: hr_utility.trace('in reg1 new insert pay_action_information');
2665: -- insert a new record into pay_action_information
2666:
2667: pay_action_information_api.create_action_information(
2668: p_action_information_id => l_action_information_id_1,
2669: p_object_version_number => l_object_version_number_1,
2670: p_action_information_category => 'CAEOY PENSION PLAN INFO',
2671: p_action_context_id => l_payroll_action_id,

Line 2713: hr_utility.trace('in reg2 pay_action_information');

2709: close c_get_emplr_reg_no;
2710: end if;
2711:
2712: if old_l_registration_no1 is not null and old_l_value1 >0 then
2713: hr_utility.trace('in reg2 pay_action_information');
2714:
2715: hr_utility.trace('in old_l_value1 = ' || to_char(old_l_value1));
2716: hr_utility.trace('in old_l_reg1 = ' || old_l_registration_no1);
2717:

Line 2729: update pay_action_information

2725: hr_utility.trace('in ln_emplr_regamt1 new = ' || to_char(ln_emplr_regamt1));
2726:
2727: ln_emplr_regamt1 := ln_emplr_regamt1 + old_l_value1;
2728:
2729: update pay_action_information
2730: set action_information5 = to_char(ln_emplr_regamt1)
2731: where action_context_id = l_payroll_action_id
2732: and tax_unit_id = l_tax_unit_id
2733: and effective_date = p_effective_date

Line 2738: hr_utility.trace('in reg2 new insert pay_action_information');

2734: and action_information_category = 'CAEOY PENSION PLAN INFO'
2735: AND ACTION_INFORMATION4 = old_l_registration_no1;
2736:
2737: else
2738: hr_utility.trace('in reg2 new insert pay_action_information');
2739:
2740: -- insert a new record into pay_action_information
2741:
2742: pay_action_information_api.create_action_information(

Line 2740: -- insert a new record into pay_action_information

2736:
2737: else
2738: hr_utility.trace('in reg2 new insert pay_action_information');
2739:
2740: -- insert a new record into pay_action_information
2741:
2742: pay_action_information_api.create_action_information(
2743: p_action_information_id => l_action_information_id_1,
2744: p_object_version_number => l_object_version_number_1,

Line 2742: pay_action_information_api.create_action_information(

2738: hr_utility.trace('in reg2 new insert pay_action_information');
2739:
2740: -- insert a new record into pay_action_information
2741:
2742: pay_action_information_api.create_action_information(
2743: p_action_information_id => l_action_information_id_1,
2744: p_object_version_number => l_object_version_number_1,
2745: p_action_information_category => 'CAEOY PENSION PLAN INFO',
2746: p_action_context_id => l_payroll_action_id,

Line 2788: hr_utility.trace('in reg3 pay_action_information');

2784: close c_get_emplr_reg_no;
2785: end if;
2786:
2787: if old_l_registration_no2 is not null and old_l_value2 > 0 then
2788: hr_utility.trace('in reg3 pay_action_information');
2789: hr_utility.trace('in old_l_value2 = ' || to_char(old_l_value2));
2790: hr_utility.trace('in old_l_reg2 = ' || old_l_registration_no2);
2791: open c_get_emplr_reg_no(to_char(l_tax_unit_id),
2792: l_payroll_action_id

Line 2802: update pay_action_information

2798: hr_utility.trace('in ln_emplr_regamt2 new = ' || to_char(ln_emplr_regamt2));
2799:
2800: ln_emplr_regamt2 := ln_emplr_regamt2 + old_l_value2;
2801:
2802: update pay_action_information
2803: set action_information5 = to_char(ln_emplr_regamt2)
2804: where action_context_id = l_payroll_action_id
2805: and tax_unit_id = l_tax_unit_id
2806: and effective_date = p_effective_date

Line 2810: hr_utility.trace('Updated pay_action_information');

2806: and effective_date = p_effective_date
2807: and action_information_category = 'CAEOY PENSION PLAN INFO'
2808: AND ACTION_INFORMATION4 = old_l_registration_no2;
2809:
2810: hr_utility.trace('Updated pay_action_information');
2811:
2812: else
2813: hr_utility.trace('in reg3 new insert pay_action_information');
2814:

Line 2813: hr_utility.trace('in reg3 new insert pay_action_information');

2809:
2810: hr_utility.trace('Updated pay_action_information');
2811:
2812: else
2813: hr_utility.trace('in reg3 new insert pay_action_information');
2814:
2815: -- insert a new record into pay_action_information
2816:
2817: pay_action_information_api.create_action_information(

Line 2815: -- insert a new record into pay_action_information

2811:
2812: else
2813: hr_utility.trace('in reg3 new insert pay_action_information');
2814:
2815: -- insert a new record into pay_action_information
2816:
2817: pay_action_information_api.create_action_information(
2818: p_action_information_id => l_action_information_id_1,
2819: p_object_version_number => l_object_version_number_1,

Line 2817: pay_action_information_api.create_action_information(

2813: hr_utility.trace('in reg3 new insert pay_action_information');
2814:
2815: -- insert a new record into pay_action_information
2816:
2817: pay_action_information_api.create_action_information(
2818: p_action_information_id => l_action_information_id_1,
2819: p_object_version_number => l_object_version_number_1,
2820: p_action_information_category => 'CAEOY PENSION PLAN INFO',
2821: p_action_context_id => l_payroll_action_id,

Line 2996: update pay_action_information

2992: if c_get_emplr_reg_no%FOUND then
2993: hr_utility.trace('in ln_emplr_regamt = ' || to_char(ln_emplr_regamt));
2994: ln_emplr_regamt := ln_emplr_regamt + old_l_value;
2995:
2996: update pay_action_information
2997: set action_information5 = to_char(ln_emplr_regamt)
2998: where action_context_id = l_payroll_action_id
2999: and tax_unit_id = l_tax_unit_id
3000: and effective_date = p_effective_date

Line 3005: -- insert a new record into pay_action_information

3001: and action_information_category = 'CAEOY PENSION PLAN INFO'
3002: AND ACTION_INFORMATION4 = old_l_registration_no;
3003:
3004: else
3005: -- insert a new record into pay_action_information
3006:
3007: pay_action_information_api.create_action_information(
3008: p_action_information_id => l_action_information_id_1,
3009: p_object_version_number => l_object_version_number_1,

Line 3007: pay_action_information_api.create_action_information(

3003:
3004: else
3005: -- insert a new record into pay_action_information
3006:
3007: pay_action_information_api.create_action_information(
3008: p_action_information_id => l_action_information_id_1,
3009: p_object_version_number => l_object_version_number_1,
3010: p_action_information_category => 'CAEOY PENSION PLAN INFO',
3011: p_action_context_id => l_payroll_action_id,

Line 3070: update pay_action_information

3066: if c_get_emplr_reg_no%FOUND then
3067: hr_utility.trace('in ln_emplr_regamt1 = ' || to_char(ln_emplr_regamt1));
3068: ln_emplr_regamt1 := ln_emplr_regamt1 + old_l_value1;
3069:
3070: update pay_action_information
3071: set action_information5 = to_char(ln_emplr_regamt1)
3072: where action_context_id = l_payroll_action_id
3073: and tax_unit_id = l_tax_unit_id
3074: and effective_date = p_effective_date

Line 3079: -- insert a new record into pay_action_information

3075: and action_information_category = 'CAEOY PENSION PLAN INFO'
3076: AND ACTION_INFORMATION4 = old_l_registration_no1;
3077:
3078: else
3079: -- insert a new record into pay_action_information
3080:
3081: pay_action_information_api.create_action_information(
3082: p_action_information_id => l_action_information_id_1,
3083: p_object_version_number => l_object_version_number_1,

Line 3081: pay_action_information_api.create_action_information(

3077:
3078: else
3079: -- insert a new record into pay_action_information
3080:
3081: pay_action_information_api.create_action_information(
3082: p_action_information_id => l_action_information_id_1,
3083: p_object_version_number => l_object_version_number_1,
3084: p_action_information_category => 'CAEOY PENSION PLAN INFO',
3085: p_action_context_id => l_payroll_action_id,

Line 3146: update pay_action_information

3142: hr_utility.trace('in ln_emplr_regamt2 = ' || to_char(ln_emplr_regamt2));
3143: if c_get_emplr_reg_no%FOUND then
3144: ln_emplr_regamt2 := ln_emplr_regamt2 + old_l_value2;
3145:
3146: update pay_action_information
3147: set action_information5 = to_char(ln_emplr_regamt2)
3148: where action_context_id = l_payroll_action_id
3149: and tax_unit_id = l_tax_unit_id
3150: and effective_date = p_effective_date

Line 3155: -- insert a new record into pay_action_information

3151: and action_information_category = 'CAEOY PENSION PLAN INFO'
3152: AND ACTION_INFORMATION4 = old_l_registration_no2;
3153:
3154: else
3155: -- insert a new record into pay_action_information
3156:
3157: pay_action_information_api.create_action_information(
3158: p_action_information_id => l_action_information_id_1,
3159: p_object_version_number => l_object_version_number_1,

Line 3157: pay_action_information_api.create_action_information(

3153:
3154: else
3155: -- insert a new record into pay_action_information
3156:
3157: pay_action_information_api.create_action_information(
3158: p_action_information_id => l_action_information_id_1,
3159: p_object_version_number => l_object_version_number_1,
3160: p_action_information_category => 'CAEOY PENSION PLAN INFO',
3161: p_action_context_id => l_payroll_action_id,

Line 3498: from pay_action_information

3494: ,cp_payroll_action_id number
3495: ,cp_reg_no varchar2
3496: ,cp_eff_date date) IS
3497: select action_information4,to_number(action_information5)
3498: from pay_action_information
3499: where action_context_id = cp_payroll_action_id
3500: and effective_date = cp_eff_date
3501: AND tax_unit_id = cp_tax_unit_id
3502: and action_information_category = 'CAEOY PENSION PLAN INFO'

Line 4249: hr_utility.trace('in reg1 pay_action_information');

4245:
4246: hr_utility.trace('Start of Employer Level PP Reg no ');
4247:
4248: if old_l_registration_no is not null and old_l_value >0 then
4249: hr_utility.trace('in reg1 pay_action_information');
4250: hr_utility.trace('in old_l_value = ' || to_char(old_l_value));
4251: hr_utility.trace('in old_l_reg = ' || old_l_registration_no);
4252:
4253: open c_get_emplr_reg_no(to_char(l_tax_unit_id),

Line 4263: update pay_action_information

4259: hr_utility.trace('in ln_emplr_regamt = ' || to_char(ln_emplr_regamt));
4260:
4261: ln_emplr_regamt := ln_emplr_regamt + old_l_value;
4262:
4263: update pay_action_information
4264: set action_information5 = to_char(ln_emplr_regamt)
4265: where action_context_id = l_payroll_action_id
4266: and tax_unit_id = l_tax_unit_id
4267: and effective_date = p_effective_date

Line 4274: hr_utility.trace('in reg1 insert pay_action_information');

4270:
4271:
4272: else
4273:
4274: hr_utility.trace('in reg1 insert pay_action_information');
4275: -- insert a new record into pay_action_information
4276:
4277: pay_action_information_api.create_action_information(
4278: p_action_information_id => l_action_information_id_1,

Line 4275: -- insert a new record into pay_action_information

4271:
4272: else
4273:
4274: hr_utility.trace('in reg1 insert pay_action_information');
4275: -- insert a new record into pay_action_information
4276:
4277: pay_action_information_api.create_action_information(
4278: p_action_information_id => l_action_information_id_1,
4279: p_object_version_number => l_object_version_number_1,

Line 4277: pay_action_information_api.create_action_information(

4273:
4274: hr_utility.trace('in reg1 insert pay_action_information');
4275: -- insert a new record into pay_action_information
4276:
4277: pay_action_information_api.create_action_information(
4278: p_action_information_id => l_action_information_id_1,
4279: p_object_version_number => l_object_version_number_1,
4280: p_action_information_category => 'CAEOY PENSION PLAN INFO',
4281: p_action_context_id => l_payroll_action_id,

Line 4323: hr_utility.trace('in reg2 pay_action_information');

4319: close c_get_emplr_reg_no;
4320: end if;
4321:
4322: if old_l_registration_no1 is not null and old_l_value1 >0 then
4323: hr_utility.trace('in reg2 pay_action_information');
4324:
4325: hr_utility.trace('in old_l_value1 = ' || to_char(old_l_value1));
4326: hr_utility.trace('in old_l_reg1 = ' || old_l_registration_no1);
4327:

Line 4339: update pay_action_information

4335: hr_utility.trace('in ln_emplr_regamt1 = ' || to_char(ln_emplr_regamt1));
4336:
4337: ln_emplr_regamt1 := ln_emplr_regamt1 + old_l_value1;
4338:
4339: update pay_action_information
4340: set action_information5 = to_char(ln_emplr_regamt1)
4341: where action_context_id = l_payroll_action_id
4342: and tax_unit_id = l_tax_unit_id
4343: and effective_date = p_effective_date

Line 4348: hr_utility.trace('in reg2 insert pay_action_information');

4344: and action_information_category = 'CAEOY PENSION PLAN INFO'
4345: AND ACTION_INFORMATION4 = old_l_registration_no1;
4346:
4347: else
4348: hr_utility.trace('in reg2 insert pay_action_information');
4349:
4350: -- insert a new record into pay_action_information
4351:
4352: pay_action_information_api.create_action_information(

Line 4350: -- insert a new record into pay_action_information

4346:
4347: else
4348: hr_utility.trace('in reg2 insert pay_action_information');
4349:
4350: -- insert a new record into pay_action_information
4351:
4352: pay_action_information_api.create_action_information(
4353: p_action_information_id => l_action_information_id_1,
4354: p_object_version_number => l_object_version_number_1,

Line 4352: pay_action_information_api.create_action_information(

4348: hr_utility.trace('in reg2 insert pay_action_information');
4349:
4350: -- insert a new record into pay_action_information
4351:
4352: pay_action_information_api.create_action_information(
4353: p_action_information_id => l_action_information_id_1,
4354: p_object_version_number => l_object_version_number_1,
4355: p_action_information_category => 'CAEOY PENSION PLAN INFO',
4356: p_action_context_id => l_payroll_action_id,

Line 4398: hr_utility.trace('in reg3 pay_action_information');

4394: close c_get_emplr_reg_no;
4395: end if;
4396:
4397: if old_l_registration_no2 is not null and old_l_value2 > 0 then
4398: hr_utility.trace('in reg3 pay_action_information');
4399: hr_utility.trace('in old_l_value2 = ' || to_char(old_l_value2));
4400: hr_utility.trace('in old_l_reg2 = ' || old_l_registration_no2);
4401: open c_get_emplr_reg_no(to_char(l_tax_unit_id),
4402: l_payroll_action_id

Line 4412: update pay_action_information

4408: hr_utility.trace('in ln_emplr_regamt2 = ' || to_char(ln_emplr_regamt2));
4409:
4410: ln_emplr_regamt2 := ln_emplr_regamt2 + old_l_value2;
4411:
4412: update pay_action_information
4413: set action_information5 = to_char(ln_emplr_regamt2)
4414: where action_context_id = l_payroll_action_id
4415: and tax_unit_id = l_tax_unit_id
4416: and effective_date = p_effective_date

Line 4420: hr_utility.trace('Updated pay_action_information');

4416: and effective_date = p_effective_date
4417: and action_information_category = 'CAEOY PENSION PLAN INFO'
4418: AND ACTION_INFORMATION4 = old_l_registration_no2;
4419:
4420: hr_utility.trace('Updated pay_action_information');
4421:
4422: else
4423: hr_utility.trace('in reg3 insert pay_action_information');
4424:

Line 4423: hr_utility.trace('in reg3 insert pay_action_information');

4419:
4420: hr_utility.trace('Updated pay_action_information');
4421:
4422: else
4423: hr_utility.trace('in reg3 insert pay_action_information');
4424:
4425: -- insert a new record into pay_action_information
4426:
4427: pay_action_information_api.create_action_information(

Line 4425: -- insert a new record into pay_action_information

4421:
4422: else
4423: hr_utility.trace('in reg3 insert pay_action_information');
4424:
4425: -- insert a new record into pay_action_information
4426:
4427: pay_action_information_api.create_action_information(
4428: p_action_information_id => l_action_information_id_1,
4429: p_object_version_number => l_object_version_number_1,

Line 4427: pay_action_information_api.create_action_information(

4423: hr_utility.trace('in reg3 insert pay_action_information');
4424:
4425: -- insert a new record into pay_action_information
4426:
4427: pay_action_information_api.create_action_information(
4428: p_action_information_id => l_action_information_id_1,
4429: p_object_version_number => l_object_version_number_1,
4430: p_action_information_category => 'CAEOY PENSION PLAN INFO',
4431: p_action_context_id => l_payroll_action_id,

Line 4618: update pay_action_information

4614: if c_get_emplr_reg_no%FOUND then
4615: hr_utility.trace('in ln_emplr_regamt = ' || to_char(ln_emplr_regamt));
4616: ln_emplr_regamt := ln_emplr_regamt + old_l_value;
4617:
4618: update pay_action_information
4619: set action_information5 = to_char(ln_emplr_regamt)
4620: where action_context_id = l_payroll_action_id
4621: and tax_unit_id = l_tax_unit_id
4622: and effective_date = p_effective_date

Line 4627: -- insert a new record into pay_action_information

4623: and action_information_category = 'CAEOY PENSION PLAN INFO'
4624: AND ACTION_INFORMATION4 = old_l_registration_no;
4625:
4626: else
4627: -- insert a new record into pay_action_information
4628:
4629: pay_action_information_api.create_action_information(
4630: p_action_information_id => l_action_information_id_1,
4631: p_object_version_number => l_object_version_number_1,

Line 4629: pay_action_information_api.create_action_information(

4625:
4626: else
4627: -- insert a new record into pay_action_information
4628:
4629: pay_action_information_api.create_action_information(
4630: p_action_information_id => l_action_information_id_1,
4631: p_object_version_number => l_object_version_number_1,
4632: p_action_information_category => 'CAEOY PENSION PLAN INFO',
4633: p_action_context_id => l_payroll_action_id,

Line 4692: update pay_action_information

4688: if c_get_emplr_reg_no%FOUND then
4689: hr_utility.trace('in ln_emplr_regamt1 = ' || to_char(ln_emplr_regamt1));
4690: ln_emplr_regamt1 := ln_emplr_regamt1 + old_l_value1;
4691:
4692: update pay_action_information
4693: set action_information5 = to_char(ln_emplr_regamt1)
4694: where action_context_id = l_payroll_action_id
4695: and tax_unit_id = l_tax_unit_id
4696: and effective_date = p_effective_date

Line 4701: -- insert a new record into pay_action_information

4697: and action_information_category = 'CAEOY PENSION PLAN INFO'
4698: AND ACTION_INFORMATION4 = old_l_registration_no1;
4699:
4700: else
4701: -- insert a new record into pay_action_information
4702:
4703: pay_action_information_api.create_action_information(
4704: p_action_information_id => l_action_information_id_1,
4705: p_object_version_number => l_object_version_number_1,

Line 4703: pay_action_information_api.create_action_information(

4699:
4700: else
4701: -- insert a new record into pay_action_information
4702:
4703: pay_action_information_api.create_action_information(
4704: p_action_information_id => l_action_information_id_1,
4705: p_object_version_number => l_object_version_number_1,
4706: p_action_information_category => 'CAEOY PENSION PLAN INFO',
4707: p_action_context_id => l_payroll_action_id,

Line 4768: update pay_action_information

4764: hr_utility.trace('in ln_emplr_regamt2 = ' || to_char(ln_emplr_regamt2));
4765: if c_get_emplr_reg_no%FOUND then
4766: ln_emplr_regamt2 := ln_emplr_regamt2 + old_l_value2;
4767:
4768: update pay_action_information
4769: set action_information5 = to_char(ln_emplr_regamt2)
4770: where action_context_id = l_payroll_action_id
4771: and tax_unit_id = l_tax_unit_id
4772: and effective_date = p_effective_date

Line 4777: -- insert a new record into pay_action_information

4773: and action_information_category = 'CAEOY PENSION PLAN INFO'
4774: AND ACTION_INFORMATION4 = old_l_registration_no2;
4775:
4776: else
4777: -- insert a new record into pay_action_information
4778:
4779: pay_action_information_api.create_action_information(
4780: p_action_information_id => l_action_information_id_1,
4781: p_object_version_number => l_object_version_number_1,

Line 4779: pay_action_information_api.create_action_information(

4775:
4776: else
4777: -- insert a new record into pay_action_information
4778:
4779: pay_action_information_api.create_action_information(
4780: p_action_information_id => l_action_information_id_1,
4781: p_object_version_number => l_object_version_number_1,
4782: p_action_information_category => 'CAEOY PENSION PLAN INFO',
4783: p_action_context_id => l_payroll_action_id,

Line 4876: pay_action_information_api.create_action_information(

4872: hr_utility.trace('l_prev_messages - '||l_prev_messages);
4873:
4874: if l_total_mesg_amt <> 0 then
4875:
4876: pay_action_information_api.create_action_information(
4877: p_action_information_id => l_action_information_id_1,
4878: p_object_version_number => l_object_version_number_1,
4879: p_action_information_category => 'CA FOOTNOTES',
4880: p_action_context_id => p_assactid,

Line 4954: pay_action_information_api.create_action_information(

4950: hr_utility.trace('l_total_mesg_amt - '||to_char(l_total_mesg_amt));
4951:
4952: if l_total_mesg_amt <> 0 then
4953:
4954: pay_action_information_api.create_action_information(
4955: p_action_information_id => l_action_information_id_1,
4956: p_object_version_number => l_object_version_number_1,
4957: p_action_information_category => 'CA FOOTNOTES',
4958: p_action_context_id => p_assactid,