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_PACKAGES_SV dependencies on VEA_PACKAGES

Line 1: PACKAGE BODY VEA_PACKAGES_SV as

1: PACKAGE BODY VEA_PACKAGES_SV as
2: /* $Header: VEAVAPKB.pls 115.16 2004/07/27 00:09:19 rvishnuv ship $ */
3: --{
4: /*======================== vea_packages_sv =============================*/
5: /*========================================================================

Line 4: /======================== vea_packages_sv =============================/

1: PACKAGE BODY VEA_PACKAGES_SV as
2: /* $Header: VEAVAPKB.pls 115.16 2004/07/27 00:09:19 rvishnuv ship $ */
3: --{
4: /*======================== vea_packages_sv =============================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PACKAGES
7:
8: NOTES: To run the script:

Line 6: PURPOSE: Table handler package for table VEA_PACKAGES

2: /* $Header: VEAVAPKB.pls 115.16 2004/07/27 00:09:19 rvishnuv ship $ */
3: --{
4: /*======================== vea_packages_sv =============================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PACKAGES
7:
8: NOTES: To run the script:
9:
10: sql> start VEAVAPKB.pls

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

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

Line 30: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

26: ========================================================================*/
27: PROCEDURE
28: validateNamingConventions
29: (
30: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
31: p_name IN vea_packages.name%TYPE,
32: p_specification_filename IN vea_packages.specification_filename%TYPE,
33: p_body_filename IN vea_packages.body_filename%TYPE,
34: p_application_short_name IN vea_packages.application_short_name%TYPE

Line 31: p_name IN vea_packages.name%TYPE,

27: PROCEDURE
28: validateNamingConventions
29: (
30: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
31: p_name IN vea_packages.name%TYPE,
32: p_specification_filename IN vea_packages.specification_filename%TYPE,
33: p_body_filename IN vea_packages.body_filename%TYPE,
34: p_application_short_name IN vea_packages.application_short_name%TYPE
35: )

Line 32: p_specification_filename IN vea_packages.specification_filename%TYPE,

28: validateNamingConventions
29: (
30: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
31: p_name IN vea_packages.name%TYPE,
32: p_specification_filename IN vea_packages.specification_filename%TYPE,
33: p_body_filename IN vea_packages.body_filename%TYPE,
34: p_application_short_name IN vea_packages.application_short_name%TYPE
35: )
36: IS

Line 33: p_body_filename IN vea_packages.body_filename%TYPE,

29: (
30: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
31: p_name IN vea_packages.name%TYPE,
32: p_specification_filename IN vea_packages.specification_filename%TYPE,
33: p_body_filename IN vea_packages.body_filename%TYPE,
34: p_application_short_name IN vea_packages.application_short_name%TYPE
35: )
36: IS
37: --{

Line 34: p_application_short_name IN vea_packages.application_short_name%TYPE

30: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
31: p_name IN vea_packages.name%TYPE,
32: p_specification_filename IN vea_packages.specification_filename%TYPE,
33: p_body_filename IN vea_packages.body_filename%TYPE,
34: p_application_short_name IN vea_packages.application_short_name%TYPE
35: )
36: IS
37: --{
38: l_api_name CONSTANT VARCHAR2(30) := 'validateNamingConventions';

Line 46: l_curr_layer_provider_code vea_packages.layer_provider_code%TYPE;

42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
44: --
45: --
46: l_curr_layer_provider_code vea_packages.layer_provider_code%TYPE;
47: l_prefix VARCHAR2(32767);
48: l_package_name_prefix VARCHAR2(32767);
49: l_file_name_prefix VARCHAR2(32767);
50:

Line 189: PURPOSE: Validates a record of VEA_PACKAGES table

185: /*========================================================================
186:
187: PROCEDURE NAME: validateUniqueServerFileNames
188:
189: PURPOSE: Validates a record of VEA_PACKAGES table
190:
191: ========================================================================*/
192: PROCEDURE
193: validateUniqueServerFileNames

Line 195: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

191: ========================================================================*/
192: PROCEDURE
193: validateUniqueServerFileNames
194: (
195: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
196: p_package_id IN vea_packages.package_id%TYPE,
197: p_name IN vea_packages.name%TYPE,
198: p_specification_filename IN vea_packages.specification_filename%TYPE,
199: p_body_filename IN vea_packages.body_filename%TYPE

Line 196: p_package_id IN vea_packages.package_id%TYPE,

192: PROCEDURE
193: validateUniqueServerFileNames
194: (
195: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
196: p_package_id IN vea_packages.package_id%TYPE,
197: p_name IN vea_packages.name%TYPE,
198: p_specification_filename IN vea_packages.specification_filename%TYPE,
199: p_body_filename IN vea_packages.body_filename%TYPE
200: )

Line 197: p_name IN vea_packages.name%TYPE,

193: validateUniqueServerFileNames
194: (
195: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
196: p_package_id IN vea_packages.package_id%TYPE,
197: p_name IN vea_packages.name%TYPE,
198: p_specification_filename IN vea_packages.specification_filename%TYPE,
199: p_body_filename IN vea_packages.body_filename%TYPE
200: )
201: IS

Line 198: p_specification_filename IN vea_packages.specification_filename%TYPE,

194: (
195: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
196: p_package_id IN vea_packages.package_id%TYPE,
197: p_name IN vea_packages.name%TYPE,
198: p_specification_filename IN vea_packages.specification_filename%TYPE,
199: p_body_filename IN vea_packages.body_filename%TYPE
200: )
201: IS
202: --{

Line 199: p_body_filename IN vea_packages.body_filename%TYPE

195: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
196: p_package_id IN vea_packages.package_id%TYPE,
197: p_name IN vea_packages.name%TYPE,
198: p_specification_filename IN vea_packages.specification_filename%TYPE,
199: p_body_filename IN vea_packages.body_filename%TYPE
200: )
201: IS
202: --{
203: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueServerFileNames';

Line 213: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

209: --
210: --
211: CURSOR pkg_spec_file_cur
212: (
213: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
214: p_specification_filename IN vea_packages.specification_filename%TYPE
215: )
216: IS
217: SELECT package_id, name

Line 214: p_specification_filename IN vea_packages.specification_filename%TYPE

210: --
211: CURSOR pkg_spec_file_cur
212: (
213: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
214: p_specification_filename IN vea_packages.specification_filename%TYPE
215: )
216: IS
217: SELECT package_id, name
218: FROM vea_packages

Line 218: FROM vea_packages

214: p_specification_filename IN vea_packages.specification_filename%TYPE
215: )
216: IS
217: SELECT package_id, name
218: FROM vea_packages
219: WHERE specification_filename = p_specification_filename
220: AND layer_provider_code = p_layer_provider_code;
221: --
222: --

Line 225: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

221: --
222: --
223: CURSOR pkg_body_file_cur
224: (
225: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
226: p_body_filename IN vea_packages.body_filename%TYPE
227: )
228: IS
229: SELECT package_id, name

Line 226: p_body_filename IN vea_packages.body_filename%TYPE

222: --
223: CURSOR pkg_body_file_cur
224: (
225: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
226: p_body_filename IN vea_packages.body_filename%TYPE
227: )
228: IS
229: SELECT package_id, name
230: FROM vea_packages

Line 230: FROM vea_packages

226: p_body_filename IN vea_packages.body_filename%TYPE
227: )
228: IS
229: SELECT package_id, name
230: FROM vea_packages
231: WHERE body_filename = p_body_filename
232: AND layer_provider_code = p_layer_provider_code;
233: --}
234: BEGIN

Line 332: PURPOSE: Validates a record of VEA_PACKAGES table

328: /*========================================================================
329:
330: PROCEDURE NAME: validateUniqueClientFileNames
331:
332: PURPOSE: Validates a record of VEA_PACKAGES table
333:
334: ========================================================================*/
335: PROCEDURE
336: validateUniqueClientFileNames

Line 338: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

334: ========================================================================*/
335: PROCEDURE
336: validateUniqueClientFileNames
337: (
338: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
339: p_package_id IN vea_packages.package_id%TYPE,
340: p_name IN vea_packages.name%TYPE,
341: p_specification_filename IN vea_packages.specification_filename%TYPE,
342: p_application_short_name IN vea_packages.application_short_name%TYPE

Line 339: p_package_id IN vea_packages.package_id%TYPE,

335: PROCEDURE
336: validateUniqueClientFileNames
337: (
338: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
339: p_package_id IN vea_packages.package_id%TYPE,
340: p_name IN vea_packages.name%TYPE,
341: p_specification_filename IN vea_packages.specification_filename%TYPE,
342: p_application_short_name IN vea_packages.application_short_name%TYPE
343: )

Line 340: p_name IN vea_packages.name%TYPE,

336: validateUniqueClientFileNames
337: (
338: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
339: p_package_id IN vea_packages.package_id%TYPE,
340: p_name IN vea_packages.name%TYPE,
341: p_specification_filename IN vea_packages.specification_filename%TYPE,
342: p_application_short_name IN vea_packages.application_short_name%TYPE
343: )
344: IS

Line 341: p_specification_filename IN vea_packages.specification_filename%TYPE,

337: (
338: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
339: p_package_id IN vea_packages.package_id%TYPE,
340: p_name IN vea_packages.name%TYPE,
341: p_specification_filename IN vea_packages.specification_filename%TYPE,
342: p_application_short_name IN vea_packages.application_short_name%TYPE
343: )
344: IS
345: --{

Line 342: p_application_short_name IN vea_packages.application_short_name%TYPE

338: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
339: p_package_id IN vea_packages.package_id%TYPE,
340: p_name IN vea_packages.name%TYPE,
341: p_specification_filename IN vea_packages.specification_filename%TYPE,
342: p_application_short_name IN vea_packages.application_short_name%TYPE
343: )
344: IS
345: --{
346: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueClientFileNames';

Line 356: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

352: --
353: --
354: CURSOR pkg_spec_file_cur
355: (
356: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
357: p_specification_filename IN vea_packages.specification_filename%TYPE
358: )
359: IS
360: SELECT package_id, application_short_name

Line 357: p_specification_filename IN vea_packages.specification_filename%TYPE

353: --
354: CURSOR pkg_spec_file_cur
355: (
356: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
357: p_specification_filename IN vea_packages.specification_filename%TYPE
358: )
359: IS
360: SELECT package_id, application_short_name
361: FROM vea_packages

Line 361: FROM vea_packages

357: p_specification_filename IN vea_packages.specification_filename%TYPE
358: )
359: IS
360: SELECT package_id, application_short_name
361: FROM vea_packages
362: WHERE specification_filename = p_specification_filename
363: AND layer_provider_code = p_layer_provider_code;
364: --}
365: BEGIN

Line 424: PURPOSE: Validates a record of VEA_PACKAGES table

420: /*========================================================================
421:
422: PROCEDURE NAME: validate
423:
424: PURPOSE: Validates a record of VEA_PACKAGES table
425:
426: ========================================================================*/
427: PROCEDURE
428: validate

Line 430: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

426: ========================================================================*/
427: PROCEDURE
428: validate
429: (
430: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
431: p_package_id IN vea_packages.package_id%TYPE,
432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

Line 431: p_package_id IN vea_packages.package_id%TYPE,

427: PROCEDURE
428: validate
429: (
430: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
431: p_package_id IN vea_packages.package_id%TYPE,
432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,

Line 432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

428: validate
429: (
430: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
431: p_package_id IN vea_packages.package_id%TYPE,
432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,

Line 433: p_generate_flag IN vea_packages.generate_flag%TYPE,

429: (
430: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
431: p_package_id IN vea_packages.package_id%TYPE,
432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,

Line 434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

430: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
431: p_package_id IN vea_packages.package_id%TYPE,
432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,

Line 435: p_name IN vea_packages.name%TYPE,

431: p_package_id IN vea_packages.package_id%TYPE,
432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,

Line 436: p_specification_filename IN vea_packages.specification_filename%TYPE,

432: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,
440: p_description IN vea_packages.description%TYPE,

Line 437: p_body_filename IN vea_packages.body_filename%TYPE,

433: p_generate_flag IN vea_packages.generate_flag%TYPE,
434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,
440: p_description IN vea_packages.description%TYPE,
441: p_application_short_name IN vea_packages.application_short_name%TYPE,

Line 438: p_label IN vea_packages.label%TYPE,

434: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,
440: p_description IN vea_packages.description%TYPE,
441: p_application_short_name IN vea_packages.application_short_name%TYPE,
442: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE

Line 439: p_version_number IN vea_packages.version_number%TYPE,

435: p_name IN vea_packages.name%TYPE,
436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,
440: p_description IN vea_packages.description%TYPE,
441: p_application_short_name IN vea_packages.application_short_name%TYPE,
442: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
443: )

Line 440: p_description IN vea_packages.description%TYPE,

436: p_specification_filename IN vea_packages.specification_filename%TYPE,
437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,
440: p_description IN vea_packages.description%TYPE,
441: p_application_short_name IN vea_packages.application_short_name%TYPE,
442: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
443: )
444: IS

Line 441: p_application_short_name IN vea_packages.application_short_name%TYPE,

437: p_body_filename IN vea_packages.body_filename%TYPE,
438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,
440: p_description IN vea_packages.description%TYPE,
441: p_application_short_name IN vea_packages.application_short_name%TYPE,
442: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
443: )
444: IS
445: --{

Line 442: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE

438: p_label IN vea_packages.label%TYPE,
439: p_version_number IN vea_packages.version_number%TYPE,
440: p_description IN vea_packages.description%TYPE,
441: p_application_short_name IN vea_packages.application_short_name%TYPE,
442: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
443: )
444: IS
445: --{
446: l_api_name CONSTANT VARCHAR2(30) := 'validate';

Line 531: PURPOSE: Inserts a record into VEA_PACKAGES table

527: /*========================================================================
528:
529: PROCEDURE NAME: insert_row
530:
531: PURPOSE: Inserts a record into VEA_PACKAGES table
532:
533: ========================================================================*/
534: PROCEDURE
535: insert_row

Line 537: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

533: ========================================================================*/
534: PROCEDURE
535: insert_row
536: (
537: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
538: p_package_id IN vea_packages.package_id%TYPE,
539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

Line 538: p_package_id IN vea_packages.package_id%TYPE,

534: PROCEDURE
535: insert_row
536: (
537: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
538: p_package_id IN vea_packages.package_id%TYPE,
539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,

Line 539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

535: insert_row
536: (
537: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
538: p_package_id IN vea_packages.package_id%TYPE,
539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,

Line 540: p_generate_flag IN vea_packages.generate_flag%TYPE,

536: (
537: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
538: p_package_id IN vea_packages.package_id%TYPE,
539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,

Line 541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

537: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
538: p_package_id IN vea_packages.package_id%TYPE,
539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,

Line 542: p_name IN vea_packages.name%TYPE,

538: p_package_id IN vea_packages.package_id%TYPE,
539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,

Line 543: p_specification_filename IN vea_packages.specification_filename%TYPE,

539: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,
547: p_description IN vea_packages.description%TYPE,

Line 544: p_body_filename IN vea_packages.body_filename%TYPE,

540: p_generate_flag IN vea_packages.generate_flag%TYPE,
541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,
547: p_description IN vea_packages.description%TYPE,
548: p_application_short_name IN vea_packages.application_short_name%TYPE,

Line 545: p_label IN vea_packages.label%TYPE,

541: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,
547: p_description IN vea_packages.description%TYPE,
548: p_application_short_name IN vea_packages.application_short_name%TYPE,
549: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE

Line 546: p_version_number IN vea_packages.version_number%TYPE,

542: p_name IN vea_packages.name%TYPE,
543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,
547: p_description IN vea_packages.description%TYPE,
548: p_application_short_name IN vea_packages.application_short_name%TYPE,
549: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
550: )

Line 547: p_description IN vea_packages.description%TYPE,

543: p_specification_filename IN vea_packages.specification_filename%TYPE,
544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,
547: p_description IN vea_packages.description%TYPE,
548: p_application_short_name IN vea_packages.application_short_name%TYPE,
549: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
550: )
551: IS

Line 548: p_application_short_name IN vea_packages.application_short_name%TYPE,

544: p_body_filename IN vea_packages.body_filename%TYPE,
545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,
547: p_description IN vea_packages.description%TYPE,
548: p_application_short_name IN vea_packages.application_short_name%TYPE,
549: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
550: )
551: IS
552: --{

Line 549: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE

545: p_label IN vea_packages.label%TYPE,
546: p_version_number IN vea_packages.version_number%TYPE,
547: p_description IN vea_packages.description%TYPE,
548: p_application_short_name IN vea_packages.application_short_name%TYPE,
549: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
550: )
551: IS
552: --{
553: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 564: INSERT INTO vea_packages

560: BEGIN
561: --{
562: l_location := '0010';
563: --
564: INSERT INTO vea_packages
565: (
566: layer_provider_code, package_id,
567: client_server_flag,
568: name, label,

Line 613: PURPOSE: Updates a record into VEA_PACKAGES table

609: /*========================================================================
610:
611: PROCEDURE NAME: update_row
612:
613: PURPOSE: Updates a record into VEA_PACKAGES table
614:
615: ========================================================================*/
616: PROCEDURE
617: update_row

Line 619: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

615: ========================================================================*/
616: PROCEDURE
617: update_row
618: (
619: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
620: p_package_id IN vea_packages.package_id%TYPE,
621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

Line 620: p_package_id IN vea_packages.package_id%TYPE,

616: PROCEDURE
617: update_row
618: (
619: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
620: p_package_id IN vea_packages.package_id%TYPE,
621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,

Line 621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

617: update_row
618: (
619: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
620: p_package_id IN vea_packages.package_id%TYPE,
621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,

Line 622: p_generate_flag IN vea_packages.generate_flag%TYPE,

618: (
619: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
620: p_package_id IN vea_packages.package_id%TYPE,
621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,

Line 623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

619: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
620: p_package_id IN vea_packages.package_id%TYPE,
621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,

Line 624: p_name IN vea_packages.name%TYPE,

620: p_package_id IN vea_packages.package_id%TYPE,
621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,

Line 625: p_specification_filename IN vea_packages.specification_filename%TYPE,

621: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,
629: p_description IN vea_packages.description%TYPE,

Line 626: p_body_filename IN vea_packages.body_filename%TYPE,

622: p_generate_flag IN vea_packages.generate_flag%TYPE,
623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,
629: p_description IN vea_packages.description%TYPE,
630: p_application_short_name IN vea_packages.application_short_name%TYPE,

Line 627: p_label IN vea_packages.label%TYPE,

623: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,
629: p_description IN vea_packages.description%TYPE,
630: p_application_short_name IN vea_packages.application_short_name%TYPE,
631: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE

Line 628: p_version_number IN vea_packages.version_number%TYPE,

624: p_name IN vea_packages.name%TYPE,
625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,
629: p_description IN vea_packages.description%TYPE,
630: p_application_short_name IN vea_packages.application_short_name%TYPE,
631: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
632: )

Line 629: p_description IN vea_packages.description%TYPE,

625: p_specification_filename IN vea_packages.specification_filename%TYPE,
626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,
629: p_description IN vea_packages.description%TYPE,
630: p_application_short_name IN vea_packages.application_short_name%TYPE,
631: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
632: )
633: IS

Line 630: p_application_short_name IN vea_packages.application_short_name%TYPE,

626: p_body_filename IN vea_packages.body_filename%TYPE,
627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,
629: p_description IN vea_packages.description%TYPE,
630: p_application_short_name IN vea_packages.application_short_name%TYPE,
631: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
632: )
633: IS
634: --{

Line 631: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE

627: p_label IN vea_packages.label%TYPE,
628: p_version_number IN vea_packages.version_number%TYPE,
629: p_description IN vea_packages.description%TYPE,
630: p_application_short_name IN vea_packages.application_short_name%TYPE,
631: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE
632: )
633: IS
634: --{
635: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 646: UPDATE vea_packages

642: BEGIN
643: --{
644: l_location := '0010';
645: --
646: UPDATE vea_packages
647: SET client_server_flag = p_client_server_flag,
648: name = p_name,
649: label = p_label,
650: generate_flag = p_generate_flag,

Line 706: delete vea_packages PK

702: --
703: IF vea_tpa_util_pvt.get_curr_layer_provider_code = vea_tpa_util_pvt.G_ORACLE
704: THEN
705: --{
706: delete vea_packages PK
707: where tpa_flag = 'Y'
708: and not exists ( select 1
709: from vea_program_units PU
710: where PU.layer_provider_code = PK.layer_provider_code

Line 760: p_application_short_name IN vea_packages.application_short_name%TYPE,

756: delete_rows
757: (
758: p_layer_provider_code IN vea_layer_headers.layer_provider_code%TYPE,
759: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
760: p_application_short_name IN vea_packages.application_short_name%TYPE,
761: x_package_count OUT NOCOPY NUMBER
762: )
763: IS
764: --{

Line 780: FROM vea_packages

776: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE
777: )
778: IS
779: SELECT package_id
780: FROM vea_packages
781: WHERE layer_provider_code = p_layer_provider_code
782: AND tp_layer_id = p_tp_layer_id;
783: --
784: --

Line 827: DELETE vea_packages

823: THEN
824: --{
825: l_location := '0050';
826: --
827: DELETE vea_packages
828: WHERE layer_provider_code = p_layer_provider_code
829: AND package_id = package_rec.package_id;
830: --}
831: ELSE

Line 840: UPDATE vea_packages

836: THEN
837: --{
838: l_location := '0070';
839: --
840: UPDATE vea_packages
841: SET tp_layer_id = null
842: WHERE layer_provider_code = p_layer_provider_code
843: AND package_id = package_rec.package_id;
844: --}

Line 887: p_version_number IN vea_packages.version_number%TYPE

883: ========================================================================*/
884: FUNCTION
885: getVersionNumber
886: (
887: p_version_number IN vea_packages.version_number%TYPE
888: )
889: RETURN VARCHAR2
890: IS
891: --{

Line 953: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

949: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
950: x_return_status OUT NOCOPY VARCHAR2,
951: x_msg_count OUT NOCOPY NUMBER,
952: x_msg_data OUT NOCOPY VARCHAR2,
953: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
954: p_package_id IN vea_packages.package_id%TYPE,
955: x_version_number OUT NOCOPY VARCHAR2,
956: p_user_name IN VARCHAR2
957: )

Line 954: p_package_id IN vea_packages.package_id%TYPE,

950: x_return_status OUT NOCOPY VARCHAR2,
951: x_msg_count OUT NOCOPY NUMBER,
952: x_msg_data OUT NOCOPY VARCHAR2,
953: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
954: p_package_id IN vea_packages.package_id%TYPE,
955: x_version_number OUT NOCOPY VARCHAR2,
956: p_user_name IN VARCHAR2
957: )
958: IS

Line 972: FROM vea_packages

968: --
969: CURSOR pkg_cur
970: IS
971: SELECT version_number, name
972: FROM vea_packages
973: WHERE layer_provider_code = p_layer_provider_code
974: AND package_id = p_package_id;
975: --
976: --

Line 977: l_version_number vea_packages.version_number%TYPE;

973: WHERE layer_provider_code = p_layer_provider_code
974: AND package_id = p_package_id;
975: --
976: --
977: l_version_number vea_packages.version_number%TYPE;
978: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
979: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
980:
981: l_version_text VARCHAR2(200);

Line 1039: UPDATE vea_packages

1035: --
1036: --
1037: l_location := '0040';
1038: --
1039: UPDATE vea_packages
1040: SET version_number = l_version_number,
1041: last_updated_by = l_user_id,
1042: last_update_date = SYSDATE,
1043: last_update_login = l_login_id

Line 1141: p_application_short_name IN vea_packages.application_short_name%TYPE,

1137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_application_short_name IN vea_packages.application_short_name%TYPE,
1142: p_specification_filename IN vea_packages.specification_filename%TYPE,
1143: x_version_number OUT NOCOPY VARCHAR2,
1144: p_user_name IN VARCHAR2
1145: )

Line 1142: p_specification_filename IN vea_packages.specification_filename%TYPE,

1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_application_short_name IN vea_packages.application_short_name%TYPE,
1142: p_specification_filename IN vea_packages.specification_filename%TYPE,
1143: x_version_number OUT NOCOPY VARCHAR2,
1144: p_user_name IN VARCHAR2
1145: )
1146: IS

Line 1163: FROM vea_packages

1159: SELECT package_id,
1160: layer_provider_code,
1161: version_number,
1162: name
1163: FROM vea_packages
1164: WHERE specification_filename = p_specification_filename;
1165:
1166: --
1167: --

Line 1168: l_version_number vea_packages.version_number%TYPE;

1164: WHERE specification_filename = p_specification_filename;
1165:
1166: --
1167: --
1168: l_version_number vea_packages.version_number%TYPE;
1169: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
1170: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
1171: --
1172: --

Line 1228: UPDATE vea_packages

1224: --
1225: --
1226: l_location := '0040';
1227: --
1228: UPDATE vea_packages
1229: SET version_number = l_version_number,
1230: last_updated_by = l_user_id,
1231: last_update_date = SYSDATE,
1232: last_update_login = l_login_id

Line 1322: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

1318: ========================================================================*/
1319: FUNCTION
1320: getId
1321: (
1322: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1323: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1324: p_name IN vea_packages.name%TYPE,
1325: p_application_short_name IN vea_packages.application_short_name%TYPE
1326: )

Line 1323: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

1319: FUNCTION
1320: getId
1321: (
1322: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1323: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1324: p_name IN vea_packages.name%TYPE,
1325: p_application_short_name IN vea_packages.application_short_name%TYPE
1326: )
1327: RETURN NUMBER

Line 1324: p_name IN vea_packages.name%TYPE,

1320: getId
1321: (
1322: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1323: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1324: p_name IN vea_packages.name%TYPE,
1325: p_application_short_name IN vea_packages.application_short_name%TYPE
1326: )
1327: RETURN NUMBER
1328: IS

Line 1325: p_application_short_name IN vea_packages.application_short_name%TYPE

1321: (
1322: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1323: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1324: p_name IN vea_packages.name%TYPE,
1325: p_application_short_name IN vea_packages.application_short_name%TYPE
1326: )
1327: RETURN NUMBER
1328: IS
1329: --{

Line 1336: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

1332: --
1333: --
1334: CURSOR package_cur
1335: (
1336: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1337: p_application_short_name IN vea_packages.application_short_name%TYPE,
1338: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1339: p_name IN vea_packages.name%TYPE
1340: )

Line 1337: p_application_short_name IN vea_packages.application_short_name%TYPE,

1333: --
1334: CURSOR package_cur
1335: (
1336: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1337: p_application_short_name IN vea_packages.application_short_name%TYPE,
1338: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1339: p_name IN vea_packages.name%TYPE
1340: )
1341: IS

Line 1338: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

1334: CURSOR package_cur
1335: (
1336: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1337: p_application_short_name IN vea_packages.application_short_name%TYPE,
1338: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1339: p_name IN vea_packages.name%TYPE
1340: )
1341: IS
1342: SELECT package_id

Line 1339: p_name IN vea_packages.name%TYPE

1335: (
1336: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1337: p_application_short_name IN vea_packages.application_short_name%TYPE,
1338: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1339: p_name IN vea_packages.name%TYPE
1340: )
1341: IS
1342: SELECT package_id
1343: FROM vea_packages

Line 1343: FROM vea_packages

1339: p_name IN vea_packages.name%TYPE
1340: )
1341: IS
1342: SELECT package_id
1343: FROM vea_packages
1344: WHERE layer_provider_code = p_layer_provider_code
1345: AND application_short_name = p_application_short_name
1346: AND client_server_flag = p_client_server_flag
1347: AND UPPER(name) = UPPER(p_name);

Line 1386: PURPOSE: Table hadndler API for VEA_PACKAGES table.

1382: /*========================================================================
1383:
1384: PROCEDURE NAME: process
1385:
1386: PURPOSE: Table hadndler API for VEA_PACKAGES table.
1387:
1388: It inserts/updates a record in VEA_PACKAGES table.
1389:
1390: ========================================================================*/

Line 1388: It inserts/updates a record in VEA_PACKAGES table.

1384: PROCEDURE NAME: process
1385:
1386: PURPOSE: Table hadndler API for VEA_PACKAGES table.
1387:
1388: It inserts/updates a record in VEA_PACKAGES table.
1389:
1390: ========================================================================*/
1391: PROCEDURE
1392: process

Line 1401: x_id OUT NOCOPY vea_packages.package_id%TYPE,

1397: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1398: x_return_status OUT NOCOPY VARCHAR2,
1399: x_msg_count OUT NOCOPY NUMBER,
1400: x_msg_data OUT NOCOPY VARCHAR2,
1401: x_id OUT NOCOPY vea_packages.package_id%TYPE,
1402: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

Line 1402: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

1398: x_return_status OUT NOCOPY VARCHAR2,
1399: x_msg_count OUT NOCOPY NUMBER,
1400: x_msg_data OUT NOCOPY VARCHAR2,
1401: x_id OUT NOCOPY vea_packages.package_id%TYPE,
1402: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,

Line 1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

1399: x_msg_count OUT NOCOPY NUMBER,
1400: x_msg_data OUT NOCOPY VARCHAR2,
1401: x_id OUT NOCOPY vea_packages.package_id%TYPE,
1402: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,

Line 1404: p_generate_flag IN vea_packages.generate_flag%TYPE,

1400: x_msg_data OUT NOCOPY VARCHAR2,
1401: x_id OUT NOCOPY vea_packages.package_id%TYPE,
1402: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,

Line 1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,

1401: x_id OUT NOCOPY vea_packages.package_id%TYPE,
1402: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,

Line 1406: p_name IN vea_packages.name%TYPE,

1402: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,

Line 1407: p_specification_filename IN vea_packages.specification_filename%TYPE,

1403: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,

Line 1408: p_body_filename IN vea_packages.body_filename%TYPE,

1404: p_generate_flag IN vea_packages.generate_flag%TYPE,
1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,
1412: p_application_short_name IN vea_packages.application_short_name%TYPE,

Line 1409: p_label IN vea_packages.label%TYPE,

1405: p_tpa_flag IN vea_packages.tpa_flag%TYPE,
1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,
1412: p_application_short_name IN vea_packages.application_short_name%TYPE,
1413: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,

Line 1410: p_version_number IN vea_packages.version_number%TYPE,

1406: p_name IN vea_packages.name%TYPE,
1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,
1412: p_application_short_name IN vea_packages.application_short_name%TYPE,
1413: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,
1414: p_id IN vea_packages.package_id%TYPE := NULL

Line 1411: p_description IN vea_packages.description%TYPE,

1407: p_specification_filename IN vea_packages.specification_filename%TYPE,
1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,
1412: p_application_short_name IN vea_packages.application_short_name%TYPE,
1413: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,
1414: p_id IN vea_packages.package_id%TYPE := NULL
1415: )

Line 1412: p_application_short_name IN vea_packages.application_short_name%TYPE,

1408: p_body_filename IN vea_packages.body_filename%TYPE,
1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,
1412: p_application_short_name IN vea_packages.application_short_name%TYPE,
1413: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,
1414: p_id IN vea_packages.package_id%TYPE := NULL
1415: )
1416: IS

Line 1413: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,

1409: p_label IN vea_packages.label%TYPE,
1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,
1412: p_application_short_name IN vea_packages.application_short_name%TYPE,
1413: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,
1414: p_id IN vea_packages.package_id%TYPE := NULL
1415: )
1416: IS
1417: --{

Line 1414: p_id IN vea_packages.package_id%TYPE := NULL

1410: p_version_number IN vea_packages.version_number%TYPE,
1411: p_description IN vea_packages.description%TYPE,
1412: p_application_short_name IN vea_packages.application_short_name%TYPE,
1413: p_tp_layer_id IN vea_packages.tp_layer_id%TYPE,
1414: p_id IN vea_packages.package_id%TYPE := NULL
1415: )
1416: IS
1417: --{
1418: l_api_name CONSTANT VARCHAR2(30) := 'process';

Line 1425: l_package_id vea_packages.package_id%TYPE;

1421: --
1422: --
1423: l_location VARCHAR2(32767);
1424: l_savepoint_name VARCHAR2(30);
1425: l_package_id vea_packages.package_id%TYPE;
1426: l_tp_layer_id vea_tp_layers.tp_layer_id%TYPE;
1427: --
1428: --
1429: CURSOR package_cur

Line 1431: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,

1427: --
1428: --
1429: CURSOR package_cur
1430: (
1431: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1432: --p_package_id IN vea_packages.package_id%TYPE,
1433: p_application_short_name IN vea_packages.application_short_name%TYPE,
1434: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1435: p_name IN vea_packages.name%TYPE

Line 1432: --p_package_id IN vea_packages.package_id%TYPE,

1428: --
1429: CURSOR package_cur
1430: (
1431: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1432: --p_package_id IN vea_packages.package_id%TYPE,
1433: p_application_short_name IN vea_packages.application_short_name%TYPE,
1434: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1435: p_name IN vea_packages.name%TYPE
1436: )

Line 1433: p_application_short_name IN vea_packages.application_short_name%TYPE,

1429: CURSOR package_cur
1430: (
1431: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1432: --p_package_id IN vea_packages.package_id%TYPE,
1433: p_application_short_name IN vea_packages.application_short_name%TYPE,
1434: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1435: p_name IN vea_packages.name%TYPE
1436: )
1437: IS

Line 1434: p_client_server_flag IN vea_packages.client_server_flag%TYPE,

1430: (
1431: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1432: --p_package_id IN vea_packages.package_id%TYPE,
1433: p_application_short_name IN vea_packages.application_short_name%TYPE,
1434: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1435: p_name IN vea_packages.name%TYPE
1436: )
1437: IS
1438: SELECT package_id

Line 1435: p_name IN vea_packages.name%TYPE

1431: p_layer_provider_code IN vea_packages.layer_provider_code%TYPE,
1432: --p_package_id IN vea_packages.package_id%TYPE,
1433: p_application_short_name IN vea_packages.application_short_name%TYPE,
1434: p_client_server_flag IN vea_packages.client_server_flag%TYPE,
1435: p_name IN vea_packages.name%TYPE
1436: )
1437: IS
1438: SELECT package_id
1439: FROM vea_packages

Line 1439: FROM vea_packages

1435: p_name IN vea_packages.name%TYPE
1436: )
1437: IS
1438: SELECT package_id
1439: FROM vea_packages
1440: WHERE layer_provider_code = p_layer_provider_code
1441: AND application_short_name = p_application_short_name
1442: AND client_server_flag = p_client_server_flag
1443: AND name = p_name;

Line 1560: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Inserting a row in vea_packages');

1556: THEN
1557: --{
1558: l_location := '0070';
1559: --
1560: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Inserting a row in vea_packages');
1561: --
1562: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
1563: THEN
1564: SELECT NVL( p_id, vea_packages_s.NEXTVAL )

Line 1564: SELECT NVL( p_id, vea_packages_s.NEXTVAL )

1560: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Inserting a row in vea_packages');
1561: --
1562: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
1563: THEN
1564: SELECT NVL( p_id, vea_packages_s.NEXTVAL )
1565: INTO l_package_id
1566: FROM DUAL;
1567: ELSE
1568: SELECT vea_packages_s.NEXTVAL

Line 1568: SELECT vea_packages_s.NEXTVAL

1564: SELECT NVL( p_id, vea_packages_s.NEXTVAL )
1565: INTO l_package_id
1566: FROM DUAL;
1567: ELSE
1568: SELECT vea_packages_s.NEXTVAL
1569: INTO l_package_id
1570: FROM DUAL;
1571: END IF;
1572: --

Line 1738: END VEA_PACKAGES_SV;

1734: --}
1735: --}
1736: END process;
1737: --}
1738: END VEA_PACKAGES_SV;