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.2 2011/03/25 21:46:32 hekkiral 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 708: PV_GE_BENEFITS_PKG.INSERT_ROW (

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

Line 750: PV_GE_BENEFITS_PKG.UPDATE_SEED_ROW (

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

Line 857: end PV_GE_BENEFITS_PKG;

853: END IF;
854:
855: end LOAD_SEED_ROW;
856:
857: end PV_GE_BENEFITS_PKG;