APPS.PJI_FM_CMT_EXTR dependencies on PA_COMMITMENT_TXNS

Line 41: pa_commitment_txns pct

37: pct.receipt_currency_code,
38: pct.receipt_currency_amount,
39: pct.receipt_exchange_rate
40: FROM
41: pa_commitment_txns pct
42: WHERE
43: pct.project_id = x_project_id ;
44:
45:

Line 61: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;

57:
58: cmtrec selcmts%ROWTYPE;
59: row_processed NUMBER;
60: l_cmtrec_curr_OK VARCHAR2(1);
61: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
62: l_err_msg VARCHAR2(2000);
63:
64: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;
65: l_Project_Rate_Date DATE;

Line 64: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;

60: l_cmtrec_curr_OK VARCHAR2(1);
61: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
62: l_err_msg VARCHAR2(2000);
63:
64: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;
65: l_Project_Rate_Date DATE;
66: l_project_exch_rate NUMBER;
67: l_PROJECT_RAW_COST NUMBER := NULL;
68: l_PROJECT_BURDENED_COST NUMBER := NULL; -- added for FP.M

Line 80: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;

76: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
77:
78:
79: l_PROJFUNC_CURR_CODE pa_projects_all.project_currency_code%TYPE := NULL;
80: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
81: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
82: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
83:
84: BEGIN

Line 200: UPDATE pa_commitment_txns

196:
197: END IF; -- DERIVATION SUBsection
198:
199: IF (l_cmtrec_curr_OK = 'Y') THEN
200: UPDATE pa_commitment_txns
201: SET tot_cmt_raw_cost = l_tot_cmt_raw_cost
202: , tot_cmt_burdened_cost = l_tot_cmt_burdened_cost
203: , project_currency_code = l_project_curr_code
204: , project_rate_date = l_project_rate_date

Line 211: UPDATE pa_commitment_txns

207: , proj_raw_cost = l_PROJECT_RAW_COST
208: , proj_burdened_cost = l_PROJECT_BURDENED_COST
209: WHERE rowid = cmtrec.rowid;
210: ELSE
211: UPDATE pa_commitment_txns
212: SET generation_error_flag = 'Y'
213: , cmt_rejection_code = l_cmt_rejection_code
214: WHERE rowid = cmtrec.rowid;
215:

Line 408: from PA_COMMITMENT_TXNS

404: from
405: PJI_FM_EXTR_DREVN; -- overload of draft revenues table for commitments
406:
407: delete
408: from PA_COMMITMENT_TXNS
409: where PROJECT_ID in
410: (
411: select
412: PROJECT_ID

Line 1152: PA_COMMITMENT_TXNS tmp1,

1148: tmp1.INVENTORY_ITEM_ID,
1149: tmp1.BOM_LABOR_RESOURCE_ID,
1150: tmp1.BOM_EQUIPMENT_RESOURCE_ID
1151: from
1152: PA_COMMITMENT_TXNS tmp1,
1153: PA_PROJECTS_ALL proj,
1154: PA_PROJECT_TYPES_ALL projtyp
1155: where
1156: tmp1.project_id = proj.project_id and