APPS.IGS_ADMAPPLICATION_PUB dependencies on IGS_AD_CODE_CLASSES

Line 2147: SELECT code_id FROM IGS_AD_CODE_CLASSES ac WHERE

2143: l_qualtype c_qualtype%ROWTYPE;
2144:
2145: CURSOR c_qualcode(cp_qual_code IN VARCHAR2,
2146: cp_qual_type_code IN VARCHAR2) IS
2147: SELECT code_id FROM IGS_AD_CODE_CLASSES ac WHERE
2148: UPPER(ac.NAME)=UPPER(cp_qual_code) AND ac.CLASS_TYPE_CODE='IGS_AD_QUAL_TYPE'
2149: AND UPPER(ac.CLASS) = UPPER(cp_qual_type_code);
2150:
2151: l_qualcode c_qualcode%ROWTYPE;

Line 2152: l_code_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;

2148: UPPER(ac.NAME)=UPPER(cp_qual_code) AND ac.CLASS_TYPE_CODE='IGS_AD_QUAL_TYPE'
2149: AND UPPER(ac.CLASS) = UPPER(cp_qual_type_code);
2150:
2151: l_qualcode c_qualcode%ROWTYPE;
2152: l_code_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
2153:
2154: BEGIN
2155: l_msg_index := 0;
2156: SAVEPOINT RECORD_QUALIFICATION_CODE_pub;

Line 2180: check_length('NAME', 'IGS_AD_CODE_CLASSES', length(p_qualifying_code));

2176: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
2177: -- P_qualifying_type_code
2178: check_length('QUALIFYING_TYPE_CODE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_type_code));
2179: -- P_QUALIFYING_CODE
2180: check_length('NAME', 'IGS_AD_CODE_CLASSES', length(p_qualifying_code));
2181: -- P_QUALIFYING_VALUE
2182: check_length('QUALIFYING_VALUE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_value));
2183: -- END OF PARAMETER VALIDATIONS.
2184: