APPS.PJI_FM_CMT_EXTR dependencies on PA_COMMITMENT_TXNS

Line 44: pa_commitment_txns pct

40: pct.receipt_currency_code,
41: pct.receipt_currency_amount,
42: pct.receipt_exchange_rate
43: FROM
44: pa_commitment_txns pct
45: WHERE
46: pct.project_id = x_project_id;
47:
48: --

Line 87: SELECT COUNT(*) INTO l_count FROM pa_commitment_txns WHERE project_id = x_project_id;

83: X_week_ending_day_index number;
84:
85: BEGIN
86:
87: SELECT COUNT(*) INTO l_count FROM pa_commitment_txns WHERE project_id = x_project_id;
88:
89: select
90: per.PERIOD_NAME,
91: per.GL_PERIOD_NAME

Line 355: pa_commitment_txns pct

351: pct.receipt_currency_code,
352: pct.receipt_currency_amount,
353: pct.receipt_exchange_rate
354: FROM
355: pa_commitment_txns pct
356: WHERE
357: pct.project_id = x_project_id ;
358:
359:

Line 375: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;

371:
372: cmtrec selcmts%ROWTYPE;
373: row_processed NUMBER;
374: l_cmtrec_curr_OK VARCHAR2(1);
375: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
376: l_err_msg VARCHAR2(2000);
377:
378: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;
379: l_Project_Rate_Date DATE;

Line 378: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;

374: l_cmtrec_curr_OK VARCHAR2(1);
375: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
376: l_err_msg VARCHAR2(2000);
377:
378: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;
379: l_Project_Rate_Date DATE;
380: l_project_exch_rate NUMBER;
381: l_PROJECT_RAW_COST NUMBER := NULL;
382: l_PROJECT_BURDENED_COST NUMBER := NULL; -- added for FP.M

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

390: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
391:
392:
393: l_PROJFUNC_CURR_CODE pa_projects_all.project_currency_code%TYPE := NULL;
394: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
395: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
396: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
397:
398: BEGIN

Line 514: UPDATE pa_commitment_txns

510:
511: END IF; -- DERIVATION SUBsection
512:
513: IF (l_cmtrec_curr_OK = 'Y') THEN
514: UPDATE pa_commitment_txns
515: SET tot_cmt_raw_cost = l_tot_cmt_raw_cost
516: , tot_cmt_burdened_cost = l_tot_cmt_burdened_cost
517: , project_currency_code = l_project_curr_code
518: , project_rate_date = l_project_rate_date

Line 525: UPDATE pa_commitment_txns

521: , proj_raw_cost = l_PROJECT_RAW_COST
522: , proj_burdened_cost = l_PROJECT_BURDENED_COST
523: WHERE rowid = cmtrec.rowid;
524: ELSE
525: UPDATE pa_commitment_txns
526: SET generation_error_flag = 'Y'
527: , cmt_rejection_code = l_cmt_rejection_code
528: WHERE rowid = cmtrec.rowid;
529:

Line 725: from PA_COMMITMENT_TXNS

721: from
722: PJI_FM_EXTR_DREVN; -- overload of draft revenues table for commitments
723:
724: delete
725: from PA_COMMITMENT_TXNS
726: where PROJECT_ID in
727: (
728: select
729: PROJECT_ID

Line 1537: PA_COMMITMENT_TXNS tmp1,

1533: tmp1.BOM_LABOR_RESOURCE_ID,
1534: tmp1.BOM_EQUIPMENT_RESOURCE_ID,
1535: tmp1.CBS_ELEMENT_ID /*Added for CBS Changes 16832862 */
1536: from
1537: PA_COMMITMENT_TXNS tmp1,
1538: PA_PROJECTS_ALL proj,
1539: PA_PROJECT_TYPES_ALL projtyp
1540: where
1541: tmp1.project_id = proj.project_id and