eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_ENTITY_GROUPS_UPLOAD_PKG dependencies on HXC_ENTITY_GROUPS

Line 1: PACKAGE BODY hxc_entity_groups_upload_pkg AS

1: PACKAGE BODY hxc_entity_groups_upload_pkg AS
2: /* $Header: hxcetgupl.pkb 120.2 2005/09/23 08:08:24 sechandr noship $ */
3:
4: g_debug boolean :=hr_utility.debug_enabled;
5:

Line 10: SELECT entity_group_id FROM hxc_entity_groups

6: FUNCTION GET_ENTITY_GROUP_ID(p_entity_type in varchar2, p_name in varchar2)
7: RETURN NUMBER IS
8:
9: cursor c_get_egroup_id (l_p_entity_type in varchar2, l_p_name in varchar2) IS
10: SELECT entity_group_id FROM hxc_entity_groups
11: WHERE entity_type = l_p_entity_type and name = l_p_name;
12: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
13: BEGIN
14: OPEN c_get_egroup_id(p_entity_type, p_name);

Line 12: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;

8:
9: cursor c_get_egroup_id (l_p_entity_type in varchar2, l_p_name in varchar2) IS
10: SELECT entity_group_id FROM hxc_entity_groups
11: WHERE entity_type = l_p_entity_type and name = l_p_name;
12: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
13: BEGIN
14: OPEN c_get_egroup_id(p_entity_type, p_name);
15: FETCH c_get_egroup_id INTO l_entity_group_id ;
16: CLOSE c_get_egroup_id;

Line 29: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;

25: P_ENTITY_TYPE IN VARCHAR2,
26: P_OWNER IN VARCHAR2,
27: P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL) IS
28:
29: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
30: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
31: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
32: l_owner VARCHAR2(6);
33:

Line 30: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;

26: P_OWNER IN VARCHAR2,
27: P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL) IS
28:
29: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
30: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
31: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
32: l_owner VARCHAR2(6);
33:
34: BEGIN

Line 31: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;

27: P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL) IS
28:
29: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
30: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
31: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
32: l_owner VARCHAR2(6);
33:
34: BEGIN
35:

Line 49: FROM hxc_entity_groups

45: l_entity_group_id,
46: l_entity_type ,
47: l_ovn,
48: l_owner
49: FROM hxc_entity_groups
50: WHERE name = p_name and entity_type = p_entity_type;
51:
52: -- IF ( p_custom_mode = 'FORCE' OR l_owner = 'SEED' )
53: -- THEN

Line 90: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;

86: P_CUSTOM_MODE IN VARCHAR2 ) IS
87:
88: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_comp_ID%TYPE;
89: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
90: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
91:
92: l_owner VARCHAR2(6);
93:
94: BEGIN

Line 179: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;

175: P_OWNER IN VARCHAR2,
176: P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
177: ,p_last_update_date IN VARCHAR2) IS
178:
179: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
180: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;

Line 180: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;

176: P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
177: ,p_last_update_date IN VARCHAR2) IS
178:
179: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
180: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;
184: l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;

Line 181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;

177: ,p_last_update_date IN VARCHAR2) IS
178:
179: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
180: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;
184: l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;
185: l_last_update_date_f HXC_ENTITY_GROUPS.last_update_date%TYPE;

Line 182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;

178:
179: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
180: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;
184: l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;
185: l_last_update_date_f HXC_ENTITY_GROUPS.last_update_date%TYPE;
186:

Line 183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;

179: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
180: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;
184: l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;
185: l_last_update_date_f HXC_ENTITY_GROUPS.last_update_date%TYPE;
186:
187: BEGIN

Line 184: l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;

180: l_entity_type HXC_ENTITY_GROUPS.ENTITY_TYPE%TYPE;
181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;
184: l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;
185: l_last_update_date_f HXC_ENTITY_GROUPS.last_update_date%TYPE;
186:
187: BEGIN
188:

Line 185: l_last_update_date_f HXC_ENTITY_GROUPS.last_update_date%TYPE;

181: l_ovn HXC_ENTITY_GROUPS.object_version_number%TYPE;
182: l_last_update_date_db HXC_ENTITY_GROUPS.last_update_date%TYPE;
183: l_last_updated_by_db HXC_ENTITY_GROUPS.last_updated_by%TYPE;
184: l_last_updated_by_f HXC_ENTITY_GROUPS.last_updated_by%TYPE;
185: l_last_update_date_f HXC_ENTITY_GROUPS.last_update_date%TYPE;
186:
187: BEGIN
188:
189: l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line 210: FROM hxc_entity_groups

206: l_ovn
207: ,l_last_update_date_db
208: ,l_last_updated_by_db
209:
210: FROM hxc_entity_groups
211: WHERE name = p_name and entity_type = p_entity_type;
212:
213: IF (fnd_load_util.upload_test( l_last_updated_by_f,
214: l_last_update_date_f,

Line 256: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;

252: ,p_last_update_date IN VARCHAR2) IS
253:
254: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_comp_ID%TYPE;
255: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;
256: l_entity_group_id HXC_ENTITY_GROUPS.ENTITY_GROUP_ID%TYPE;
257:
258: l_last_update_date_db HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
259: l_last_updated_by_db HXC_ENTITY_GROUP_COMPS.last_updated_by%TYPE;
260: l_last_updated_by_f HXC_ENTITY_GROUP_COMPS.last_updated_by%TYPE;

Line 349: END hxc_entity_groups_upload_pkg;

345:
346: END LOAD_ENTITY_GROUP_COMPS_ROW;
347:
348:
349: END hxc_entity_groups_upload_pkg;