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.IGS_AS_VAL_UAPI dependencies on IGS_AS_UNTAS_PATTERN

Line 18: -- IGS_AS_UNTAS_PATTERN applies too. That is, the IGS_AD_LOCATION, mode and

14: gv_other_detail VARCHAR2(255);
15: BEGIN -- assp_val_uapi_uoo
16: -- This module validate that the IGS_AS_ASSESSMNT_ITM being assigned to the
17: -- IGS_AS_UNT_PATRN_ITM is valid for the IGS_PS_UNIT offering options that the
18: -- IGS_AS_UNTAS_PATTERN applies too. That is, the IGS_AD_LOCATION, mode and
19: -- class must be identical.
20: DECLARE
21: cst_null CONSTANT VARCHAR2(4) := 'NULL';
22: v_uap_location_cd IGS_AS_UNTAS_PATTERN.location_cd%TYPE;

Line 22: v_uap_location_cd IGS_AS_UNTAS_PATTERN.location_cd%TYPE;

18: -- IGS_AS_UNTAS_PATTERN applies too. That is, the IGS_AD_LOCATION, mode and
19: -- class must be identical.
20: DECLARE
21: cst_null CONSTANT VARCHAR2(4) := 'NULL';
22: v_uap_location_cd IGS_AS_UNTAS_PATTERN.location_cd%TYPE;
23: v_uap_unit_class IGS_AS_UNTAS_PATTERN.unit_class%TYPE;
24: v_uap_unit_mode IGS_AS_UNTAS_PATTERN.unit_mode%TYPE;
25: v_uai_location_cd IGS_AS_UNITASS_ITEM.location_cd%TYPE;
26: v_uai_unit_class IGS_AS_UNITASS_ITEM.unit_class%TYPE;

Line 23: v_uap_unit_class IGS_AS_UNTAS_PATTERN.unit_class%TYPE;

19: -- class must be identical.
20: DECLARE
21: cst_null CONSTANT VARCHAR2(4) := 'NULL';
22: v_uap_location_cd IGS_AS_UNTAS_PATTERN.location_cd%TYPE;
23: v_uap_unit_class IGS_AS_UNTAS_PATTERN.unit_class%TYPE;
24: v_uap_unit_mode IGS_AS_UNTAS_PATTERN.unit_mode%TYPE;
25: v_uai_location_cd IGS_AS_UNITASS_ITEM.location_cd%TYPE;
26: v_uai_unit_class IGS_AS_UNITASS_ITEM.unit_class%TYPE;
27: v_uai_unit_mode IGS_AS_UNITASS_ITEM.unit_mode%TYPE;

Line 24: v_uap_unit_mode IGS_AS_UNTAS_PATTERN.unit_mode%TYPE;

20: DECLARE
21: cst_null CONSTANT VARCHAR2(4) := 'NULL';
22: v_uap_location_cd IGS_AS_UNTAS_PATTERN.location_cd%TYPE;
23: v_uap_unit_class IGS_AS_UNTAS_PATTERN.unit_class%TYPE;
24: v_uap_unit_mode IGS_AS_UNTAS_PATTERN.unit_mode%TYPE;
25: v_uai_location_cd IGS_AS_UNITASS_ITEM.location_cd%TYPE;
26: v_uai_unit_class IGS_AS_UNITASS_ITEM.unit_class%TYPE;
27: v_uai_unit_mode IGS_AS_UNITASS_ITEM.unit_mode%TYPE;
28: CURSOR c_uap IS

Line 32: FROM IGS_AS_UNTAS_PATTERN uap

28: CURSOR c_uap IS
29: SELECT uap.location_cd,
30: uap.unit_class,
31: uap.unit_mode
32: FROM IGS_AS_UNTAS_PATTERN uap
33: WHERE uap.ass_pattern_id = p_ass_pattern_id;
34: CURSOR c_uai IS
35: SELECT uai.location_cd,
36: uai.unit_class,