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 2444: pay_action_information_api.create_action_information (

2440: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2441: CLOSE csr_Get_Defined_Balance_Id;
2442: 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) ;
2443:
2444: pay_action_information_api.create_action_information (
2445: p_action_information_id=> l_action_info_id,
2446: p_action_context_id=> p_assignment_action_id,
2447: p_action_context_type=> 'AAP',
2448: p_object_version_number=> l_ovn,

Line 2494: pay_action_information_api.create_action_information (

2490:
2491: ELSE
2492:
2493: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 37');
2494: pay_action_information_api.create_action_information (
2495: p_action_information_id=> l_action_info_id,
2496: p_action_context_id=> p_assignment_action_id,
2497: p_action_context_type=> 'AAP',
2498: p_object_version_number=> l_ovn,

Line 2535: pay_action_information_api.create_action_information (

2531: p_action_information29=> '1' ,
2532: p_action_information30 => NULL
2533: );
2534:
2535: pay_action_information_api.create_action_information (
2536: p_action_information_id=> l_action_info_id,
2537: p_action_context_id=> p_assignment_action_id,
2538: p_action_context_type=> 'AAP',
2539: p_object_version_number=> l_ovn,

Line 2577: pay_action_information_api.create_action_information (

2573: p_action_information30 => NULL
2574: );
2575:
2576: IF l_s1_tax_base > 0 THEN
2577: pay_action_information_api.create_action_information (
2578: p_action_information_id=> l_action_info_id,
2579: p_action_context_id=> p_assignment_action_id,
2580: p_action_context_type=> 'AAP',
2581: p_object_version_number=> l_ovn,

Line 2620: pay_action_information_api.create_action_information (

2616: );
2617: END IF;
2618:
2619: IF l_s2_tax_base > 0 THEN
2620: pay_action_information_api.create_action_information (
2621: p_action_information_id=> l_action_info_id,
2622: p_action_context_id=> p_assignment_action_id,
2623: p_action_context_type=> 'AAP',
2624: p_object_version_number=> l_ovn,

Line 2664: pay_action_information_api.create_action_information (

2660: END IF;
2661:
2662: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 38');
2663: IF l_s3_tax_base > 0 THEN
2664: pay_action_information_api.create_action_information (
2665: p_action_information_id=> l_action_info_id,
2666: p_action_context_id=> p_assignment_action_id,
2667: p_action_context_type=> 'AAP',
2668: p_object_version_number=> l_ovn,

Line 2711: pay_action_information_api.create_action_information (

2707:
2708: ELSIF l_count < 1 and l_record_id ='VSRAERIE' THEN
2709: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 39');
2710:
2711: pay_action_information_api.create_action_information (
2712: p_action_information_id=> l_action_info_id,
2713: p_action_context_id=> p_assignment_action_id,
2714: p_action_context_type=> 'AAP',
2715: p_object_version_number=> l_ovn,

Line 2752: pay_action_information_api.create_action_information (

2748: p_action_information29=> NULL,
2749: p_action_information30=> NULL
2750: );
2751: IF l_s1_tax_base > 0 THEN
2752: pay_action_information_api.create_action_information (
2753: p_action_information_id=> l_action_info_id,
2754: p_action_context_id=> p_assignment_action_id,
2755: p_action_context_type=> 'AAP',
2756: p_object_version_number=> l_ovn,

Line 2795: pay_action_information_api.create_action_information (

2791: );
2792: END IF;
2793:
2794: IF l_s2_tax_base > 0 THEN
2795: pay_action_information_api.create_action_information (
2796: p_action_information_id=> l_action_info_id,
2797: p_action_context_id=> p_assignment_action_id,
2798: p_action_context_type=> 'AAP',
2799: p_object_version_number=> l_ovn,

Line 2887: pay_action_information_api.create_action_information (

2883: ELSE
2884: CODE_014:= l_subsidy_basis;
2885: END IF;
2886:
2887: pay_action_information_api.create_action_information (
2888: p_action_information_id=> l_action_info_id,
2889: p_action_context_id=> p_assignment_action_id,
2890: p_action_context_type=> 'AAP',
2891: p_object_version_number=> l_ovn,

Line 2956: FROM pay_action_information pai

2952: CURSOR csr_prpt_header (p_payroll_action_id NUMBER) IS
2953: SELECT action_information2 emp_type ,action_information3 emp_id
2954: ,action_information4 business_id ,action_information5 org_type ,action_information6 contact_person
2955: ,action_information7 phone ,action_information8 year ,action_information9 transact_type
2956: FROM pay_action_information pai
2957: WHERE action_information_category = 'EMEA REPORT INFORMATION'
2958: AND action_information1 = 'PYFIDPSA'
2959: AND action_context_id = p_payroll_action_id;
2960:

Line 2968: FROM pay_action_information pai , pay_assignment_actions paa

2964: CURSOR csr_arch_fi (p_payroll_action_id NUMBER) IS
2965: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
2966: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
2967: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
2968: FROM pay_action_information pai , pay_assignment_actions paa
2969: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
2970: AND pai.action_context_type= 'AAP'
2971: AND pai.action_context_id= paa.assignment_action_id
2972: AND paa.payroll_action_id = p_payroll_action_id

Line 2983: FROM pay_action_information pai , pay_assignment_actions paa

2979: CURSOR csr_arch_fi_p2 (p_payroll_action_id NUMBER) IS
2980: SELECT substr(action_information4,1,1) payment_type , SUM(nvl(action_information9,0)) payment , SUM(nvl(action_information10,0)) tax , COUNT(*) num
2981: ,SUM(nvl(action_information12,0)) pretax_ded, SUM(nvl(action_information11,0)) pen_unemp_ins , SUM(nvl(action_information25,0)) bik
2982: , SUM(nvl(action_information27,0) + nvl(action_information23,0)) CODE_670 ,SUM(nvl(action_information28,0)) CODE_631
2983: FROM pay_action_information pai , pay_assignment_actions paa
2984: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
2985: AND pai.action_context_type= 'AAP'
2986: AND pai.action_context_id= paa.assignment_action_id
2987: AND paa.payroll_action_id = p_payroll_action_id

Line 3001: FROM pay_action_information pai , pay_assignment_actions paa

2997: /* Cursor to fetch data related to Foreign Residents Social Security Not Liable*/
2998: CURSOR csr_arch_fr_nss ( p_payroll_action_id NUMBER) IS
2999: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3000: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3001: FROM pay_action_information pai , pay_assignment_actions paa
3002: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3003: AND pai.action_context_type= 'AAP'
3004: AND pai.action_context_id= paa.assignment_action_id
3005: AND paa.payroll_action_id = p_payroll_action_id

Line 3015: FROM pay_action_information pai , pay_assignment_actions paa

3011: /* Cursor to fetch data related to Foreign Residents Social Security liable*/
3012: CURSOR csr_arch_fr_ss ( p_payroll_action_id NUMBER) IS
3013: SELECT SUM(nvl(action_information15,0)) payment, SUM(nvl(action_information16,0)) tax , COUNT(*) num,
3014: SUM(nvl(action_information19,0)) pretax_ded, SUM(nvl(action_information18,0)) bik
3015: FROM pay_action_information pai , pay_assignment_actions paa
3016: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3017: AND pai.action_context_type= 'AAP'
3018: AND pai.action_context_id= paa.assignment_action_id
3019: AND paa.payroll_action_id = p_payroll_action_id

Line 3027: FROM pay_action_information pai , pay_assignment_actions paa

3023:
3024: /* Cursor to fetch data related to Record VSPSERIE*/
3025: CURSOR csr_VSPSERIE (p_payroll_action_id NUMBER) IS
3026: SELECT pai.action_information30
3027: FROM pay_action_information pai , pay_assignment_actions paa
3028: WHERE paa.payroll_action_id = p_payroll_action_id
3029: AND pai.action_context_id= paa.assignment_action_id
3030: AND pai.action_context_type= 'AAP'
3031: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3041: FROM pay_action_information pai , pay_assignment_actions paa

3037:
3038: /* Cursor to fetch data related to Record VSRAERIE*/
3039: CURSOR csr_VSRAERIE(p_payroll_action_id NUMBER) IS
3040: SELECT pai.action_information30
3041: FROM pay_action_information pai , pay_assignment_actions paa
3042: WHERE paa.payroll_action_id = p_payroll_action_id
3043: AND pai.action_context_id= paa.assignment_action_id
3044: AND pai.action_context_type= 'AAP'
3045: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3054: FROM pay_action_information pai

3050:
3051: /* Cursor to fetch data related to Record VSPSVYSL*/
3052: CURSOR csr_VSPSVYSL(p_payroll_action_id NUMBER) IS
3053: SELECT *
3054: FROM pay_action_information pai
3055: WHERE pai.action_context_id= p_payroll_action_id
3056: AND pai.action_context_type= 'PA'
3057: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
3058: AND pai.action_information1 = 'PYFIDPSA'

Line 3068: FROM pay_action_information pai

3064:
3065: /* Cursor to fetch data related to Record VSPSVYHT*/
3066: CURSOR csr_VSPSVYHT(p_payroll_action_id NUMBER) IS
3067: SELECT *
3068: FROM pay_action_information pai
3069: WHERE pai.action_context_id= p_payroll_action_id
3070: AND pai.action_context_type= 'PA'
3071: AND pai.action_information_category = 'EMEA REPORT INFORMATION'
3072: AND pai.action_information1 = 'PYFIDPSA'

Line 3081: FROM pay_action_information pai , pay_assignment_actions paa

3077:
3078: /* Cursor to fetch data related to Record VSPSTUKI*/
3079: CURSOR csr_VSPSTUKI(p_payroll_action_id NUMBER) IS
3080: SELECT pai.action_information30
3081: FROM pay_action_information pai , pay_assignment_actions paa
3082: WHERE paa.payroll_action_id = p_payroll_action_id
3083: AND pai.action_context_id= paa.assignment_action_id
3084: AND pai.action_context_type= 'AAP'
3085: AND pai.action_information_category = 'EMEA REPORT INFORMATION'

Line 3163: pay_action_information_api.create_action_information (

3159: FETCH csr_arch_fi_p2 INTO rg_csr_arch_fi_p2;
3160: CLOSE csr_arch_fi_p2;
3161:
3162: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 5');
3163: pay_action_information_api.create_action_information (
3164: p_action_information_id=> l_action_info_id,
3165: p_action_context_id=> p_payroll_action_id,
3166: p_action_context_type=> 'PA',
3167: p_object_version_number=> l_ovn,

Line 3213: pay_action_information_api.create_action_information (

3209: l_tot_670:= nvl(rg_csr_arch_fi.code_670,0) + nvl(rg_csr_arch_fi_p2.code_670,0) + l_tot_670;
3210:
3211: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 6');
3212: ELSE
3213: pay_action_information_api.create_action_information (
3214: p_action_information_id=> l_action_info_id,
3215: p_action_context_id=> p_payroll_action_id,
3216: p_action_context_type=> 'PA',
3217: p_object_version_number=> l_ovn,

Line 3269: pay_action_information_api.create_action_information (

3265: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 7');
3266: FOR rg_csr_arch_fr_ss IN csr_arch_fr_ss(p_payroll_action_id)
3267: LOOP
3268: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 8');
3269: pay_action_information_api.create_action_information (
3270: p_action_information_id=> l_action_info_id,
3271: p_action_context_id=> p_payroll_action_id,
3272: p_action_context_type=> 'PA',
3273: p_object_version_number=> l_ovn,

Line 3321: pay_action_information_api.create_action_information (

3317: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 10');
3318: FOR rg_csr_arch_fr_nss IN csr_arch_fr_nss(p_payroll_action_id)
3319: LOOP
3320: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 11');
3321: pay_action_information_api.create_action_information (
3322: p_action_information_id=> l_action_info_id,
3323: p_action_context_id=> p_payroll_action_id,
3324: p_action_context_type=> 'PA',
3325: p_object_version_number=> l_ovn,

Line 3387: pay_action_information_api.create_action_information (

3383: l_tot_631:= g_deduction_ss*100;
3384: END IF;
3385:
3386: fnd_file.put_line(fnd_file.log,'DEINITIALIZATION_CODE 12');
3387: pay_action_information_api.create_action_information (
3388: p_action_information_id=> l_action_info_id,
3389: p_action_context_id=> p_payroll_action_id,
3390: p_action_context_type=> 'PA',
3391: p_object_version_number=> l_ovn,

Line 3436: UPDATE pay_action_information pai

3432:
3433: FOR rg_csr_VSPSERIE IN csr_VSPSERIE(p_payroll_action_id )
3434: LOOP
3435: l_end_code:=l_end_code + 1 ;
3436: UPDATE pay_action_information pai
3437: SET pai.action_information30 =l_end_code
3438: WHERE CURRENT OF csr_VSPSERIE;
3439: END LOOP;
3440:

Line 3444: UPDATE pay_action_information pai

3440:
3441: FOR rg_csr_VSRAERIE IN csr_VSRAERIE(p_payroll_action_id )
3442: LOOP
3443: l_end_code:=l_end_code + 1 ;
3444: UPDATE pay_action_information pai
3445: SET pai.action_information30 =l_end_code
3446: WHERE CURRENT OF csr_VSRAERIE;
3447: END LOOP;
3448:

Line 3452: UPDATE pay_action_information

3448:
3449: FOR rg_csr_VSPSTUKI IN csr_VSPSTUKI(p_payroll_action_id )
3450: LOOP
3451: l_end_code:=l_end_code + 1 ;
3452: UPDATE pay_action_information
3453: SET action_information30 =l_end_code
3454: WHERE CURRENT OF csr_VSPSTUKI;
3455: END LOOP;
3456:

Line 3460: UPDATE pay_action_information

3456:
3457: FOR rg_csr_VSPSVYSL IN csr_VSPSVYSL(p_payroll_action_id )
3458: LOOP
3459: l_end_code:=l_end_code + 1 ;
3460: UPDATE pay_action_information
3461: SET action_information30 =l_end_code
3462: WHERE CURRENT OF csr_VSPSVYSL;
3463: END LOOP;
3464:

Line 3468: UPDATE pay_action_information

3464:
3465: FOR rg_csr_VSPSVYHT IN csr_VSPSVYHT(p_payroll_action_id )
3466: LOOP
3467: l_end_code:=l_end_code + 1 ;
3468: UPDATE pay_action_information
3469: SET action_information30 =l_end_code
3470: WHERE CURRENT OF csr_VSPSVYHT;
3471: END LOOP;
3472: