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 922: from pay_action_information

918:
919: cursor c_get_nonbox_footnote(cp_asg_act_id number) is
920: select action_information4,
921: action_information5
922: from pay_action_information
923: where action_context_id = cp_asg_act_id
924: and action_information_category = 'CA FOOTNOTES'
925: and action_context_type = 'AAP'
926: and action_information6 = 'T4A'

Line 1953: from pay_action_information

1949: ,cp_payroll_action_id number
1950: ,cp_reg_no varchar2
1951: ,cp_eff_date date) IS
1952: select action_information4,to_number(action_information5)
1953: from pay_action_information
1954: where action_context_id = cp_payroll_action_id
1955: and effective_date = cp_eff_date
1956: AND tax_unit_id = cp_tax_unit_id
1957: and action_information_category = 'CAEOY PENSION PLAN INFO'

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

2651: /* Bug fix#2696309, Employer level Pension Plan Register Number */
2652: hr_utility.trace('Start of Employer Level PP Reg no ');
2653:
2654: if old_l_registration_no is not null and old_l_value >0 then
2655: hr_utility.trace('in reg1 pay_action_information');
2656: hr_utility.trace('in old_l_value = ' || to_char(old_l_value));
2657: hr_utility.trace('in old_l_reg = ' || old_l_registration_no);
2658:
2659: open c_get_emplr_reg_no(to_char(l_tax_unit_id),

Line 2669: update pay_action_information

2665: hr_utility.trace('in ln_emplr_regamt = ' || to_char(ln_emplr_regamt));
2666:
2667: ln_emplr_regamt := ln_emplr_regamt + old_l_value;
2668:
2669: update pay_action_information
2670: set action_information5 = to_char(ln_emplr_regamt)
2671: where action_context_id = l_payroll_action_id
2672: and tax_unit_id = l_tax_unit_id
2673: and effective_date = p_effective_date

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

2676:
2677:
2678: else
2679:
2680: hr_utility.trace('in reg1 insert pay_action_information');
2681: -- insert a new record into pay_action_information
2682:
2683: pay_action_information_api.create_action_information(
2684: p_action_information_id => l_action_information_id_1,

Line 2681: -- insert a new record into pay_action_information

2677:
2678: else
2679:
2680: hr_utility.trace('in reg1 insert pay_action_information');
2681: -- insert a new record into pay_action_information
2682:
2683: pay_action_information_api.create_action_information(
2684: p_action_information_id => l_action_information_id_1,
2685: p_object_version_number => l_object_version_number_1,

Line 2683: pay_action_information_api.create_action_information(

2679:
2680: hr_utility.trace('in reg1 insert pay_action_information');
2681: -- insert a new record into pay_action_information
2682:
2683: pay_action_information_api.create_action_information(
2684: p_action_information_id => l_action_information_id_1,
2685: p_object_version_number => l_object_version_number_1,
2686: p_action_information_category => 'CAEOY PENSION PLAN INFO',
2687: p_action_context_id => l_payroll_action_id,

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

2725: close c_get_emplr_reg_no;
2726: end if;
2727:
2728: if old_l_registration_no1 is not null and old_l_value1 >0 then
2729: hr_utility.trace('in reg2 pay_action_information');
2730:
2731: hr_utility.trace('in old_l_value1 = ' || to_char(old_l_value1));
2732: hr_utility.trace('in old_l_reg1 = ' || old_l_registration_no1);
2733:

Line 2745: update pay_action_information

2741: hr_utility.trace('in ln_emplr_regamt1 = ' || to_char(ln_emplr_regamt1));
2742:
2743: ln_emplr_regamt1 := ln_emplr_regamt1 + old_l_value1;
2744:
2745: update pay_action_information
2746: set action_information5 = to_char(ln_emplr_regamt1)
2747: where action_context_id = l_payroll_action_id
2748: and tax_unit_id = l_tax_unit_id
2749: and effective_date = p_effective_date

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

2750: and action_information_category = 'CAEOY PENSION PLAN INFO'
2751: AND ACTION_INFORMATION4 = old_l_registration_no1;
2752:
2753: else
2754: hr_utility.trace('in reg2 insert pay_action_information');
2755:
2756: -- insert a new record into pay_action_information
2757:
2758: pay_action_information_api.create_action_information(

Line 2756: -- insert a new record into pay_action_information

2752:
2753: else
2754: hr_utility.trace('in reg2 insert pay_action_information');
2755:
2756: -- insert a new record into pay_action_information
2757:
2758: pay_action_information_api.create_action_information(
2759: p_action_information_id => l_action_information_id_1,
2760: p_object_version_number => l_object_version_number_1,

Line 2758: pay_action_information_api.create_action_information(

2754: hr_utility.trace('in reg2 insert pay_action_information');
2755:
2756: -- insert a new record into pay_action_information
2757:
2758: pay_action_information_api.create_action_information(
2759: p_action_information_id => l_action_information_id_1,
2760: p_object_version_number => l_object_version_number_1,
2761: p_action_information_category => 'CAEOY PENSION PLAN INFO',
2762: p_action_context_id => l_payroll_action_id,

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

2800: close c_get_emplr_reg_no;
2801: end if;
2802:
2803: if old_l_registration_no2 is not null and old_l_value2 > 0 then
2804: hr_utility.trace('in reg3 pay_action_information');
2805: hr_utility.trace('in old_l_value2 = ' || to_char(old_l_value2));
2806: hr_utility.trace('in old_l_reg2 = ' || old_l_registration_no2);
2807: open c_get_emplr_reg_no(to_char(l_tax_unit_id),
2808: l_payroll_action_id

Line 2818: update pay_action_information

2814: hr_utility.trace('in ln_emplr_regamt2 = ' || to_char(ln_emplr_regamt2));
2815:
2816: ln_emplr_regamt2 := ln_emplr_regamt2 + old_l_value2;
2817:
2818: update pay_action_information
2819: set action_information5 = to_char(ln_emplr_regamt2)
2820: where action_context_id = l_payroll_action_id
2821: and tax_unit_id = l_tax_unit_id
2822: and effective_date = p_effective_date

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

2822: and effective_date = p_effective_date
2823: and action_information_category = 'CAEOY PENSION PLAN INFO'
2824: AND ACTION_INFORMATION4 = old_l_registration_no2;
2825:
2826: hr_utility.trace('Updated pay_action_information');
2827:
2828: else
2829: hr_utility.trace('in reg3 insert pay_action_information');
2830:

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

2825:
2826: hr_utility.trace('Updated pay_action_information');
2827:
2828: else
2829: hr_utility.trace('in reg3 insert pay_action_information');
2830:
2831: -- insert a new record into pay_action_information
2832:
2833: pay_action_information_api.create_action_information(

Line 2831: -- insert a new record into pay_action_information

2827:
2828: else
2829: hr_utility.trace('in reg3 insert pay_action_information');
2830:
2831: -- insert a new record into pay_action_information
2832:
2833: pay_action_information_api.create_action_information(
2834: p_action_information_id => l_action_information_id_1,
2835: p_object_version_number => l_object_version_number_1,

Line 2833: pay_action_information_api.create_action_information(

2829: hr_utility.trace('in reg3 insert pay_action_information');
2830:
2831: -- insert a new record into pay_action_information
2832:
2833: pay_action_information_api.create_action_information(
2834: p_action_information_id => l_action_information_id_1,
2835: p_object_version_number => l_object_version_number_1,
2836: p_action_information_category => 'CAEOY PENSION PLAN INFO',
2837: p_action_context_id => l_payroll_action_id,

Line 3016: update pay_action_information

3012: if c_get_emplr_reg_no%FOUND then
3013: hr_utility.trace('in ln_emplr_regamt = ' || to_char(ln_emplr_regamt));
3014: ln_emplr_regamt := ln_emplr_regamt + old_l_value;
3015:
3016: update pay_action_information
3017: set action_information5 = to_char(ln_emplr_regamt)
3018: where action_context_id = l_payroll_action_id
3019: and tax_unit_id = l_tax_unit_id
3020: and effective_date = p_effective_date

Line 3025: -- insert a new record into pay_action_information

3021: and action_information_category = 'CAEOY PENSION PLAN INFO'
3022: AND ACTION_INFORMATION4 = old_l_registration_no;
3023:
3024: else
3025: -- insert a new record into pay_action_information
3026:
3027: pay_action_information_api.create_action_information(
3028: p_action_information_id => l_action_information_id_1,
3029: p_object_version_number => l_object_version_number_1,

Line 3027: pay_action_information_api.create_action_information(

3023:
3024: else
3025: -- insert a new record into pay_action_information
3026:
3027: pay_action_information_api.create_action_information(
3028: p_action_information_id => l_action_information_id_1,
3029: p_object_version_number => l_object_version_number_1,
3030: p_action_information_category => 'CAEOY PENSION PLAN INFO',
3031: p_action_context_id => l_payroll_action_id,

Line 3090: update pay_action_information

3086: if c_get_emplr_reg_no%FOUND then
3087: hr_utility.trace('in ln_emplr_regamt1 = ' || to_char(ln_emplr_regamt1));
3088: ln_emplr_regamt1 := ln_emplr_regamt1 + old_l_value1;
3089:
3090: update pay_action_information
3091: set action_information5 = to_char(ln_emplr_regamt1)
3092: where action_context_id = l_payroll_action_id
3093: and tax_unit_id = l_tax_unit_id
3094: and effective_date = p_effective_date

Line 3099: -- insert a new record into pay_action_information

3095: and action_information_category = 'CAEOY PENSION PLAN INFO'
3096: AND ACTION_INFORMATION4 = old_l_registration_no1;
3097:
3098: else
3099: -- insert a new record into pay_action_information
3100:
3101: pay_action_information_api.create_action_information(
3102: p_action_information_id => l_action_information_id_1,
3103: p_object_version_number => l_object_version_number_1,

Line 3101: pay_action_information_api.create_action_information(

3097:
3098: else
3099: -- insert a new record into pay_action_information
3100:
3101: pay_action_information_api.create_action_information(
3102: p_action_information_id => l_action_information_id_1,
3103: p_object_version_number => l_object_version_number_1,
3104: p_action_information_category => 'CAEOY PENSION PLAN INFO',
3105: p_action_context_id => l_payroll_action_id,

Line 3166: update pay_action_information

3162: hr_utility.trace('in ln_emplr_regamt2 = ' || to_char(ln_emplr_regamt2));
3163: if c_get_emplr_reg_no%FOUND then
3164: ln_emplr_regamt2 := ln_emplr_regamt2 + old_l_value2;
3165:
3166: update pay_action_information
3167: set action_information5 = to_char(ln_emplr_regamt2)
3168: where action_context_id = l_payroll_action_id
3169: and tax_unit_id = l_tax_unit_id
3170: and effective_date = p_effective_date

Line 3175: -- insert a new record into pay_action_information

3171: and action_information_category = 'CAEOY PENSION PLAN INFO'
3172: AND ACTION_INFORMATION4 = old_l_registration_no2;
3173:
3174: else
3175: -- insert a new record into pay_action_information
3176:
3177: pay_action_information_api.create_action_information(
3178: p_action_information_id => l_action_information_id_1,
3179: p_object_version_number => l_object_version_number_1,

Line 3177: pay_action_information_api.create_action_information(

3173:
3174: else
3175: -- insert a new record into pay_action_information
3176:
3177: pay_action_information_api.create_action_information(
3178: p_action_information_id => l_action_information_id_1,
3179: p_object_version_number => l_object_version_number_1,
3180: p_action_information_category => 'CAEOY PENSION PLAN INFO',
3181: p_action_context_id => l_payroll_action_id,

Line 3270: pay_action_information_api.create_action_information(

3266: hr_utility.trace('l_prev_messages - '||l_prev_messages);
3267:
3268: if l_total_mesg_amt <> 0 then
3269:
3270: pay_action_information_api.create_action_information(
3271: p_action_information_id => l_action_information_id_1,
3272: p_object_version_number => l_object_version_number_1,
3273: p_action_information_category => 'CA FOOTNOTES',
3274: p_action_context_id => p_assactid,

Line 3348: pay_action_information_api.create_action_information(

3344: hr_utility.trace('l_total_mesg_amt - '||to_char(l_total_mesg_amt));
3345:
3346: if l_total_mesg_amt <> 0 then
3347:
3348: pay_action_information_api.create_action_information(
3349: p_action_information_id => l_action_information_id_1,
3350: p_object_version_number => l_object_version_number_1,
3351: p_action_information_category => 'CA FOOTNOTES',
3352: p_action_context_id => p_assactid,