APPS.PA_TXN_ACCUMS dependencies on PA_COMMITMENT_TXNS_V

Line 1296: -- from the view pa_commitment_txns_v

1292: RAISE;
1293: END delete_cmt_txns;
1294:
1295: -- This procedure creates the commitment txns into pa_commitment_txns
1296: -- from the view pa_commitment_txns_v
1297:
1298: --
1299: -- Name: Create_Cmt_Txns
1300: --

Line 1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';

1359: ELSE
1360:
1361: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1362: IF x_use_tmp_table = 'N' THEN /* 14457478 */
1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1364: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1365: ELSIF x_use_tmp_table = 'Y' THEN
1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';
1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);

Line 1371: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V

1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1368: END IF; /* 14457478 */
1369: END IF;
1370:
1371: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V
1372: -- View.
1373:
1374: if (x_start_project_id is not null) then -- refresh cmts for single prj
1375:

Line 1592: pa_commitment_txns_v pctv

1588: pctv.wip_resource_id,
1589: pctv.resource_class,
1590: pctv.cbs_element_id --16461684
1591: FROM
1592: pa_commitment_txns_v pctv
1593: WHERE
1594: pctv.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097
1595: AND NVL(pctv.system_linkage_function,'X') =
1596: NVL(NVL(x_system_linkage_function,pctv.system_linkage_function),'X')

Line 2225: PA_COMMITMENT_TXNS_V pctv

2221: pctv.WIP_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID,
2222: pctv.RESOURCE_CLASS,
2223: pctv.CBS_ELEMENT_ID --16461684
2224: from
2225: PA_COMMITMENT_TXNS_V pctv
2226: where
2227: pctv.PROJECT_ID = l_project_id_1
2228: /* 14457478 */
2229: AND pctv.PROJECT_ID IS NOT NULL