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.ASO_QUOTE_LINES_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 610: -- insert into aso_price_adjustments

606: p_OBJECT_VERSION_NUMBER => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);
607:
608: END LOOP;
609:
610: -- insert into aso_price_adjustments
611:
612: -- l_price_adj_attr_tbl := p_price_adj_attr_tbl;
613:
614:

Line 858: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(

854: l_price_adj_rec.quote_header_id := p_qte_line_rec.quote_header_id;
855: x_price_adj_tbl(i) := l_price_adj_rec;
856: -- BC4J Fix
857: --x_price_adj_tbl(i).PRICE_ADJUSTMENT_ID := NULL;
858: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
859: px_PRICE_ADJUSTMENT_ID => x_price_adj_tbl(i).PRICE_ADJUSTMENT_ID,
860: p_CREATION_DATE => SYSDATE,
861: p_CREATED_BY => G_USER_ID,
862: p_LAST_UPDATE_DATE => SYSDATE,

Line 4759: from aso_price_adjustments b

4755: cursor c_pbh( p_price_adjustment_id number ) is
4756: select price_adjustment_id
4757: from aso_price_adj_relationships a
4758: where a.price_adjustment_id = ( select price_adjustment_id
4759: from aso_price_adjustments b
4760: where a.price_adjustment_id = b.price_adjustment_id
4761: and b.MODIFIER_LINE_TYPE_CODE = 'PBH')
4762: and a.rltd_price_adj_id = p_price_adjustment_id;
4763:

Line 8249: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(

8245: l_price_adj_rec.quote_line_id := l_qte_line_rec.quote_line_id;
8246: -- BC4J Fix
8247: --x_price_adj_tbl(i).PRICE_ADJUSTMENT_ID := NULL;
8248:
8249: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
8250: px_PRICE_ADJUSTMENT_ID => x_price_adj_tbl(i).PRICE_ADJUSTMENT_ID,
8251: p_CREATION_DATE => SYSDATE,
8252: p_CREATED_BY => G_USER_ID,
8253: p_LAST_UPDATE_DATE => SYSDATE,

Line 8370: UPDATE aso_price_adjustments

8366:
8367: if l_price_adjustment_id is not null then
8368:
8369: --update all child lines
8370: UPDATE aso_price_adjustments
8371: SET updated_flag = 'Y',
8372: applied_flag = null
8373: Where price_adjustment_id in ( SELECT rltd_price_adj_id
8374: FROM aso_price_adj_relationships b

Line 8378: UPDATE aso_price_adjustments

8374: FROM aso_price_adj_relationships b
8375: WHERE price_adjustment_id = l_price_adjustment_id );
8376:
8377: --update the parent PBH line
8378: UPDATE aso_price_adjustments
8379: SET updated_flag = 'Y',
8380: applied_flag = 'Y'
8381: Where price_adjustment_id = l_price_adjustment_id;
8382:

Line 8388: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(

8384:
8385: end if;
8386:
8387:
8388: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(
8389: p_PRICE_ADJUSTMENT_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID,
8390: p_CREATION_DATE => l_price_adj_rec.creation_date,
8391: p_CREATED_BY => G_USER_ID,
8392: p_LAST_UPDATE_DATE => SYSDATE,

Line 8487: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(

8483: p_OBJECT_VERSION_NUMBER => l_price_adj_rec.OBJECT_VERSION_NUMBER
8484: );
8485:
8486: ELSIF l_price_adj_rec.operation_code = 'DELETE' THEN
8487: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
8488: p_PRICE_ADJ_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID);
8489:
8490: END IF;
8491: END LOOP;

Line 9268: from aso_price_adjustments

9264: where quote_line_id = P_qte_line_Rec.quote_line_id;
9265:
9266: cursor c_prg_lines is
9267: select modifier_line_type_code
9268: from aso_price_adjustments
9269: where quote_line_id = p_qte_line_rec.quote_line_id
9270: and modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9271:
9272: cursor c_free_lines is

Line 9274: from aso_price_adjustments a, aso_price_adj_relationships b

9270: and modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9271:
9272: cursor c_free_lines is
9273: select a.quote_line_id
9274: from aso_price_adjustments a, aso_price_adj_relationships b
9275: where a.price_adjustment_id = b.rltd_price_adj_id
9276: and b.quote_line_id = p_qte_line_rec.quote_line_id
9277: and a.quote_line_id <> p_qte_line_rec.quote_line_id;
9278:

Line 9514: aso_price_adjustments adj

9510: select rel.rltd_price_adj_id
9511: BULK COLLECT INTO
9512: adj_id_tbl
9513: from aso_price_adj_relationships rel,
9514: aso_price_adjustments adj
9515: where rel.price_adjustment_id = adj.price_adjustment_id
9516: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9517: and rel.price_adjustment_id in (select a.price_adjustment_id
9518: from aso_price_adj_relationships a,

Line 9519: aso_price_adjustments b

9515: where rel.price_adjustment_id = adj.price_adjustment_id
9516: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9517: and rel.price_adjustment_id in (select a.price_adjustment_id
9518: from aso_price_adj_relationships a,
9519: aso_price_adjustments b
9520: where a.rltd_price_adj_id = b.price_adjustment_id
9521: and b.quote_line_id = p_qte_line_rec.quote_line_id);
9522:
9523: if aso_debug_pub.g_debug_flag = 'Y' THEN

Line 9543: UPDATE aso_price_adjustments

9539: if adj_id_tbl.count > 0 then
9540:
9541: FORALL i IN adj_id_tbl.FIRST..adj_id_tbl.LAST
9542:
9543: UPDATE aso_price_adjustments
9544: SET updated_flag = 'Y'
9545: WHERE price_adjustment_id = adj_id_tbl(i)
9546: AND modifier_line_type_code = G_DISCOUNT;
9547:

Line 9559: from aso_price_adj_relationships a, aso_price_adjustments b

9555:
9556: select a.price_adjustment_id
9557: BULK COLLECT INTO
9558: adj_id_tbl
9559: from aso_price_adj_relationships a, aso_price_adjustments b
9560: where a.rltd_price_adj_id = b.price_adjustment_id
9561: and b.quote_line_id = p_qte_line_rec.quote_line_id;
9562:
9563: if aso_debug_pub.g_debug_flag = 'Y' THEN

Line 9583: UPDATE aso_price_adjustments

9579: if adj_id_tbl.count> 0 then
9580:
9581: FORALL i IN adj_id_tbl.FIRST..adj_id_tbl.LAST
9582:
9583: UPDATE aso_price_adjustments
9584: SET updated_flag = 'Y'
9585: WHERE price_adjustment_id = adj_id_tbl(i)
9586: AND modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9587:

Line 9599: aso_debug_pub.add('Delete_Quote_Line: Updation of updated_flag column in aso_price_adjustments table failed.');

9595:
9596: when others then
9597:
9598: if aso_debug_pub.g_debug_flag = 'Y' THEN
9599: aso_debug_pub.add('Delete_Quote_Line: Updation of updated_flag column in aso_price_adjustments table failed.');
9600: end if;
9601:
9602: end;
9603:

Line 9607: aso_debug_pub.add('After updation of updated_flag column in aso_price_adjustments table.', 1, 'Y');

9603:
9604: end if;
9605:
9606: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9607: aso_debug_pub.add('After updation of updated_flag column in aso_price_adjustments table.', 1, 'Y');
9608: end if;
9609:
9610: --Changes for deleting PRG lines
9611: open c_prg_lines;

Line 9722: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(

9718:
9719: -- delete price adjustments
9720: -- this should once again delete price adj relationships
9721: BEGIN
9722: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
9723: p_LINE_ID => p_qte_line_rec.quote_line_id,
9724: p_TYPE_CODE => 'QUOTE_LINE');
9725: EXCEPTION
9726: WHEN NO_DATA_FOUND THEN