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.IGF_AP_LI_ISIR_IMP_PROC dependencies on DBMS_UTILITY

Line 3123: lookups_table dbms_utility.uncl_array;

3119:
3120:
3121: PROCEDURE put_meaning(list IN VARCHAR2)
3122: AS
3123: lookups_table dbms_utility.uncl_array;
3124: -- Get the details of
3125: CURSOR c_meaning(p_lookup_code VARCHAR2,
3126: p_lookup_type VARCHAR2)
3127: IS

Line 3137: dbms_utility.comma_to_table(list,tablen,lookups_table);

3133: c_meaning_rec c_meaning%ROWTYPE;
3134: l_hash_value NUMBER;
3135: tablen NUMBER;
3136: BEGIN
3137: dbms_utility.comma_to_table(list,tablen,lookups_table);
3138: FOR i IN lookups_table.FIRST .. lookups_table.LAST
3139: LOOP
3140: c_meaning_rec := NULL;
3141: OPEN c_meaning(lookups_table(i),'IGF_AW_LOOKUPS_MSG');

Line 3144: l_hash_value := dbms_utility.get_hash_value(

3140: c_meaning_rec := NULL;
3141: OPEN c_meaning(lookups_table(i),'IGF_AW_LOOKUPS_MSG');
3142: FETCH c_meaning INTO c_meaning_rec;
3143: CLOSE c_meaning;
3144: l_hash_value := dbms_utility.get_hash_value(
3145: lookups_table(i),
3146: 1000,
3147: 25000);
3148: lookup_meaning_table(l_hash_value).field_name:=lookups_table(i);

Line 3170: lookups_table DBMS_UTILITY.uncl_array;

3166: || Who When What
3167: || (reverse chronological order - newest change first)
3168: */
3169: tablen BINARY_INTEGER ;
3170: lookups_table DBMS_UTILITY.uncl_array;
3171: l_hash_value NUMBER;
3172:
3173:
3174: -- Get the details of

Line 3188: DBMS_UTILITY.comma_to_table(list,tablen,lookups_table);

3184:
3185: l_lookup_values c_lookup_values%ROWTYPE;
3186:
3187: BEGIN
3188: DBMS_UTILITY.comma_to_table(list,tablen,lookups_table);
3189:
3190: FOR i IN lookups_table.FIRST .. lookups_table.LAST
3191: LOOP
3192:

Line 3196: l_hash_value := DBMS_UTILITY.get_hash_value(

3192:
3193:
3194: FOR rec IN c_lookup_values(lookups_table(i),p_award_year)
3195: LOOP
3196: l_hash_value := DBMS_UTILITY.get_hash_value(
3197: RTRIM(LTRIM(lookups_table(i)))||'@*?'||rec.lookup_code,
3198: 1000,
3199: 25000);
3200:

Line 3233: l_hash_value := dbms_utility.get_hash_value(

3229: l_lookup_type igf_aw_lookups_view. lookup_type%TYPE;
3230: BEGIN
3231:
3232:
3233: l_hash_value := dbms_utility.get_hash_value(
3234: RTRIM(LTRIM(p_lookup_type))||'@*?'|| RTRIM(LTRIM(p_lookup_code)),
3235: 1000,
3236: 25000);
3237:

Line 3328: l_hash_value := dbms_utility.get_hash_value(string,1000,25000);

3324: */
3325:
3326: BEGIN
3327:
3328: l_hash_value := dbms_utility.get_hash_value(string,1000,25000);
3329: END get_hash_value;
3330:
3331:
3332: FUNCTION Val_Name ( l_length IN NUMBER,

Line 4042: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',

4038:
4039: IF NOT l_ret_val THEN
4040: p_status:=FALSE;
4041: indx:= indx+1;
4042: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',
4043: 1000,
4044: 25000);
4045: p_igf_ap_message_table(indx).field_name:='';
4046: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_STATE_LEGAL_RESIDENCE_TXT');

Line 4058: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',

4054:
4055: IF NOT l_ret_val THEN
4056: p_status:=FALSE;
4057: indx:= indx+1;
4058: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',
4059: 1000,
4060: 25000);
4061: p_igf_ap_message_table(indx).field_name:='';
4062: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('S_STATE_LEGAL_RESIDENCE');

Line 4072: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',

4068: l_ret_val:=is_lookup_code_exist(p_isir_rec.perm_state_txt,'IGF_AP_STATE_CODES');
4069: IF NOT l_ret_val THEN
4070: p_status:=FALSE;
4071: indx:= indx+1;
4072: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',
4073: 1000,
4074: 25000);
4075: p_igf_ap_message_table(indx).field_name:='';
4076: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('PERM_STATE_TXT');

Line 4086: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',

4082: l_ret_val:=is_lookup_code_exist(p_isir_rec.driver_license_state_txt,'IGF_AP_STATE_CODES');
4083: IF NOT l_ret_val THEN
4084: p_status:=FALSE;
4085: indx:= indx+1;
4086: l_hash_value:=dbms_utility.get_hash_value('STATE_CODES',
4087: 1000,
4088: 25000);
4089: p_igf_ap_message_table(indx).field_name:=' ';
4090: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('DRIVER_LICENSE_STATE_TXT');

Line 4099: l_hash_value:=dbms_utility.get_hash_value('CITIZENSHIP_TYPES',

4095: l_ret_val:=is_lookup_code_exist(p_isir_rec.citizenship_status_type,'IGF_CITIZENSHIP_TYPE');
4096: IF NOT l_ret_val THEN
4097: p_status:=FALSE;
4098: indx:= indx+1;
4099: l_hash_value:=dbms_utility.get_hash_value('CITIZENSHIP_TYPES',
4100: 1000,
4101: 25000);
4102: p_igf_ap_message_table(indx).field_name:=' ';
4103: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('CITIZENSHIP_STATUS_TYPE');

Line 4113: l_hash_value:=dbms_utility.get_hash_value('MARITAL_STATUSES',

4109: l_ret_val:=is_lookup_code_exist( p_isir_rec.s_marital_status_type,'IGF_ST_MARITAL_STAT_TYPE');
4110: IF NOT l_ret_val THEN
4111: p_status:=FALSE;
4112: indx:= indx+1;
4113: l_hash_value:=dbms_utility.get_hash_value('MARITAL_STATUSES',
4114: 1000,
4115: 25000);
4116: p_igf_ap_message_table(indx).field_name:=' ';
4117: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('S_MARITAL_STATUS_TYPE');

Line 4129: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',

4125: l_ret_val:=is_lookup_code_exist( p_isir_rec.summ_enrl_status_type,'IGF_ENROLMENT_TYPE');
4126: IF NOT l_ret_val THEN
4127: p_status:=FALSE;
4128: indx:= indx+1;
4129: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',
4130: 1000,
4131: 25000);
4132:
4133: p_igf_ap_message_table(indx).field_name:=' ';

Line 4141: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',

4137: l_ret_val:=is_lookup_code_exist( p_isir_rec.summ_enrl_status_type,'IGF_AP_ENROLLMENT_STATUS_TYPE');
4138: IF NOT l_ret_val THEN
4139: p_status:=FALSE;
4140: indx:= indx+1;
4141: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',
4142: 1000,
4143: 25000);
4144:
4145: p_igf_ap_message_table(indx).field_name:=' ';

Line 4156: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',

4152: l_ret_val:=is_lookup_code_exist(p_isir_rec.fall_enrl_status_type,'IGF_ENROLMENT_TYPE');
4153: IF NOT l_ret_val THEN
4154: p_status:=FALSE;
4155: indx:= indx+1;
4156: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',
4157: 1000,
4158: 25000);
4159: p_igf_ap_message_table(indx).field_name:=' ';
4160: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('FALL_ENRL_STATUS_TYPE');

