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_S

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 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 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 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 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 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 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 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 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 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 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 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 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;