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

Line 154: FROM pay_action_information pai

150: CURSOR csr_arch_ref_no(p_payroll_action_id NUMBER
151: ,p_bg_id NUMBER)
152: IS
153: SELECT 1
154: FROM pay_action_information pai
155: ,pay_payroll_actions ppa
156: ,hr_organization_units hou
157: WHERE pai.action_information_category = 'IN_24Q_ORG'
158: AND pai.action_context_type = 'PA'

Line 622: pay_action_information_api.create_action_information

618: NVL(t_challan_entry_asg_tab(i).surcharge,0)<>0 OR
619: NVL(t_challan_entry_asg_tab(i).cess,0)<>0 OR
620: NVL(t_challan_entry_asg_tab(i).interest,0)<>0 OR
621: NVL(t_challan_entry_asg_tab(i).others,0)<>0 ) THEN
622: pay_action_information_api.create_action_information
623: (p_action_context_id => p_arc_pay_action_id
624: ,p_action_context_type => 'PA'
625: ,p_action_information_category => 'IN_24Q_CHALLAN'
626: ,p_source_id => t_challan_entry_asg_tab(i).org_info_id

Line 785: FROM pay_action_information

781:
782: CURSOR csr_challan_recs
783: IS
784: SELECT COUNT(*)
785: FROM pay_action_information
786: WHERE action_information_category = 'IN_24Q_CHALLAN'
787: AND action_context_type = 'PA'
788: AND action_context_id = p_arc_pay_action_id
789: AND action_information3 = p_gre_id

Line 911: pay_action_information_api.create_action_information

907: pay_in_utils.trace('l_pao_reg_code : ',l_pao_reg_code);
908: pay_in_utils.trace('l_ddo_reg_code : ',l_ddo_reg_code);
909: end if;
910:
911: pay_action_information_api.create_action_information
912: (p_action_context_id => p_arc_pay_action_id
913: ,p_action_context_type => 'PA'
914: ,p_action_information_category => 'IN_24Q_ORG'
915: ,p_action_information1 => p_gre_id

Line 1126: pay_action_information_api.create_action_information

1122: pay_in_utils.trace('l_effective_start_date : ',l_effective_start_date);
1123: pay_in_utils.trace('l_effective_end_date : ',l_effective_end_date);
1124: end if;
1125:
1126: pay_action_information_api.create_action_information
1127: (p_action_context_id => p_arc_asg_action_id
1128: ,p_action_context_type => 'AAP'
1129: ,p_action_information_category => 'IN_24Q_PERSON'
1130: ,p_source_id => p_run_asg_action_id

Line 1387: pay_action_information_api.create_action_information

1383: -- STEP 4: Archive values
1384:
1385: IF (g_quarter = 'Q4') THEN
1386: IF (l_q4_80cce_total <> 0) THEN
1387: pay_action_information_api.create_action_information
1388: (p_action_context_id => p_arc_asg_action_id
1389: ,p_action_context_type => 'AAP'
1390: ,p_action_information_category => 'IN_24Q_VIA'
1391: ,p_source_id => p_run_asg_action_id

Line 1402: pay_action_information_api.create_action_information

1398: END IF;
1399:
1400: -- Bug 12332524
1401: IF (l_q4_80ccf_total <> 0) THEN
1402: pay_action_information_api.create_action_information
1403: (p_action_context_id => p_arc_asg_action_id
1404: ,p_action_context_type => 'AAP'
1405: ,p_action_information_category => 'IN_24Q_VIA'
1406: ,p_source_id => p_run_asg_action_id

Line 1416: pay_action_information_api.create_action_information

1412: );
1413: END IF;
1414:
1415: IF (l_q4_others_total <> 0) THEN
1416: pay_action_information_api.create_action_information
1417: (p_action_context_id => p_arc_asg_action_id
1418: ,p_action_context_type => 'AAP'
1419: ,p_action_information_category => 'IN_24Q_VIA'
1420: ,p_source_id => p_run_asg_action_id

Line 1430: pay_action_information_api.create_action_information

1426: );
1427: END IF;
1428: ELSE
1429: IF (l_80g_gross <>0 OR l_80g_qa <> 0) THEN
1430: pay_action_information_api.create_action_information
1431: (p_action_context_id => p_arc_asg_action_id
1432: ,p_action_context_type => 'AAP'
1433: ,p_action_information_category => 'IN_24Q_VIA'
1434: ,p_source_id => p_run_asg_action_id

Line 1444: pay_action_information_api.create_action_information

1440: );
1441: END IF;
1442:
1443: IF (l_80gg_qa_gross <> 0) THEN
1444: pay_action_information_api.create_action_information
1445: (p_action_context_id => p_arc_asg_action_id
1446: ,p_action_context_type => 'AAP'
1447: ,p_action_information_category => 'IN_24Q_VIA'
1448: ,p_source_id => p_run_asg_action_id

Line 1458: pay_action_information_api.create_action_information

1454: );
1455: END IF;
1456:
1457: IF (l_via_others_gross <>0 OR l_via_others_qa <> 0) THEN
1458: pay_action_information_api.create_action_information
1459: (p_action_context_id => p_arc_asg_action_id
1460: ,p_action_context_type => 'AAP'
1461: ,p_action_information_category => 'IN_24Q_VIA'
1462: ,p_source_id => p_run_asg_action_id

Line 1643: pay_action_information_api.create_action_information

1639: if g_debug then
1640: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1641: pay_in_utils.trace('balance_value : ',g_result_table(i).balance_value);
1642: end if;
1643: pay_action_information_api.create_action_information
1644: (p_action_context_id => p_arc_asg_action_id
1645: ,p_action_context_type => 'AAP'
1646: ,p_action_information_category => 'IN_24Q_SALARY'
1647: ,p_source_id => p_run_asg_action_id

Line 1657: pay_action_information_api.create_action_information

1653: END IF;
1654: END IF;
1655: END LOOP;
1656: IF l_total_cess <> 0 THEN
1657: pay_action_information_api.create_action_information
1658: (p_action_context_id => p_arc_asg_action_id
1659: ,p_action_context_type => 'AAP'
1660: ,p_action_information_category => 'IN_24Q_SALARY'
1661: ,p_source_id => p_run_asg_action_id

Line 1713: pay_action_information_api.create_action_information

1709:
1710:
1711: IF (l_balance_value <> 0)
1712: THEN
1713: pay_action_information_api.create_action_information
1714: (p_action_context_id => p_arc_asg_action_id
1715: ,p_action_context_type => 'AAP'
1716: ,p_action_information_category => 'IN_24Q_SALARY'
1717: ,p_source_id => p_run_asg_action_id

Line 2002: pay_action_information_api.create_action_information

1998: end if;
1999:
2000: IF (l_balance_value <> 0)
2001: THEN
2002: pay_action_information_api.create_action_information
2003: (p_action_context_id => p_arc_asg_action_id
2004: ,p_action_context_type => 'AAP'
2005: ,p_action_information_category => 'IN_24Q_PERQ'
2006: ,p_source_id => p_run_asg_action_id

Line 2042: pay_action_information_api.create_action_information

2038: pay_in_utils.trace('l_balance_value : ',l_balance_value);
2039: end if;
2040:
2041: IF (g_result_table1(1).balance_value <>0 OR l_balance_value <>0 ) THEN
2042: pay_action_information_api.create_action_information
2043: (p_action_context_id => p_arc_asg_action_id
2044: ,p_action_context_type => 'AAP'
2045: ,p_action_information_category => 'IN_24Q_PERQ'
2046: ,p_source_id => p_run_asg_action_id

Line 2107: pay_action_information_api.create_action_information

2103: IF (( g_balance_value_tab1(i).balance_value <> 0)
2104: OR(g_balance_value_tab(i).balance_value <> 0)
2105: )
2106: THEN
2107: pay_action_information_api.create_action_information
2108: (p_action_context_id => p_arc_asg_action_id
2109: ,p_action_context_type => 'AAP'
2110: ,p_action_information_category => 'IN_24Q_PERQ'
2111: ,p_source_id => p_run_asg_action_id

Line 2213: pay_action_information_api.create_action_information

2209: IF ((g_result_table1(i).balance_value <> 0)
2210: OR(g_result_table2(i).balance_value <> 0)
2211: )
2212: THEN
2213: pay_action_information_api.create_action_information
2214: (p_action_context_id => p_arc_asg_action_id
2215: ,p_action_context_type => 'AAP'
2216: ,p_action_information_category => 'IN_24Q_PERQ'
2217: ,p_source_id => p_run_asg_action_id

Line 2462: pay_action_information_api.create_action_information

2458: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
2459: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
2460: end if;
2461:
2462: pay_action_information_api.create_action_information
2463: (p_action_context_id => p_arc_asg_action_id
2464: ,p_action_context_type => 'AAP'
2465: ,p_action_information_category => 'IN_24Q_DEDUCTEE'
2466: ,p_assignment_id => p_assignment_id

Line 2612: FROM pay_action_information pai,

2608: CURSOR c_pay_action_level_check(p_payroll_action_id NUMBER
2609: ,p_gre_id NUMBER)
2610: IS
2611: SELECT 1
2612: FROM pay_action_information pai,
2613: pay_assignment_actions paa
2614: WHERE pai.action_information_category = 'IN_24Q_ORG'
2615: AND pai.action_context_type = 'PA'
2616: AND pai.action_context_id = p_payroll_action_id

Line 2869: FROM pay_action_information

2865: CURSOR cur_challan_recs
2866: IS
2867: SELECT DISTINCT action_information1 challan_no
2868: ,action_information3 gre_id
2869: FROM pay_action_information
2870: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
2871: AND action_context_type = 'AAP'
2872: AND action_context_id IN (SELECT assignment_action_id
2873: FROM pay_assignment_actions

Line 2884: FROM pay_action_information

2880: SELECT DISTINCT action_information2
2881: , action_information4
2882: , action_information_id
2883: , object_version_number
2884: FROM pay_action_information
2885: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
2886: AND action_context_type = 'AAP'
2887: AND action_information3 = p_gre_id
2888: AND action_information1 = p_challan

Line 2899: FROM pay_action_information

2895:
2896: CURSOR cur_salary_recs
2897: IS
2898: SELECT DISTINCT action_information3 gre_id
2899: FROM pay_action_information
2900: WHERE action_information_category = 'IN_24Q_PERSON'
2901: AND action_context_type = 'AAP'
2902: AND action_context_id IN (SELECT assignment_action_id
2903: FROM pay_assignment_actions

Line 2914: FROM pay_action_information

2910: SELECT DISTINCT action_information1 person_id
2911: , source_id
2912: , action_information_id
2913: , object_version_number
2914: FROM pay_action_information
2915: WHERE action_information_category = 'IN_24Q_PERSON'
2916: AND action_context_type = 'AAP'
2917: AND action_information3 = p_gre_id
2918: AND action_context_id IN (SELECT assignment_action_id

Line 2938: pay_action_information_api.update_action_information

2934: l_index := 0;
2935: FOR cur_rec IN cur_deductee_recs(c_challan_rec.challan_no ,c_challan_rec.gre_id)
2936: LOOP
2937: l_index := l_index + 1;
2938: pay_action_information_api.update_action_information
2939: (p_validate => FALSE
2940: ,p_action_information_id => cur_rec.action_information_id
2941: ,p_object_version_number => cur_rec.object_version_number
2942: ,p_action_information25 => l_index

Line 2955: pay_action_information_api.update_action_information

2951: l_index := 0;
2952: FOR cur_rec IN cur_person_recs(c_salary_rec.gre_id)
2953: LOOP
2954: l_index := l_index + 1;
2955: pay_action_information_api.update_action_information
2956: (p_validate => FALSE
2957: ,p_action_information_id => cur_rec.action_information_id
2958: ,p_object_version_number => cur_rec.object_version_number
2959: ,p_action_information11 => l_index