APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 855: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(

851: l_price_adj_rec := p_price_adjustment_tbl(i);
852: -- BC4J Fix
853: --x_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID := NULL;
854: l_sysdate := sysdate;
855: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
856: px_PRICE_ADJUSTMENT_ID => x_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID,
857: p_CREATION_DATE => SYSDATE,
858: p_CREATED_BY => G_USER_ID,
859: p_LAST_UPDATE_DATE => l_sysdate,

Line 1881: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(

1877: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1878: aso_debug_pub.add('Before price_adj.update_rows - Update Rows', 1, 'Y');
1879: END IF;
1880:
1881: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
1882: px_PRICE_ADJUSTMENT_ID => x_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID,
1883: p_CREATION_DATE => SYSDATE,
1884: p_CREATED_BY => G_USER_ID,
1885: p_LAST_UPDATE_DATE => l_sysdate,

Line 1986: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(

1982:
1983: l_price_adj_rec := p_price_adjustment_tbl(i);
1984: l_sysdate := sysdate;
1985: x_price_adjustment_tbl(i).last_update_date := l_sysdate;
1986: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(
1987: p_PRICE_ADJUSTMENT_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID,
1988: p_CREATION_DATE => l_price_adj_rec.creation_date,
1989: p_CREATED_BY => G_USER_ID,
1990: p_LAST_UPDATE_DATE => l_sysdate,

Line 2082: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(

2078: p_ADJUSTED_AMOUNT_PER_PQTY => l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY,
2079: p_OBJECT_VERSION_NUMBER => l_price_adj_rec.OBJECT_VERSION_NUMBER
2080: );
2081: ELSIF P_Price_Adjustment_Tbl(i).operation_code = 'DELETE' THEN
2082: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
2083: p_PRICE_ADJUSTMENT_ID => p_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID);
2084: END IF;
2085: END LOOP;
2086:

Line 10655: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJUSTMENTS table data',1,'N');

10651:
10652: --New code for Delete_Promotion 07/22/02
10653:
10654: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10655: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJUSTMENTS table data',1,'N');
10656: END IF;
10657:
10658: DELETE FROM ASO_PRICE_ADJUSTMENTS
10659: WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line 10658: DELETE FROM ASO_PRICE_ADJUSTMENTS

10654: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10655: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJUSTMENTS table data',1,'N');
10656: END IF;
10657:
10658: DELETE FROM ASO_PRICE_ADJUSTMENTS
10659: WHERE QUOTE_HEADER_ID = p_qte_header_id;
10660:
10661: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10662: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJ_ATTRIBS table data',1,'N');

Line 10667: from aso_price_adjustments

10663: END IF;
10664:
10665: DELETE FROM aso_price_adj_attribs
10666: WHERE price_adjustment_id IN (select price_adjustment_id
10667: from aso_price_adjustments
10668: where quote_header_id = p_qte_header_id
10669: and quote_line_id is NULL);
10670:
10671: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 10877: (SELECT price_adjustment_id FROM aso_price_adjustments

10873: PRICE_ADJUSTMENT_ID,
10874: RLTD_PRICE_ADJ_ID
10875: FROM ASO_PRICE_ADJ_RELATIONSHIPS
10876: WHERE price_adjustment_id IN
10877: (SELECT price_adjustment_id FROM aso_price_adjustments
10878: WHERE quote_header_id = x_quote_header_id)
10879: AND quote_line_id IN
10880: (SELECT quote_line_id FROM aso_quote_lines_all
10881: WHERE quote_header_id = x_quote_header_id);

Line 10903: ASO_PRICE_ADJUSTMENTS apa

10899: apr.QUOTE_LINE_ID,
10900: apr.PRICE_ADJUSTMENT_ID,
10901: apr.RLTD_PRICE_ADJ_ID
10902: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr,
10903: ASO_PRICE_ADJUSTMENTS apa
10904: WHERE apr.price_adjustment_id = apa.price_adjustment_id
10905: AND apa.quote_header_id = x_quote_header_id
10906: AND EXISTS (select 'x' from aso_quote_lines_all aql
10907: where aql.quote_header_id = x_quote_header_id