APPS.HXC_APPROVAL_WF_UTIL dependencies on WF_ITEM_TYPES

Line 9: (p_item_type in wf_item_types.name%type,

5: c_previous_approver_name constant varchar2(17) := 'PREVIOUS_APPROVER';
6: c_app_id_name constant varchar2(17) := 'PREVIOUS_APP_ID';
7:
8: Procedure copy_previous_approvers
9: (p_item_type in wf_item_types.name%type,
10: p_current_key in wf_item_attribute_values.item_key%type,
11: p_copyto_key in wf_item_attribute_values.item_key%type) is
12:
13:

Line 15: (p_item_type in wf_item_types.name%type,

11: p_copyto_key in wf_item_attribute_values.item_key%type) is
12:
13:
14: cursor c_copy_approvers
15: (p_item_type in wf_item_types.name%type,
16: p_item_key in wf_item_attribute_values.item_key%type) is
17: select name, number_value
18: from wf_item_attribute_values
19: where item_type = p_item_type

Line 40: (p_item_type in wf_item_types.name%type,

36:
37: end copy_previous_approvers;
38:
39: Function get_previous_approver
40: (p_item_type in wf_item_types.name%type,
41: p_item_key in wf_item_attribute_values.item_key%type,
42: p_app_period_id in hxc_app_period_summary.application_period_id%type)
43: Return number is
44:

Line 46: (p_item_type in wf_item_types.name%type,

42: p_app_period_id in hxc_app_period_summary.application_period_id%type)
43: Return number is
44:
45: cursor c_previous_approver
46: (p_item_type in wf_item_types.name%type,
47: p_item_key in wf_item_attribute_values.item_key%type,
48: p_app_period_id in hxc_app_period_summary.application_period_id%type) is
49: select preapr.number_value
50: from wf_item_attribute_values appid,

Line 75: (p_item_type in wf_item_types.name%type,

71:
72: End get_previous_approver;
73:
74: Function keep_previous_approver
75: (p_item_type in wf_item_types.name%type,
76: p_item_key in wf_item_attribute_values.item_key%type,
77: p_app_period_id in hxc_app_period_summary.application_period_id%type)
78: RETURN number is
79:

Line 87: (p_item_type in wf_item_types.name%type,

83: from hxc_app_period_summary
84: where application_period_id = p_app_id;
85:
86: cursor c_previous_approvers
87: (p_item_type in wf_item_types.name%type,
88: p_item_key in wf_item_attribute_values.item_key%type) is
89: select count(*)
90: from wf_item_attribute_values
91: where item_type = p_item_type