[Home] [Help]
PACKAGE: APPS.ASO_CFG_INT
Source
1 PACKAGE aso_cfg_int AUTHID CURRENT_USER as
2 /* $Header: asoicfgs.pls 120.1.12010000.2 2010/04/12 06:14:08 rassharm ship $ */
3 -- Start of Comments
4 -- Package name : aso_cfg_int
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12
13
14 TYPE rtln_rec_type IS RECORD(
15 operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR ,
16 quote_line_id NUMBER := FND_API.G_MISS_NUM ,
17 quote_line_detail_id NUMBER := FND_API.G_MISS_NUM ,
18 parent_config_item_id NUMBER := FND_API.G_MISS_NUM ,
19 config_item_id NUMBER := FND_API.G_MISS_NUM ,
20 inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
21 organization_id NUMBER := FND_API.G_MISS_NUM ,
22 component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR ,
23 quantity NUMBER := FND_API.G_MISS_NUM ,
24 uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR ,
25 included_flag VARCHAR2(1) := 'N' ,
26 created_flag VARCHAR2(1) := 'N' ,
27 complete_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ,
28 valid_configuration_flag VARCHAR2(1) := FND_API.G_MISS_CHAR ) ;
29
30 TYPE rtln_tbl_type IS TABLE OF rtln_rec_type
31 INDEX BY BINARY_INTEGER ;
32
33 G_rtln_tbl rtln_tbl_type ;
34 G_MISS_rtln_tbl rtln_tbl_type ;
35
36
37
38 -- API Name: Get_configuration_lines
39 -- Type : Public
40 -- Pre-Req :
41
42 TYPE Control_Rec_Type IS RECORD
43 (new_config_flag VARCHAR2(1) DEFAULT FND_API.G_TRUE ,
44 handle_deleted_flag VARCHAR2(1) DEFAULT NULL,
45 new_name VARCHAR2(240) DEFAULT NULL );
46
47 G_MISS_Control_Rec Control_Rec_Type;
48
49 PROCEDURE Get_configuration_lines(
50 P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
51 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
52 p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
53 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
54 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
55 x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
56 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
58 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) ;
59
60 PROCEDURE Delete_configuration(
61 P_Api_version_NUmber IN NUMBER,
62 P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,
63 P_config_hdr_id IN NUMBER,
64 p_config_rev_nbr IN NUMBER,
65 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
67 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
68
69
70 PROCEDURE Delete_configuration_auto(
71 P_Api_version_NUmber IN NUMBER,
72 P_Init_msg_List IN VARCHAR2 := FND_API.G_FALSE,
73 P_config_hdr_id IN NUMBER,
74 p_config_rev_nbr IN NUMBER,
75 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
76 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
77 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
78
79
80 Procedure Copy_Configuration( p_api_version_number IN NUMBER,
81 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
82 p_commit IN VARCHAR2 := FND_API.G_FALSE,
83 p_config_header_id IN NUMBER,
84 p_config_revision_num IN NUMBER,
85 p_copy_mode IN VARCHAR2,
86 p_handle_deleted_flag IN VARCHAR2 := NULL,
87
88 p_new_name IN VARCHAR2 := NULL,
89 p_autonomous_flag IN VARCHAR2 := FND_API.G_FALSE,
90 x_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
91 x_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
92 x_orig_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type,
93 x_new_item_id_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type,
94 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
96 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 );
98
99
100 PROCEDURE get_config_details(
101 p_api_version_number IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_control_rec IN aso_quote_pub.control_rec_type
105 := aso_quote_pub.G_MISS_control_rec,
106 p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
107 p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
108 p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
109 p_config_hdr_id IN NUMBER ,
110 p_config_rev_nbr IN NUMBER,
111 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
112 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
113 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 );
115
116
117 PROCEDURE Pricing_Callback( p_config_session_key IN VARCHAR2,
118 p_price_type IN VARCHAR2,
119 x_total_price OUT NOCOPY /* file.sql.39 change */ NUMBER );
120
121 FUNCTION Query_Qte_Line_Rows (
122 P_Qte_Header_Id IN NUMBER ,
123 P_Qte_Line_Id IN NUMBER
124 ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
125
126
127 PROCEDURE Create_hdr_xml
128 ( p_model_line_id IN NUMBER,
129 x_xml_hdr OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
131
132
133 PROCEDURE Send_input_xml
134 ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
135 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
136 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
137 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
138 P_xml_hdr IN VARCHAR2,
139 X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
140 X_config_changed OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- CZ ER
141 X_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142 X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
143 X_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 );
145
146
147 PROCEDURE Parse_output_xml
148 ( p_xml_msg IN LONG,
149 x_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
150 x_complete_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
151 x_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
152 x_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
153 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
154 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
155 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 );
157
158
159 PROCEDURE Validate_Configuration
160 (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
161 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
163 p_control_rec IN aso_quote_pub.control_rec_type
164 := aso_quote_pub.G_MISS_control_rec,
165 P_model_line_id IN NUMBER,
166 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
167 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
168 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
169 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
170 X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
171 X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
172 X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
173 X_complete_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
174 X_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
175 X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
176 X_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
177 );
178
179
180
181 End aso_cfg_int;