77: CURSOR SHARED_TYPES IS
78: SELECT
79: SYSTEM_TYPE_CD
80: FROM
81: PER_SHARED_TYPES
82: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;
83: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
84: BEGIN
85: OPEN SHARED_TYPES;
79: SYSTEM_TYPE_CD
80: FROM
81: PER_SHARED_TYPES
82: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;
83: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
84: BEGIN
85: OPEN SHARED_TYPES;
86: FETCH SHARED_TYPES
87: INTO
187: CURSOR SHARED_TYPES IS
188: SELECT
189: SYSTEM_TYPE_CD
190: FROM
191: PER_SHARED_TYPES
192: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID;
193: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
194: BEGIN
195: OPEN SHARED_TYPES;
189: SYSTEM_TYPE_CD
190: FROM
191: PER_SHARED_TYPES
192: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID;
193: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
194: BEGIN
195: OPEN SHARED_TYPES;
196: FETCH SHARED_TYPES
197: INTO
241: CURSOR CSR_UOM IS
242: SELECT
243: SYSTEM_TYPE_CD
244: FROM
245: PER_SHARED_TYPES
246: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID
247: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
248: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
249: L_FORMAT_MASK VARCHAR2(50);
244: FROM
245: PER_SHARED_TYPES
246: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID
247: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
248: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
249: L_FORMAT_MASK VARCHAR2(50);
250: BEGIN
251: OPEN CSR_UOM;
252: FETCH CSR_UOM
272: CURSOR CSR_UOM IS
273: SELECT
274: SYSTEM_TYPE_CD
275: FROM
276: PER_SHARED_TYPES
277: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
278: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
279: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
280: L_FORMAT_MASK VARCHAR2(50);
275: FROM
276: PER_SHARED_TYPES
277: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
278: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
279: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
280: L_FORMAT_MASK VARCHAR2(50);
281: BEGIN
282: OPEN CSR_UOM;
283: FETCH CSR_UOM