APPS.PO_DRAFTS_PVT dependencies on PO_NOTIFICATION_CONTROLS

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 4413: -- Identify Header level locks required because of change in po_notification_controls

4409: PO_LOG.stmt_all_session_gt(d_module, d_position, G_LOCKS_REQUIRED_ID);
4410: PO_LOG.stmt(d_module,d_position ,'number of rows Inserted ',SQL%ROWCOUNT);
4411: END IF;
4412:
4413: -- Identify Header level locks required because of change in po_notification_controls
4414: INSERT INTO po_session_gt(
4415: key,
4416: index_char1, -- records identifier
4417: index_char2, -- entity_name

Line 4441: FROM po_notification_controls pnc,

4437: NVL(pnc.start_date_active ,G_NULL_DATE),
4438: NVL(pnc.end_date_active ,G_NULL_DATE)
4439: ) p_lock_attrs,
4440: pnc.notification_id
4441: FROM po_notification_controls pnc,
4442: po_session_gt pogt
4443: WHERE pnc.po_header_id = pogt.char1 -- po_header_id
4444: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
4445: AND pogt.index_char2 = G_LOCK_HEADER_ENTITY