Line 4180: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',

4176: l_ret_val:=is_lookup_code_exist(p_isir_rec.winter_enrl_status_type,'IGF_ENROLMENT_TYPE');
4177: IF NOT l_ret_val THEN
4178: p_status:=FALSE;
4179: indx:= indx+1;
4180: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',
4181: 1000,
4182: 25000);
4183: p_igf_ap_message_table(indx).field_name:=' ';
4184: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('WINTER_ENRL_STATUS_TYPE');

Line 4204: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',

4200: l_ret_val:=is_lookup_code_exist(p_isir_rec.spring_enrl_status_type,'IGF_ENROLMENT_TYPE');
4201: IF NOT l_ret_val THEN
4202: p_status:=FALSE;
4203: indx:= indx+1;
4204: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',
4205: 1000,
4206: 25000);
4207: p_igf_ap_message_table(indx).field_name:=' ';
4208: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('SPRING_ENRL_STATUS_TYPE');

Line 4229: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',

4225: l_ret_val:=is_lookup_code_exist(p_isir_rec.summ2_enrl_status_type,'IGF_ENROLMENT_TYPE');
4226: IF NOT l_ret_val THEN
4227: p_status:=FALSE;
4228: indx:= indx+1;
4229: l_hash_value:=dbms_utility.get_hash_value('ENROLLMENT_TYPES',
4230: 1000,
4231: 25000);
4232: p_igf_ap_message_table(indx).field_name:=' ';
4233: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('SUMM2_ENRL_STATUS_TYPE');

