APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_PRICE_ADJ_ATTRIBS

Line 967: ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(

963: FOR i in 1..l_price_adj_attr_tbl.count LOOP
964: -- BC4J Fix
965: --x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID := NULL;
966: l_sysdate := sysdate;
967: ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
968: px_PRICE_ADJ_ATTRIB_ID => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
969: p_CREATION_DATE => SYSDATE,
970: p_CREATED_BY => G_USER_ID,
971: p_LAST_UPDATE_DATE => l_sysdate,

Line 2162: ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(

2158: -- BC4J Fix
2159: --x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID := NULL;
2160: x_price_adj_attr_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2161:
2162: ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
2163: px_PRICE_ADJ_ATTRIB_ID => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
2164: p_CREATION_DATE => SYSDATE,
2165: p_CREATED_BY => G_USER_ID,
2166: p_LAST_UPDATE_DATE => l_sysdate,

Line 2189: ASO_PRICE_ADJ_ATTRIBS_PKG.Update_Row(

2185: x_price_adj_attr_tbl(i) := l_price_adj_attr_tbl(i);
2186: --l_price_adj_attr_rec := l_price_adj_attr_tbl(i);
2187: x_price_adj_attr_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2188:
2189: ASO_PRICE_ADJ_ATTRIBS_PKG.Update_Row(
2190: p_PRICE_ADJ_ATTRIB_ID => x_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
2191: p_CREATION_DATE => l_price_adj_attr_tbl(i).creation_date,
2192: p_CREATED_BY => G_USER_ID,
2193: p_LAST_UPDATE_DATE => l_sysdate,

Line 2209: ASO_PRICE_ADJ_ATTRIBS_PKG.Delete_Row(

2205: p_COMPARISON_OPERATOR => l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
2206: p_FLEX_TITLE => l_price_adj_attr_tbl(i).FLEX_TITLE,
2207: p_OBJECT_VERSION_NUMBER => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER);
2208: ELSIF l_Price_Adj_Attr_Tbl(i).operation_code = 'DELETE' THEN
2209: ASO_PRICE_ADJ_ATTRIBS_PKG.Delete_Row(
2210: p_PRICE_ADJ_ATTRIB_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID);
2211: END IF;
2212: END LOOP;
2213:

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

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');
11734: END IF;
11735:
11736: DELETE FROM aso_price_adj_attribs
11737: WHERE price_adjustment_id IN (select price_adjustment_id

Line 11736: DELETE FROM aso_price_adj_attribs

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');
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);