APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 859: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(

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

Line 1940: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(

1936: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1937: aso_debug_pub.add('Before price_adj.update_rows - Update Rows', 1, 'Y');
1938: END IF;
1939:
1940: ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
1941: px_PRICE_ADJUSTMENT_ID => x_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID,
1942: p_CREATION_DATE => SYSDATE,
1943: p_CREATED_BY => G_USER_ID,
1944: p_LAST_UPDATE_DATE => l_sysdate,

Line 2045: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(

2041:
2042: l_price_adj_rec := p_price_adjustment_tbl(i);
2043: l_sysdate := sysdate;
2044: x_price_adjustment_tbl(i).last_update_date := l_sysdate;
2045: ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(
2046: p_PRICE_ADJUSTMENT_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID,
2047: p_CREATION_DATE => l_price_adj_rec.creation_date,
2048: p_CREATED_BY => G_USER_ID,
2049: p_LAST_UPDATE_DATE => l_sysdate,

Line 2141: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(

2137: p_ADJUSTED_AMOUNT_PER_PQTY => l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY,
2138: p_OBJECT_VERSION_NUMBER => l_price_adj_rec.OBJECT_VERSION_NUMBER
2139: );
2140: ELSIF P_Price_Adjustment_Tbl(i).operation_code = 'DELETE' THEN
2141: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
2142: p_PRICE_ADJUSTMENT_ID => p_price_adjustment_tbl(i).PRICE_ADJUSTMENT_ID);
2143: END IF;
2144: END LOOP;
2145:

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

11722:
11723: --New code for Delete_Promotion 07/22/02
11724:
11725: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11726: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJUSTMENTS table data',1,'N');
11727: END IF;
11728:
11729: DELETE FROM ASO_PRICE_ADJUSTMENTS
11730: WHERE QUOTE_HEADER_ID = p_qte_header_id;

Line 11729: DELETE FROM ASO_PRICE_ADJUSTMENTS

11725: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11726: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJUSTMENTS table data',1,'N');
11727: END IF;
11728:
11729: DELETE FROM ASO_PRICE_ADJUSTMENTS
11730: WHERE QUOTE_HEADER_ID = p_qte_header_id;
11731:
11732: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11733: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ADJ_ATTRIBS table data',1,'N');

Line 11738: from aso_price_adjustments

11734: END IF;
11735:
11736: DELETE FROM aso_price_adj_attribs
11737: WHERE price_adjustment_id IN (select price_adjustment_id
11738: from aso_price_adjustments
11739: where quote_header_id = p_qte_header_id
11740: and quote_line_id is NULL);
11741:
11742: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 11948: (SELECT price_adjustment_id FROM aso_price_adjustments

11944: PRICE_ADJUSTMENT_ID,
11945: RLTD_PRICE_ADJ_ID
11946: FROM ASO_PRICE_ADJ_RELATIONSHIPS
11947: WHERE price_adjustment_id IN
11948: (SELECT price_adjustment_id FROM aso_price_adjustments
11949: WHERE quote_header_id = x_quote_header_id)
11950: AND quote_line_id IN
11951: (SELECT quote_line_id FROM aso_quote_lines_all
11952: WHERE quote_header_id = x_quote_header_id);

Line 11974: ASO_PRICE_ADJUSTMENTS apa

11970: apr.QUOTE_LINE_ID,
11971: apr.PRICE_ADJUSTMENT_ID,
11972: apr.RLTD_PRICE_ADJ_ID
11973: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr,
11974: ASO_PRICE_ADJUSTMENTS apa
11975: WHERE apr.price_adjustment_id = apa.price_adjustment_id
11976: AND apa.quote_header_id = x_quote_header_id
11977: AND EXISTS (select 'x' from aso_quote_lines_all aql
11978: where aql.quote_header_id = x_quote_header_id