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 8131: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(

8127: l_price_adj_rec.quote_line_id := l_qte_line_rec.quote_line_id;
8128: -- BC4J Fix
8129: --x_price_adj_tbl(i).PRICE_ADJUSTMENT_ID := NULL;
8130:
8131: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
8132: px_PRICE_ADJUSTMENT_ID => x_price_adj_tbl(i).PRICE_ADJUSTMENT_ID,
8133: p_CREATION_DATE => SYSDATE,
8134: p_CREATED_BY => G_USER_ID,
8135: p_LAST_UPDATE_DATE => SYSDATE,

Line 8252: UPDATE aso_price_adjustments

8248:
8249: if l_price_adjustment_id is not null then
8250:
8251: --update all child lines
8252: UPDATE aso_price_adjustments
8253: SET updated_flag = 'Y',
8254: applied_flag = null
8255: Where price_adjustment_id in ( SELECT rltd_price_adj_id
8256: FROM aso_price_adj_relationships b

Line 8260: UPDATE aso_price_adjustments

8256: FROM aso_price_adj_relationships b
8257: WHERE price_adjustment_id = l_price_adjustment_id );
8258:
8259: --update the parent PBH line
8260: UPDATE aso_price_adjustments
8261: SET updated_flag = 'Y',
8262: applied_flag = 'Y'
8263: Where price_adjustment_id = l_price_adjustment_id;
8264:

Line 8270: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(

8266:
8267: end if;
8268:
8269:
8270: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(
8271: p_PRICE_ADJUSTMENT_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID,
8272: p_CREATION_DATE => l_price_adj_rec.creation_date,
8273: p_CREATED_BY => G_USER_ID,
8274: p_LAST_UPDATE_DATE => SYSDATE,

Line 8369: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(

8365: p_OBJECT_VERSION_NUMBER => l_price_adj_rec.OBJECT_VERSION_NUMBER
8366: );
8367:
8368: ELSIF l_price_adj_rec.operation_code = 'DELETE' THEN
8369: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
8370: p_PRICE_ADJ_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID);
8371:
8372: END IF;
8373: END LOOP;

Line 9150: from aso_price_adjustments

9146: where quote_line_id = P_qte_line_Rec.quote_line_id;
9147:
9148: cursor c_prg_lines is
9149: select modifier_line_type_code
9150: from aso_price_adjustments
9151: where quote_line_id = p_qte_line_rec.quote_line_id
9152: and modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9153:
9154: cursor c_free_lines is

Line 9156: from aso_price_adjustments a, aso_price_adj_relationships b

9152: and modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9153:
9154: cursor c_free_lines is
9155: select a.quote_line_id
9156: from aso_price_adjustments a, aso_price_adj_relationships b
9157: where a.price_adjustment_id = b.rltd_price_adj_id
9158: and b.quote_line_id = p_qte_line_rec.quote_line_id
9159: and a.quote_line_id <> p_qte_line_rec.quote_line_id;
9160:

Line 9396: aso_price_adjustments adj

9392: select rel.rltd_price_adj_id
9393: BULK COLLECT INTO
9394: adj_id_tbl
9395: from aso_price_adj_relationships rel,
9396: aso_price_adjustments adj
9397: where rel.price_adjustment_id = adj.price_adjustment_id
9398: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9399: and rel.price_adjustment_id in (select a.price_adjustment_id
9400: from aso_price_adj_relationships a,

Line 9401: aso_price_adjustments b

9397: where rel.price_adjustment_id = adj.price_adjustment_id
9398: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9399: and rel.price_adjustment_id in (select a.price_adjustment_id
9400: from aso_price_adj_relationships a,
9401: aso_price_adjustments b
9402: where a.rltd_price_adj_id = b.price_adjustment_id
9403: and b.quote_line_id = p_qte_line_rec.quote_line_id);
9404:
9405: if aso_debug_pub.g_debug_flag = 'Y' THEN

Line 9425: UPDATE aso_price_adjustments

9421: if adj_id_tbl.count > 0 then
9422:
9423: FORALL i IN adj_id_tbl.FIRST..adj_id_tbl.LAST
9424:
9425: UPDATE aso_price_adjustments
9426: SET updated_flag = 'Y'
9427: WHERE price_adjustment_id = adj_id_tbl(i)
9428: AND modifier_line_type_code = G_DISCOUNT;
9429:

Line 9441: from aso_price_adj_relationships a, aso_price_adjustments b

9437:
9438: select a.price_adjustment_id
9439: BULK COLLECT INTO
9440: adj_id_tbl
9441: from aso_price_adj_relationships a, aso_price_adjustments b
9442: where a.rltd_price_adj_id = b.price_adjustment_id
9443: and b.quote_line_id = p_qte_line_rec.quote_line_id;
9444:
9445: if aso_debug_pub.g_debug_flag = 'Y' THEN

Line 9465: UPDATE aso_price_adjustments

9461: if adj_id_tbl.count> 0 then
9462:
9463: FORALL i IN adj_id_tbl.FIRST..adj_id_tbl.LAST
9464:
9465: UPDATE aso_price_adjustments
9466: SET updated_flag = 'Y'
9467: WHERE price_adjustment_id = adj_id_tbl(i)
9468: AND modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9469:

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

9477:
9478: when others then
9479:
9480: if aso_debug_pub.g_debug_flag = 'Y' THEN
9481: aso_debug_pub.add('Delete_Quote_Line: Updation of updated_flag column in aso_price_adjustments table failed.');
9482: end if;
9483:
9484: end;
9485:

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

9485:
9486: end if;
9487:
9488: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9489: aso_debug_pub.add('After updation of updated_flag column in aso_price_adjustments table.', 1, 'Y');
9490: end if;
9491:
9492: --Changes for deleting PRG lines
9493: open c_prg_lines;

Line 9604: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(

9600:
9601: -- delete price adjustments
9602: -- this should once again delete price adj relationships
9603: BEGIN
9604: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
9605: p_LINE_ID => p_qte_line_rec.quote_line_id,
9606: p_TYPE_CODE => 'QUOTE_LINE');
9607: EXCEPTION
9608: WHEN NO_DATA_FOUND THEN