[Home] [Help]
PACKAGE: APPS.ASO_SPLIT_LINE_INT
Source
1 PACKAGE ASO_SPLIT_LINE_INT as
2 /* $Header: asoispls.pls 120.1 2005/06/29 12:35:59 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_SPLIT_LINE_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 type search_tbl_type is table of number index by binary_integer;
11
12
13 PROCEDURE Split_quote_line(
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,
23 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
24 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 );
26
27 --Overloaded one
28
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,
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 );
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,
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 );
61
62 End ASO_SPLIT_LINE_INT;