APPS.PO_DRAFTS_PVT dependencies on PO_GA_ORG_ASSIGNMENTS

Line 4169: -- po_headers_all, po_ga_org_assignments, po_notification_controls

4165: --Pre-reqs: None
4166: --Modifies:
4167: -- po_entity_locks
4168: --Locks:
4169: -- po_headers_all, po_ga_org_assignments, po_notification_controls
4170: --Function:
4171: -- This procedure generates the change data for the passed entities PKs,
4172: -- creates entries in po_entity_locks table corresponding to the modified
4173: -- attributes, and locks the required rows in transaction tables.

Line 4359: -- Identify Header level locks required because of change in po_ga_org_assignments

4355: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
4356: PO_LOG.stmt(d_module, d_position, 'Number of Records Inserted',SQL%ROWCOUNT);
4357: END IF;
4358:
4359: -- Identify Header level locks required because of change in po_ga_org_assignments
4360: INSERT INTO po_session_gt(
4361: key,
4362: index_char1, -- records identifier
4363: index_char2, -- entity_name

Line 4384: FROM po_ga_org_assignments pgoa,

4380: NVL(pgoa.purchasing_org_id ,g_null_num),
4381: NVL(pgoa.vendor_site_id ,G_NULL_NUM)
4382: ) p_lock_attrs,
4383: pgoa.org_assignment_id
4384: FROM po_ga_org_assignments pgoa,
4385: po_session_gt pogt
4386: WHERE pgoa.po_header_id = pogt.char1 -- po_header_id
4387: and pogt.index_char1 = G_CHANGED_ENTTIES_ID
4388: and pogt.index_char2 = G_LOCK_HEADER_ENTITY