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.IPA_ASSET_MECH_APIS_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 68: pa_expenditure_items_all pei,

64: pei.expenditure_item_id
65: FROM pa_projects_all ppr, -- Changed to _all as part of MOAC changes.
66: pa_project_types ppt,
67: -- pa_cost_distribution_lines_all pcdl,
68: pa_expenditure_items_all pei,
69: pa_tasks pt,
70: pa_tasks pt2
71: WHERE ppr.segment1 between x_project_num_from and x_project_num_to and
72: ppr.template_flag <> 'Y' and

Line 214: update pa_expenditure_items_all pei

210: if nvl(fnd_profile.value('CRL: COPY GROUPING ELEMENT INFORMATION'),'N') = 'Y' then
211: open get_invoice_8910;
212: fetch get_invoice_8910 into l_exp_id;
213: while get_invoice_8910%found loop
214: update pa_expenditure_items_all pei
215: set (attribute8, attribute9, attribute10) =
216: (select aid.attribute8,aid.attribute9, aid.attribute10
217: from ap_invoice_distributions aid,
218: pa_cost_distribution_lines_all pcd

Line 523: x_err_stage := 'Updating PA_EXPENDITURE_ITEMS_ALL';

519: where rowid = v_row_id2;
520:
521:
522: <>
523: x_err_stage := 'Updating PA_EXPENDITURE_ITEMS_ALL';
524: update pa_expenditure_items_all
525: set crl_asset_creation_rej_code = v_rejection_code,
526: crl_asset_creation_status_code = decode(v_rejection_code,null,'Y','R') ,
527: request_id = x_request_id,

Line 524: update pa_expenditure_items_all

520:
521:
522: <>
523: x_err_stage := 'Updating PA_EXPENDITURE_ITEMS_ALL';
524: update pa_expenditure_items_all
525: set crl_asset_creation_rej_code = v_rejection_code,
526: crl_asset_creation_status_code = decode(v_rejection_code,null,'Y','R') ,
527: request_id = x_request_id,
528: program_application_id = x_program_application_id,