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_LAYER_HEADERS_SV dependencies on VEA_LAYER_HEADERS

Line 1: PACKAGE BODY VEA_LAYER_HEADERS_SV as

1: PACKAGE BODY VEA_LAYER_HEADERS_SV as
2: /* $Header: VEAVALHB.pls 115.13 2004/07/27 00:52:27 rvishnuv ship $ */
3: --{
4: /*====================== vea_layer_headers_sv =========================*/
5: /*========================================================================

Line 4: /====================== vea_layer_headers_sv =========================/

1: PACKAGE BODY VEA_LAYER_HEADERS_SV as
2: /* $Header: VEAVALHB.pls 115.13 2004/07/27 00:52:27 rvishnuv ship $ */
3: --{
4: /*====================== vea_layer_headers_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_LAYER_HEADERS
7:
8: NOTES: To run the script:

Line 6: PURPOSE: Table handler package for table VEA_LAYER_HEADERS

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

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

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

Line 24: PURPOSE: Inserts a record into VEA_LAYER_HEADERS table

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

Line 30: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
31: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

Line 31: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,

27: PROCEDURE
28: insert_row
29: (
30: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
31: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

Line 32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,

28: insert_row
29: (
30: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
31: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
36: p_condition_type IN vea_layer_headers.condition_type%TYPE,

Line 33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,

29: (
30: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
31: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
36: p_condition_type IN vea_layer_headers.condition_type%TYPE,
37: p_description IN vea_layer_headers.description%TYPE

Line 34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

30: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
31: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
36: p_condition_type IN vea_layer_headers.condition_type%TYPE,
37: p_description IN vea_layer_headers.description%TYPE
38: )

Line 35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

31: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
36: p_condition_type IN vea_layer_headers.condition_type%TYPE,
37: p_description IN vea_layer_headers.description%TYPE
38: )
39: IS

Line 36: p_condition_type IN vea_layer_headers.condition_type%TYPE,

32: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
36: p_condition_type IN vea_layer_headers.condition_type%TYPE,
37: p_description IN vea_layer_headers.description%TYPE
38: )
39: IS
40: --{

Line 37: p_description IN vea_layer_headers.description%TYPE

33: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
34: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
35: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
36: p_condition_type IN vea_layer_headers.condition_type%TYPE,
37: p_description IN vea_layer_headers.description%TYPE
38: )
39: IS
40: --{
41: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 52: INSERT INTO vea_layer_headers

48: BEGIN
49: --{
50: l_location := '0010';
51: --
52: INSERT INTO vea_layer_headers
53: (
54: layer_provider_code, layer_header_id,
55: program_unit_id, program_unit_lp_code,
56: tps_program_unit_id, tps_program_unit_lp_code,

Line 95: PURPOSE: Updates a record into VEA_LAYER_HEADERS table

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

Line 101: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

97: ========================================================================*/
98: PROCEDURE
99: update_row
100: (
101: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
102: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

Line 102: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,

98: PROCEDURE
99: update_row
100: (
101: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
102: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

Line 103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,

99: update_row
100: (
101: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
102: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
107: p_condition_type IN vea_layer_headers.condition_type%TYPE,

Line 104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,

100: (
101: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
102: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
107: p_condition_type IN vea_layer_headers.condition_type%TYPE,
108: p_description IN vea_layer_headers.description%TYPE,

Line 105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

101: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
102: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
107: p_condition_type IN vea_layer_headers.condition_type%TYPE,
108: p_description IN vea_layer_headers.description%TYPE,
109: p_old_layer_header_id IN vea_layer_headers.layer_header_id%TYPE

Line 106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

102: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
107: p_condition_type IN vea_layer_headers.condition_type%TYPE,
108: p_description IN vea_layer_headers.description%TYPE,
109: p_old_layer_header_id IN vea_layer_headers.layer_header_id%TYPE
110: )

Line 107: p_condition_type IN vea_layer_headers.condition_type%TYPE,

103: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
107: p_condition_type IN vea_layer_headers.condition_type%TYPE,
108: p_description IN vea_layer_headers.description%TYPE,
109: p_old_layer_header_id IN vea_layer_headers.layer_header_id%TYPE
110: )
111: IS

Line 108: p_description IN vea_layer_headers.description%TYPE,

104: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
107: p_condition_type IN vea_layer_headers.condition_type%TYPE,
108: p_description IN vea_layer_headers.description%TYPE,
109: p_old_layer_header_id IN vea_layer_headers.layer_header_id%TYPE
110: )
111: IS
112: --{

Line 109: p_old_layer_header_id IN vea_layer_headers.layer_header_id%TYPE

105: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
106: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
107: p_condition_type IN vea_layer_headers.condition_type%TYPE,
108: p_description IN vea_layer_headers.description%TYPE,
109: p_old_layer_header_id IN vea_layer_headers.layer_header_id%TYPE
110: )
111: IS
112: --{
113: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 177: UPDATE vea_layer_headers

173: --
174: --
175: l_location := '0030';
176: --
177: UPDATE vea_layer_headers
178: SET
179: tps_program_unit_id = p_tps_program_unit_id,
180: tps_program_unit_lp_code = p_tps_program_unit_lp_code,
181: program_unit_id = p_program_unit_id,

Line 227: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

223: ========================================================================*/
224: PROCEDURE
225: delete_rows
226: (
227: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
228: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
229: p_application_short_name IN vea_packages.application_short_name%TYPE,
230: x_layer_header_count OUT NOCOPY NUMBER
231: )

Line 244: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

240: --
241: --
242: CURSOR layer_header_cur
243: (
244: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
245: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
246: )
247: IS
248: SELECT distinct layer_header_id

Line 256: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

252: --
253: --
254: CURSOR application_cur
255: (
256: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
257: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
258: p_application_short_name IN vea_packages.application_short_name%TYPE
259: )
260: IS

Line 257: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,

253: --
254: CURSOR application_cur
255: (
256: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
257: p_layer_header_id IN vea_layer_headers.layer_header_id%TYPE,
258: p_application_short_name IN vea_packages.application_short_name%TYPE
259: )
260: IS
261: SELECT 'x'

Line 262: FROM vea_layer_headers LH,

258: p_application_short_name IN vea_packages.application_short_name%TYPE
259: )
260: IS
261: SELECT 'x'
262: FROM vea_layer_headers LH,
263: vea_program_units PU,
264: vea_packages PK
265: WHERE LH.layer_provider_code = p_layer_provider_code
266: AND LH.layer_header_id = p_layer_header_id

Line 358: DELETE vea_layer_headers

354: --
355: --
356: l_location := '0110';
357: --
358: DELETE vea_layer_headers
359: WHERE layer_provider_code = p_layer_provider_code
360: AND layer_header_id = layer_header_rec.layer_header_id;
361: --}
362: END IF;

Line 393: PURPOSE: Table hadndler API for VEA_LAYER_HEADERS table.

389: /*========================================================================
390:
391: PROCEDURE NAME: process
392:
393: PURPOSE: Table hadndler API for VEA_LAYER_HEADERS table.
394:
395: It inserts/updates a record in VEA_LAYER_HEADERS table.
396:
397: ========================================================================*/

Line 395: It inserts/updates a record in VEA_LAYER_HEADERS table.

391: PROCEDURE NAME: process
392:
393: PURPOSE: Table hadndler API for VEA_LAYER_HEADERS table.
394:
395: It inserts/updates a record in VEA_LAYER_HEADERS table.
396:
397: ========================================================================*/
398: PROCEDURE
399: process

Line 408: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,

404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
409: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

Line 409: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

405: x_return_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
409: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

Line 410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,

406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
409: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,

Line 411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,

407: x_msg_data OUT NOCOPY VARCHAR2,
408: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
409: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,

Line 412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,

408: x_id OUT NOCOPY vea_layer_headers.layer_header_id%TYPE,
409: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,

Line 413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,

409: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
417: p_package_name IN vea_packages.name%TYPE,

Line 414: p_condition_type IN vea_layer_headers.condition_type%TYPE,

410: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
417: p_package_name IN vea_packages.name%TYPE,
418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,

Line 415: p_description IN vea_layer_headers.description%TYPE,

411: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
417: p_package_name IN vea_packages.name%TYPE,
418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,
419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,

Line 416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,

412: p_tps_program_unit_id IN vea_layer_headers.tps_program_unit_id%TYPE,
413: p_tps_program_unit_lp_code IN vea_layer_headers.tps_program_unit_lp_code%TYPE,
414: p_condition_type IN vea_layer_headers.condition_type%TYPE,
415: p_description IN vea_layer_headers.description%TYPE,
416: p_id IN vea_layer_headers.layer_header_id%TYPE := NULL,
417: p_package_name IN vea_packages.name%TYPE,
418: p_pkg_app_name IN vea_packages.application_short_name%TYPE,
419: p_pkg_cs_flag IN vea_packages.client_server_flag%TYPE,
420: p_program_unit_name IN vea_program_units.name%TYPE,

Line 435: l_layer_header_id vea_layer_headers.layer_header_id%TYPE;

431: --
432: --
433: l_location VARCHAR2(32767);
434: l_savepoint_name VARCHAR2(30);
435: l_layer_header_id vea_layer_headers.layer_header_id%TYPE;
436: l_program_unit_id vea_program_units.program_unit_id%TYPE;
437: l_tpa_program_unit_id vea_program_units.program_unit_id%TYPE;
438: l_tps_program_unit_id vea_program_units.program_unit_id%TYPE;
439: l_package_id vea_program_units.package_id%TYPE;

Line 452: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,

448: and layer_provideR_code = p_lpc;
449:
450: CURSOR layer_header_cur
451: (
452: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
453: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
454: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
455: p_condition_type IN vea_layer_headers.condition_type%TYPE
456: )

Line 453: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,

449:
450: CURSOR layer_header_cur
451: (
452: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
453: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
454: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
455: p_condition_type IN vea_layer_headers.condition_type%TYPE
456: )
457: IS

Line 454: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,

450: CURSOR layer_header_cur
451: (
452: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
453: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
454: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
455: p_condition_type IN vea_layer_headers.condition_type%TYPE
456: )
457: IS
458: SELECT layer_header_id

Line 455: p_condition_type IN vea_layer_headers.condition_type%TYPE

451: (
452: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
453: p_program_unit_id IN vea_layer_headers.program_unit_id%TYPE,
454: p_program_unit_lp_code IN vea_layer_headers.program_unit_lp_code%TYPE,
455: p_condition_type IN vea_layer_headers.condition_type%TYPE
456: )
457: IS
458: SELECT layer_header_id
459: FROM vea_layer_headers

Line 459: FROM vea_layer_headers

455: p_condition_type IN vea_layer_headers.condition_type%TYPE
456: )
457: IS
458: SELECT layer_header_id
459: FROM vea_layer_headers
460: WHERE layer_provider_code = p_layer_provider_code
461: AND program_unit_id = p_program_unit_id
462: AND program_unit_lp_code = p_program_unit_lp_code
463: AND NVL(condition_type,'!') = NVL(p_condition_type,'!');

Line 617: SELECT NVL( p_id, vea_layer_headers_s.NEXTVAL )

613: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_tpsPkg_cs_flag is ' || p_tpsPkg_cs_flag);
614: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_tpsPkg_app_name is ' || p_tpsPkg_app_name);
615: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
616: THEN
617: SELECT NVL( p_id, vea_layer_headers_s.NEXTVAL )
618: INTO l_layer_header_id
619: FROM DUAL;
620: ELSE
621: SELECT vea_layer_headers_s.NEXTVAL

Line 621: SELECT vea_layer_headers_s.NEXTVAL

617: SELECT NVL( p_id, vea_layer_headers_s.NEXTVAL )
618: INTO l_layer_header_id
619: FROM DUAL;
620: ELSE
621: SELECT vea_layer_headers_s.NEXTVAL
622: INTO l_layer_header_id
623: FROM DUAL;
624: END IF;
625: --

Line 741: END VEA_LAYER_HEADERS_SV;

737: --}
738: --}
739: END process;
740: --}
741: END VEA_LAYER_HEADERS_SV;