eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.VEA_PARAMETER_MAPPINGS_SV dependencies on VEA_PARAMETER_MAPPINGS

Line 1: PACKAGE BODY VEA_PARAMETER_MAPPINGS_SV as

1: PACKAGE BODY VEA_PARAMETER_MAPPINGS_SV as
2: /* $Header: VEAVAPMB.pls 115.9 2004/07/27 00:52:54 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameter_mappings_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_parameter_mappings_sv =========================/

1: PACKAGE BODY VEA_PARAMETER_MAPPINGS_SV as
2: /* $Header: VEAVAPMB.pls 115.9 2004/07/27 00:52:54 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameter_mappings_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PARAMETER_MAPPINGS
7:
8: NOTES: To run the script:

Line 6: PURPOSE: Table handler package for table VEA_PARAMETER_MAPPINGS

2: /* $Header: VEAVAPMB.pls 115.9 2004/07/27 00:52:54 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameter_mappings_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PARAMETER_MAPPINGS
7:
8: NOTES: To run the script:
9:
10: sql> start VEAVALHB.pls

Line 17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_PARAMETER_MAPPINGS_SV';

13: Created N PARIKH 09/09/99 10:00 AM
14:
15: =========================================================================*/
16:
17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_PARAMETER_MAPPINGS_SV';
18: --
19: --
20: /*========================================================================
21:

Line 24: PURPOSE: Inserts a record into VEA_PARAMETER_MAPPINGS table

20: /*========================================================================
21:
22: PROCEDURE NAME: insert_row
23:
24: PURPOSE: Inserts a record into VEA_PARAMETER_MAPPINGS table
25:
26: ========================================================================*/
27: PROCEDURE
28: insert_row

Line 30: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
31: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,

Line 31: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,

27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
31: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,

Line 32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,

28: insert_row
29: (
30: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
31: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
36: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,

Line 33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,

29: (
30: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
31: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
36: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
37: p_description IN vea_parameter_mappings.description%TYPE

Line 34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,

30: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
31: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
36: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
37: p_description IN vea_parameter_mappings.description%TYPE
38: )

Line 35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,

31: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
36: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
37: p_description IN vea_parameter_mappings.description%TYPE
38: )
39: IS

Line 36: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,

