APPS.PO_NOTIFICATION_CTRL_DRAFT_PKG dependencies on PO_NOTIFICATION_CONTROLS

Line 77: -- table of po notification controls unique identifier

73: -- the draft record according to the parameter.
74: --Parameters:
75: --IN:
76: --p_notification_id_tbl
77: -- table of po notification controls unique identifier
78: --p_draft_id_tbl
79: -- table of draft ids this sync up will be done for
80: --p_delete_flag_tbl
81: -- table fo flags to indicate whether the draft record should be maked as

Line 224: FROM po_notification_controls

220: attribute6,
221: attribute7,
222: attribute8,
223: attribute9
224: FROM po_notification_controls
225: WHERE notification_id = p_notification_id_tbl(i)
226: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
227: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
228:

Line 383: DELETE FROM po_notification_controls PNC

379:
380: -- bug5187544
381: -- Delete only records that have not been rejected
382:
383: DELETE FROM po_notification_controls PNC
384: WHERE PNC.notification_id IN
385: ( SELECT PNCD.notification_id
386: FROM po_notification_ctrl_draft PNCD
387: WHERE PNCD.draft_id = p_draft_id

Line 402: MERGE INTO po_notification_controls PNC

398: --PNC.program_update_date
399: --PNC.request_id
400: --PNC.created_by
401: --PNC.creation_date
402: MERGE INTO po_notification_controls PNC
403: USING (
404: SELECT
405: PNCD.draft_id,
406: PNCD.delete_flag,

Line 633: FROM po_notification_controls

629: END IF;
630:
631: SELECT 1
632: INTO l_dummy
633: FROM po_notification_controls
634: WHERE notification_id = p_notification_id
635: FOR UPDATE NOWAIT;
636:
637: IF (PO_LOG.d_proc) THEN