APPS.PA_INVOICE_DETAIL_PROCESS dependencies on PA_EXPENDITURE_ITEMS

Line 748: Update PA_EXPENDITURE_ITEMS

744: BEGIN
745: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_ei ...');
746: /* For bug 2877649 Setting the Transfer_price amounts and TP rates to NULL for EIs marked as Never Processed */
747: forall i in 1..I_EI_count
748: Update PA_EXPENDITURE_ITEMS
749: Set CC_IC_PROCESSED_CODE = 'X',
750: DENOM_TP_CURRENCY_CODE = NULL,
751: DENOM_TRANSFER_PRICE = NULL,
752: ACCT_TP_RATE_TYPE = NULL,

Line 1140: Update PA_EXPENDITURE_ITEMS

1136: IF g1_debug_mode = 'Y' THEN
1137: PA_IC_INV_UTILS.log_message('Enter pa_invoice_detail_process.update_rejection_reason...');
1138: END IF;
1139: FORALL I IN 1..P_No_of_records
1140: Update PA_EXPENDITURE_ITEMS
1141: Set CC_REJECTION_CODE = P_Error_code(I)
1142: Where EXPENDITURE_ITEM_ID = P_Exp_Id(I);
1143:
1144: EXCEPTION

Line 1165: /* Apply pending changes for PA_EXPENDITURE_ITEMS */

1161: PA_INVOICE_DETAIL_PKG.delete_rows(P_Delete_tab);
1162: PA_INVOICE_DETAIL_PKG.update_rows(P_Update_tab,I_MRC_REQD_FLAG);
1163: PA_INVOICE_DETAIL_PKG.insert_rows(P_Insert_tab);
1164:
1165: /* Apply pending changes for PA_EXPENDITURE_ITEMS */
1166: update_ei;
1167: update_rejection_reason( P_Error_code, P_Exp_Id, P_no_of_records );
1168:
1169: /* Apply changes for Provider Reclass */

Line 1905: FROM pa_expenditure_items

1901:
1902: /*Change for bug 5370844*/
1903: SELECT cc_Cross_charge_code
1904: INTO l_cc_Cross_charge_code
1905: FROM pa_expenditure_items
1906: WHERE expenditure_item_id = P_EI_id(I);
1907:
1908: IF nvl(P_AdjEI_id(I),0) <> 0 AND l_cc_Cross_charge_code = 'N'
1909: THEN

Line 2099: from pa_expenditure_items_all

2095: into l_rate_schedule_id
2096: from pa_tasks
2097: where task_id in
2098: ( select task_id
2099: from pa_expenditure_items_all
2100: where expenditure_item_id = P_EI_id(I)
2101: );
2102: /* Get the burden amount from the call to the procedure PA_COST_PLUS.Get_Burden_Amount,
2103: which gets the revision for the given burden schedule, then burden structure,