APPS.PO_NOTIFICATION_CTRL_DRAFT_PKG dependencies on PO_NOTIFICATION_CTRL_DRAFT

Line 1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PKG AS

1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PKG AS
2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PKG.plb 120.5 2006/09/28 23:04:57 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_NOTIFICATION_CTRL_DRAFT_PKG');

Line 2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PKG.plb 120.5 2006/09/28 23:04:57 bao noship $ */

1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PKG AS
2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PKG.plb 120.5 2006/09/28 23:04:57 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_NOTIFICATION_CTRL_DRAFT_PKG');
6:

Line 5: PO_LOG.get_package_base('PO_NOTIFICATION_CTRL_DRAFT_PKG');

1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PKG AS
2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PKG.plb 120.5 2006/09/28 23:04:57 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_NOTIFICATION_CTRL_DRAFT_PKG');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: delete_rows

Line 48: DELETE FROM po_notification_ctrl_draft

44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: DELETE FROM po_notification_ctrl_draft
49: WHERE draft_id = p_draft_id
50: AND notification_id = NVL(p_notification_id, notification_id);
51:
52: d_position := 10;

Line 113: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist

109: PO_LOG.proc_begin(d_module);
110: END IF;
111:
112: x_record_already_exist_tbl :=
113: PO_NOTIFICATION_CTRL_DRAFT_PVT.draft_changes_exist
114: ( p_draft_id_tbl => p_draft_id_tbl,
115: p_notification_id_tbl => p_notification_id_tbl
116: );
117:

Line 150: INSERT INTO po_notification_ctrl_draft

146: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
147: END IF;
148:
149: FORALL i IN 1..p_notification_id_tbl.COUNT
150: INSERT INTO po_notification_ctrl_draft
151: (
152: draft_id,
153: delete_flag,
154: change_accepted_flag,

Line 235: UPDATE po_notification_ctrl_draft

231: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
232: END IF;
233:
234: FORALL i IN 1..p_notification_id_tbl.COUNT
235: UPDATE po_notification_ctrl_draft
236: SET delete_flag = p_delete_flag_tbl(i)
237: WHERE notification_id = p_notification_id_tbl(i)
238: AND draft_id = p_draft_id_tbl(i)
239: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 386: FROM po_notification_ctrl_draft PNCD

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
388: AND PNCD.delete_flag = 'Y'
389: AND NVL(PNCD.change_accepted_flag, 'Y') = 'Y' );
390:

Line 440: FROM po_notification_ctrl_draft PNCD

436: PNCD.attribute6,
437: PNCD.attribute7,
438: PNCD.attribute8,
439: PNCD.attribute9
440: FROM po_notification_ctrl_draft PNCD
441: WHERE PNCD.draft_id = p_draft_id
442: AND NVL(PNCD.change_accepted_flag, 'Y') = 'Y'
443: ) PNCDV
444: ON (PNC.notification_id = PNCDV.notification_id)

Line 589: FROM po_notification_ctrl_draft

585: END IF;
586:
587: SELECT 1
588: INTO l_dummy
589: FROM po_notification_ctrl_draft
590: WHERE notification_id = p_notification_id
591: AND draft_id = p_draft_id
592: FOR UPDATE NOWAIT;
593:

Line 646: END PO_NOTIFICATION_CTRL_DRAFT_PKG;

642: WHEN NO_DATA_FOUND THEN
643: NULL;
644: END lock_transaction_record;
645:
646: END PO_NOTIFICATION_CTRL_DRAFT_PKG;