1: PACKAGE BODY VEA_PARAMETERS_SV as
2: /* $Header: VEAVAPAB.pls 115.12 2004/07/27 02:42:20 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameters_sv =========================*/
5: /*========================================================================
1: PACKAGE BODY VEA_PARAMETERS_SV as
2: /* $Header: VEAVAPAB.pls 115.12 2004/07/27 02:42:20 rvishnuv ship $ */
3: --{
4: /*====================== vea_parameters_sv =========================*/
5: /*========================================================================
6: PURPOSE: Table handler package for table VEA_PARAMETERS
7:
8: NOTES: To run the script:
13: Created N PARIKH 09/09/99 10:00 AM
14:
15: =========================================================================*/
16:
17: G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'VEA_PARAMETERS_SV';
18: --
19: --
20: /*========================================================================
21:
429: --
430: --
431: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
432: THEN
433: SELECT NVL( p_id, vea_parameters_s.NEXTVAL )
434: INTO l_parameter_id
435: FROM DUAL;
436: ELSE
437: SELECT vea_parameters_s.NEXTVAL
433: SELECT NVL( p_id, vea_parameters_s.NEXTVAL )
434: INTO l_parameter_id
435: FROM DUAL;
436: ELSE
437: SELECT vea_parameters_s.NEXTVAL
438: INTO l_parameter_id
439: FROM DUAL;
440: END IF;
441: --
558: --}
559: --}
560: END process;
561: --}
562: END VEA_PARAMETERS_SV;