[Home] [Help]
PACKAGE: APPS.VEA_LAYERS_SV
Source
1 PACKAGE VEA_LAYERS_SV AUTHID CURRENT_USER as
2 /* $Header: VEAVALAS.pls 115.9 2004/07/27 00:06:34 rvishnuv ship $ */
3 --{
4 /*====================== vea_layers_sv =========================*/
5 /*========================================================================
6 PURPOSE:
7
8 NOTES: To run the script:
9
10 sql> start VEAVALHS.pls
11
12 HISTORY
13 Created N PARIKH 09/09/99 10:00 AM
14
15 =========================================================================*/
16 --
17 --
18 TYPE g_param_combination_rec_type
19 IS RECORD
20 (
21 usedTPGC BOOLEAN,
22 usedCUST BOOLEAN,
23 usedSHIP BOOLEAN,
24 usedBILL BOOLEAN,
25 usedISHP BOOLEAN
26 );
27 --
28 --
29 TYPE g_parameter_value_rec_type
30 IS RECORD
31 (
32 TPGC_value ece_xref_data.xref_int_value%TYPE,
33 CUST_value ece_xref_data.xref_int_value%TYPE,
34 SHIP_value ece_xref_data.xref_int_value%TYPE,
35 BILL_value ece_xref_data.xref_int_value%TYPE,
36 ISHP_value ece_xref_data.xref_int_value%TYPE,
37 execution_priority NUMBER
38 );
39 --
40 --
41 TYPE g_parameter_tbl_type
42 IS TABLE OF g_parameter_value_rec_type
43 INDEX BY BINARY_INTEGER;
44 --
45 --
46 TYPE g_layer_branch_rec_type
47 IS RECORD
48 (
49 program_unit_id vea_program_units.program_unit_id%TYPE,
50 program_unit_name vea_program_units.name%TYPE,
51 layer_provider_code vea_layers.layer_provider_code%TYPE,
52 layer_header_id vea_layers.layer_header_id%TYPE,
53 layer_id vea_layers.layer_id%TYPE,
54 sequence_number vea_layers.sequence_number%TYPE,
55 execution_sequence vea_layers.execution_sequence%TYPE,
56 active_flag vea_layers.active_flag%TYPE,
57 tps_parameter1_name vea_parameters.name%TYPE,
58 tps_parameter1_value ece_xref_data.xref_int_value%TYPE,
59 tps_parameter2_name vea_parameters.name%TYPE,
60 tps_parameter2_value ece_xref_data.xref_int_value%TYPE,
61 tps_parameter3_name vea_parameters.name%TYPE,
62 tps_parameter3_value ece_xref_data.xref_int_value%TYPE,
63 tps_parameter4_name vea_parameters.name%TYPE,
64 tps_parameter4_value ece_xref_data.xref_int_value%TYPE,
65 tps_parameter5_name vea_parameters.name%TYPE,
66 tps_parameter5_value ece_xref_data.xref_int_value%TYPE,
67 tps_parameter6_name vea_parameters.name%TYPE,
68 tps_parameter6_value ece_xref_data.xref_int_value%TYPE,
69 tps_parameter7_name vea_parameters.name%TYPE,
70 tps_parameter7_value ece_xref_data.xref_int_value%TYPE,
71 tps_parameter8_name vea_parameters.name%TYPE,
72 tps_parameter8_value ece_xref_data.xref_int_value%TYPE,
73 tps_parameter9_name vea_parameters.name%TYPE,
74 tps_parameter9_value ece_xref_data.xref_int_value%TYPE,
75 tps_parameter10_name vea_parameters.name%TYPE,
76 tps_parameter10_value ece_xref_data.xref_int_value%TYPE
77 );
78 --
79 --
80 TYPE g_layer_branch_tbl_type
81 IS TABLE OF g_layer_branch_rec_type
82 INDEX BY BINARY_INTEGER;
83 --
84 --
85 g_layer_branch_tbl g_layer_branch_tbl_type;
86 --
87 --
88 TYPE g_layer_active_rec_type
89 IS RECORD
90 (
91 program_unit_id vea_program_units.program_unit_id%TYPE,
92 program_unit_lp_code vea_program_units.layer_provider_code%TYPE,
93 tp_layer_id vea_tp_layers.tp_layer_id%TYPE,
94 tp_layer_name vea_tp_layers.name%TYPE,
95 active_flag vea_layers.active_flag%TYPE
96 );
97 --
98 --
99 TYPE g_layer_active_tbl_type
100 IS TABLE OF g_layer_active_rec_type
101 INDEX BY BINARY_INTEGER;
102 --
103 --
104 g_layer_active_tbl g_layer_active_tbl_type;
105 --
106 --
107 k_TPGC CONSTANT VARCHAR2(30) := 'x_tp_group_code';
108 k_CUST CONSTANT VARCHAR2(30) := 'x_customer_number';
109 k_SHIP CONSTANT VARCHAR2(30) := 'x_ship_to_ece_locn_code';
110 k_BILL CONSTANT VARCHAR2(30) := 'x_bill_to_ece_locn_code';
111 k_ISHP CONSTANT VARCHAR2(30) := 'x_inter_ship_to_ece_locn_code';
112 --
113 --
114 k_TPGC_PL CONSTANT NUMBER := 2;
115 k_CUST_PL CONSTANT NUMBER := 4;
116 k_SHIP_PL CONSTANT NUMBER := 8;
117 k_BILL_PL CONSTANT NUMBER := 16;
118 k_ISHP_PL CONSTANT NUMBER := 32;
119 --
120 --
121 PROCEDURE
122 delete_rows
123 (
124 p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
125 p_layer_header_id IN vea_layers.layer_header_id%TYPE,
126 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
127 x_layer_count OUT NOCOPY NUMBER
128 );
129 --
130 --
131 PROCEDURE
132 processConflictingLayers
133 (
134 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE DEFAULT NULL,
135 p_layer_provider_code IN vea_layers.layer_provider_code%TYPE DEFAULT NULL
136 );
137 --
138 --
139 PROCEDURE
140 populateLayerActiveTable
141 (
142 p_layer_provider_code IN vea_layers.layer_provider_code%TYPE
143 );
144 --
145 --
146 PROCEDURE
147 process
148 (
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151 p_commit IN VARCHAR2 := FND_API.G_FALSE,
152 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 x_id OUT NOCOPY vea_layers.layer_id%TYPE,
157 p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
158 p_layer_header_id IN vea_layers.layer_header_id%TYPE,
159 p_new_program_unit_id IN vea_layers.new_program_unit_id%TYPE,
160 p_program_unit_lp_code IN vea_layers.program_unit_lp_code%TYPE,
161 p_sequence_number IN vea_layers.sequence_number%TYPE,
162 p_description IN vea_layers.description%TYPE,
163 p_tps_parameter1_id IN vea_layers.tps_parameter1_id%TYPE,
164 p_tps_parameter1_value IN vea_layers.tps_parameter1_value%TYPE,
165 p_tps_parameter2_id IN vea_layers.tps_parameter2_id%TYPE DEFAULT NULL,
166 p_tps_parameter2_value IN vea_layers.tps_parameter2_value%TYPE DEFAULT NULL,
167 p_tps_parameter3_id IN vea_layers.tps_parameter3_id%TYPE DEFAULT NULL,
168 p_tps_parameter3_value IN vea_layers.tps_parameter3_value%TYPE DEFAULT NULL,
169 p_tps_parameter4_id IN vea_layers.tps_parameter4_id%TYPE DEFAULT NULL,
170 p_tps_parameter4_value IN vea_layers.tps_parameter4_value%TYPE DEFAULT NULL,
171 p_tps_parameter5_id IN vea_layers.tps_parameter5_id%TYPE DEFAULT NULL,
172 p_tps_parameter5_value IN vea_layers.tps_parameter5_value%TYPE DEFAULT NULL,
173 p_tps_parameter6_id IN vea_layers.tps_parameter6_id%TYPE DEFAULT NULL,
174 p_tps_parameter6_value IN vea_layers.tps_parameter6_value%TYPE DEFAULT NULL,
175 p_tps_parameter7_id IN vea_layers.tps_parameter7_id%TYPE DEFAULT NULL,
176 p_tps_parameter7_value IN vea_layers.tps_parameter7_value%TYPE DEFAULT NULL,
177 p_tps_parameter8_id IN vea_layers.tps_parameter8_id%TYPE DEFAULT NULL,
178 p_tps_parameter8_value IN vea_layers.tps_parameter8_value%TYPE DEFAULT NULL,
179 p_tps_parameter9_id IN vea_layers.tps_parameter9_id%TYPE DEFAULT NULL,
180 p_tps_parameter9_value IN vea_layers.tps_parameter9_value%TYPE DEFAULT NULL,
181 p_tps_parameter10_id IN vea_layers.tps_parameter10_id%TYPE DEFAULT NULL,
182 p_tps_parameter10_value IN vea_layers.tps_parameter10_value%TYPE DEFAULT NULL,
183 p_id IN vea_layers.layer_id%TYPE := NULL,
184 p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE := NULL,
185 p_tp_layer_name IN vea_tp_layers.name%TYPE DEFAULT NULL,
186 p_tps_parameter1_name IN vea_parameters.name%TYPE DEFAULT NULL,
187 p_tps_parameter2_name IN vea_parameters.name%TYPE DEFAULT NULL,
188 p_tps_parameter3_name IN vea_parameters.name%TYPE DEFAULT NULL,
189 p_tps_parameter4_name IN vea_parameters.name%TYPE DEFAULT NULL,
190 p_tps_parameter5_name IN vea_parameters.name%TYPE DEFAULT NULL,
191 p_tps_parameter6_name IN vea_parameters.name%TYPE DEFAULT NULL,
192 p_tps_parameter7_name IN vea_parameters.name%TYPE DEFAULT NULL,
193 p_tps_parameter8_name IN vea_parameters.name%TYPE DEFAULT NULL,
194 p_tps_parameter9_name IN vea_parameters.name%TYPE DEFAULT NULL,
195 p_tps_parameter10_name IN vea_parameters.name%TYPE DEFAULT NULL
196 );
197 --
198 --
199 PROCEDURE checkConflictingLayers(
200 p_package_name IN vea_packages.name%TYPE,
201 p_program_unit_name IN vea_program_units.name%TYPE);
202
203 --
204 --
205 --}
206 END VEA_LAYERS_SV;