DBA Data[Home] [Help]

APPS.ASO_SPLIT_LINE_INT dependencies on ASO_QUOTE_PUB

Line 18: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

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,

Line 19: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

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,

Line 20: := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,

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

Line 21: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

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

Line 33: p_control_rec IN aso_quote_pub.control_rec_type

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,

Line 34: := aso_quote_pub.g_miss_control_rec,

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,

Line 35: p_qte_header_rec IN aso_quote_pub.qte_header_rec_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

Line 36: := aso_quote_pub.g_miss_qte_header_rec,

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,

Line 37: p_original_qte_line_rec IN aso_quote_pub.qte_line_rec_type,

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,

Line 38: p_qte_line_tbl IN 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,

Line 39: p_ln_shipment_tbl IN aso_quote_pub.shipment_tbl_type

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,

Line 40: := aso_quote_pub.g_miss_shipment_tbl,

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

Line 41: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ aso_quote_pub.qte_line_tbl_type,

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

Line 49: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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,

Line 50: p_control_rec IN aso_quote_pub.control_rec_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,

Line 51: p_original_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_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,

Line 53: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

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,

Line 54: P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_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,
58: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 56: X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_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,
59: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60: );