APPS.BEN_EXT_PURGE dependencies on BEN_EXT_RSLT

Line 49: from ben_ext_rslt xrs

45: cursor c_xrs (p_date date ) is
46: select xrs.ext_rslt_id,xrs.ext_dfn_id ,
47: xrs.object_version_number,
48: xrs.eff_dt
49: from ben_ext_rslt xrs
50: where ( xrs.ext_dfn_id = p_ext_dfn_id
51: or p_ext_dfn_id is null )
52: and ( xrs.ext_rslt_id = p_ext_rslt_id
53: or p_ext_rslt_id is null )

Line 60: from ben_ext_rslt_dtl xrd

56:
57: cursor c_xrd (p_ext_rslt_id number)is
58: select ext_rslt_dtl_id,
59: object_version_number
60: from ben_ext_rslt_dtl xrd
61: where xrd.ext_rslt_id = p_ext_rslt_id ;
62:
63:
64: cursor c_xre (p_ext_rslt_id number)is

Line 67: from ben_Ext_rslt_err xre

63:
64: cursor c_xre (p_ext_rslt_id number)is
65: select ext_rslt_err_id,
66: object_version_number
67: from ben_Ext_rslt_err xre
68: where xre.ext_rslt_id = p_ext_rslt_id ;
69:
70:
71: cursor c_Xdf (p_ext_dfn_id number ) is

Line 105: ben_EXT_RSLT_DTL_api. delete_EXT_RSLT_DTL

101: for l_xrd in c_xrd(l_xrs.ext_rslt_id)
102: Loop
103: hr_Utility.set_location('detail '||l_name || ' ' || l_rcd_count, 5);
104: l_object_version_number := l_xrd.object_version_number ;
105: ben_EXT_RSLT_DTL_api. delete_EXT_RSLT_DTL
106: (p_ext_rslt_dtl_id => l_xrd.ext_rslt_dtl_id
107: ,p_object_version_number => l_object_version_number
108: ) ;
109: l_rcd_count := l_rcd_count + 1 ;

Line 118: ben_EXT_RSLT_ERR_api. delete_EXT_RSLT_ERR

114: for l_xre in c_xre(l_xrs.ext_rslt_id)
115: Loop
116: hr_Utility.set_location('error '||l_name , 5);
117: l_object_version_number := l_xre.object_version_number ;
118: ben_EXT_RSLT_ERR_api. delete_EXT_RSLT_ERR
119: (p_ext_rslt_err_id => l_xre.ext_rslt_err_id
120: ,p_object_version_number => l_object_version_number
121: ,p_effective_date => l_xrs.eff_dt
122: ) ;

Line 129: ben_EXT_RSLT_api.delete_EXT_RSLT

125:
126:
127: -- Deleting Result
128: l_object_version_number := l_xrs.object_version_number ;
129: ben_EXT_RSLT_api.delete_EXT_RSLT
130: (p_ext_rslt_id => l_xrs.ext_rslt_id
131: ,p_object_version_number => l_object_version_number
132: ,p_effective_date => l_xrs.eff_dt
133: ) ;