1 PACKAGE ASO_NETWORK_UI_PVT AUTHID CURRENT_USER as
2 /* $Header: asovnets.pls 120.1 2005/06/29 12:42:17 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_NETWORK_UI_PVT
5 -- Purpose : This is a wrapper, to make the CZ API Calls for MACD Functionality in Quoting Forms UI
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- publication applicability parameters
11 -- config_creation_date (optional)
12 -- config_model_lookup_date (optional)
13 -- config_effective_date (optional)
14 -- calling_application_id (required)
15 -- usage_name (optional): if usage_name is not supplied: the value of profile option 'CZ_PUBLICATION_USAGE'
16 -- will be used if it is set; G_ANY_USAGE_NAME will be used otherwise.
17 -- publication_mode (optional): if publication_mode is not provided: the value of profile option
18 -- 'CZ_PUBLICATION_MODE' will be used if it is set; G_PRODUCTION_PUB_MODE will be used otherwise.
19 -- language (optional): default value is session language
20
21 TYPE aso_appl_param_rec_type IS RECORD
22 (
23 config_creation_date DATE,
24 config_model_lookup_date DATE,
25 config_effective_date DATE,
26 calling_application_id NUMBER,
27 usage_name VARCHAR2(255),
28 publication_mode VARCHAR2(1),
29 language VARCHAR2(4)
30 );
31
32
33 ------number tbl declaration
34 TYPE aso_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
35 ---TYPE aso_number_tbl_type IS TABLE OF NUMBER;
36
37 -----
38
39 TYPE aso_Instance_Rec_Type IS RECORD
40 (
41 Instance_id NUMBER,
42 Price_List_Id NUMBER := FND_API.G_MISS_NUM
43 );
44 G_MISS_Instance_Rec aso_Instance_Rec_Type;
45
46 TYPE aso_Instance_Tbl_Type IS TABLE OF aso_Instance_Rec_Type INDEX BY BINARY_INTEGER;
47 G_MISS_Instance_Tbl aso_Instance_Tbl_Type;
48
49
50 ------------------------------------------------------------------------------
51 -- API name : is_container
52 -- Package Name: ASO_NETWORK_UI_PVT
53 -- Type : Private
54 -- Pre-reqs : None
55 -- Function: Checks if a model specified by the top inventory_item_id and
56 -- organization_id is a network container model.
57 -- Version : Current version 1.0
58 -- Initial version 1.0
59 -- Parameters:
60 -- IN: p_api_version (required), standard IN parameterp_inventory_item_id (required),
61 -- top inventory_item_id of model
62 -- p_inventory_item_id (required), top inventory_item_id of model
63 -- p_organization_id (required), organization_id of model
64 -- p_appl_param_rec (required), publication applicability parameters
65 -- program callers should pass in the same set of applicability
66 -- parameter values as they pass in the Configurator xml initialize
67 -- message.
68 -- OUT: x_return_value, has one of the following values FND_API.G_TRUE,FND_API.G_FALSE,NULL
69 -- x_return_status, standard OUT NOCOPY parameter (see generate_config_trees)
70 -- x_msg_count, standard OUT NOCOPY parameter
71 -- x_msg_data, standard OUT NOCOPY parameter
72
73
74 procedure aso_is_container(p_api_version IN NUMBER
75 ,p_inventory_item_id IN NUMBER
76 ,p_organization_id IN NUMBER
77 ,p_appl_param_rec IN ASO_NETWORK_UI_PVT.aso_appl_param_rec_type
78 ,x_return_value OUT NOCOPY VARCHAR2
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_count OUT NOCOPY NUMBER
81 ,x_msg_data OUT NOCOPY VARCHAR2
82 );
83
84
85
86
87
88 -------------------------------------------------------------------------------------------
89 -- API name : get_contained_models
90 -- Package Name: ASO_NETWORK_UI_PVT
91 -- Type : Private
92 -- Pre-reqs : None
93 -- Function: Retrieves all possible enclosed trackable child models for the network
94 -- container model specified by the input inventory_item_id and
95 -- organization_id
96 -- Version : Current version 1.0
97 -- Initial version 1.0
98
99 -- Parameters:
100 -- IN: p_api_version (required), standard IN parameter
101 -- p_inventory_item_id (required), top inventory_item_id of network
102 -- container model
103 -- p_organization_id (required), organization_id of network container model
104 -- p_appl_param_rec (required), publication applicability parameters
105 -- program callers should pass in the same set of applicability
106 -- parameter values as they pass in the Configurator xml initialize
107 -- message
108 --
109 -- OUT: x_model_tbl, output array of inventory_item_ids of enclosed models
110 -- IF any error occurs during execution of this procedure, null will be
111 -- returned.
112 -- x_return_status, standard OUT NOCOPY parameter (see generate_config_trees)
113 -- x_msg_count, standard OUT NOCOPY parameter
114 -- x_msg_data, standard OUT NOCOPY parameter
115
116 procedure aso_get_contained_models(p_api_version IN NUMBER
117 ,p_inventory_item_id IN NUMBER
118 ,p_organization_id IN NUMBER
119 ,p_appl_param_rec IN ASO_NETWORK_UI_PVT.aso_appl_param_rec_type
120 ,x_model_tbl OUT NOCOPY ASO_NETWORK_UI_PVT.aso_number_tbl_type
121 ,x_return_status OUT NOCOPY VARCHAR2
122 ,x_msg_count OUT NOCOPY NUMBER
123 ,x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126
127 PROCEDURE aso_config_operations(
128 P_Api_Version_Number IN NUMBER,
129 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
133 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
134 P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl ,
135 P_instance_tbl IN ASO_NETWORK_UI_PVT.aso_Instance_Tbl_Type,
136 p_operation_code IN VARCHAR2,
137 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
138 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
139 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
140 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 );
142
143 PROCEDURE aso_Get_config_details(
144 P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
145 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
146 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
147 p_control_rec IN aso_quote_pub.control_rec_type := aso_quote_pub.G_MISS_control_rec,
148 p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
149 p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
150 p_config_hdr_id IN NUMBER ,
151 p_config_rev_nbr IN NUMBER,
152 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
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 END ASO_NETWORK_UI_PVT;