eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on PO_PRICE_ADJUSTMENTS_DRAFT

Line 1406: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJ

1402: SELECT ADJ.price_adjustment_id
1403: ,LDUP.line_detail_index
1404: FROM QP_LDETS_V LDUP
1405: ,QP_PREQ_LINES_TMP QLUP
1406: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJ
1407: WHERE LDUP.process_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)
1408: AND LDUP.list_line_id = ADJ.list_line_id
1409: AND ADJ.po_line_id = QLUP.line_id
1410: AND ADJ.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id

Line 1446: --Sync PO PRICE ADJUSTMENTS table with PO PRICE ADJUSTMENTS DRAFT

1442: IF g_debug_stmt THEN
1443: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Before extracting adjustments from QP temp tables');
1444: END IF;
1445:
1446: --Sync PO PRICE ADJUSTMENTS table with PO PRICE ADJUSTMENTS DRAFT
1447: FOR i IN p_order_line_id_tbl.FIRST .. p_order_line_id_tbl.LAST
1448: LOOP
1449: PO_PRICE_ADJ_DRAFT_PKG.sync_draft_from_txn
1450: ( p_draft_id => p_draft_id

Line 1526: --Merge PO PRICE ADJUSTMENTS DRAFT table with PO PRICE ADJUSTMENTS for retro calls

1522: END IF;
1523:
1524: END IF;
1525:
1526: --Merge PO PRICE ADJUSTMENTS DRAFT table with PO PRICE ADJUSTMENTS for retro calls
1527: --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation
1528: IF (NVL(p_pricing_call_src, 'NULL') = 'RETRO' OR NVL(p_pricing_call_src, 'NULL') = 'AUTO') THEN
1529: --Merge Draft table with Base table
1530: PO_PRICE_ADJ_DRAFT_PKG.merge_changes( p_draft_id => p_draft_id );

Line 1617: --DELETE FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJD

1613: IF g_debug_stmt THEN
1614: PO_DEBUG.debug_stmt(p_log_head,l_progress,'The PO Line is not updated by pricing engine');
1615: END IF;
1616: ELSE
1617: --DELETE FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJD
1618: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD
1619: SET ADJD.delete_flag = 'Y'
1620: WHERE ADJD.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
1621: AND ADJD.po_header_id = p_order_header_id

Line 1618: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD

1614: PO_DEBUG.debug_stmt(p_log_head,l_progress,'The PO Line is not updated by pricing engine');
1615: END IF;
1616: ELSE
1617: --DELETE FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJD
1618: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD
1619: SET ADJD.delete_flag = 'Y'
1620: WHERE ADJD.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
1621: AND ADJD.po_header_id = p_order_header_id
1622: AND ADJD.po_line_id = l_line_id

Line 1662: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT

1658:
1659: --Only child adjustments are marked for deletion, no need to mark the attributes for deletion. The attributes are deleted along with the adjustments
1660: IF l_adj_id_tbl.count > 0 THEN
1661: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
1662: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT
1663: SET delete_flag = 'Y'
1664: WHERE draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
1665: AND parent_adjustment_id = l_adj_id_tbl(i);
1666:

Line 1724: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ

1720:
1721: BEGIN
1722: SELECT ADJ.price_adjustment_id
1723: INTO l_price_adjustment_id
1724: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ
1725: WHERE ADJ.draft_id = p_draft_id
1726: AND ADJ.price_adjustment_id = p_price_adjustment_id
1727: FOR UPDATE NOWAIT;
1728:

Line 1755: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD

1751: END IF;
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END;
1754:
1755: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD
1756: SET ( LAST_UPDATE_DATE
1757: , LAST_UPDATED_BY
1758: , LAST_UPDATE_LOGIN
1759: , operand

Line 1825: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD

1821:
1822: --reset the columns used to identify the overridden modifier
1823: --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation
1824: IF NVL(p_pricing_call_src, 'NULL') = 'RETRO' OR NVL(p_allow_price_override_flag, 'Y') <> 'Y' THEN
1825: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD
1826: SET ADJD.updated_flag = 'N',
1827: ADJD.change_reason_code = null,
1828: ADJD.change_reason_text = null
1829: WHERE ADJD.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id

Line 1856: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT

1852: IF g_debug_stmt THEN
1853: PO_DEBUG.debug_stmt(p_log_head,l_progress,'Insert Adjustments called with Order Header ID: '||p_order_header_id);
1854: END IF;
1855:
1856: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
1857: (DRAFT_ID
1858: , PRICE_ADJUSTMENT_ID
1859: , ADJ_LINE_NUM
1860: , CREATION_DATE

Line 2071: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ

2067: AND (nvl(LDETS.automatic_flag, 'N') = 'Y')
2068: AND LDETS.created_from_list_type_code NOT IN ('PRL', 'AGR')
2069: AND LDETS.list_line_type_code <> 'PLL'
2070: AND LDETS.list_line_id NOT IN (SELECT ADJ.list_line_id
2071: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2072: WHERE ADJ.list_line_id = LDETS.list_line_id
2073: AND ADJ.po_line_id = QLINE.line_id)
2074: );
2075: l_progress := '280';

Line 2087: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ

2083: BULK COLLECT INTO l_price_adjustment_id_tbl
2084: ,l_rltd_price_adj_id_tbl
2085: FROM QP_PREQ_RLTD_LINES_TMP RLTD
2086: , QP_PREQ_LINES_TMP QPL
2087: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2088: , PO_PRICE_ADJUSTMENTS_DRAFT RADJ
2089: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX
2090: AND QPL.LINE_ID = ADJ.PO_LINE_ID
2091: AND ADJ.draft_id = p_draft_id

Line 2088: , PO_PRICE_ADJUSTMENTS_DRAFT RADJ

2084: ,l_rltd_price_adj_id_tbl
2085: FROM QP_PREQ_RLTD_LINES_TMP RLTD
2086: , QP_PREQ_LINES_TMP QPL
2087: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2088: , PO_PRICE_ADJUSTMENTS_DRAFT RADJ
2089: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX
2090: AND QPL.LINE_ID = ADJ.PO_LINE_ID
2091: AND ADJ.draft_id = p_draft_id
2092: AND QPL.LINE_TYPE_CODE = 'LINE'

Line 2103: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJ

2099: AND RLTD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
2100:
2101: --Update adjustment table with parent record
2102: FORALL i IN l_rltd_price_adj_id_tbl.FIRST..l_rltd_price_adj_id_tbl.LAST
2103: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2104: SET ADJ.parent_adjustment_id = l_price_adjustment_id_tbl(i)
2105: WHERE ADJ.price_adjustment_id = l_rltd_price_adj_id_tbl(i);
2106: --New Parent Adjustment Id Logic end
2107:

Line 2131: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ

2127:
2128: CURSOR refresh_attribs_cur IS
2129: SELECT ADJ.price_adjustment_id, ldets.line_detail_index
2130: FROM QP_PREQ_LINES_TMP QPL
2131: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2132: , QP_LDETS_V LDETS
2133: WHERE LDETS.list_line_id = ADJ.list_line_id
2134: AND ADJ.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
2135: AND LDETS.line_index = QPL.line_index

Line 2310: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ

2306: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2307: , 1
2308: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2309: , QP_LDETS_v LDETS
2310: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2311: , QP_PREQ_LINES_TMP QPLINE
2312: WHERE ADJ.po_header_id = p_order_header_id
2313: AND QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2314: AND QPLAT.line_detail_index = LDETS.line_detail_index

Line 2362: FROM po_price_adjustments_draft ADJD

2358: END IF;
2359:
2360: SELECT price_adjustment_id
2361: BULK COLLECT INTO l_price_adjustment_id_tbl
2362: FROM po_price_adjustments_draft ADJD
2363: WHERE ADJD.draft_id = p_draft_id
2364: AND ADJD.applied_flag IS NULL --this check is needed to ensure if the manual modifier is newly added
2365: AND NVL(ADJD.automatic_flag, 'N') = 'N' --line is not automatic modifier
2366: AND NVL(ADJD.delete_flag, 'N') = 'N' --line is not marked for deletion

Line 2416: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJD

2412: , 'QP_ATTR_DEFNS_PRICING' --FLEX_TITLE
2413: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2414: , 1
2415: FROM QP_PRICING_ATTRIBUTES PRA
2416: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJD
2417: WHERE ADJD.draft_id = p_draft_id
2418: AND ADJD.price_adjustment_id = l_price_adjustment_id_tbl(i)
2419: AND ADJD.list_header_id = PRA.list_header_id
2420: AND ADJD.list_line_id = PRA.list_line_id

Line 2476: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJD

2472: , 'QP_ATTR_DEFNS_QUALIFIER' --FLEX_TITLE
2473: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2474: , 1
2475: FROM QP_QUALIFIERS QUAL
2476: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJD
2477: WHERE ADJD.draft_id = p_draft_id
2478: AND ADJD.price_adjustment_id = l_price_adjustment_id_tbl(i)
2479: AND ADJD.list_header_id = QUAL.list_header_id
2480: AND ADJD.list_line_id = QUAL.list_line_id

Line 2822: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE

2818: END copy_line_adjustments;
2819:
2820:
2821: PROCEDURE copy_draft_line_adjustments
2822: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
2823: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2824: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
2825: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2826: , p_mode IN VARCHAR2

Line 2823: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE

2819:
2820:
2821: PROCEDURE copy_draft_line_adjustments
2822: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
2823: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2824: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
2825: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2826: , p_mode IN VARCHAR2
2827: , x_return_status_text OUT NOCOPY VARCHAR2

Line 2824: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE

2820:
2821: PROCEDURE copy_draft_line_adjustments
2822: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
2823: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2824: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
2825: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2826: , p_mode IN VARCHAR2
2827: , x_return_status_text OUT NOCOPY VARCHAR2
2828: , x_return_status OUT NOCOPY VARCHAR2

Line 2825: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE

2821: PROCEDURE copy_draft_line_adjustments
2822: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
2823: , p_src_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2824: , p_dest_po_header_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_header_id%TYPE
2825: , p_dest_po_line_id IN PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2826: , p_mode IN VARCHAR2
2827: , x_return_status_text OUT NOCOPY VARCHAR2
2828: , x_return_status OUT NOCOPY VARCHAR2
2829: )

Line 2839: l_src_price_adjustment_id PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE;

2835: l_return_status_text VARCHAR2(2000);
2836: COPYDOC_ADJUSTMENT_FAILURE EXCEPTION;
2837:
2838: l_po_price_adjustment_record PO_PRICE_ADJUSTMENTS_V%ROWTYPE;
2839: l_src_price_adjustment_id PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE;
2840:
2841: l_src_adj_count NUMBER;
2842: --l_src_asoc_count NUMBER;
2843: l_src_attr_count NUMBER;

Line 2861: CURSOR po_price_adjustments_cur(p_src_line_id PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE

2857: l_dest_price_adjustment_id_tbl NUMBER_TYPE;
2858: i PLS_INTEGER;
2859:
2860: --Used to pick only the parent adjustments
2861: CURSOR po_price_adjustments_cur(p_src_line_id PO_PRICE_ADJUSTMENTS_DRAFT.po_line_id%TYPE
2862: ,p_auto_manual_flag VARCHAR2
2863: ,p_override_allowed_flag VARCHAR2
2864: ,p_overridden_flag VARCHAR2) IS
2865: SELECT ADJV.*

Line 2980: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ

2976: FROM PO_PRICE_ADJ_ASSOCS_DRAFT ASOC
2977: WHERE ASOC.draft_id = p_draft_id
2978: AND ASOC.line_id = p_src_po_line_id
2979: AND EXISTS (SELECT 1
2980: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2981: WHERE ADJ.draft_id = p_draft_id
2982: AND ADJ.line_id = p_src_po_line_id
2983: AND (l_auto_manual_flag IS NULL OR ADJ.automatic_flag = l_auto_manual_flag)
2984: AND (l_override_allowed_flag IS NULL OR ADJ.update_allowed = l_override_allowed_flag)

Line 3045: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ

3041: FROM PO_PRICE_ADJ_ASSOCS_DRAFT ASOC
3042: WHERE ASOC.draft_id = p_draft_id
3043: AND ASOC.line_id = p_src_po_line_id
3044: AND EXISTS (SELECT 1
3045: FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ
3046: WHERE ADJ.draft_id = p_draft_id
3047: AND ADJ.line_id = p_src_po_line_id
3048: AND (l_auto_manual_flag IS NULL OR ADJ.automatic_flag = l_auto_manual_flag)
3049: AND (l_override_allowed_flag IS NULL OR ADJ.update_allowed = l_override_allowed_flag)

Line 3180: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT

3176: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Update parent adjustment ids');
3177: END IF;
3178:
3179: FORALL i IN l_src_price_adjustment_id_tbl.FIRST .. l_src_price_adjustment_id_tbl.LAST
3180: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT
3181: SET parent_adjustment_id = l_dest_price_adjustment_id_tbl(i)
3182: WHERE parent_adjustment_id = l_src_price_adjustment_id_tbl(i)
3183: AND draft_id = p_draft_id
3184: AND po_header_id = p_dest_po_header_id

Line 3436: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT

3432: PROCEDURE insert_draft_adj_rec(p_draft_id IN NUMBER
3433: ,p_adj_rec IN PO_PRICE_ADJUSTMENTS_V%ROWTYPE)
3434: IS
3435: BEGIN
3436: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
3437: (DRAFT_ID
3438: , CHANGE_ACCEPTED_FLAG
3439: , DELETE_FLAG
3440: , PRICE_ADJUSTMENT_ID

Line 3790: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE

3786: --End of Comments
3787: -------------------------------------------------------------------------------
3788: -------------------------------------------------------------------------------
3789: PROCEDURE delete_adjustment_dependants
3790: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
3791: , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE )
3792: IS
3793: BEGIN
3794: --Delete dependant fields first

Line 3791: , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE )

3787: -------------------------------------------------------------------------------
3788: -------------------------------------------------------------------------------
3789: PROCEDURE delete_adjustment_dependants
3790: ( p_draft_id IN PO_PRICE_ADJUSTMENTS_DRAFT.draft_id%TYPE
3791: , p_price_adjustment_id IN PO_PRICE_ADJUSTMENTS_DRAFT.price_adjustment_id%TYPE )
3792: IS
3793: BEGIN
3794: --Delete dependant fields first
3795: --Delete Price Adjustment Attributes

Line 3804: DELETE FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ

3800: SELECT ASOC.rltd_price_adj_id
3801: FROM PO_PRICE_ADJ_ASSOCS_DRAFT ASOC
3802: WHERE ASOC.price_adjustment_id = p_price_adjustment_id);
3803:
3804: DELETE FROM PO_PRICE_ADJUSTMENTS_DRAFT ADJ
3805: WHERE ADJ.draft_id = p_draft_id
3806: AND ADJ.price_adjustment_id IN (SELECT ASOC.rltd_price_adj_id
3807: FROM PO_PRICE_ADJ_ASSOCS_DRAFT ASOC
3808: WHERE ASOC.price_adjustment_id = p_price_adjustment_id);