14: P_Api_Version_Number IN NUMBER,
15: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
15: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
16: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17: p_qte_line_id IN NUMBER,
18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
22: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
24: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: );
29: PROCEDURE split_quote_line(
30: p_api_version_number IN number,
31: p_init_msg_list IN varchar2 := fnd_api.g_false,
32: p_commit IN varchar2 := fnd_api.g_false,
33: p_control_rec IN aso_quote_pub.control_rec_type
34: := aso_quote_pub.g_miss_control_rec,
35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
30: p_api_version_number IN number,
31: p_init_msg_list IN varchar2 := fnd_api.g_false,
32: p_commit IN varchar2 := fnd_api.g_false,
33: p_control_rec IN aso_quote_pub.control_rec_type
34: := aso_quote_pub.g_miss_control_rec,
35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
31: p_init_msg_list IN varchar2 := fnd_api.g_false,
32: p_commit IN varchar2 := fnd_api.g_false,
33: p_control_rec IN aso_quote_pub.control_rec_type
34: := aso_quote_pub.g_miss_control_rec,
35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
32: p_commit IN varchar2 := fnd_api.g_false,
33: p_control_rec IN aso_quote_pub.control_rec_type
34: := aso_quote_pub.g_miss_control_rec,
35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
40: := aso_quote_pub.g_miss_shipment_tbl,
33: p_control_rec IN aso_quote_pub.control_rec_type
34: := aso_quote_pub.g_miss_control_rec,
35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
40: := aso_quote_pub.g_miss_shipment_tbl,
41: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
34: := aso_quote_pub.g_miss_control_rec,
35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
40: := aso_quote_pub.g_miss_shipment_tbl,
41: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
42: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
40: := aso_quote_pub.g_miss_shipment_tbl,
41: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
42: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
43: x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
36: := aso_quote_pub.g_miss_qte_header_rec,
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
40: := aso_quote_pub.g_miss_shipment_tbl,
41: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
42: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
43: x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
44: x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2
37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,
38: p_qte_line_tbl IN aso_quote_pub.qte_line_tbl_type,
39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type
40: := aso_quote_pub.g_miss_shipment_tbl,
41: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,
42: x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2,
43: x_msg_count OUT NOCOPY /* file.sql.39 change */ number,
44: x_msg_data OUT NOCOPY /* file.sql.39 change */ varchar2
45: );
45: );
46:
47:
48: PROCEDURE Do_Split_line (
49: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
50: p_control_rec IN aso_quote_pub.control_rec_type,
51: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
52: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
53: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
46:
47:
48: PROCEDURE Do_Split_line (
49: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
50: p_control_rec IN aso_quote_pub.control_rec_type,
51: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
52: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
53: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
54: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
47:
48: PROCEDURE Do_Split_line (
49: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
50: p_control_rec IN aso_quote_pub.control_rec_type,
51: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
52: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
53: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
54: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
55: p_commit IN VARCHAR2,
49: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
50: p_control_rec IN aso_quote_pub.control_rec_type,
51: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
52: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
53: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
54: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
55: p_commit IN VARCHAR2,
56: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
57: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
50: p_control_rec IN aso_quote_pub.control_rec_type,
51: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
52: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
53: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
54: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
55: p_commit IN VARCHAR2,
56: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
57: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
52: p_serviceable_item IN VARCHAR2 := FND_API.G_FALSE,
53: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
54: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
55: p_commit IN VARCHAR2,
56: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
57: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
59: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60: );