Line 4252: l_hash_value:=dbms_utility.get_hash_value('HIGHGRADLEVEL_TYPES',

4248: l_ret_val:=is_lookup_code_exist(p_isir_rec.fathers_highest_edu_level_type,'IGF_HIGH_GRAD_LVL_TYPE');
4249: IF NOT l_ret_val THEN
4250: p_status:=FALSE;
4251: indx:= indx+1;
4252: l_hash_value:=dbms_utility.get_hash_value('HIGHGRADLEVEL_TYPES',
4253: 1000,
4254: 25000);
4255: p_igf_ap_message_table(indx).field_name:=' ';
4256: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('FATHERS_HIGHEST_EDU_LEVEL_TYPE');

Line 4265: l_hash_value:=dbms_utility.get_hash_value('HIGHGRADLEVEL_TYPES',

4261: l_ret_val:=is_lookup_code_exist(p_isir_rec.mothers_highest_edu_level_type,'IGF_HIGH_GRAD_LVL_TYPE');
4262: IF NOT l_ret_val THEN
4263: p_status:=FALSE;
4264: indx:= indx+1;
4265: l_hash_value:=dbms_utility.get_hash_value('HIGHGRADLEVEL_TYPES',
4266: 1000,
4267: 25000);
4268: p_igf_ap_message_table(indx).field_name:=' ';
4269: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('MOTHERS_HIGHEST_EDU_LEVEL_TYPE');

Line 4279: l_hash_value:=dbms_utility.get_hash_value('DEGCERT_TYPES',

4275: l_ret_val:=is_lookup_code_exist(p_isir_rec.degree_certification_type,'IGF_DEG_CERT_TYPE');
4276: IF NOT l_ret_val THEN
4277: p_status:=FALSE;
4278: indx:= indx+1;
4279: l_hash_value:=dbms_utility.get_hash_value('DEGCERT_TYPES',
4280: 1000,
4281: 25000);
4282: p_igf_ap_message_table(indx).field_name:=' ';
4283: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('DEGREE_CERTIFICATION_TYPE');

Line 4292: l_hash_value:=dbms_utility.get_hash_value('GRADE_LEVELS',

4288: l_ret_val:=is_lookup_code_exist(p_isir_rec.grade_level_in_college_type,'IGF_AP_GRADE_LEVEL');
4289: IF NOT l_ret_val THEN
4290: p_status:=FALSE;
4291: indx:= indx+1;
4292: l_hash_value:=dbms_utility.get_hash_value('GRADE_LEVELS',
4293: 1000,
4294: 25000);
4295: p_igf_ap_message_table(indx).field_name:=' ';
4296: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('GRADE_LEVEL_IN_COLLEGE_TYPE');

Line 4306: l_hash_value:=dbms_utility.get_hash_value('DRUG_CONVICTS',

4302: l_ret_val:=is_lookup_code_exist(p_isir_rec.drug_offence_conviction_type,'IGF_DRUG_ELIGIBILITY_TYPE');
4303: IF NOT l_ret_val THEN
4304: p_status:=FALSE;
4305: indx:= indx+1;
4306: l_hash_value:=dbms_utility.get_hash_value('DRUG_CONVICTS',
4307: 1000,
4308: 25000);
4309: p_igf_ap_message_table(indx).field_name:=' ';
4310: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('DRUG_OFFENCE_CONVICTION_TYPE');

Line 4320: l_hash_value:=dbms_utility.get_hash_value('TAXRETSTAT_TYPES',

4316: l_ret_val:=is_lookup_code_exist(p_isir_rec.s_tax_return_status_type,'IGF_TAX_RET_STAT_TYPE');
4317: IF NOT l_ret_val THEN
4318: p_status:=FALSE;
4319: indx:= indx+1;
4320: l_hash_value:=dbms_utility.get_hash_value('TAXRETSTAT_TYPES',
4321: 1000,
4322: 25000);
4323: p_igf_ap_message_table(indx).field_name:=' ';
4324: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('S_TAX_RETURN_STATUS_TYPE');

Line 4334: l_hash_value:=dbms_utility.get_hash_value('TAXRETSTAT_TYPES',

4330: l_ret_val:=is_lookup_code_exist(p_isir_rec.p_tax_return_status_type,'IGF_TAX_RET_STAT_TYPE') ;
4331: IF NOT l_ret_val THEN
4332: p_status:=FALSE;
4333: indx:= indx+1;
4334: l_hash_value:=dbms_utility.get_hash_value('TAXRETSTAT_TYPES',
4335: 1000,
4336: 25000);
4337: p_igf_ap_message_table(indx).field_name:=' ';
4338: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_TAX_RETURN_STATUS_TYPE');

Line 4347: l_hash_value:=dbms_utility.get_hash_value('TAXFORM_TYPES',

4343: l_ret_val:=is_lookup_code_exist(p_isir_rec.s_type_tax_return_type,'IGF_TAX_FORM_TYPE');
4344: IF NOT l_ret_val THEN
4345: p_status:=FALSE;
4346: indx:= indx+1;
4347: l_hash_value:=dbms_utility.get_hash_value('TAXFORM_TYPES',
4348: 1000,
4349: 25000);
4350: p_igf_ap_message_table(indx).field_name:=' ';
4351: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('S_TYPE_TAX_RETURN_TYPE');

Line 4361: l_hash_value:=dbms_utility.get_hash_value('TAXFORM_TYPES',

4357: l_ret_val:=is_lookup_code_exist(p_isir_rec.p_type_tax_return_type,'IGF_TAX_FORM_TYPE');
4358: IF NOT l_ret_val THEN
4359: p_status:=FALSE;
4360: indx:= indx+1;
4361: l_hash_value:=dbms_utility.get_hash_value('TAXFORM_TYPES',
4362: 1000,
4363: 25000);
4364: p_igf_ap_message_table(indx).field_name:=' ';
4365: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_TYPE_TAX_RETURN_TYPE');

Line 4374: l_hash_value:=dbms_utility.get_hash_value('TAXEXEM_ELIGTYPES',

4370: l_ret_val:=is_lookup_code_exist(p_isir_rec.s_elig_1040ez_type,'IGF_TAX_EXEMPTION_ELIG_TYPE');
4371: IF NOT l_ret_val THEN
4372: p_status:=FALSE;
4373: indx:= indx+1;
4374: l_hash_value:=dbms_utility.get_hash_value('TAXEXEM_ELIGTYPES',
4375: 1000,
4376: 25000);
4377: p_igf_ap_message_table(indx).field_name:=' ';
4378: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('S_ELIG_1040EZ_TYPE');

Line 4387: l_hash_value:=dbms_utility.get_hash_value('TAXEXEM_ELIGTYPES',

4383: l_ret_val:=is_lookup_code_exist(p_isir_rec.p_elig_1040aez_type,'IGF_TAX_EXEMPTION_ELIG_TYPE');
4384: IF NOT l_ret_val THEN
4385: p_status:=FALSE;
4386: indx:= indx+1;
4387: l_hash_value:=dbms_utility.get_hash_value('TAXEXEM_ELIGTYPES',
4388: 1000,
4389: 25000);
4390: p_igf_ap_message_table(indx).field_name:=' ';
4391: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_ELIG_1040AEZ_TYPE');

Line 4400: l_hash_value:=dbms_utility.get_hash_value('PMARITAL_STATUSES',

4396: l_ret_val:=is_lookup_code_exist(p_isir_rec.p_marital_status_type,'IGF_P_MARITAL_STAT_TYPE');
4397: IF NOT l_ret_val THEN
4398: p_status:=FALSE;
4399: indx:= indx+1;
4400: l_hash_value:=dbms_utility.get_hash_value('PMARITAL_STATUSES',
4401: 1000,
4402: 25000);
4403: p_igf_ap_message_table(indx).field_name:=' ';
4404: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_MARITAL_STATUS_TYPE');

Line 4413: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',

4409: l_ret_val:=is_lookup_code_exist(p_isir_rec.first_house_plan_type,'IGF_AP_HOUSING_STAT');
4410: IF NOT l_ret_val THEN
4411: p_status:=FALSE;
4412: indx:= indx+1;
4413: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',
4414: 1000,
4415: 25000);
4416: p_igf_ap_message_table(indx).field_name:=' ';
4417: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('FIRST_HOUSE_PLAN_TYPE');

Line 4426: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',

4422: l_ret_val:=is_lookup_code_exist(p_isir_rec.second_house_plan_type,'IGF_AP_HOUSING_STAT');
4423: IF NOT l_ret_val THEN
4424: p_status:=FALSE;
4425: indx:= indx+1;
4426: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',
4427: 1000,
4428: 25000);
4429: p_igf_ap_message_table(indx).field_name:=' ';
4430: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('SECOND_HOUSE_PLAN_TYPE');

Line 4439: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',

4435: l_ret_val:=is_lookup_code_exist(p_isir_rec.third_house_plan_type,'IGF_AP_HOUSING_STAT');
4436: IF NOT l_ret_val THEN
4437: p_status:=FALSE;
4438: indx:= indx+1;
4439: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',
4440: 1000,
4441: 25000);
4442: p_igf_ap_message_table(indx).field_name:=' ';
4443: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('THIRD_HOUSE_PLAN_TYPE');

Line 4452: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',

4448: l_ret_val:=is_lookup_code_exist(p_isir_rec.fourth_house_plan_type,'IGF_AP_HOUSING_STAT');
4449: IF NOT l_ret_val THEN
4450: p_status:=FALSE;
4451: indx:= indx+1;
4452: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',
4453: 1000,
4454: 25000);
4455: p_igf_ap_message_table(indx).field_name:=' ';
4456: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('FOURTH_HOUSE_PLAN_TYPE');

Line 4466: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',

4462: l_ret_val:=is_lookup_code_exist(p_isir_rec.fifth_house_plan_type,'IGF_AP_HOUSING_STAT');
4463: IF NOT l_ret_val THEN
4464: p_status:=FALSE;
4465: indx:= indx+1;
4466: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',
4467: 1000,
4468: 25000);
4469: p_igf_ap_message_table(indx).field_name:=' ';
4470: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('FIFTH_HOUSE_PLAN_TYPE');

Line 4480: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',

4476: l_ret_val:=is_lookup_code_exist(p_isir_rec.sixth_house_plan_type,'IGF_AP_HOUSING_STAT');
4477: IF NOT l_ret_val THEN
4478: p_status:=FALSE;
4479: indx:= indx+1;
4480: l_hash_value:=dbms_utility.get_hash_value('HOUSING_STATS',
4481: 1000,
4482: 25000);
4483: p_igf_ap_message_table(indx).field_name:=' ';
4484: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('SIXTH_HOUSE_PLAN_TYPE');

Line 4494: l_hash_value:=dbms_utility.get_hash_value('IGF_AP_CSS_DEP_STATUS',

4490: l_ret_val:= is_lookup_code_exist(p_isir_rec.dependency_status_type,'IGF_AP_DEP_STATUS');
4491: IF NOT l_ret_val THEN
4492: p_status:=FALSE;
4493: indx:= indx+1;
4494: l_hash_value:=dbms_utility.get_hash_value('IGF_AP_CSS_DEP_STATUS',
4495: 1000,
4496: 25000);
4497: p_igf_ap_message_table(indx).field_name:=' ';
4498: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('DEPENDENCY_STATUS_TYPE');