APPS.PQH_PQHWSOPS_XMLP_PKG dependencies on PER_SHARED_TYPES

Line 78: from Per_Shared_types

74:
75: function cf_1formula(Budget_Unit_id1 in number, actual_amt in number, committed_amt in number) return number is
76: Cursor Shared_types is
77: Select System_Type_cd
78: from Per_Shared_types
79: Where Shared_type_id = Budget_Unit_id1;
80:
81: L_Shared_type_Cd Per_Shared_Types.System_Type_Cd%TYPE;
82: begin

Line 81: L_Shared_type_Cd Per_Shared_Types.System_Type_Cd%TYPE;

77: Select System_Type_cd
78: from Per_Shared_types
79: Where Shared_type_id = Budget_Unit_id1;
80:
81: L_Shared_type_Cd Per_Shared_Types.System_Type_Cd%TYPE;
82: begin
83: Open Shared_types;
84: Fetch Shared_types into l_Shared_Type_Cd;
85: Close ShaRED_TYPES;

Line 220: from Per_Shared_types

216:
217: function cf_org_projected_expformula(Budget_Unit_id in number, cf_org_actual_amt in number, cf_org_committed_amt in number) return number is
218: Cursor Shared_types is
219: Select System_Type_cd
220: from Per_Shared_types
221: Where Shared_type_id = Budget_Unit_id;
222:
223: L_Shared_type_Cd Per_Shared_Types.System_Type_Cd%TYPE;
224: begin

Line 223: L_Shared_type_Cd Per_Shared_Types.System_Type_Cd%TYPE;

219: Select System_Type_cd
220: from Per_Shared_types
221: Where Shared_type_id = Budget_Unit_id;
222:
223: L_Shared_type_Cd Per_Shared_Types.System_Type_Cd%TYPE;
224: begin
225: Open Shared_types;
226: Fetch Shared_types into l_Shared_Type_Cd;
227: Close ShaRED_TYPES;

Line 261: from per_shared_types

257:
258: function cf_format_mask1(budget_unit_id in number) return char is
259: cursor csr_uom is
260: select system_type_cd
261: from per_shared_types
262: where shared_type_id = budget_unit_id and
263: lookup_type = 'BUDGET_MEASUREMENT_TYPE';
264:
265: l_budget_measurement_type per_shared_types.shared_type_name%TYPE;

Line 265: l_budget_measurement_type per_shared_types.shared_type_name%TYPE;

261: from per_shared_types
262: where shared_type_id = budget_unit_id and
263: lookup_type = 'BUDGET_MEASUREMENT_TYPE';
264:
265: l_budget_measurement_type per_shared_types.shared_type_name%TYPE;
266: l_format_mask varchar2(50);
267: BEGIN
268: open csr_uom;
269: fetch csr_uom into l_budget_measurement_type;

Line 283: from per_shared_types

279:
280: function cf_format_mask2(budget_unit_id1 in number) return char is
281: cursor csr_uom is
282: select system_type_cd
283: from per_shared_types
284: where shared_type_id = budget_unit_id1 and
285: lookup_type = 'BUDGET_MEASUREMENT_TYPE';
286:
287: l_budget_measurement_type per_shared_types.shared_type_name%TYPE;

Line 287: l_budget_measurement_type per_shared_types.shared_type_name%TYPE;

283: from per_shared_types
284: where shared_type_id = budget_unit_id1 and
285: lookup_type = 'BUDGET_MEASUREMENT_TYPE';
286:
287: l_budget_measurement_type per_shared_types.shared_type_name%TYPE;
288: l_format_mask varchar2(50);
289: BEGIN
290: open csr_uom;
291: fetch csr_uom into l_budget_measurement_type;