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_ADJ_DRAFT_PKG dependencies on PO_PRICE_ADJUSTMENTS

Line 52: DELETE FROM po_price_adjustments_draft

48: DELETE FROM po_price_adj_attribs_draft
49: WHERE draft_id = p_draft_id
50: AND price_adjustment_id = NVL(p_price_adjustment_id, price_adjustment_id);
51:
52: DELETE FROM po_price_adjustments_draft
53: WHERE draft_id = p_draft_id
54: AND price_adjustment_id = NVL(p_price_adjustment_id, price_adjustment_id);
55:
56: d_position := 10;

Line 146: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT

142: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
143: END IF;
144:
145: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT
146: INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
147: (DRAFT_ID
148: , DELETE_FLAG
149: , CHANGE_ACCEPTED_FLAG
150: , PRICE_ADJUSTMENT_ID

Line 346: FROM PO_PRICE_ADJUSTMENTS ADJ

342: , ADJ.ac_attribute15
343: , ADJ.operand_per_pqty
344: , ADJ.adjusted_amount_per_pqty
345: , 1
346: FROM PO_PRICE_ADJUSTMENTS ADJ
347: WHERE ADJ.price_adjustment_id = p_price_adjustment_id_tbl(i)
348: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
349: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
350:

Line 357: UPDATE po_price_adjustments_draft

353: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
354: END IF;
355:
356: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT
357: UPDATE po_price_adjustments_draft
358: SET delete_flag = p_delete_flag_tbl(i)
359: WHERE (price_adjustment_id = p_price_adjustment_id_tbl(i)
360: OR parent_adjustment_id = p_price_adjustment_id_tbl(i))
361: AND draft_id = p_draft_id_tbl(i)

Line 565: FROM po_price_adjustments ADJ

561: ,p_delete_flag
562: BULK COLLECT INTO l_price_adjustment_id_tbl
563: ,l_draft_id_tbl
564: ,l_delete_flag_tbl
565: FROM po_price_adjustments ADJ
566: WHERE ADJ.po_header_id = p_order_header_id
567: AND ADJ.po_line_id = NVL(p_order_line_id, ADJ.po_line_id);
568:
569: sync_draft_from_txn

Line 638: DELETE FROM po_price_adjustments ADJ

634: -- Once this is fixed we'll move the delete statement back to the merge
635: -- statement
636:
637: -- Delete only records that have not been rejected
638: DELETE FROM po_price_adjustments ADJ
639: WHERE ADJ.price_adjustment_id IN
640: ( SELECT ADJD.price_adjustment_id
641: FROM po_price_adjustments_draft ADJD
642: WHERE ADJD.draft_id = p_draft_id

Line 641: FROM po_price_adjustments_draft ADJD

637: -- Delete only records that have not been rejected
638: DELETE FROM po_price_adjustments ADJ
639: WHERE ADJ.price_adjustment_id IN
640: ( SELECT ADJD.price_adjustment_id
641: FROM po_price_adjustments_draft ADJD
642: WHERE ADJD.draft_id = p_draft_id
643: AND ADJD.delete_flag = 'Y'
644: AND NVL(ADJD.change_accepted_flag, 'Y') = 'Y')
645: RETURNING ADJ.price_adjustment_id BULK COLLECT INTO l_price_adjustment_id_tbl;

Line 649: UPDATE po_price_adjustments_draft ADJD

645: RETURNING ADJ.price_adjustment_id BULK COLLECT INTO l_price_adjustment_id_tbl;
646:
647: /*
648: --Set the Delete Flag to Y for the child price break lines if the price break header is marked for deletion
649: UPDATE po_price_adjustments_draft ADJD
650: SET delete_flag = 'Y'
651: WHERE EXISTS (SELECT 1
652: FROM po_price_adjustments_draft DADJD
653: WHERE DADJD.price_adjustment_id = ADJD.parent_adjustment_id

Line 652: FROM po_price_adjustments_draft DADJD

648: --Set the Delete Flag to Y for the child price break lines if the price break header is marked for deletion
649: UPDATE po_price_adjustments_draft ADJD
650: SET delete_flag = 'Y'
651: WHERE EXISTS (SELECT 1
652: FROM po_price_adjustments_draft DADJD
653: WHERE DADJD.price_adjustment_id = ADJD.parent_adjustment_id
654: AND DADJD.delete_flag = 'Y');
655: */
656: --Delete Child adjustment lines

Line 658: DELETE FROM po_price_adjustments ADJ

654: AND DADJD.delete_flag = 'Y');
655: */
656: --Delete Child adjustment lines
657: FORALL i IN l_price_adjustment_id_tbl.FIRST .. l_price_adjustment_id_tbl.LAST
658: DELETE FROM po_price_adjustments ADJ
659: WHERE ADJ.parent_adjustment_id = l_price_adjustment_id_tbl(i);
660:
661: --Delete the attributes corresponding to the lines that are marked for deletion
662: DELETE FROM po_price_adj_attribs ATTR

Line 665: FROM po_price_adjustments_draft ADJD

661: --Delete the attributes corresponding to the lines that are marked for deletion
662: DELETE FROM po_price_adj_attribs ATTR
663: WHERE ATTR.price_adjustment_id IN
664: (SELECT ADJD.price_adjustment_id
665: FROM po_price_adjustments_draft ADJD
666: WHERE ADJD.draft_id = p_draft_id
667: --AND ADJD.delete_flag = 'Y' --delete all attributes irrespective of the flag
668: AND NVL(ADJD.change_accepted_flag, 'Y') = 'Y');
669:

Line 670: MERGE INTO po_price_adjustments ADJ

666: WHERE ADJD.draft_id = p_draft_id
667: --AND ADJD.delete_flag = 'Y' --delete all attributes irrespective of the flag
668: AND NVL(ADJD.change_accepted_flag, 'Y') = 'Y');
669:
670: MERGE INTO po_price_adjustments ADJ
671: USING (
672: SELECT DFT.draft_id
673: , DFT.change_accepted_flag
674: , DFT.delete_flag

Line 770: FROM po_price_adjustments_draft DFT

766: , DFT.ac_attribute14
767: , DFT.ac_attribute15
768: , DFT.operand_per_pqty
769: , DFT.adjusted_amount_per_pqty
770: FROM po_price_adjustments_draft DFT
771: WHERE DFT.draft_id = p_draft_id
772: AND NVL(DFT.change_accepted_flag, 'Y') = 'Y') ADJD
773: ON (ADJ.price_adjustment_id = ADJD.price_adjustment_id)
774: WHEN MATCHED THEN

