DBA Data[Home] [Help]

APPS.HXC_ENTITY_GROUPS_UPLOAD_PKG dependencies on HXC_ENTITY_GROUP_COMPS

Line 88: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_comp_ID%TYPE;

84: P_ATTRIBUTE3 IN VARCHAR2,
85: P_OWNER IN VARCHAR2,
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);

Line 89: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;

85: P_OWNER IN VARCHAR2,
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:

Line 112: FROM hxc_entity_group_comps

108: INTO
109: l_entity_group_comp_id,
110: l_object_version_number,
111: l_owner
112: FROM hxc_entity_group_comps
113: WHERE entity_group_id = l_entity_group_id
114: AND attribute_category = P_ATTRIBUTE_CATEGORY;
115:
116: if g_debug then

Line 254: l_entity_group_comp_id HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_comp_ID%TYPE;

250: P_OWNER IN VARCHAR2,
251: P_CUSTOM_MODE IN VARCHAR2
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;

Line 255: l_object_version_number HXC_ENTITY_GROUP_COMPS.OBJECT_VERSION_NUMBER%TYPE;

251: P_CUSTOM_MODE IN VARCHAR2
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;

Line 258: l_last_update_date_db HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;

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;
261: l_last_update_date_f HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
262:

Line 259: l_last_updated_by_db HXC_ENTITY_GROUP_COMPS.last_updated_by%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;
261: l_last_update_date_f HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
262:
263: BEGIN

Line 260: l_last_updated_by_f HXC_ENTITY_GROUP_COMPS.last_updated_by%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;
261: l_last_update_date_f HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
262:
263: BEGIN
264: -- check to see row exists

Line 261: l_last_update_date_f HXC_ENTITY_GROUP_COMPS.last_update_date%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;
261: l_last_update_date_f HXC_ENTITY_GROUP_COMPS.last_update_date%TYPE;
262:
263: BEGIN
264: -- check to see row exists
265:

Line 285: FROM hxc_entity_group_comps

281: l_entity_group_comp_id,
282: l_object_version_number
283: ,l_last_update_date_db
284: ,l_last_updated_by_db
285: FROM hxc_entity_group_comps
286: WHERE entity_group_id = l_entity_group_id
287: AND attribute_category = P_ATTRIBUTE_CATEGORY;
288:
289: if g_debug then