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

Line 262: FROM pay_action_information

258: -- fnd_file.put_line(fnd_file.log,'Range Code 5');
259:
260: SELECT count(*)
261: INTO l_count
262: FROM pay_action_information
263: WHERE action_information_category = 'EMEA REPORT DETAILS'
264: AND action_information1 = 'PYFIDPSA'
265: AND action_context_id = p_payroll_action_id;
266:

Line 348: pay_action_information_api.create_action_information (

344:
345: -- fnd_file.put_line(fnd_file.log,'Range Code 13');
346:
347:
348: pay_action_information_api.create_action_information (
349: p_action_information_id => l_action_info_id
350: ,p_action_context_id => p_payroll_action_id
351: ,p_action_context_type => 'PA'
352: ,p_object_version_number => l_ovn

Line 390: pay_action_information_api.create_action_information (

386: ,p_action_information30 => null );
387:
388: -- fnd_file.put_line(fnd_file.log,'Range Code 14');
389:
390: pay_action_information_api.create_action_information (
391: p_action_information_id => l_action_info_id
392: ,p_action_context_id => p_payroll_action_id
393: ,p_action_context_type => 'PA'
394: ,p_object_version_number => l_ovn

Line 810: FROM pay_action_information pai , pay_assignment_actions paa

806: CURSOR csr_rpt_header (p_asg_act_id NUMBER) IS
807: SELECT action_context_id payroll_action_id ,action_information2 emp_type ,action_information3 emp_id
808: ,action_information4 business_id ,action_information5 org_type ,action_information6 contact_person
809: ,action_information7 phone ,action_information8 year ,action_information9 transact_type
810: FROM pay_action_information pai , pay_assignment_actions paa
811: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
812: AND pai.action_information1 = 'PYFIDPSA'
813: AND pai.action_context_id = paa.payroll_action_id
814: AND paa.assignment_action_id = p_asg_act_id;

Line 874: FROM pay_action_information

870:
871: /* Cursor to check archived data */
872: CURSOR csr_arch_chk (p_record_id VARCHAR2, p_payment_type VARCHAR2, p_assignment_action_id NUMBER) IS
873: SELECT COUNT(*)
874: FROM pay_action_information
875: WHERE action_information_category = 'EMEA REPORT INFORMATION'
876: AND action_context_type = 'AAP'
877: AND action_context_id= p_assignment_action_id
878: AND action_information1 =p_record_id

Line 2583: pay_action_information_api.create_action_information (

2579: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2580: CLOSE csr_Get_Defined_Balance_Id;
2581: l_wtax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id, P_VIRTUAL_DATE => l_bal_date) ;
2582:
2583: pay_action_information_api.create_action_information (
2584: p_action_information_id=> l_action_info_id,
2585: p_action_context_id=> p_assignment_action_id,
2586: p_action_context_type=> 'AAP',
2587: p_object_version_number=> l_ovn,

Line 2633: pay_action_information_api.create_action_information (

2629:
2630: ELSE
2631:
2632: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 37');
2633: pay_action_information_api.create_action_information (
2634: p_action_information_id=> l_action_info_id,
2635: p_action_context_id=> p_assignment_action_id,
2636: p_action_context_type=> 'AAP',
2637: p_object_version_number=> l_ovn,

Line 2674: pay_action_information_api.create_action_information (

2670: p_action_information29=> '1' ,
2671: p_action_information30 => NULL
2672: );
2673:
2674: pay_action_information_api.create_action_information (
2675: p_action_information_id=> l_action_info_id,
2676: p_action_context_id=> p_assignment_action_id,
2677: p_action_context_type=> 'AAP',
2678: p_object_version_number=> l_ovn,

Line 2716: pay_action_information_api.create_action_information (

2712: p_action_information30 => NULL
2713: );
2714:
2715: IF l_s1_tax_base > 0 THEN
2716: pay_action_information_api.create_action_information (
2717: p_action_information_id=> l_action_info_id,
2718: p_action_context_id=> p_assignment_action_id,
2719: p_action_context_type=> 'AAP',
2720: p_object_version_number=> l_ovn,

Line 2759: pay_action_information_api.create_action_information (

2755: );
2756: END IF;
2757:
2758: IF l_s2_tax_base > 0 THEN
2759: pay_action_information_api.create_action_information (
2760: p_action_information_id=> l_action_info_id,
2761: p_action_context_id=> p_assignment_action_id,
2762: p_action_context_type=> 'AAP',
2763: p_object_version_number=> l_ovn,

Line 2803: pay_action_information_api.create_action_information (

2799: END IF;
2800:
2801: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 38');
2802: IF l_s3_tax_base > 0 THEN
2803: pay_action_information_api.create_action_information (
2804: p_action_information_id=> l_action_info_id,
2805: p_action_context_id=> p_assignment_action_id,
2806: p_action_context_type=> 'AAP',
2807: p_object_version_number=> l_ovn,

Line 2850: pay_action_information_api.create_action_information (

2846:
2847: ELSIF l_count < 1 and l_record_id ='VSRAERIE' THEN
2848: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 39');
2849:
2850: pay_action_information_api.create_action_information (
2851: p_action_information_id=> l_action_info_id,
2852: p_action_context_id=> p_assignment_action_id,
2853: p_action_context_type=> 'AAP',
2854: p_object_version_number=> l_ovn,

Line 2891: pay_action_information_api.create_action_information (

2887: p_action_information29=> NULL,
2888: p_action_information30=> NULL
2889: );
2890: IF l_s1_tax_base > 0 THEN
2891: pay_action_information_api.create_action_information (
2892: p_action_information_id=> l_action_info_id,
2893: p_action_context_id=> p_assignment_action_id,
2894: p_action_context_type=> 'AAP',
2895: p_object_version_number=> l_ovn,

Line 2934: pay_action_information_api.create_action_information (

2930: );
2931: END IF;
2932:
2933: IF l_s2_tax_base > 0 THEN
2934: pay_action_information_api.create_action_information (
2935: p_action_information_id=> l_action_info_id,
2936: p_action_context_id=> p_assignment_action_id,
2937: p_action_context_type=> 'AAP',
2938: p_object_version_number=> l_ovn,

Line 3026: pay_action_information_api.create_action_information (

3022: ELSE
3023: CODE_014:= l_subsidy_basis;
3024: END IF;
3025:
3026: pay_action_information_api.create_action_information (
3027: p_action_information_id=> l_action_info_id,
3028: p_action_context_id=> p_assignment_action_id,
3029: p_action_context_type=> 'AAP',
3030: p_object_version_number=> l_ovn,

Line 3095: FROM pay_action_information pai

3091: CURSOR csr_prpt_header (p_payroll_action_id NUMBER) IS
3092: SELECT action_information2 emp_type ,action_information3 emp_id
3093: ,action_information4 business_id ,action_information5 org_type ,action_information6 contact_person
3094: ,action_information7 phone ,action_information8 year ,action_information9 transact_type
3095: FROM pay_action_information pai
3096: WHERE action_information_category = 'EMEA REPORT INFORMATION'
3097: AND action_information1 = 'PYFIDPSA'
3098: AND action_context_id = p_payroll_action_id;
3099:

Line 3107: FROM pay_action_information pai , pay_assignment_actions paa

3103: CURSOR csr_arch_fi (p_payroll_action_id NUMBER) IS
3104: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
3105: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
3106: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
3107: FROM pay_action_information pai , pay_assignment_actions paa
3108: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3109: AND pai.action_context_type= 'AAP'
3110: AND pai.action_context_id= paa.assignment_action_id
3111: AND paa.payroll_action_id = p_payroll_action_id

Line 3122: FROM pay_action_information pai , pay_assignment_actions paa

3118: CURSOR csr_arch_fi_p2 (p_payroll_action_id NUMBER) IS
3119: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
3120: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
3121: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
3122: FROM pay_action_information pai , pay_assignment_actions paa
3123: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3124: AND pai.action_context_type= 'AAP'
3125: AND pai.action_context_id= paa.assignment_action_id
3126: AND paa.payroll_action_id = p_payroll_action_id

Line 3140: FROM pay_action_information pai , pay_assignment_actions paa

3136: /* Cursor to fetch data related to Foreign Residents Social Security Not Liable*/
3137: CURSOR csr_arch_fr_nss ( p_payroll_action_id NUMBER) IS
3138: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3139: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3140: FROM pay_action_information pai , pay_assignment_actions paa
3141: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3142: AND pai.action_context_type= 'AAP'
3143: AND pai.action_context_id= paa.assignment_action_id
3144: AND paa.payroll_action_id = p_payroll_action_id

Line 3154: FROM pay_action_information pai , pay_assignment_actions paa

3150: /* Cursor to fetch data related to Foreign Residents Social Security liable*/
3151: CURSOR csr_arch_fr_ss ( p_payroll_action_id NUMBER) IS
3152: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3153: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3154: FROM pay_action_information pai , pay_assignment_actions paa
3155: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3156: AND pai.action_context_type= 'AAP'
3157: AND pai.action_context_id= paa.assignment_action_id
3158: AND paa.payroll_action_id = p_payroll_action_id

Line 3166: FROM pay_action_information pai , pay_assignment_actions paa

3162:
3163: /* Cursor to fetch data related to Record VSPSERIE*/
3164: CURSOR csr_VSPSERIE (p_payroll_action_id NUMBER) IS
3165: SELECT pai.action_information30
3166: FROM pay_action_information pai , pay_assignment_actions paa
3167: WHERE paa.payroll_action_id = p_payroll_action_id
3168: AND pai.action_context_id= paa.assignment_action_id
3169: AND pai.action_context_type= 'AAP'
3170: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3180: FROM pay_action_information pai , pay_assignment_actions paa

3176:
3177: /* Cursor to fetch data related to Record VSRAERIE*/
3178: CURSOR csr_VSRAERIE(p_payroll_action_id NUMBER) IS
3179: SELECT pai.action_information30
3180: FROM pay_action_information pai , pay_assignment_actions paa
3181: WHERE paa.payroll_action_id = p_payroll_action_id
3182: AND pai.action_context_id= paa.assignment_action_id
3183: AND pai.action_context_type= 'AAP'
3184: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3193: FROM pay_action_information pai

3189:
3190: /* Cursor to fetch data related to Record VSPSVYSL*/
3191: CURSOR csr_VSPSVYSL(p_payroll_action_id NUMBER) IS
3192: SELECT *
3193: FROM pay_action_information pai
3194: WHERE pai.action_context_id= p_payroll_action_id
3195: AND pai.action_context_type= 'PA'
3196: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
3197: AND pai.action_information1 = 'PYFIDPSA'

Line 3207: FROM pay_action_information pai

3203:
3204: /* Cursor to fetch data related to Record VSPSVYHT*/
3205: CURSOR csr_VSPSVYHT(p_payroll_action_id NUMBER) IS
3206: SELECT *
3207: FROM pay_action_information pai
3208: WHERE pai.action_context_id= p_payroll_action_id
3209: AND pai.action_context_type= 'PA'
3210: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
3211: AND pai.action_information1 = 'PYFIDPSA'

Line 3220: FROM pay_action_information pai , pay_assignment_actions paa

3216:
3217: /* Cursor to fetch data related to Record VSPSTUKI*/
3218: CURSOR csr_VSPSTUKI(p_payroll_action_id NUMBER) IS
3219: SELECT pai.action_information30
3220: FROM pay_action_information pai , pay_assignment_actions paa
3221: WHERE paa.payroll_action_id = p_payroll_action_id
3222: AND pai.action_context_id= paa.assignment_action_id
3223: AND pai.action_context_type= 'AAP'
3224: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3302: pay_action_information_api.create_action_information (

3298: FETCH csr_arch_fi_p2 INTO rg_csr_arch_fi_p2;
3299: CLOSE csr_arch_fi_p2;
3300:
3301: -- fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 5');
3302: pay_action_information_api.create_action_information (
3303: p_action_information_id=> l_action_info_id,
3304: p_action_context_id=> p_payroll_action_id,
3305: p_action_context_type=> 'PA',
3306: p_object_version_number=> l_ovn,

Line 3352: pay_action_information_api.create_action_information (

3348: l_tot_670:= nvl(rg_csr_arch_fi.code_670,0) + nvl(rg_csr_arch_fi_p2.code_670,0) + l_tot_670;
3349:
3350: -- fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 6');
3351: ELSE
3352: pay_action_information_api.create_action_information (
3353: p_action_information_id=> l_action_info_id,
3354: p_action_context_id=> p_payroll_action_id,
3355: p_action_context_type=> 'PA',
3356: p_object_version_number=> l_ovn,

Line 3408: pay_action_information_api.create_action_information (

3404: -- fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 7');
3405: FOR rg_csr_arch_fr_ss IN csr_arch_fr_ss(p_payroll_action_id)
3406: LOOP
3407: -- fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 8');
3408: pay_action_information_api.create_action_information (
3409: p_action_information_id=> l_action_info_id,
3410: p_action_context_id=> p_payroll_action_id,
3411: p_action_context_type=> 'PA',
3412: p_object_version_number=> l_ovn,

Line 3460: pay_action_information_api.create_action_information (

3456: -- fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 10');
3457: FOR rg_csr_arch_fr_nss IN csr_arch_fr_nss(p_payroll_action_id)
3458: LOOP
3459: -- fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 11');
3460: pay_action_information_api.create_action_information (
3461: p_action_information_id=> l_action_info_id,
3462: p_action_context_id=> p_payroll_action_id,
3463: p_action_context_type=> 'PA',
3464: p_object_version_number=> l_ovn,

Line 3526: pay_action_information_api.create_action_information (

3522: l_tot_631:= g_deduction_ss*100;
3523: END IF;
3524:
3525: -- fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 12');
3526: pay_action_information_api.create_action_information (
3527: p_action_information_id=> l_action_info_id,
3528: p_action_context_id=> p_payroll_action_id,
3529: p_action_context_type=> 'PA',
3530: p_object_version_number=> l_ovn,

Line 3575: UPDATE pay_action_information pai

3571:
3572: FOR rg_csr_VSPSERIE IN csr_VSPSERIE(p_payroll_action_id )
3573: LOOP
3574: l_end_code:=l_end_code + 1 ;
3575: UPDATE pay_action_information pai
3576: SET pai.action_information30 =l_end_code
3577: WHERE CURRENT OF csr_VSPSERIE;
3578: END LOOP;
3579:

Line 3583: UPDATE pay_action_information pai

3579:
3580: FOR rg_csr_VSRAERIE IN csr_VSRAERIE(p_payroll_action_id )
3581: LOOP
3582: l_end_code:=l_end_code + 1 ;
3583: UPDATE pay_action_information pai
3584: SET pai.action_information30 =l_end_code
3585: WHERE CURRENT OF csr_VSRAERIE;
3586: END LOOP;
3587:

Line 3591: UPDATE pay_action_information

3587:
3588: FOR rg_csr_VSPSTUKI IN csr_VSPSTUKI(p_payroll_action_id )
3589: LOOP
3590: l_end_code:=l_end_code + 1 ;
3591: UPDATE pay_action_information
3592: SET action_information30 =l_end_code
3593: WHERE CURRENT OF csr_VSPSTUKI;
3594: END LOOP;
3595:

Line 3599: UPDATE pay_action_information

3595:
3596: FOR rg_csr_VSPSVYSL IN csr_VSPSVYSL(p_payroll_action_id )
3597: LOOP
3598: l_end_code:=l_end_code + 1 ;
3599: UPDATE pay_action_information
3600: SET action_information30 =l_end_code
3601: WHERE CURRENT OF csr_VSPSVYSL;
3602: END LOOP;
3603:

Line 3607: UPDATE pay_action_information

3603:
3604: FOR rg_csr_VSPSVYHT IN csr_VSPSVYHT(p_payroll_action_id )
3605: LOOP
3606: l_end_code:=l_end_code + 1 ;
3607: UPDATE pay_action_information
3608: SET action_information30 =l_end_code
3609: WHERE CURRENT OF csr_VSPSVYHT;
3610: END LOOP;
3611: