APPS.HXC_APPROVAL_WF_UTIL dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 10: p_current_key in wf_item_attribute_values.item_key%type,

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:
14: cursor c_copy_approvers

Line 11: p_copyto_key in wf_item_attribute_values.item_key%type) is

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:
14: cursor c_copy_approvers
15: (p_item_type in wf_item_types.name%type,

Line 16: p_item_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
20: and item_key = p_item_key

Line 18: from wf_item_attribute_values

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
20: and item_key = p_item_key
21: and name like c_previous_root||'%';
22:

Line 41: p_item_key in wf_item_attribute_values.item_key%type,

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:
45: cursor c_previous_approver

Line 47: p_item_key in wf_item_attribute_values.item_key%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,
51: wf_item_attribute_values preapr

Line 50: from wf_item_attribute_values appid,

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,
51: wf_item_attribute_values preapr
52: where appid.number_value = p_app_period_id
53: and appid.item_type = p_item_type
54: and appid.item_key = p_item_key

Line 51: wf_item_attribute_values preapr

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,
51: wf_item_attribute_values preapr
52: where appid.number_value = p_app_period_id
53: and appid.item_type = p_item_type
54: and appid.item_key = p_item_key
55: and appid.name like c_app_id_name||'%'

Line 60: l_previous_approver wf_item_attribute_values.number_value%type;

56: and preapr.item_type = appid.item_type
57: and preapr.item_key = appid.item_key
58: and preapr.name = replace(appid.name,c_app_id_name,c_previous_approver_name);
59:
60: l_previous_approver wf_item_attribute_values.number_value%type;
61:
62: Begin
63: open c_previous_approver(p_item_type,p_item_key,p_app_period_id);
64: fetch c_previous_approver into l_previous_approver;

Line 76: p_item_key in wf_item_attribute_values.item_key%type,

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:
80: cursor c_previous_approver

Line 88: p_item_key in wf_item_attribute_values.item_key%type) is

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
92: and item_key = p_item_key

Line 90: from wf_item_attribute_values

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
92: and item_key = p_item_key
93: and name like c_previous_approver_name||'%';
94:

Line 97: l_item_attribute_name wf_item_attribute_values.name%type;

93: and name like c_previous_approver_name||'%';
94:
95: l_previous_approver hxc_app_period_summary.approver_id%type;
96: l_previous_approvers number;
97: l_item_attribute_name wf_item_attribute_values.name%type;
98: l_item_attr_app_id_name wf_item_attribute_values.name%type;
99:
100: Begin
101: --

Line 98: l_item_attr_app_id_name wf_item_attribute_values.name%type;

94:
95: l_previous_approver hxc_app_period_summary.approver_id%type;
96: l_previous_approvers number;
97: l_item_attribute_name wf_item_attribute_values.name%type;
98: l_item_attr_app_id_name wf_item_attribute_values.name%type;
99:
100: Begin
101: --
102: -- 0. Find the last approver of this application period