APPS.PQH_WKS_BUDGET dependencies on PQH_UTILITY

Line 82: pqh_utility.get_all_unit_desc(p_worksheet_detail_id => p_worksheet_detail_id,

78: p_unit1_desc out nocopy varchar2,
79: p_unit2_desc out nocopy varchar2,
80: p_unit3_desc out nocopy varchar2) is
81: begin
82: pqh_utility.get_all_unit_desc(p_worksheet_detail_id => p_worksheet_detail_id,
83: p_unit1_desc => p_unit1_desc,
84: p_unit2_desc => p_unit2_desc,
85: p_unit3_desc => p_unit3_desc);
86: exception when others then

Line 94: this procedure commented out nocopy here and code being to pqh_utility package

90: raise;
91: end;
92:
93: /*
94: this procedure commented out nocopy here and code being to pqh_utility package
95:
96:
97: Procedure get_all_unit_desc(p_worksheet_detail_id in number,
98: p_unit1_desc out nocopy varchar2,

Line 178: l_unit_name := pqh_utility.get_unit_desc(p_unit_id);

174:
175: function get_unit_desc(p_unit_id in number) return varchar2 is
176: l_unit_name per_shared_types_vl.shared_type_name%type;
177: begin
178: l_unit_name := pqh_utility.get_unit_desc(p_unit_id);
179: return l_unit_name;
180: end;
181: /*
182: This function moved from here to shared aru component package pqh_utility

Line 182: This function moved from here to shared aru component package pqh_utility

178: l_unit_name := pqh_utility.get_unit_desc(p_unit_id);
179: return l_unit_name;
180: end;
181: /*
182: This function moved from here to shared aru component package pqh_utility
183: so that process log form could use it.
184:
185: function get_unit_desc(p_unit_id in number) return varchar2 is
186: cursor c1 is select shared_type_name