APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_PRICE_ATTRIBUTES

Line 1432: ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(

1428: l_price_attributes_rec.quote_header_id := x_qte_header_rec.quote_header_id;
1429: x_price_attributes_tbl(i) := l_price_attributes_rec;
1430: -- BC4J Fix
1431: --x_price_attributes_tbl(i).price_attribute_id := NULL;
1432: ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(
1433: px_PRICE_ATTRIBUTE_ID => x_price_attributes_tbl(i).price_attribute_id,
1434: p_CREATION_DATE => SYSDATE,
1435: p_CREATED_BY => G_USER_ID,
1436: p_LAST_UPDATE_DATE => SYSDATE,

Line 2810: ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(

2806: l_price_attributes_rec.quote_header_id := l_qte_header_id;
2807: -- BC4J Fix
2808: --x_price_attributes_tbl(1).price_attribute_id := NULL;
2809:
2810: ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(
2811: px_PRICE_ATTRIBUTE_ID => x_price_attributes_tbl(i).price_attribute_id,
2812: p_CREATION_DATE => SYSDATE,
2813: p_CREATED_BY => G_USER_ID,
2814: p_LAST_UPDATE_DATE => SYSDATE,

Line 2952: ASO_PRICE_ATTRIBUTES_PKG.Update_Row(

2948:
2949:
2950: ELSIF l_price_attributes_rec.operation_code = 'UPDATE' THEN
2951:
2952: ASO_PRICE_ATTRIBUTES_PKG.Update_Row(
2953: p_PRICE_ATTRIBUTE_ID => l_price_attributes_rec.price_attribute_id,
2954: p_CREATION_DATE => l_price_attributes_rec.creation_date,
2955: p_CREATED_BY => G_USER_ID,
2956: p_LAST_UPDATE_DATE => SYSDATE,

Line 3094: ASO_PRICE_ATTRIBUTES_PKG.Delete_Row(

3090:
3091: /* Commented the following code to call new api aso_pricing_int.delete_promotion 07/22/02
3092:
3093: ELSIF l_price_attributes_rec.operation_code = 'DELETE' THEN
3094: ASO_PRICE_ATTRIBUTES_PKG.Delete_Row(
3095: p_PRICE_ATTRIBUTE_ID => l_price_attributes_rec.price_attribute_id);
3096:
3097: */
3098:

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

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
11743: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ATTRIBUTES table data',1,'N');
11744: END IF;
11745:
11746: DELETE FROM ASO_PRICE_ATTRIBUTES
11747: WHERE QUOTE_HEADER_ID = p_qte_header_id

Line 11746: DELETE FROM ASO_PRICE_ATTRIBUTES

11742: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11743: aso_debug_pub.add('Delete_Quote: Before deleting ASO_PRICE_ATTRIBUTES table data',1,'N');
11744: END IF;
11745:
11746: DELETE FROM ASO_PRICE_ATTRIBUTES
11747: WHERE QUOTE_HEADER_ID = p_qte_header_id
11748: and quote_line_id is NULL;
11749:
11750: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 11751: aso_debug_pub.add('Delete_Quote: After deleting ASO_PRICE_ATTRIBUTES table data',1,'N');

11747: WHERE QUOTE_HEADER_ID = p_qte_header_id
11748: and quote_line_id is NULL;
11749:
11750: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11751: aso_debug_pub.add('Delete_Quote: After deleting ASO_PRICE_ATTRIBUTES table data',1,'N');
11752: END IF;
11753:
11754:
11755: --End of New code for Delete_Promotion 07/22/02