APPS.PO_PRICE_DIFF_DRAFT_PKG dependencies on PO_PRICE_DIFF_DRAFT

Line 1: PACKAGE BODY PO_PRICE_DIFF_DRAFT_PKG AS

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

Line 2: /* $Header: PO_PRICE_DIFF_DRAFT_PKG.plb 120.5 2006/09/28 23:05:20 bao noship $ */

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

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

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

Line 49: DELETE FROM po_price_diff_draft

45: IF (PO_LOG.d_proc) THEN
46: PO_LOG.proc_begin(d_module);
47: END IF;
48:
49: DELETE FROM po_price_diff_draft
50: WHERE draft_id = p_draft_id
51: AND price_differential_id = NVL(p_price_differential_id,
52: price_differential_id);
53:

Line 115: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist

111: PO_LOG.proc_begin(d_module);
112: END IF;
113:
114: x_record_already_exist_tbl :=
115: PO_PRICE_DIFF_DRAFT_PVT.draft_changes_exist
116: ( p_draft_id_tbl => p_draft_id_tbl,
117: p_price_differential_id_tbl => p_price_differential_id_tbl
118: );
119:

Line 152: INSERT INTO po_price_diff_draft

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

Line 201: UPDATE po_price_diff_draft

197: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
198: END IF;
199:
200: FORALL i IN 1..p_price_differential_id_tbl.COUNT
201: UPDATE po_price_diff_draft
202: SET delete_flag = p_delete_flag_tbl(i)
203: WHERE price_differential_id = p_price_differential_id_tbl(i)
204: AND draft_id = p_draft_id_tbl(i)
205: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 353: FROM po_price_diff_draft PPDD

349:
350: DELETE FROM po_price_differentials PPD
351: WHERE PPD.price_differential_id IN
352: ( SELECT PPDD.price_differential_id
353: FROM po_price_diff_draft PPDD
354: WHERE PPDD.draft_id = p_draft_id
355: AND PPDD.delete_flag = 'Y'
356: AND NVL(PPDD.change_accepted_flag, 'Y') = 'Y');
357:

Line 387: FROM po_price_diff_draft PPDD

383: PPDD.created_by,
384: PPDD.last_update_date,
385: PPDD.last_updated_by,
386: PPDD.last_update_login
387: FROM po_price_diff_draft PPDD
388: WHERE PPDD.draft_id = p_draft_id
389: AND NVL(PPDD.change_accepted_flag, 'Y') = 'Y'
390: ) PPDDV
391: ON (PPD.price_differential_id = PPDDV.price_differential_id)

Line 484: FROM po_price_diff_draft

480: END IF;
481:
482: SELECT 1
483: INTO l_dummy
484: FROM po_price_diff_draft
485: WHERE price_differential_id = p_price_differential_id
486: AND draft_id = p_draft_id
487: FOR UPDATE NOWAIT;
488:

Line 541: END PO_PRICE_DIFF_DRAFT_PKG;

537: WHEN NO_DATA_FOUND THEN
538: NULL;
539: END lock_transaction_record;
540:
541: END PO_PRICE_DIFF_DRAFT_PKG;