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.PA_REVERSE_COSTED_LAB dependencies on PA_EXPENDITURE_ITEMS

Line 187: FROM pa_expenditure_items item,

183: ,exp.incurred_by_person_id incurred_by_person_id
184: ,item.interface_run_id interface_run_id
185: ,'Y' reverse_eligibile_flag
186: ,NULL reverse_error_code
187: FROM pa_expenditure_items item,
188: pa_expenditures exp
189: WHERE exp.expenditure_id = item.expenditure_id
190: AND exp.expenditure_status_code = 'APPROVED'
191: AND (item.cost_distributed_flag = 'Y' OR (item.cost_distributed_flag = 'N'

Line 213: FROM pa_expenditure_items item,

209: ,exp.incurred_by_person_id incurred_by_person_id
210: ,item.interface_run_id interface_run_id
211: ,uncosted_eis_exist(NVL(P_cost_set,item.interface_run_id), NVL(P_inc_by_person_id,exp.incurred_by_person_id)) reverse_eligibile_flag -- returns X if exists
212: ,NULL reverse_error_code
213: FROM pa_expenditure_items item,
214: pa_expenditures exp
215: WHERE exp.expenditure_id = item.expenditure_id
216: AND exp.expenditure_status_code = 'APPROVED'
217: AND item.system_linkage_function IN ('ST','OT','PJ','BTC')

Line 232: FROM pa_expenditure_items ei1

228: CURSOR c_adjustedeis (X_expid NUMBER)
229: IS
230: SELECT ei1.expenditure_item_id ,
231: ei1.adjusted_expenditure_item_id
232: FROM pa_expenditure_items ei1
233: WHERE ei1.adjusted_expenditure_item_id= X_expid
234: AND NVL(ei1.net_zero_adjustment_flag,'N')='Y'
235: AND ei1.cost_distributed_flag='N';
236:

Line 240: FROM pa_expenditure_items ei,

236:
237: CURSOR c_uncosted_costset (x_empid NUMBER, x_costset_id NUMBER)
238: IS
239: SELECT ei.expenditure_item_id
240: FROM pa_expenditure_items ei,
241: pa_expenditures exp
242: WHERE ei.expenditure_id = exp.expenditure_id
243: AND ei.interface_run_id = x_costset_id
244: AND exp.incurred_by_person_id = x_empid

Line 249: FROM PA_EXPENDITURE_ITEMS EI1,

245: AND ei.cost_distributed_flag='N';
246:
247: CURSOR c_block_backout (x_empid NUMBER, x_costset_id NUMBER) IS
248: SELECT EI1.EXPENDITURE_ITEM_ID
249: FROM PA_EXPENDITURE_ITEMS EI1,
250: PA_EXPENDITURES EXP1
251: WHERE EXP1.INCURRED_BY_PERSON_ID = X_EMPID
252: AND EI1.EXPENDITURE_ID = EXP1.EXPENDITURE_ID
253: AND EI1.INTERFACE_RUN_ID = x_costset_id

Line 258: FROM PA_EXPENDITURE_ITEMS EI3,

254: AND EI1.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
255: AND EXISTS
256: (
257: SELECT EI2.EXPENDITURE_ITEM_ID
258: FROM PA_EXPENDITURE_ITEMS EI3,
259: PA_EXPENDITURE_ITEMS EI2,
260: PA_EXPENDITURES EXP2
261: WHERE EI3.interface_run_id = EI1.INTERFACE_RUN_ID
262: AND SUBSTR(EI2.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1) =

Line 259: PA_EXPENDITURE_ITEMS EI2,

255: AND EXISTS
256: (
257: SELECT EI2.EXPENDITURE_ITEM_ID
258: FROM PA_EXPENDITURE_ITEMS EI3,
259: PA_EXPENDITURE_ITEMS EI2,
260: PA_EXPENDITURES EXP2
261: WHERE EI3.interface_run_id = EI1.INTERFACE_RUN_ID
262: AND SUBSTR(EI2.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1) =
263: SUBSTR(EI3.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1)

Line 274: FROM PA_EXPENDITURE_ITEMS EI5 ,

270: AND EI2.INTERFACE_RUN_ID > EI1.INTERFACE_RUN_ID
271: UNION
272: /* adjustment is not by PAXREVTXN reversal process but from OTL */
273: SELECT EI4.EXPENDITURE_ITEM_ID
274: FROM PA_EXPENDITURE_ITEMS EI5 ,
275: PA_EXPENDITURE_ITEMS EI4 ,
276: PA_EXPENDITURES EXP4
277: WHERE EI5.interface_run_id = EI1.INTERFACE_RUN_ID
278: AND EXP4.INCURRED_BY_PERSON_ID = X_EMPID

Line 275: PA_EXPENDITURE_ITEMS EI4 ,

271: UNION
272: /* adjustment is not by PAXREVTXN reversal process but from OTL */
273: SELECT EI4.EXPENDITURE_ITEM_ID
274: FROM PA_EXPENDITURE_ITEMS EI5 ,
275: PA_EXPENDITURE_ITEMS EI4 ,
276: PA_EXPENDITURES EXP4
277: WHERE EI5.interface_run_id = EI1.INTERFACE_RUN_ID
278: AND EXP4.INCURRED_BY_PERSON_ID = X_EMPID
279: AND EXP4.EXPENDITURE_ID = EI4.EXPENDITURE_ID

Line 312: l_temp_interface_run_id pa_expenditure_items.interface_run_id%TYPE :=-1;

308: l_result NUMBER;
309: l_temp_emp_id pa_expenditures.incurred_by_person_id%TYPE := -1;
310: l_Exp_item_id_tb2 PA_PLSQL_DATATYPES.IdTabTyp;
311: l_Exp_item_id_tb3 PA_PLSQL_DATATYPES.IdTabTyp; --Bug12779047
312: l_temp_interface_run_id pa_expenditure_items.interface_run_id%TYPE :=-1;
313: -- =======================================================================
314: -- Start of Comments
315: -- API Name : CLEAR_PLSQL_TABLES
316: -- Type : Public

Line 500: UPDATE pa_expenditure_items ei

496: IF l_Cost_Dist_Flag_tbl(i)='N'
497: THEN
498: G_err_stage := ' Update expenditure cost columns with cdl amount if CDF =N and marked for recalculation ,etc';
499: write_log(LOG, G_err_stage);
500: UPDATE pa_expenditure_items ei
501: SET ei.cost_distributed_flag='Y',
502: (ei.raw_cost ,
503: ei.Raw_Cost_Rate,
504: ei.burden_cost,

Line 689: pa_expenditure_items ei ,

685: INTO
686: l_trx_source_costed,
687: l_ALLOW_ADJUSTMENTS_FLAG
688: FROM
689: pa_expenditure_items ei ,
690: pa_transaction_sources txs
691: WHERE ei.transaction_source = txs.transaction_source(+)
692: AND ei.expenditure_item_id = X_expenditure_item_id;
693: IF l_trx_source_costed ='N' AND l_ALLOW_ADJUSTMENTS_FLAG='Y' THEN

Line 752: FROM pa_expenditure_items item,

748: END IF;
749:
750: SELECT COUNT(1)
751: INTO l_count
752: FROM pa_expenditure_items item,
753: pa_expenditures exp
754: WHERE exp.expenditure_id = item.expenditure_id
755: AND (exp.incurred_by_person_id =P_incurred_by_person_id
756: AND item.interface_run_id =P_interface_run_id)

Line 763: FROM PA_EXPENDITURE_ITEMS EI1,

759:
760: -- Added for bug 12779047
761: SELECT Count(EI1.EXPENDITURE_ITEM_ID)
762: INTO l_count2 /*Changed variable from l_count to l_count2 for bug:12915699 */
763: FROM PA_EXPENDITURE_ITEMS EI1,
764: PA_EXPENDITURES EXP1
765: WHERE EXP1.INCURRED_BY_PERSON_ID = P_incurred_by_person_id
766: AND EI1.EXPENDITURE_ID = EXP1.EXPENDITURE_ID
767: AND EI1.INTERFACE_RUN_ID = P_interface_run_id

Line 772: FROM PA_EXPENDITURE_ITEMS EI3,

768: AND EI1.TRANSACTION_SOURCE = 'ORACLE TIME AND LABOR'
769: AND EXISTS
770: (
771: SELECT EI2.EXPENDITURE_ITEM_ID
772: FROM PA_EXPENDITURE_ITEMS EI3,
773: PA_EXPENDITURE_ITEMS EI2,
774: PA_EXPENDITURES EXP2
775: WHERE EI3.interface_run_id = EI1.INTERFACE_RUN_ID
776: AND SUBSTR(EI2.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1) =

Line 773: PA_EXPENDITURE_ITEMS EI2,

769: AND EXISTS
770: (
771: SELECT EI2.EXPENDITURE_ITEM_ID
772: FROM PA_EXPENDITURE_ITEMS EI3,
773: PA_EXPENDITURE_ITEMS EI2,
774: PA_EXPENDITURES EXP2
775: WHERE EI3.interface_run_id = EI1.INTERFACE_RUN_ID
776: AND SUBSTR(EI2.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1) =
777: SUBSTR(EI3.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI2.ORIG_TRANSACTION_REFERENCE,':') - 1)

Line 788: FROM PA_EXPENDITURE_ITEMS EI5 ,

784: AND EI2.INTERFACE_RUN_ID > EI1.INTERFACE_RUN_ID
785: UNION
786: /* adjustment is not by PAXREVTXN reversal process but from OTL */
787: SELECT EI4.EXPENDITURE_ITEM_ID
788: FROM PA_EXPENDITURE_ITEMS EI5 ,
789: PA_EXPENDITURE_ITEMS EI4 ,
790: PA_EXPENDITURES EXP4
791: WHERE EI5.interface_run_id = EI1.INTERFACE_RUN_ID
792: AND EXP4.INCURRED_BY_PERSON_ID = P_incurred_by_person_id

Line 789: PA_EXPENDITURE_ITEMS EI4 ,

785: UNION
786: /* adjustment is not by PAXREVTXN reversal process but from OTL */
787: SELECT EI4.EXPENDITURE_ITEM_ID
788: FROM PA_EXPENDITURE_ITEMS EI5 ,
789: PA_EXPENDITURE_ITEMS EI4 ,
790: PA_EXPENDITURES EXP4
791: WHERE EI5.interface_run_id = EI1.INTERFACE_RUN_ID
792: AND EXP4.INCURRED_BY_PERSON_ID = P_incurred_by_person_id
793: AND EXP4.EXPENDITURE_ID = EI4.EXPENDITURE_ID

Line 914: -- and mark the CDF on pa_expenditure_items_all

910: -- Type : Public
911: -- Pre-Reqs : None
912: -- Type : Procedure
913: -- Function : Creates the reversal cdl for backout items
914: -- and mark the CDF on pa_expenditure_items_all
915:
916: --
917: --
918: --

Line 971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;

967: p_project_rate_type pa_cost_distribution_lines.project_rate_type%TYPE;
968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
974: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
975: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;

Line 972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;

968: p_project_exchange_rate pa_cost_distribution_lines.project_exchange_rate%TYPE;
969: p_project_id pa_cost_distribution_lines.project_id%TYPE;
970: p_task_id pa_cost_distribution_lines.task_id%TYPE;
971: p_parent_adjusted_id pa_expenditure_items.adjusted_expenditure_item_id%TYPE;
972: p_parent_transferred_id pa_expenditure_items.transferred_from_exp_item_id%TYPE;
973: p_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%TYPE;
974: p_transaction_source pa_transaction_sources.transaction_source%TYPE;
975: l_si_assets_addition_flag pa_cost_distribution_lines.si_assets_addition_flag%TYPE ;
976: p_err_code NUMBER;

Line 1002: l_org_id pa_expenditure_items.org_id%type;

998: p_cdlsr5 pa_cost_distribution_lines.system_reference5%TYPE;
999: l_pa_date DATE ;
1000: l_recvr_pa_date DATE ;
1001: l_ei_date DATE ;
1002: l_org_id pa_expenditure_items.org_id%type;
1003: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1004: l_recvr_org_id pa_expenditure_items.org_id%type;
1005: l_gl_date DATE;
1006: l_recvr_gl_date DATE;

Line 1004: l_recvr_org_id pa_expenditure_items.org_id%type;

1000: l_recvr_pa_date DATE ;
1001: l_ei_date DATE ;
1002: l_org_id pa_expenditure_items.org_id%type;
1003: actual_cdl_line_num pa_cost_distribution_lines.line_num%TYPE;
1004: l_recvr_org_id pa_expenditure_items.org_id%type;
1005: l_gl_date DATE;
1006: l_recvr_gl_date DATE;
1007: l_exp_id NUMBER;
1008: l_sob_id NUMBER;

Line 1035: FROM pa_expenditure_items_All ITEMS,

1031: ,l_org_id
1032: ,l_recvr_org_id
1033: ,l_sys_link_function
1034: ,l_exp_id
1035: FROM pa_expenditure_items_All ITEMS,
1036: pa_transaction_sources TRN
1037: WHERE ITEMS.transaction_source = TRN.transaction_source (+)
1038: AND ITEMS.expenditure_item_id = X_exp_item_id;
1039: SELECT imp1.set_of_books_id, imp2.set_of_books_id

Line 1245: UPDATE pa_expenditure_items

1241: , p_costing_method => l_costing_method);
1242: IF p_err_code IS NOT NULL THEN
1243: raise e_cdl_error;
1244: END IF;
1245: UPDATE pa_expenditure_items
1246: SET cost_distributed_flag = 'Y'
1247: WHERE expenditure_item_id = X_backout_id;
1248: X_status := 0;
1249: EXCEPTION

Line 1295: INSERT INTO pa_expenditure_items_all(

1291: write_log(LOG, 'Inside createorigexpitem');
1292: G_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1293: G_PROG_APPL_ID := FND_GLOBAL.PROG_APPL_ID;
1294: X_transfer_id := pa_utils.GetNextEiId;
1295: INSERT INTO pa_expenditure_items_all(
1296: expenditure_item_id
1297: , task_id
1298: , expenditure_type
1299: , system_linkage_function

Line 1538: pa_expenditure_items_all ei

1534: , null --ei.rate_source_code
1535: , null --ei.costing_method
1536: , NULL --PAYROLL_ACCRUAL_FLAG
1537: FROM
1538: pa_expenditure_items_all ei
1539: WHERE
1540: ei.expenditure_item_id = X_exp_item_id;
1541: /* Fix for bug 2211472 */
1542: /* Adding the comment of original expenditure_item to the TRANSFERED expenditure item