32: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
36: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
37: p_description IN vea_parameter_mappings.description%TYPE
38: )
39: IS
40: --{

Line 37: p_description IN vea_parameter_mappings.description%TYPE

33: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
34: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
35: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
36: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
37: p_description IN vea_parameter_mappings.description%TYPE
38: )
39: IS
40: --{
41: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 52: INSERT INTO vea_parameter_mappings

48: BEGIN
49: --{
50: l_location := '0010';
51: --
52: INSERT INTO vea_parameter_mappings
53: (
54: layer_provider_code, parameter_mapping_id,
55: layer_header_id,
56: program_unit_parameter_id, program_unit_param_lp_code,

Line 95: PURPOSE: Updates a record into VEA_PARAMETER_MAPPINGS table

91: /*========================================================================
92:
93: PROCEDURE NAME: update_row
94:
95: PURPOSE: Updates a record into VEA_PARAMETER_MAPPINGS table
96:
97: ========================================================================*/
98: PROCEDURE
99: update_row

Line 101: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,

97: ========================================================================*/
98: PROCEDURE
99: update_row
100: (
101: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
102: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,

Line 102: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,

98: PROCEDURE
99: update_row
100: (
101: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
102: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,

Line 103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,

99: update_row
100: (
101: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
102: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
107: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,

Line 104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,

100: (
101: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
102: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
107: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
108: p_description IN vea_parameter_mappings.description%TYPE

Line 105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,

101: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
102: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
107: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
108: p_description IN vea_parameter_mappings.description%TYPE
109: )

Line 106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,

102: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
107: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
108: p_description IN vea_parameter_mappings.description%TYPE
109: )
110: IS

Line 107: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,

103: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
107: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
108: p_description IN vea_parameter_mappings.description%TYPE
109: )
110: IS
111: --{

Line 108: p_description IN vea_parameter_mappings.description%TYPE

104: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
105: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
106: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
107: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
108: p_description IN vea_parameter_mappings.description%TYPE
109: )
110: IS
111: --{
112: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 123: UPDATE vea_parameter_mappings

119: BEGIN
120: --{
121: l_location := '0010';
122: --
123: UPDATE vea_parameter_mappings
124: SET program_unit_parameter_id = p_program_unit_parameter_id,
125: program_unit_param_lp_code = p_program_unit_param_lp_code,
126: layer_header_id = p_layer_header_id,
127: tps_parameter_id = p_tps_parameter_id,

Line 165: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,

161: ========================================================================*/
162: PROCEDURE
163: delete_rows
164: (
165: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
166: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE
167: )
168: IS
169: --{

Line 166: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE

162: PROCEDURE
163: delete_rows
164: (
165: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
166: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE
167: )
168: IS
169: --{
170: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';

Line 179: DELETE vea_parameter_mappings

175: BEGIN
176: --{
177: l_location := '0010';
178: --
179: DELETE vea_parameter_mappings
180: WHERE layer_provider_code = p_layer_provider_code
181: AND layer_header_id = p_layer_header_id;
182: --}
183: EXCEPTION

Line 203: PURPOSE: Table hadndler API for VEA_PARAMETER_MAPPINGS table.

199: /*========================================================================
200:
201: PROCEDURE NAME: process
202:
203: PURPOSE: Table hadndler API for VEA_PARAMETER_MAPPINGS table.
204:
205: It inserts/updates a record in VEA_PARAMETER_MAPPINGS table.
206:
207: ========================================================================*/

Line 205: It inserts/updates a record in VEA_PARAMETER_MAPPINGS table.

201: PROCEDURE NAME: process
202:
203: PURPOSE: Table hadndler API for VEA_PARAMETER_MAPPINGS table.
204:
205: It inserts/updates a record in VEA_PARAMETER_MAPPINGS table.
206:
207: ========================================================================*/
208: PROCEDURE
209: process

Line 218: x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,

214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,
219: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,

Line 219: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,

215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,
219: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,

Line 220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,

216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,
219: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,

Line 221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,

217: x_msg_data OUT NOCOPY VARCHAR2,
218: x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,
219: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
225: p_description IN vea_parameter_mappings.description%TYPE,

Line 222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,

218: x_id OUT NOCOPY vea_parameter_mappings.parameter_mapping_id%TYPE,
219: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
225: p_description IN vea_parameter_mappings.description%TYPE,
226: p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,

Line 223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,

219: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
225: p_description IN vea_parameter_mappings.description%TYPE,
226: p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,
227: p_program_unit_parameter_name IN vea_parameters.name%TYPE,

Line 224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,

220: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
225: p_description IN vea_parameter_mappings.description%TYPE,
226: p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,
227: p_program_unit_parameter_name IN vea_parameters.name%TYPE,
228: p_tps_parameter_name IN vea_parameters.name%TYPE

Line 225: p_description IN vea_parameter_mappings.description%TYPE,

221: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
225: p_description IN vea_parameter_mappings.description%TYPE,
226: p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,
227: p_program_unit_parameter_name IN vea_parameters.name%TYPE,
228: p_tps_parameter_name IN vea_parameters.name%TYPE
229:

Line 226: p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,

222: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE,
223: p_program_unit_parameter_id IN vea_parameter_mappings.program_unit_parameter_id%TYPE,
224: p_program_unit_param_lp_code IN vea_parameter_mappings.program_unit_param_lp_code%TYPE,
225: p_description IN vea_parameter_mappings.description%TYPE,
226: p_id IN vea_parameter_mappings.parameter_mapping_id%TYPE := NULL,
227: p_program_unit_parameter_name IN vea_parameters.name%TYPE,
228: p_tps_parameter_name IN vea_parameters.name%TYPE
229:
230: )

Line 240: l_parameter_mapping_id vea_parameter_mappings.parameter_mapping_id%TYPE;

236: --
237: --
238: l_location VARCHAR2(32767);
239: l_savepoint_name VARCHAR2(30);
240: l_parameter_mapping_id vea_parameter_mappings.parameter_mapping_id%TYPE;
241: l_program_unit_parameter_id vea_parameter_mappings.program_unit_parameter_id%TYPE;
242: l_tps_parameter_id vea_parameter_mappings.tps_parameter_id%TYPE;
243: l_layer_header_id vea_parameter_mappings.layer_header_id%TYPE;
244: --

Line 241: l_program_unit_parameter_id vea_parameter_mappings.program_unit_parameter_id%TYPE;

237: --
238: l_location VARCHAR2(32767);
239: l_savepoint_name VARCHAR2(30);
240: l_parameter_mapping_id vea_parameter_mappings.parameter_mapping_id%TYPE;
241: l_program_unit_parameter_id vea_parameter_mappings.program_unit_parameter_id%TYPE;
242: l_tps_parameter_id vea_parameter_mappings.tps_parameter_id%TYPE;
243: l_layer_header_id vea_parameter_mappings.layer_header_id%TYPE;
244: --
245: --

Line 242: l_tps_parameter_id vea_parameter_mappings.tps_parameter_id%TYPE;

238: l_location VARCHAR2(32767);
239: l_savepoint_name VARCHAR2(30);
240: l_parameter_mapping_id vea_parameter_mappings.parameter_mapping_id%TYPE;
241: l_program_unit_parameter_id vea_parameter_mappings.program_unit_parameter_id%TYPE;
242: l_tps_parameter_id vea_parameter_mappings.tps_parameter_id%TYPE;
243: l_layer_header_id vea_parameter_mappings.layer_header_id%TYPE;
244: --
245: --
246: CURSOR parameter_mapping_cur

Line 243: l_layer_header_id vea_parameter_mappings.layer_header_id%TYPE;

239: l_savepoint_name VARCHAR2(30);
240: l_parameter_mapping_id vea_parameter_mappings.parameter_mapping_id%TYPE;
241: l_program_unit_parameter_id vea_parameter_mappings.program_unit_parameter_id%TYPE;
242: l_tps_parameter_id vea_parameter_mappings.tps_parameter_id%TYPE;
243: l_layer_header_id vea_parameter_mappings.layer_header_id%TYPE;
244: --
245: --
246: CURSOR parameter_mapping_cur
247: (

Line 248: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,

244: --
245: --
246: CURSOR parameter_mapping_cur
247: (
248: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
249: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
250: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
251: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
252: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE

Line 249: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,

245: --
246: CURSOR parameter_mapping_cur
247: (
248: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
249: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
250: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
251: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
252: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE
253: )

Line 250: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,

246: CURSOR parameter_mapping_cur
247: (
248: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
249: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
250: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
251: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
252: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE
253: )
254: IS

Line 251: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,

247: (
248: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
249: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
250: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
251: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
252: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE
253: )
254: IS
255: SELECT parameter_mapping_id

Line 252: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE

248: p_layer_provider_code IN vea_parameter_mappings.layer_provider_code%TYPE,
249: p_parameter_mapping_id IN vea_parameter_mappings.parameter_mapping_id%TYPE,
250: p_layer_header_id IN vea_parameter_mappings.layer_header_id%TYPE,
251: p_tps_parameter_id IN vea_parameter_mappings.tps_parameter_id%TYPE,
252: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE
253: )
254: IS
255: SELECT parameter_mapping_id
256: FROM vea_parameter_mappings

Line 256: FROM vea_parameter_mappings

252: p_tps_parameter_lp_code IN vea_parameter_mappings.tps_parameter_lp_code%TYPE
253: )
254: IS
255: SELECT parameter_mapping_id
256: FROM vea_parameter_mappings
257: WHERE layer_provider_code = p_layer_provider_code
258: --AND parameter_mapping_id = p_parameter_mapping_id;
259: --AND parameter_mapping_id = NVL(p_parameter_mapping_id,parameter_mapping_id)
260: AND layer_header_id = p_layer_header_id

Line 369: SELECT NVL( p_id, vea_parameter_mappings_s.NEXTVAL )

365: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' l_tps_parameter_id is ' || l_tps_parameter_id);
366: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_layer_provider_code is ' || p_layer_provider_code);
367: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
368: THEN
369: SELECT NVL( p_id, vea_parameter_mappings_s.NEXTVAL )
370: INTO l_parameter_mapping_id
371: FROM DUAL;
372: ELSE
373: SELECT vea_parameter_mappings_s.NEXTVAL

Line 373: SELECT vea_parameter_mappings_s.NEXTVAL

369: SELECT NVL( p_id, vea_parameter_mappings_s.NEXTVAL )
370: INTO l_parameter_mapping_id
371: FROM DUAL;
372: ELSE
373: SELECT vea_parameter_mappings_s.NEXTVAL
374: INTO l_parameter_mapping_id
375: FROM DUAL;
376: END IF;
377: --

Line 485: END VEA_PARAMETER_MAPPINGS_SV;

481: --}
482: --}
483: END process;
484: --}
485: END VEA_PARAMETER_MAPPINGS_SV;