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_24QC_ARCHIVE dependencies on PAY_ACTION_INFORMATION_API

Line 5291: pay_action_information_api.create_action_information

5287: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
5288: AND ((l_c5_change_only = FALSE)) AND (g_quarter IN ('Q4') AND (l_flag = 0))
5289: THEN
5290:
5291: pay_action_information_api.create_action_information
5292: (p_action_context_id => l_arch_asg_action_id
5293: ,p_action_context_type => 'AAP'
5294: ,p_action_information_category => 'IN_24QC_PERSON'
5295: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5322: pay_action_information_api.create_action_information

5318: (tab_24q_ba_data(l).balance_value <> 0)
5319: )
5320: THEN
5321:
5322: pay_action_information_api.create_action_information
5323: (p_action_context_id => l_arch_asg_action_id
5324: ,p_action_context_type => 'AAP'
5325: ,p_action_information_category => 'IN_24QC_SALARY'
5326: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5349: pay_action_information_api.create_action_information

5345: FETCH c_get_bal_24q INTO l_balance_value;
5346: CLOSE c_get_bal_24q;
5347:
5348: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0)) THEN
5349: pay_action_information_api.create_action_information
5350: (p_action_context_id => l_arch_asg_action_id
5351: ,p_action_context_type => 'AAP'
5352: ,p_action_information_category => 'IN_24QC_SALARY'
5353: ,p_source_id => g_sal_data_rec_del(i).source_id

Line 5396: pay_action_information_api.create_action_information

5392:
5393: pay_in_utils.trace('Delete Source ID : ', g_sal_data_rec_del(i).source_id );
5394: pay_in_utils.trace('l_max_pact : ', l_max_pact );
5395:
5396: pay_action_information_api.create_action_information
5397: (p_action_context_id => l_arch_asg_action_id
5398: ,p_action_context_type => 'AAP'
5399: ,p_action_information_category => 'IN_24QC_PERSON'
5400: ,p_source_id => l_max_pact

Line 5425: pay_action_information_api.create_action_information

5421: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
5422: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
5423: )
5424: THEN
5425: pay_action_information_api.create_action_information
5426: (p_action_context_id => l_arch_asg_action_id
5427: ,p_action_context_type => 'AAP'
5428: ,p_action_information_category => 'IN_24QC_VIA'
5429: ,p_source_id => l_max_pact

Line 5440: pay_action_information_api.create_action_information

5436: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
5437: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
5438: )
5439: THEN
5440: pay_action_information_api.create_action_information
5441: (p_action_context_id => l_arch_asg_action_id
5442: ,p_action_context_type => 'AAP'
5443: ,p_action_information_category => 'IN_24QC_SALARY'
5444: ,p_source_id => l_max_pact

Line 5470: pay_action_information_api.create_action_information

5466:
5467: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_prev_pay) AND (l_flag1=0))
5468: THEN
5469:
5470: pay_action_information_api.create_action_information
5471: (p_action_context_id => l_arch_asg_action_id
5472: ,p_action_context_type => 'AAP'
5473: ,p_action_information_category => 'IN_24QC_PERSON'
5474: ,p_source_id => l_max_pact

Line 5500: pay_action_information_api.create_action_information

5496: (tab_24q_ba_data(l).balance_value <> 0)
5497: )
5498: THEN
5499:
5500: pay_action_information_api.create_action_information
5501: (p_action_context_id => l_arch_asg_action_id
5502: ,p_action_context_type => 'AAP'
5503: ,p_action_information_category => 'IN_24QC_SALARY'
5504: ,p_source_id => l_max_pact

Line 5674: pay_action_information_api.create_action_information

5670: pay_in_utils.trace('Addition Assignment ID : ', g_sal_data_rec_add(i).assignment_id );
5671:
5672: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_flag1=0) AND (l_prev_c5))
5673: THEN
5674: pay_action_information_api.create_action_information
5675: (p_action_context_id => l_arch_asg_action_id
5676: ,p_action_context_type => 'AAP'
5677: ,p_action_information_category => 'IN_24QC_PERSON'
5678: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5704: pay_action_information_api.create_action_information

5700: (tab_24q_ba_data(l).balance_value <> 0)
5701: )
5702: THEN
5703:
5704: pay_action_information_api.create_action_information
5705: (p_action_context_id => l_arch_asg_action_id
5706: ,p_action_context_type => 'AAP'
5707: ,p_action_information_category => 'IN_24QC_SALARY'
5708: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5736: pay_action_information_api.create_action_information

5732: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
5733: AND ((l_c5_change_only=FALSE)) AND (g_quarter IN ('Q4') AND (l_flag=0))
5734: THEN
5735:
5736: pay_action_information_api.create_action_information
5737: (p_action_context_id => l_arch_asg_action_id
5738: ,p_action_context_type => 'AAP'
5739: ,p_action_information_category => 'IN_24QC_PERSON'
5740: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5765: pay_action_information_api.create_action_information

5761: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
5762: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
5763: )
5764: THEN
5765: pay_action_information_api.create_action_information
5766: (p_action_context_id => l_arch_asg_action_id
5767: ,p_action_context_type => 'AAP'
5768: ,p_action_information_category => 'IN_24QC_VIA'
5769: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5780: pay_action_information_api.create_action_information

5776: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
5777: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
5778: )
5779: THEN
5780: pay_action_information_api.create_action_information
5781: (p_action_context_id => l_arch_asg_action_id
5782: ,p_action_context_type => 'AAP'
5783: ,p_action_information_category => 'IN_24QC_SALARY'
5784: ,p_source_id => g_sal_data_rec_add(i).source_id

Line 5843: pay_action_information_api.create_action_information

5839: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
5840: AND ((l_c5_change_only=FALSE)) AND (l_future_pay=TRUE) AND ((j>0) OR (j IS NULL)) AND (g_quarter IN ('Q4') AND (l_flag2=0))
5841: THEN
5842:
5843: pay_action_information_api.create_action_information
5844: (p_action_context_id => l_arch_asg_action_id
5845: ,p_action_context_type => 'AAP'
5846: ,p_action_information_category => 'IN_24QC_PERSON'
5847: ,p_source_id => l_prev_max_pact

Line 5875: pay_action_information_api.create_action_information

5871:
5872: IF ((l_prev_asg_action_id IS NOT NULL) AND (l_balance_value <> 0))
5873: THEN
5874:
5875: pay_action_information_api.create_action_information
5876: (p_action_context_id => l_arch_asg_action_id
5877: ,p_action_context_type => 'AAP'
5878: ,p_action_information_category => 'IN_24QC_SALARY'
5879: ,p_source_id => l_prev_max_pact

Line 5902: pay_action_information_api.create_action_information

5898: CLOSE c_get_bal_24q;
5899:
5900: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0))
5901: THEN
5902: pay_action_information_api.create_action_information
5903: (p_action_context_id => l_arch_asg_action_id
5904: ,p_action_context_type => 'AAP'
5905: ,p_action_information_category => 'IN_24QC_SALARY'
5906: ,p_source_id => l_prev_max_pact

Line 6048: pay_action_information_api.create_action_information

6044:
6045: IF (INSTR(l_action_information_category,'C5')<> 0) AND (g_correction_mode IN ('%','C5') AND (l_flag1=0) AND (l_future_pay=TRUE))
6046: THEN
6047:
6048: pay_action_information_api.create_action_information
6049: (p_action_context_id => l_arch_asg_action_id
6050: ,p_action_context_type => 'AAP'
6051: ,p_action_information_category => 'IN_24QC_PERSON'
6052: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6078: pay_action_information_api.create_action_information

6074: (tab_24q_ba_data(l).balance_value <> 0)
6075: )
6076: THEN
6077:
6078: pay_action_information_api.create_action_information
6079: (p_action_context_id => l_arch_asg_action_id
6080: ,p_action_context_type => 'AAP'
6081: ,p_action_information_category => 'IN_24QC_SALARY'
6082: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6098: pay_action_information_api.create_action_information

6094: IF (INSTR(l_action_information_category,'C4')<> 0) AND (g_correction_mode IN ('%','C4'))
6095: AND (l_c5_change_only=FALSE) AND (g_quarter IN ('Q4') AND (l_flag2 = 0))
6096: THEN
6097:
6098: pay_action_information_api.create_action_information
6099: (p_action_context_id => l_arch_asg_action_id
6100: ,p_action_context_type => 'AAP'
6101: ,p_action_information_category => 'IN_24QC_PERSON'
6102: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6130: pay_action_information_api.create_action_information

6126: (tab_24q_ba_data(l).balance_value <> 0)
6127: )
6128: THEN
6129:
6130: pay_action_information_api.create_action_information
6131: (p_action_context_id => l_arch_asg_action_id
6132: ,p_action_context_type => 'AAP'
6133: ,p_action_information_category => 'IN_24QC_SALARY'
6134: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6158: pay_action_information_api.create_action_information

6154: FETCH c_get_bal_24q INTO l_balance_value;
6155: CLOSE c_get_bal_24q;
6156:
6157: IF ((l_24qa_source_id IS NOT NULL) AND (l_balance_value <> 0)) THEN
6158: pay_action_information_api.create_action_information
6159: (p_action_context_id => l_arch_asg_action_id
6160: ,p_action_context_type => 'AAP'
6161: ,p_action_information_category => 'IN_24QC_SALARY'
6162: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6190: pay_action_information_api.create_action_information

6186: IF (INSTR(l_action_information_category,'C4')<> 0)AND(g_correction_mode IN ('%','C4'))
6187: AND (l_c5_change_only=FALSE) AND (g_quarter IN ('Q4') AND (l_flag = 0))
6188: THEN
6189:
6190: pay_action_information_api.create_action_information
6191: (p_action_context_id => l_arch_asg_action_id
6192: ,p_action_context_type => 'AAP'
6193: ,p_action_information_category => 'IN_24QC_PERSON'
6194: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6219: pay_action_information_api.create_action_information

6215: IF ((tab_liv_ba_data(l).balance_value <> 0) AND
6216: (tab_liv_ba_data(l).balance_name IN ('80CCE','Others'))
6217: )
6218: THEN
6219: pay_action_information_api.create_action_information
6220: (p_action_context_id => l_arch_asg_action_id
6221: ,p_action_context_type => 'AAP'
6222: ,p_action_information_category => 'IN_24QC_VIA'
6223: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6234: pay_action_information_api.create_action_information

6230: ELSIF ((tab_liv_ba_data(l).balance_value <> 0) AND
6231: (tab_liv_ba_data(l).balance_name NOT IN ('F16 Deductions Sec 80CCE'))
6232: )
6233: THEN
6234: pay_action_information_api.create_action_information
6235: (p_action_context_id => l_arch_asg_action_id
6236: ,p_action_context_type => 'AAP'
6237: ,p_action_information_category => 'IN_24QC_SALARY'
6238: ,p_source_id => g_sal_data_rec_upd(i).source_id

Line 6472: pay_action_information_api.create_action_information

6468: ,INSTR(l_action_information_category,'G')
6469: );
6470: l_category := l_category || 'C5';
6471:
6472: pay_action_information_api.create_action_information
6473: (p_action_context_id => l_arch_asg_action_id
6474: ,p_action_context_type => 'AAP'
6475: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6476: ,p_source_id => g_ee_data_rec_del(i).element_entry_id

Line 6516: pay_action_information_api.create_action_information

6512: ,INSTR(l_action_information_category,'G')
6513: );
6514: l_category := l_category || 'C3';
6515:
6516: pay_action_information_api.create_action_information
6517: (p_action_context_id => l_arch_asg_action_id
6518: ,p_action_context_type => 'AAP'
6519: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6520: ,p_source_id => g_ee_data_rec_del(i).element_entry_id

Line 6610: pay_action_information_api.create_action_information

6606: FETCH c_max_challan_number_24qc INTO j;
6607: CLOSE c_max_challan_number_24qc;
6608: pay_in_utils.set_location(g_debug,'Number found is ' || j, 2);
6609:
6610: pay_action_information_api.create_action_information
6611: (p_action_context_id => l_arch_asg_action_id
6612: ,p_action_context_type => 'AAP'
6613: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6614: ,p_source_id => g_ee_data_rec_add(i).element_entry_id

Line 6750: pay_action_information_api.create_action_information

6746: ,INSTR(l_action_information_category,'G')
6747: );
6748: l_category := l_category || 'C5';
6749:
6750: pay_action_information_api.create_action_information
6751: (p_action_context_id => l_arch_asg_action_id
6752: ,p_action_context_type => 'AAP'
6753: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6754: ,p_source_id => g_ee_data_rec_upd(i).element_entry_id

Line 6795: pay_action_information_api.create_action_information

6791: ,INSTR(l_action_information_category,'G')
6792: );
6793: l_category := l_category || 'C3';
6794:
6795: pay_action_information_api.create_action_information
6796: (p_action_context_id => l_arch_asg_action_id
6797: ,p_action_context_type => 'AAP'
6798: ,p_action_information_category => 'IN_24QC_DEDUCTEE'
6799: ,p_source_id => g_ee_data_rec_upd(i).element_entry_id

Line 7036: pay_action_information_api.create_action_information

7032: pay_in_utils.set_location(g_debug,'l_challan_deductee_no '|| l_challan_deductee_no ,3);
7033: pay_in_utils.set_location(g_debug,'l_action_information_id '|| l_action_information_id ,3);
7034: END IF;
7035: -- Now Archive these details
7036: pay_action_information_api.create_action_information
7037: (p_action_context_id => p_24qc_pay_act_id
7038: ,p_action_context_type => 'PA'
7039: ,p_action_information_category => 'IN_24QC_CHALLAN'
7040: ,p_source_id => g_challan_data_noc(i).org_information_id

Line 7232: pay_action_information_api.create_action_information

7228: CLOSE c_challan_live_data;
7229: pay_in_utils.set_location(g_debug,'Fetched Live Data ' ,1);
7230:
7231: pay_in_utils.set_location(g_debug,'Archiving Data ' ,1);
7232: pay_action_information_api.create_action_information
7233: (p_action_context_id => p_24qc_pay_act_id
7234: ,p_action_context_type => 'PA'
7235: ,p_action_information_category => 'IN_24QC_CHALLAN'
7236: ,p_source_id => g_challan_data_add(i).org_information_id

Line 7360: pay_action_information_api.create_action_information

7356: + NVL(g_challan_data_upd(i).education_cess,0)
7357: + NVL(g_challan_data_upd(i).interest,0)
7358: + NVL(g_challan_data_upd(i).other,0);
7359:
7360: pay_action_information_api.create_action_information
7361: (p_action_context_id => p_24qc_pay_act_id
7362: ,p_action_context_type => 'PA'
7363: ,p_action_information_category => 'IN_24QC_CHALLAN'
7364: ,p_source_id => l_org_information_id

Line 7476: pay_action_information_api.create_action_information

7472: pay_in_utils.set_location(g_debug,'Deductor Type is : ' || l_deductor_type,9);
7473:
7474: pay_in_utils.set_location(g_debug,'Archiving Data ', 9);
7475:
7476: pay_action_information_api.create_action_information
7477: (p_action_context_id => p_payroll_action_id
7478: ,p_action_context_type => 'PA'
7479: ,p_action_information_category => 'IN_24QC_ORG'
7480: ,p_source_id => l_action_context_id

Line 7634: pay_action_information_api.create_action_information

7630: ELSE
7631: l_new_nil_challan := 'Y';
7632: END IF;
7633:
7634: pay_action_information_api.create_action_information
7635: (p_action_context_id => p_24qc_pay_act_id
7636: ,p_action_context_type => 'PA'
7637: ,p_action_information_category => 'IN_24QC_ORG'
7638: ,p_source_id => p_24qa_pay_act_id

Line 7703: pay_action_information_api.create_action_information

7699:
7700: pay_in_utils.set_location(g_debug,'Archiving Data ',7);
7701: pay_in_utils.set_location(g_debug,'Address Change is '|| g_24qc_empr_change , 2);
7702:
7703: pay_action_information_api.create_action_information
7704: (p_action_context_id => p_24qc_pay_act_id
7705: ,p_action_context_type => 'PA'
7706: ,p_action_information_category => 'IN_24QC_ORG'
7707: ,p_source_id => p_24qa_pay_act_id

Line 8125: pay_action_information_api.create_action_information

8121: l_flag_number := -1;
8122: l_flag_number := check_archival_status(NULL,'IN_24QC_CHALLAN',g_challan_data_upd(i).transfer_voucher_number,NULL);
8123: IF((g_challan_data_upd(i).transfer_voucher_number = c_rec.challan)AND(l_flag_number = 0))
8124: THEN
8125: pay_action_information_api.create_action_information
8126: (p_action_context_id => p_payroll_action_id
8127: ,p_action_context_type => 'PA'
8128: ,p_action_information_category => 'IN_24QC_CHALLAN'
8129: ,p_source_id => g_challan_data_upd(i).org_information_id

Line 8158: pay_action_information_api.create_action_information

8154: l_flag_number := -1;
8155: l_flag_number := check_archival_status(NULL,'IN_24QC_CHALLAN',g_challan_data_noc(i).transfer_voucher_number,NULL);
8156: IF((g_challan_data_noc(i).transfer_voucher_number = c_rec.challan)AND(l_flag_number =0))
8157: THEN
8158: pay_action_information_api.create_action_information
8159: (p_action_context_id => p_payroll_action_id
8160: ,p_action_context_type => 'PA'
8161: ,p_action_information_category => 'IN_24QC_CHALLAN'
8162: ,p_source_id => g_challan_data_noc(i).org_information_id

Line 8223: pay_action_information_api.create_action_information

8219: pay_in_utils.set_location(g_debug,'p_payroll_action_id is '|| p_payroll_action_id, 10);
8220: l_action_info_id := NULL;
8221: l_ovn := NULL;
8222:
8223: pay_action_information_api.create_action_information
8224: (p_action_context_id => p_payroll_action_id
8225: ,p_action_context_type => 'PA'
8226: ,p_action_information_category => 'IN_24QC_ORG'
8227: ,p_action_information1 => g_gre_id

Line 9525: pay_action_information_api.update_action_information

9521: END IF;
9522: END IF;
9523:
9524: pay_in_utils.set_location(g_debug,'Updating API called for Challan ', 3);
9525: pay_action_information_api.update_action_information
9526: (p_validate => FALSE
9527: ,p_action_information_id => t_challan_nos(l_index).action_information_id
9528: ,p_object_version_number => t_challan_nos(l_index).object_version_number
9529: ,p_action_information29 => t_challan_nos(l_index).correction_type

Line 9552: pay_action_information_api.update_action_information

9548: pay_in_utils.set_location(g_debug,'c_salary_rec.gre_id...',c_salary_rec.gre_id);
9549:
9550: FOR cur_rec IN cur_person_update_recs(c_salary_rec.gre_id)
9551: LOOP
9552: pay_action_information_api.update_action_information
9553: (p_validate => FALSE
9554: ,p_action_information_id => cur_rec.action_information_id
9555: ,p_object_version_number => cur_rec.object_version_number
9556: ,p_action_information12 => l_index

Line 9628: pay_action_information_api.update_action_information

9624: END IF;
9625:
9626:
9627: pay_in_utils.set_location(g_debug,'Updating API called for Org ', 3);
9628: pay_action_information_api.update_action_information
9629: (p_validate => FALSE
9630: ,p_action_information_id => l_action_info_id
9631: ,p_object_version_number => l_ovn
9632: ,p_action_information29 => org_correction_type