APPS.PO_R12_CAT_UPG_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 2341: INSERT INTO PO_GA_ORG_ASSIGNMENTS(

2337: -- Org Assignments Row.
2338: -- SQL Why : To migrate data to txn tables
2339: -- SQL Join: none
2340: FORALL i IN 1 .. l_remaining_val_po_hdr_ids.COUNT
2341: INSERT INTO PO_GA_ORG_ASSIGNMENTS(
2342: /*PO_UC12*/
2343: org_assignment_id,
2344: /*/PO_UC12*/
2345: po_header_id,

Line 2359: PO_GA_ORG_ASSIGNMENTS_S.nextval,

2355: creation_date,
2356: created_by)
2357: VALUES(
2358: /*PO_UC12*/
2359: PO_GA_ORG_ASSIGNMENTS_S.nextval,
2360: /*/PO_UC12*/
2361: l_remaining_val_po_hdr_ids(i),
2362: g_job.org_id,
2363: --'N', --g_job.delete_flag,

Line 2544: DELETE FROM PO_GA_ORG_ASSIGNMENTS

2540: l_progress := '020';
2541:
2542: -- For each of the above GBPA Header, delete the default Org Assignments Row
2543: FORALL i IN 1.. l_po_header_ids.COUNT
2544: DELETE FROM PO_GA_ORG_ASSIGNMENTS
2545: WHERE po_header_id = l_po_header_ids(i);
2546:
2547: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of Org Assignments deleted='||SQL%rowcount); END IF;
2548: