DBA Data[Home] [Help]

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 1362: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';

1358:
1359: ELSE
1360:
1361: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1362: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1363: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1364: END IF;
1365:
1366: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V

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

1362: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1363: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1364: END IF;
1365:
1366: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V
1367: -- View.
1368:
1369: if (x_start_project_id is not null) then -- refresh cmts for single prj
1370:

Line 1577: pa_commitment_txns_v pctv

1573: pctv.wip_resource_id,
1574: pctv.wip_resource_id,
1575: pctv.resource_class
1576: FROM
1577: pa_commitment_txns_v pctv
1578: WHERE
1579: pctv.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097
1580: AND NVL(pctv.system_linkage_function,'X') =
1581: NVL(NVL(x_system_linkage_function,pctv.system_linkage_function),'X');

Line 2170: PA_COMMITMENT_TXNS_V pctv

2166: pctv.WIP_RESOURCE_ID BOM_LABOR_RESOURCE_ID,
2167: pctv.WIP_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID,
2168: pctv.RESOURCE_CLASS
2169: from
2170: PA_COMMITMENT_TXNS_V pctv
2171: where
2172: pctv.PROJECT_ID = l_project_id_1;
2173:
2174: /* single project batch