APPS.VEA_PROGRAM_UNITS_SV dependencies on VEA_PROGRAM_UNITS_S

Line 1: PACKAGE BODY VEA_PROGRAM_UNITS_SV as

1: PACKAGE BODY VEA_PROGRAM_UNITS_SV as
2: /* $Header: VEAVAPUB.pls 115.14 2004/07/27 02:42:47 rvishnuv ship $ */
3: --{
4: /*====================== vea_program_units_sv =========================*/
5: /*========================================================================

Line 4: /*====================== vea_program_units_sv =========================*/

1: PACKAGE BODY VEA_PROGRAM_UNITS_SV as
2: /* $Header: VEAVAPUB.pls 115.14 2004/07/27 02:42:47 rvishnuv ship $ */
3: --{
4: /*====================== vea_program_units_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PROGRAM_UNITS
7:
8: NOTES: To run the script:

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

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

Line 995: SELECT NVL( p_id, vea_program_units_s.NEXTVAL )

991: l_location := '0120';
992: --
993: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
994: THEN
995: SELECT NVL( p_id, vea_program_units_s.NEXTVAL )
996: INTO l_program_unit_id
997: FROM DUAL;
998: ELSE
999: SELECT vea_program_units_s.NEXTVAL

Line 999: SELECT vea_program_units_s.NEXTVAL

995: SELECT NVL( p_id, vea_program_units_s.NEXTVAL )
996: INTO l_program_unit_id
997: FROM DUAL;
998: ELSE
999: SELECT vea_program_units_s.NEXTVAL
1000: INTO l_program_unit_id
1001: FROM DUAL;
1002: END IF;
1003: --

Line 1193: END VEA_PROGRAM_UNITS_SV;

1189: --}
1190: --}
1191: END process;
1192: --}
1193: END VEA_PROGRAM_UNITS_SV;