DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PJM_PO_COMMITMENTS_TMP

Line 3832: DELETE FROM pa_pjm_po_commitments_tmp; /* Bug 6408874 */

3828: TmpProjectTab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 6408874
3829: BEGIN
3830:
3831: DELETE FROM pa_commitment_txns_tmp;
3832: DELETE FROM pa_pjm_po_commitments_tmp; /* Bug 6408874 */
3833: DELETE FROM pa_pjm_req_commitments_tmp; /* Bug 6408874 */
3834: -- DELETE FROM pa_fp_ra_map_tmp;
3835:
3836: x_last_updated_by := NVL(FND_GLOBAL.USER_ID,-1);

Line 3950: insert into pa_pjm_po_commitments_tmp

3946: -- where pmprd.project_id = TmpProjectTab(i);
3947:
3948:
3949: forall i in 1..TmpProjectTab.count -- commented for bug 6408874, back for bug 7491714
3950: insert into pa_pjm_po_commitments_tmp
3951: (project_id
3952: ,task_id
3953: ,po_number
3954: ,po_distribution_id