APPS.VEA_TP_LAYERS_SV dependencies on VEA_TP_LAYERS_S

Line 1: PACKAGE BODY VEA_TP_LAYERS_SV as

1: PACKAGE BODY VEA_TP_LAYERS_SV as
2: /* $Header: VEAVATLB.pls 115.5 2004/07/27 00:08:47 rvishnuv ship $ */
3: --{
4: /*====================== vea_tp_layers_sv =========================*/
5: /*========================================================================

Line 4: /*====================== vea_tp_layers_sv =========================*/

1: PACKAGE BODY VEA_TP_LAYERS_SV as
2: /* $Header: VEAVATLB.pls 115.5 2004/07/27 00:08:47 rvishnuv ship $ */
3: --{
4: /*====================== vea_tp_layers_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_TP_LAYERS
7:
8: NOTES: To run the script:

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

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

Line 741: SELECT NVL( p_id, vea_tp_layers_s.NEXTVAL )

737: l_location := '0070';
738: --
739: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
740: THEN
741: SELECT NVL( p_id, vea_tp_layers_s.NEXTVAL )
742: INTO l_tp_layer_id
743: FROM DUAL;
744: ELSE
745: SELECT vea_tp_layers_s.NEXTVAL

Line 745: SELECT vea_tp_layers_s.NEXTVAL

741: SELECT NVL( p_id, vea_tp_layers_s.NEXTVAL )
742: INTO l_tp_layer_id
743: FROM DUAL;
744: ELSE
745: SELECT vea_tp_layers_s.NEXTVAL
746: INTO l_tp_layer_id
747: FROM DUAL;
748: END IF;
749: --

Line 867: END VEA_TP_LAYERS_SV;

863: --}
864: --}
865: END process;
866: --}
867: END VEA_TP_LAYERS_SV;