APPS.HXC_PROJ_MANAGER_APPROVAL_PKG dependencies on HXC_APPROVAL_COMPS

Line 19: select APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER from hxc_approval_comps where APPROVAL_MECHANISM = 'ENTRY_LEVEL_APPROVAL' and APPROVAL_STYLE_ID = l_approval_style_id;

15: select TIME_RECIPIENT_ID from HXC_TIME_RECIPIENTs where APPLICATION_ID = 275 ;
16:
17: cursor csr_get_ela_approval_comp(l_approval_style_id in number)
18: is
19: select APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER from hxc_approval_comps where APPROVAL_MECHANISM = 'ENTRY_LEVEL_APPROVAL' and APPROVAL_STYLE_ID = l_approval_style_id;
20:
21: --bug 4671272
22: cursor csr_get_flex_value_set_id
23: is

Line 57: select APPROVAL_MECHANISM, APPROVAL_MECHANISM_ID, APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER , WF_NAME , WF_ITEM_TYPE from hxc_approval_comps where

53:
54:
55: cursor csr_get_approval_mechanism( l_approval_style_id in number, l_time_category_id in number)
56: is
57: select APPROVAL_MECHANISM, APPROVAL_MECHANISM_ID, APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER , WF_NAME , WF_ITEM_TYPE from hxc_approval_comps where
58: APPROVAL_STYLE_ID = l_approval_style_id and TIME_CATEGORY_ID = l_time_category_id
59: and OBJECT_VERSION_NUMBER = ( select max( OBJECT_VERSION_NUMBER ) from hxc_approval_comps where
60: APPROVAL_STYLE_ID = l_approval_style_id and TIME_CATEGORY_ID = l_time_category_id);
61:

Line 59: and OBJECT_VERSION_NUMBER = ( select max( OBJECT_VERSION_NUMBER ) from hxc_approval_comps where

55: cursor csr_get_approval_mechanism( l_approval_style_id in number, l_time_category_id in number)
56: is
57: select APPROVAL_MECHANISM, APPROVAL_MECHANISM_ID, APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER , WF_NAME , WF_ITEM_TYPE from hxc_approval_comps where
58: APPROVAL_STYLE_ID = l_approval_style_id and TIME_CATEGORY_ID = l_time_category_id
59: and OBJECT_VERSION_NUMBER = ( select max( OBJECT_VERSION_NUMBER ) from hxc_approval_comps where
60: APPROVAL_STYLE_ID = l_approval_style_id and TIME_CATEGORY_ID = l_time_category_id);
61:
62:
63: CURSOR csr_get_map_comp_id

Line 186: hxc_approval_comps_api.create_approval_comps(

182: ----------------------- Creating Approval Component for each Time Category-----------------+
183: /* As a new Time Category has been created we also need to create a corresponding Approval Component with the just created Time Category */
184:
185:
186: hxc_approval_comps_api.create_approval_comps(
187: p_approval_mechanism => l_approval_mechanism,
188: p_approval_mechanism_id => l_mechanism_id,
189: p_approval_style_id => l_approval_style_id,
190: p_time_recipient_id => -1,

Line 266: hxc_approval_comps_api.update_approval_comps

262: if g_debug then
263: hr_utility.set_location(l_proc, 60);
264: end if;
265:
266: hxc_approval_comps_api.update_approval_comps
267: (
268: p_approval_comp_id => l_approval_comp_id
269: ,p_object_version_number => l_object_version_number
270: ,p_approval_mechanism => l_approval_mechanism

Line 445: hxc_approval_comps_api.create_approval_comps(

441: p_approval_style_id => l_approval_style_id,
442: p_object_version_number => l_object_version_number);
443:
444: /* Creating the ENTRY_LEVEL_APPROVAL approval component for the above created Special ELA Approval Style */
445: hxc_approval_comps_api.create_approval_comps(
446: p_approval_mechanism => 'ENTRY_LEVEL_APPROVAL',
447: p_approval_style_id => l_approval_style_id,
448: p_time_recipient_id => l_time_recipient_id,
449: p_approval_order => 10,

Line 461: hxc_approval_comps_api.create_approval_comps(

457: l_parent_object_version_number := l_object_version_number;
458:
459: /* Creating the mandatory default approval style for ELA, */
460:
461: hxc_approval_comps_api.create_approval_comps(
462: p_approval_mechanism => 'HR_SUPERVISOR',
463: p_approval_style_id => l_approval_style_id,
464: p_time_recipient_id => -1,
465: p_approval_order => 10,