APPS.PV_GE_BENEFITS_PKG dependencies on PV_GE_BENEFITS_PKG

Line 1: package body PV_GE_BENEFITS_PKG as

1: package body PV_GE_BENEFITS_PKG as
2: /* $Header: pvxtpgbb.pls 120.1 2005/06/30 14:54:27 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_BENEFIT_ID in NUMBER,

Line 412: PV_GE_BENEFITS_PKG.UPDATE_ROW (

408: l_last_updated_by := x.last_updated_by;
409: end loop;
410:
411: IF ( l_last_updated_by = 1) THEN
412: PV_GE_BENEFITS_PKG.UPDATE_ROW (
413: X_BENEFIT_ID => x_BENEFIT_ID
414: , X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER
415: , X_BENEFIT_TYPE_CODE => x_BENEFIT_TYPE_CODE
416: , X_BENEFIT_STATUS_CODE => x_BENEFIT_STATUS_CODE

Line 444: PV_GE_BENEFITS_PKG.SEED_UPDATE_ROW (

440: , X_LAST_UPDATED_BY => X_LAST_UPDATED_BY
441: , X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
442: );
443: ELSE
444: PV_GE_BENEFITS_PKG.SEED_UPDATE_ROW (
445: X_BENEFIT_ID => x_BENEFIT_ID
446: , X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER
447: , X_BENEFIT_TYPE_CODE => x_BENEFIT_TYPE_CODE
448: , X_BENEFIT_STATUS_CODE => x_BENEFIT_STATUS_CODE

Line 710: PV_GE_BENEFITS_PKG.INSERT_ROW (

706:
707: if c_chk_benefit_exists%notfound then
708: close c_chk_benefit_exists;
709: l_obj_verno := 1;
710: PV_GE_BENEFITS_PKG.INSERT_ROW (
711: X_ROWID => L_ROW_ID
712: , X_BENEFIT_ID => p_BENEFIT_ID
713: , X_OBJECT_VERSION_NUMBER => L_OBJ_VERNO
714: , X_BENEFIT_TYPE_CODE => p_BENEFIT_TYPE_CODE

Line 752: PV_GE_BENEFITS_PKG.UPDATE_SEED_ROW (

748: open c_obj_verno;
749: fetch c_obj_verno into l_obj_verno;
750: close c_obj_verno;
751:
752: PV_GE_BENEFITS_PKG.UPDATE_SEED_ROW (
753: X_BENEFIT_ID => p_BENEFIT_ID
754: , X_OBJECT_VERSION_NUMBER => L_OBJ_VERNO
755: , X_BENEFIT_TYPE_CODE => p_BENEFIT_TYPE_CODE
756: , X_BENEFIT_STATUS_CODE => p_BENEFIT_STATUS_CODE

Line 859: end PV_GE_BENEFITS_PKG;

855: END IF;
856:
857: end LOAD_SEED_ROW;
858:
859: end PV_GE_BENEFITS_PKG;