Line 1107: ,po_price_adjustments_draft ADJD

1103: , ATTR.flex_title
1104: , ATTR.price_adj_attrib_id
1105: , 1
1106: FROM po_price_adj_attribs_draft ATTR
1107: ,po_price_adjustments_draft ADJD
1108: WHERE ADJD.draft_id = p_draft_id
1109: AND ADJD.draft_id = ATTR.draft_id
1110: AND ADJD.price_adjustment_id = ATTR.price_adjustment_id
1111: AND NVL(ADJD.delete_flag, 'N') <> 'Y'

Line 1137: -- id for po price adjustments record

1133: -- Obtain database lock for the record in draft table
1134: --Parameters:
1135: --IN:
1136: --p_price_adjustment_id
1137: -- id for po price adjustments record
1138: --p_draft_id
1139: -- draft unique identifier
1140: --RETURN:
1141: --End of Comments

Line 1162: FROM po_price_adjustments_draft

1158: END IF;
1159:
1160: SELECT 1
1161: INTO l_dummy
1162: FROM po_price_adjustments_draft
1163: WHERE price_adjustment_id = p_price_adjustment_id
1164: AND draft_id = p_draft_id
1165: FOR UPDATE NOWAIT;
1166:

Line 1206: FROM po_price_adjustments

1202: END IF;
1203:
1204: SELECT 1
1205: INTO l_dummy
1206: FROM po_price_adjustments
1207: WHERE price_adjustment_id = p_price_adjustment_id
1208: FOR UPDATE NOWAIT;
1209:
1210: IF (PO_LOG.d_proc) THEN