DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_HEADERS_PVT

Line 99: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

95: l_qte_num NUMBER;
96: l_qte_header_id NUMBER;
97: l_qte_status_id NUMBER;
98: l_dummy VARCHAR2 ( 2 );
99: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
100: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
101: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
102: X_New_Qte_Line_Id NUMBER;
103: -- hyang: for bug 2692785

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

876: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
877: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
878: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
879: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
880: , X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
881: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
882: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
883: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
884: ) IS

Line 1172: ASO_QUOTE_HEADERS_PVT.Insert_Rows (

1168: l_qte_header_rec.object_version_number := FND_API.G_MISS_NUM;
1169:
1170: --End of BC4J Primary Key Fix
1171:
1172: ASO_QUOTE_HEADERS_PVT.Insert_Rows (
1173: p_qte_header_rec => l_qte_header_rec
1174: , p_Price_Attributes_Tbl => l_price_attr_tbl
1175: , P_Price_Adjustment_Tbl => l_price_adj_tbl
1176: , P_Price_Adj_Attr_Tbl => l_price_adj_attr_tbl

Line 1598: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

1594: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1595: , P_Qte_Header_Id IN NUMBER
1596: , P_New_Qte_Header_Id IN NUMBER
1597: , P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1598: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1599: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
1600: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1601: , P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
1602: , X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1671: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1671: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1672: := P_Price_Index_Link_Tbl;
1673: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
1674: l_qte_line_id NUMBER;
1675: l_index NUMBER;

Line 1673: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1671: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1672: := P_Price_Index_Link_Tbl;
1673: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
1674: l_qte_line_id NUMBER;
1675: l_index NUMBER;
1676: l_index_2 NUMBER;
1677: l_service_ref_line_id NUMBER;

Line 2911: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

2907: , p_new_qte_header_id IN NUMBER
2908: , p_qte_header_id IN NUMBER
2909: , p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
2910: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
2911: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2912: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2913: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2914: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
2915: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2912: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

2908: , p_qte_header_id IN NUMBER
2909: , p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
2910: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
2911: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2912: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2913: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2914: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
2915: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2916: , p_line_quantity IN NUMBER := FND_API.G_MISS_NUM

Line 3434: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

3430: , p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
3431: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
3432: , p_new_qte_header_id IN NUMBER
3433: , p_qte_header_id IN NUMBER
3434: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
3435: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
3436: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3437: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
3438: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3435: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

3431: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
3432: , p_new_qte_header_id IN NUMBER
3433: , p_qte_header_id IN NUMBER
3434: , lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
3435: , lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
3436: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3437: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
3438: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3439: , p_line_quantity IN NUMBER := FND_API.G_MISS_NUM

Line 4305: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

4301: l_quantity NUMBER := 0;
4302: l_remaining_quantity NUMBER := 0;
4303: l_return_value Varchar2(1);
4304:
4305: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
4306: l_old_config_header_id NUMBER;
4307: l_old_config_revision_num NUMBER;
4308: l_config_hdr_id NUMBER;
4309: l_config_rev_nbr NUMBER;

Line 4337: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

4333: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4334: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
4335: l_ship_id NUMBER;
4336: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
4337: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
4338:
4339: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
4340: l_api_name varchar2(50) := 'Split_Model_Line';
4341: TYPE inserted_qte_line_Rec_Type IS RECORD