DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_HEADERS_PVT

Line 105: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

101: l_qte_num NUMBER;
102: l_qte_header_id NUMBER;
103: l_qte_status_id NUMBER;
104: l_dummy VARCHAR2 ( 2 );
105: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
106: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
107: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
108: X_New_Qte_Line_Id NUMBER;
109: -- hyang: for bug 2692785

Line 1234: , X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

1230: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
1231: /* Code change for Quoting Usability Sun ER End */
1232: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
1233: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
1234: , X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1235: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1236: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
1237: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1238: ) IS

Line 1698: ASO_QUOTE_HEADERS_PVT.Insert_Rows (

1694: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1695: aso_debug_pub.ADD ( 'Copy_Header_Rows - Before insert_rows ', 1 , 'Y' );
1696: END IF;
1697:
1698: ASO_QUOTE_HEADERS_PVT.Insert_Rows (
1699: p_qte_header_rec => l_qte_header_rec
1700: , p_Price_Attributes_Tbl => l_price_attr_tbl
1701: , P_Price_Adjustment_Tbl => l_price_adj_tbl
1702: , P_Price_Adj_Attr_Tbl => l_price_adj_attr_tbl

Line 2293: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

2289: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
2290: , P_Qte_Header_Id IN NUMBER
2291: , P_New_Qte_Header_Id IN NUMBER
2292: , P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2293: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2294: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
2295: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2296: , P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
2297: , X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2366: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2365: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec; -- Code change for Quoting Usability Sun ER
2366: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2367: := P_Price_Index_Link_Tbl;
2368: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
2369: l_qte_line_id NUMBER;
2370: l_index NUMBER;

Line 2368: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2365: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec; -- Code change for Quoting Usability Sun ER
2366: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2367: := P_Price_Index_Link_Tbl;
2368: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
2369: l_qte_line_id NUMBER;
2370: l_index NUMBER;
2371: l_index_2 NUMBER;
2372: l_service_ref_line_id NUMBER;

Line 2700: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;

2696: l_def_control_rec.Dependency_Flag := FND_API.G_TRUE;
2697: l_def_control_rec.Defaulting_Flag := FND_API.G_TRUE;
2698: l_def_control_rec.Application_Type_Code := 'QUOTING HTML';
2699: l_def_control_rec.Defaulting_Flow_Code := 'CREATE';
2700: l_db_object_name := ASO_QUOTE_HEADERS_PVT.G_QUOTE_LINE_DB_NAME;
2701:
2702: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2703: aso_debug_pub.add('Copy_Line_Rows - Dependency_Flag: '|| l_def_control_rec.Dependency_Flag, 1, 'Y');
2704: aso_debug_pub.add('Copy_Line_Rows - Defaulting_Flag: '|| l_def_control_rec.Defaulting_Flag, 1, 'Y');

Line 2763: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN

2759: END IF;
2760:
2761: l_qte_line_tbl(i) := lx_qte_line_rec;
2762:
2763: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN
2764: l_shipment_tbl(i) := lx_ln_shipment_rec;
2765: END IF;
2766:
2767: IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN

Line 2767: IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN

2763: IF aso_quote_headers_pvt.Shipment_Null_Rec_Exists(lx_ln_shipment_rec, l_db_object_name) THEN
2764: l_shipment_tbl(i) := lx_ln_shipment_rec;
2765: END IF;
2766:
2767: IF aso_quote_headers_pvt.Payment_Null_Rec_Exists(lx_ln_payment_rec, l_db_object_name) THEN
2768: l_payment_tbl(i) := lx_ln_payment_rec;
2769: END IF;
2770:
2771: End If;

Line 4219: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

4215: , p_new_qte_header_id IN NUMBER
4216: , p_qte_header_id IN NUMBER
4217: , p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
4218: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
4219: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4220: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4221: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4222: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
4223: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 4220: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

4216: , p_qte_header_id IN NUMBER
4217: , p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
4218: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
4219: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4220: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4221: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4222: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
4223: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4224: , p_line_quantity IN NUMBER := FND_API.G_MISS_NUM

Line 4742: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

4738: , p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
4739: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
4740: , p_new_qte_header_id IN NUMBER
4741: , p_qte_header_id IN NUMBER
4742: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4743: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4744: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4745: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
4746: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 4743: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

4739: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
4740: , p_new_qte_header_id IN NUMBER
4741: , p_qte_header_id IN NUMBER
4742: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4743: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
4744: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4745: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
4746: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
4747: , p_line_quantity IN NUMBER := FND_API.G_MISS_NUM

Line 5613: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

5609: l_quantity NUMBER := 0;
5610: l_remaining_quantity NUMBER := 0;
5611: l_return_value Varchar2(1);
5612:
5613: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
5614: l_old_config_header_id NUMBER;
5615: l_old_config_revision_num NUMBER;
5616: l_config_hdr_id NUMBER;
5617: l_config_rev_nbr NUMBER;

Line 5645: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

5641: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5642: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
5643: l_ship_id NUMBER;
5644: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
5645: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
5646:
5647: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
5648: l_api_name varchar2(50) := 'Split_Model_Line';
5649: TYPE inserted_qte_line_Rec_Type IS RECORD