APPS.HXC_PUBLIC_TEMP_GROUP_COMP_API dependencies on HXC_ENTITY_GROUPS

Line 32: FROM hxc_entity_groups heg

28: SELECT 'error'
29: FROM dual
30: WHERE EXISTS (
31: SELECT 'x'
32: FROM hxc_entity_groups heg
33: WHERE heg.name = p_name
34: and heg.entity_type = 'PUBLIC_TEMPLATE_GROUP'
35: and heg.business_group_id = p_business_group_id);
36:

Line 37: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

33: WHERE heg.name = p_name
34: and heg.entity_type = 'PUBLIC_TEMPLATE_GROUP'
35: and heg.business_group_id = p_business_group_id);
36:
37: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
38: l_error VARCHAR2(5) := NULL;
39:
40: BEGIN
41: OPEN csr_group_name_exists;

Line 198: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

194: p_business_group_id IN NUMBER,
195: p_attached_pref_name OUT NOCOPY VARCHAR2
196: )
197: IS
198: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
199: l_attached_pref_name VARCHAR2(325) := null;
200:
201: CURSOR csr_get_ovn IS
202: SELECT

Line 204: FROM hxc_entity_groups heg

200:
201: CURSOR csr_get_ovn IS
202: SELECT
203: object_version_number
204: FROM hxc_entity_groups heg
205: WHERE entity_group_id = p_entity_group_id
206: AND heg.business_group_id = p_business_group_id;
207:
208: BEGIN

Line 323: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

319: ,p_name IN VARCHAR2
320: ,p_description IN VARCHAR2
321: )
322: IS
323: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
324: l_business_group_id HXC_ENTITY_GROUPS.BUSINESS_GROUP_ID%TYPE;
325: l_legislation_code HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE;
326: l_name HXC_ENTITY_GROUPS.NAME%TYPE;
327:

Line 324: l_business_group_id HXC_ENTITY_GROUPS.BUSINESS_GROUP_ID%TYPE;

320: ,p_description IN VARCHAR2
321: )
322: IS
323: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
324: l_business_group_id HXC_ENTITY_GROUPS.BUSINESS_GROUP_ID%TYPE;
325: l_legislation_code HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE;
326: l_name HXC_ENTITY_GROUPS.NAME%TYPE;
327:
328: CURSOR csr_get_entity_detail IS

Line 325: l_legislation_code HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE;

321: )
322: IS
323: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
324: l_business_group_id HXC_ENTITY_GROUPS.BUSINESS_GROUP_ID%TYPE;
325: l_legislation_code HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE;
326: l_name HXC_ENTITY_GROUPS.NAME%TYPE;
327:
328: CURSOR csr_get_entity_detail IS
329: SELECT

Line 326: l_name HXC_ENTITY_GROUPS.NAME%TYPE;

322: IS
323: l_object_version_number HXC_ENTITY_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
324: l_business_group_id HXC_ENTITY_GROUPS.BUSINESS_GROUP_ID%TYPE;
325: l_legislation_code HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE;
326: l_name HXC_ENTITY_GROUPS.NAME%TYPE;
327:
328: CURSOR csr_get_entity_detail IS
329: SELECT
330: object_version_number

Line 335: hxc_entity_groups heg

331: ,business_group_id
332: ,legislation_code
333: ,name
334: FROM
335: hxc_entity_groups heg
336: WHERE
337: entity_group_id = p_entity_group_id;
338:
339: CURSOR csr_exist_template_name(l_business_group_id in HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE) IS

Line 339: CURSOR csr_exist_template_name(l_business_group_id in HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE) IS

335: hxc_entity_groups heg
336: WHERE
337: entity_group_id = p_entity_group_id;
338:
339: CURSOR csr_exist_template_name(l_business_group_id in HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE) IS
340: SELECT 'error'
341: FROM dual
342: WHERE EXISTS (
343: SELECT 'x'

Line 344: FROM hxc_entity_groups heg

340: SELECT 'error'
341: FROM dual
342: WHERE EXISTS (
343: SELECT 'x'
344: FROM hxc_entity_groups heg
345: WHERE heg.name = p_name
346: and heg.entity_type = 'PUBLIC_TEMPLATE_GROUP'
347: and heg.business_group_id = l_business_group_id);
348:

Line 480: SELECT heg.NAME FROM hxc_entity_groups heg ,

476: ) RETURN VARCHAR2 IS
477:
478: CURSOR cur_attached_public_temp_grps(p_template_id in hxc_time_building_blocks.time_building_block_id%type)
479: IS
480: SELECT heg.NAME FROM hxc_entity_groups heg ,
481: hxc_entity_group_comps hegc
482: WHERE
483: heg.ENTITY_TYPE = 'PUBLIC_TEMPLATE_GROUP'
484: and heg.entity_group_id =hegc.entity_group_id