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);
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:
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
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;
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;
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:
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
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
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:
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