DBA Data[Home] [Help]

APPS.PQH_PQHWSEPS_XMLP_PKG dependencies on PER_SHARED_TYPES

Line 71: PER_SHARED_TYPES

67: CURSOR SHARED_TYPES IS
68: SELECT
69: SYSTEM_TYPE_CD
70: FROM
71: PER_SHARED_TYPES
72: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;
73: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
74: BEGIN
75: OPEN SHARED_TYPES;

Line 73: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;

69: SYSTEM_TYPE_CD
70: FROM
71: PER_SHARED_TYPES
72: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;
73: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
74: BEGIN
75: OPEN SHARED_TYPES;
76: FETCH SHARED_TYPES
77: INTO

Line 181: PER_SHARED_TYPES

177: CURSOR SHARED_TYPES IS
178: SELECT
179: SYSTEM_TYPE_CD
180: FROM
181: PER_SHARED_TYPES
182: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID;
183: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
184: BEGIN
185: OPEN SHARED_TYPES;

Line 183: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;

179: SYSTEM_TYPE_CD
180: FROM
181: PER_SHARED_TYPES
182: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID;
183: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
184: BEGIN
185: OPEN SHARED_TYPES;
186: FETCH SHARED_TYPES
187: INTO

Line 235: PER_SHARED_TYPES

231: CURSOR CSR_UOM IS
232: SELECT
233: SYSTEM_TYPE_CD
234: FROM
235: PER_SHARED_TYPES
236: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID
237: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
238: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
239: L_FORMAT_MASK VARCHAR2(50);

Line 238: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;

234: FROM
235: PER_SHARED_TYPES
236: WHERE SHARED_TYPE_ID = ELM_BUDGET_UNIT_ID
237: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
238: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
239: L_FORMAT_MASK VARCHAR2(50);
240: BEGIN
241: OPEN CSR_UOM;
242: FETCH CSR_UOM

Line 266: PER_SHARED_TYPES

262: CURSOR CSR_UOM IS
263: SELECT
264: SYSTEM_TYPE_CD
265: FROM
266: PER_SHARED_TYPES
267: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
268: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
269: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
270: L_FORMAT_MASK VARCHAR2(50);

Line 269: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;

265: FROM
266: PER_SHARED_TYPES
267: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
268: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
269: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
270: L_FORMAT_MASK VARCHAR2(50);
271: BEGIN
272: OPEN CSR_UOM;
273: FETCH CSR_UOM