DBA Data[Home] [Help]

APPS.PQH_PQHWSEES_XMLP_PKG dependencies on PER_SHARED_TYPES

Line 81: PER_SHARED_TYPES

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;

Line 83: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;

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

Line 191: PER_SHARED_TYPES

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;

Line 193: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;

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

Line 245: PER_SHARED_TYPES

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);

Line 248: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;

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

Line 276: PER_SHARED_TYPES

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);

Line 279: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;

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