eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PQHWSPCH_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_ID1;
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_ID1;
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 159: PER_SHARED_TYPES

155: CURSOR SHARED_TYPES IS
156: SELECT
157: SYSTEM_TYPE_CD
158: FROM
159: PER_SHARED_TYPES
160: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;
161: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
162: BEGIN
163: OPEN SHARED_TYPES;

Line 161: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;

157: SYSTEM_TYPE_CD
158: FROM
159: PER_SHARED_TYPES
160: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID;
161: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
162: BEGIN
163: OPEN SHARED_TYPES;
164: FETCH SHARED_TYPES
165: INTO

Line 278: PER_SHARED_TYPES

274: CURSOR SHARED_TYPES IS
275: SELECT
276: SYSTEM_TYPE_CD
277: FROM
278: PER_SHARED_TYPES
279: WHERE SHARED_TYPE_ID = BGRP_BUDGET_UNIT_ID;
280: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
281: BEGIN
282: OPEN SHARED_TYPES;

Line 280: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;

276: SYSTEM_TYPE_CD
277: FROM
278: PER_SHARED_TYPES
279: WHERE SHARED_TYPE_ID = BGRP_BUDGET_UNIT_ID;
280: L_SHARED_TYPE_CD PER_SHARED_TYPES.SYSTEM_TYPE_CD%TYPE;
281: BEGIN
282: OPEN SHARED_TYPES;
283: FETCH SHARED_TYPES
284: INTO

Line 354: PER_SHARED_TYPES

350: CURSOR CSR_UOM IS
351: SELECT
352: SYSTEM_TYPE_CD
353: FROM
354: PER_SHARED_TYPES
355: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
356: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
357: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
358: L_FORMAT_MASK VARCHAR2(50);

Line 357: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;

353: FROM
354: PER_SHARED_TYPES
355: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID
356: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
357: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
358: L_FORMAT_MASK VARCHAR2(50);
359: BEGIN
360: OPEN CSR_UOM;
361: FETCH CSR_UOM

Line 385: PER_SHARED_TYPES

381: CURSOR CSR_UOM IS
382: SELECT
383: SYSTEM_TYPE_CD
384: FROM
385: PER_SHARED_TYPES
386: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID1
387: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
388: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
389: L_FORMAT_MASK VARCHAR2(50);

Line 388: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;

384: FROM
385: PER_SHARED_TYPES
386: WHERE SHARED_TYPE_ID = BUDGET_UNIT_ID1
387: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
388: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
389: L_FORMAT_MASK VARCHAR2(50);
390: BEGIN
391: OPEN CSR_UOM;
392: FETCH CSR_UOM

Line 416: PER_SHARED_TYPES

412: CURSOR CSR_UOM IS
413: SELECT
414: SYSTEM_TYPE_CD
415: FROM
416: PER_SHARED_TYPES
417: WHERE SHARED_TYPE_ID = BGRP_BUDGET_UNIT_ID
418: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
419: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
420: L_FORMAT_MASK VARCHAR2(50);

Line 419: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;

415: FROM
416: PER_SHARED_TYPES
417: WHERE SHARED_TYPE_ID = BGRP_BUDGET_UNIT_ID
418: AND LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE';
419: L_BUDGET_MEASUREMENT_TYPE PER_SHARED_TYPES.SHARED_TYPE_NAME%TYPE;
420: L_FORMAT_MASK VARCHAR2(50);
421: BEGIN
422: OPEN CSR_UOM;
423: FETCH CSR_UOM