APPS.BEN_BEF_UPLOAD_PKG dependencies on BEN_EXT_FLD

Line 15: l_ext_fld_id ben_ext_fld.ext_fld_id%TYPE;

11: , p_alwd_in_rcd_cd VARCHAR2
12: , p_Group_lvl_cd VARCHAR2 default null
13: , p_custom_mode VARCHAR2 ) IS
14:
15: l_ext_fld_id ben_ext_fld.ext_fld_id%TYPE;
16: l_ovn ben_ext_fld.object_version_number%TYPE;
17: l_owner VARCHAR2(6);
18:
19: l_rowid rowid;

Line 16: l_ovn ben_ext_fld.object_version_number%TYPE;

12: , p_Group_lvl_cd VARCHAR2 default null
13: , p_custom_mode VARCHAR2 ) IS
14:
15: l_ext_fld_id ben_ext_fld.ext_fld_id%TYPE;
16: l_ovn ben_ext_fld.object_version_number%TYPE;
17: l_owner VARCHAR2(6);
18:
19: l_rowid rowid;
20:

Line 31: FROM ben_ext_fld

27: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
28: INTO l_ext_fld_id
29: , l_ovn
30: , l_owner
31: FROM ben_ext_fld
32: WHERE short_name = P_SHORT_NAME;
33:
34:
35: -- IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' ) THEN

Line 37: BEN_EXT_FLD_PKG.UPDATE_ROW (

33:
34:
35: -- IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' ) THEN
36:
37: BEN_EXT_FLD_PKG.UPDATE_ROW (
38: P_EXT_FLD_ID => l_ext_fld_id
39: , P_DECD_FLAG => p_decd_flag
40: , P_SHORT_NAME => p_short_name
41: , P_FRMT_MASK_TYP_CD => p_frmt_mask_typ_cd

Line 59: select ben_ext_fld_s.nextval

55: EXCEPTION WHEN NO_DATA_FOUND
56: THEN
57:
58: if l_ext_fld_id is null then
59: select ben_ext_fld_s.nextval
60: into l_ext_fld_id
61: from dual;
62: end if ;
63:

Line 64: ben_ext_fld_pkg.insert_row (

60: into l_ext_fld_id
61: from dual;
62: end if ;
63:
64: ben_ext_fld_pkg.insert_row (
65: P_ROWID => l_rowid
66: , P_EXT_FLD_ID => l_ext_fld_id
67: , P_DECD_FLAG => p_decd_flag
68: , P_SHORT_NAME => p_short_name