APPS.HXC_APPROVAL_WF_UTIL dependencies on HXC_APP_PERIOD_SUMMARY

Line 42: p_app_period_id in hxc_app_period_summary.application_period_id%type)

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
46: (p_item_type in wf_item_types.name%type,

Line 48: p_app_period_id in hxc_app_period_summary.application_period_id%type) 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
52: where appid.number_value = p_app_period_id

Line 77: p_app_period_id in hxc_app_period_summary.application_period_id%type)

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
81: (p_app_id in hxc_app_period_summary.application_period_id%type) is

Line 81: (p_app_id in hxc_app_period_summary.application_period_id%type) is

77: p_app_period_id in hxc_app_period_summary.application_period_id%type)
78: RETURN number is
79:
80: cursor c_previous_approver
81: (p_app_id in hxc_app_period_summary.application_period_id%type) is
82: select approver_id
83: from hxc_app_period_summary
84: where application_period_id = p_app_id;
85:

Line 83: from hxc_app_period_summary

79:
80: cursor c_previous_approver
81: (p_app_id in hxc_app_period_summary.application_period_id%type) is
82: select approver_id
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,

Line 95: l_previous_approver hxc_app_period_summary.approver_id%type;

91: where item_type = p_item_type
92: and item_key = p_item_key
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: