APPS.PO_NOTIFICATION_CTRL_DRAFT_PVT dependencies on PO_NOTIFICATION_CTRL_DRAFT

Line 1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PVT AS

1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PVT AS
2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PVT.plb 120.2 2005/07/26 16:21 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_NOTIFICATION_CTRL_DRAFT_PVT');

Line 2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PVT.plb 120.2 2005/07/26 16:21 bao noship $ */

1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PVT AS
2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PVT.plb 120.2 2005/07/26 16:21 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_NOTIFICATION_CTRL_DRAFT_PVT');
6:

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

1: PACKAGE BODY PO_NOTIFICATION_CTRL_DRAFT_PVT AS
2: /* $Header: PO_NOTIFICATION_CTRL_DRAFT_PVT.plb 120.2 2005/07/26 16:21 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_NOTIFICATION_CTRL_DRAFT_PVT');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: draft_changes_exist

Line 82: FROM po_notification_ctrl_draft PNCD

78: SELECT l_key,
79: l_index_tbl(i)
80: FROM DUAL
81: WHERE EXISTS (SELECT 1
82: FROM po_notification_ctrl_draft PNCD
83: WHERE PNCD.draft_id = p_draft_id_tbl(i)
84: AND PNCD.notification_id = NVL(p_notification_id_tbl(i),
85: PNCD.notification_id)
86: AND NVL(PNCD.change_accepted_flag, 'Y') = 'Y');

Line 227: PO_NOTIFICATION_CTRL_DRAFT_PKG.merge_changes

223: END IF;
224:
225: d_position := 10;
226: -- Merge Changes
227: PO_NOTIFICATION_CTRL_DRAFT_PKG.merge_changes
228: ( p_draft_id => p_draft_info.draft_id
229: );
230:
231: d_position := 20;

Line 241: END PO_NOTIFICATION_CTRL_DRAFT_PVT;

237: );
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: END apply_changes;
240:
241: END PO_NOTIFICATION_CTRL_DRAFT_PVT;