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.

[Home] [Help]

APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on DBMS_UTILITY

Line 3054: l_hash_value := DBMS_UTILITY.get_hash_value(

3050: l_lookup_type igf_aw_lookups_view.lookup_type%TYPE;
3051: BEGIN
3052:
3053:
3054: l_hash_value := DBMS_UTILITY.get_hash_value(
3055: RTRIM(LTRIM(p_lookup_type))||'@*?'|| RTRIM(LTRIM(p_lookup_code)),
3056: 1000,
3057: 25000);
3058:

Line 3088: lookups_table DBMS_UTILITY.uncl_array;

3084: || Who When What
3085: || (reverse chronological order - newest change first)
3086: */
3087: tablen BINARY_INTEGER ;
3088: lookups_table DBMS_UTILITY.uncl_array;
3089: l_hash_value NUMBER;
3090:
3091:
3092: -- Get the details of

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

3102:
3103: l_lookup_values c_lookup_values%ROWTYPE;
3104:
3105: BEGIN
3106: DBMS_UTILITY.comma_to_table(list,tablen,lookups_table);
3107:
3108: FOR i IN lookups_table.FIRST .. lookups_table.LAST
3109: LOOP
3110:

Line 3114: l_hash_value := DBMS_UTILITY.get_hash_value(

3110:
3111:
3112: FOR rec IN c_lookup_values(lookups_table(i),p_award_year)
3113: LOOP
3114: l_hash_value := DBMS_UTILITY.get_hash_value(
3115: RTRIM(LTRIM(lookups_table(i)))||'@*?'||rec.lookup_code,
3116: 1000,
3117: 25000);
3118:

Line 3134: lookups_table DBMS_UTILITY.uncl_array;

3130: END put_hash_values ;
3131:
3132: PROCEDURE put_meaning(list IN VARCHAR2)
3133: AS
3134: lookups_table DBMS_UTILITY.uncl_array;
3135: -- Get the details of
3136: CURSOR c_meaning(p_lookup_code VARCHAR2,
3137: p_lookup_type VARCHAR2)
3138: IS

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

3145: c_meaning_rec c_meaning%ROWTYPE;
3146: l_hash_value NUMBER;
3147: tablen NUMBER;
3148: BEGIN
3149: DBMS_UTILITY.comma_to_table(list,tablen,lookups_table);
3150: FOR i IN lookups_table.FIRST .. lookups_table.LAST
3151: LOOP
3152: c_meaning_rec := NULL;
3153: OPEN c_meaning(lookups_table(i),'IGF_AW_LOOKUPS_MSG');

Line 3156: l_hash_value := DBMS_UTILITY.get_hash_value(

3152: c_meaning_rec := NULL;
3153: OPEN c_meaning(lookups_table(i),'IGF_AW_LOOKUPS_MSG');
3154: FETCH c_meaning INTO c_meaning_rec;
3155: CLOSE c_meaning;
3156: l_hash_value := DBMS_UTILITY.get_hash_value(
3157: lookups_table(i),
3158: 1000,
3159: 25000);
3160: lookup_meaning_table(l_hash_value).field_name:=lookups_table(i);

Line 4681: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',

4677:
4678: IF NOT l_ret_val THEN
4679: p_status:=FALSE;
4680: indx:= indx+1;
4681: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4682: 1000,
4683: 25000);
4684: p_igf_ap_message_table(indx).field_name:='';
4685: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_2_ATTEND_COLLEGE_TYPE');

Line 4700: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',

4696:
4697: IF NOT l_ret_val THEN
4698: p_status:=FALSE;
4699: indx:= indx+1;
4700: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4701: 1000,
4702: 25000);
4703: p_igf_ap_message_table(indx).field_name:='';
4704: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_3_ATTEND_COLLEGE_TYPE');

Line 4719: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',

4715:
4716: IF NOT l_ret_val THEN
4717: p_status:=FALSE;
4718: indx:= indx+1;
4719: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4720: 1000,
4721: 25000);
4722: p_igf_ap_message_table(indx).field_name:='';
4723: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_4_ATTEND_COLLEGE_TYPE');

Line 4738: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',

4734:
4735: IF NOT l_ret_val THEN
4736: p_status:=FALSE;
4737: indx:= indx+1;
4738: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4739: 1000,
4740: 25000);
4741: p_igf_ap_message_table(indx).field_name:='';
4742: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_5_ATTEND_COLLEGE_TYPE');

Line 4757: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',

4753:
4754: IF NOT l_ret_val THEN
4755: p_status:=FALSE;
4756: indx:= indx+1;
4757: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4758: 1000,
4759: 25000);
4760: p_igf_ap_message_table(indx).field_name:='';
4761: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_6_ATTEND_COLLEGE_TYPE');

Line 4776: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',

4772:
4773: IF NOT l_ret_val THEN
4774: p_status:=FALSE;
4775: indx:= indx+1;
4776: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4777: 1000,
4778: 25000);
4779: -- fnd_file.put_line(fnd_file.log,'l_hash_value :'||l_hash_value );
4780: p_igf_ap_message_table(indx).field_name:='';

Line 4796: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',

4792:
4793: IF NOT l_ret_val THEN
4794: p_status:=FALSE;
4795: indx:= indx+1;
4796: l_hash_value:=DBMS_UTILITY.get_hash_value('ATTENDS_COLLEGE',
4797: 1000,
4798: 25000);
4799: p_igf_ap_message_table(indx).field_name:='';
4800: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_8_ATTEND_COLLEGE_TYPE');

Line 4815: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',

4811:
4812: IF NOT l_ret_val THEN
4813: p_status:=FALSE;
4814: indx:= indx+1;
4815: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',
4816: 1000,
4817: 25000);
4818: p_igf_ap_message_table(indx).field_name:='';
4819: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COLLEGE_2_TYPE');

Line 4834: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',

4830:
4831: IF NOT l_ret_val THEN
4832: p_status:=FALSE;
4833: indx:= indx+1;
4834: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',
4835: 1000,
4836: 25000);
4837: p_igf_ap_message_table(indx).field_name:='';
4838: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COLLEGE_3_TYPE');

Line 4853: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',

4849:
4850: IF NOT l_ret_val THEN
4851: p_status:=FALSE;
4852: indx:= indx+1;
4853: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',
4854: 1000,
4855: 25000);
4856: p_igf_ap_message_table(indx).field_name:='';
4857: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COLLEGE_4_TYPE');

Line 4871: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',

4867:
4868: IF NOT l_ret_val THEN
4869: p_status:=FALSE;
4870: indx:= indx+1;
4871: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',
4872: 1000,
4873: 25000);
4874: p_igf_ap_message_table(indx).field_name:='';
4875: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COLLEGE_5_TYPE');

Line 4889: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',

4885:
4886: IF NOT l_ret_val THEN
4887: p_status:=FALSE;
4888: indx:= indx+1;
4889: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',
4890: 1000,
4891: 25000);
4892: p_igf_ap_message_table(indx).field_name:='';
4893: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COLLEGE_6_TYPE');

Line 4908: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',

4904:
4905: IF NOT l_ret_val THEN
4906: p_status:=FALSE;
4907: indx:= indx+1;
4908: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',
4909: 1000,
4910: 25000);
4911: p_igf_ap_message_table(indx).field_name:='';
4912: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COLLEGE_7_TYPE');

Line 4926: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',

4922:
4923: IF NOT l_ret_val THEN
4924: p_status:=FALSE;
4925: indx:= indx+1;
4926: l_hash_value:=DBMS_UTILITY.get_hash_value('COLLEGE_TYPE',
4927: 1000,
4928: 25000);
4929: p_igf_ap_message_table(indx).field_name:='';
4930: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COLLEGE_8_TYPE');

Line 4944: l_hash_value:=DBMS_UTILITY.get_hash_value('FINANCIAL_AID_STATUS',

4940:
4941: IF NOT l_ret_val THEN
4942: p_status:=FALSE;
4943: indx:= indx+1;
4944: l_hash_value:=DBMS_UTILITY.get_hash_value('FINANCIAL_AID_STATUS',
4945: 1000,
4946: 25000);
4947: p_igf_ap_message_table(indx).field_name:='';
4948: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('FINANCIAL_AID_STATUS_TYPE');

Line 4962: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_STATE_CODES',

4958:
4959: IF NOT l_ret_val THEN
4960: p_status:=FALSE;
4961: indx:= indx+1;
4962: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_STATE_CODES',
4963: 1000,
4964: 25000);
4965: p_igf_ap_message_table(indx).field_name:='';
4966: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('STATE_MAILING_TXT');

Line 4980: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_STATE_CODES',

4976:
4977: IF NOT l_ret_val THEN
4978: p_status:=FALSE;
4979: indx:= indx+1;
4980: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_STATE_CODES',
4981: 1000,
4982: 25000);
4983: p_igf_ap_message_table(indx).field_name:='';
4984: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('STATE_LEGAL_RESIDENCE_TXT');

Line 4998: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_STATE_CODES',

4994:
4995: IF NOT l_ret_val THEN
4996: p_status:=FALSE;
4997: indx:= indx+1;
4998: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_STATE_CODES',
4999: 1000,
5000: 25000);
5001: p_igf_ap_message_table(indx).field_name:='';
5002: 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_CD');

Line 5016: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5012:
5013: IF NOT l_ret_val THEN
5014: p_status:=FALSE;
5015: indx:= indx+1;
5016: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5017: 1000,
5018: 25000);
5019: p_igf_ap_message_table(indx).field_name:='';
5020: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('WARD_COURT_FLAG');

Line 5034: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5030:
5031: IF NOT l_ret_val THEN
5032: p_status:=FALSE;
5033: indx:= indx+1;
5034: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5035: 1000,
5036: 25000);
5037: p_igf_ap_message_table(indx).field_name:='';
5038: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LEGAL_DEPENDENTS_OTHER_FLAG');

Line 5052: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5048:
5049: IF NOT l_ret_val THEN
5050: p_status:=FALSE;
5051: indx:= indx+1;
5052: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5053: 1000,
5054: 25000);
5055: p_igf_ap_message_table(indx).field_name:='';
5056: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LIVE_ON_FARM_FLAG');

Line 5070: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5066:
5067: IF NOT l_ret_val THEN
5068: p_status:=FALSE;
5069: indx:= indx+1;
5070: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5071: 1000,
5072: 25000);
5073: p_igf_ap_message_table(indx).field_name:='';
5074: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('TRUST_AVAIL_FLAG');

Line 5088: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5084:
5085: IF NOT l_ret_val THEN
5086: p_status:=FALSE;
5087: indx:= indx+1;
5088: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5089: 1000,
5090: 25000);
5091: p_igf_ap_message_table(indx).field_name:='';
5092: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('VET_US_FLAG');

Line 5106: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5102:
5103: IF NOT l_ret_val THEN
5104: p_status:=FALSE;
5105: indx:= indx+1;
5106: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5107: 1000,
5108: 25000);
5109: p_igf_ap_message_table(indx).field_name:='';
5110: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_NATURAL_PAR_STATUS_FLAG');

Line 5126: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5122:
5123: IF NOT l_ret_val THEN
5124: p_status:=FALSE;
5125: indx:= indx+1;
5126: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5127: 1000,
5128: 25000);
5129: p_igf_ap_message_table(indx).field_name:='';
5130: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_OWN_BUSINESS_FARM_FLAG');

Line 5144: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',

5140:
5141: IF NOT l_ret_val THEN
5142: p_status:=FALSE;
5143: indx:= indx+1;
5144: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_YES_NO',
5145: 1000,
5146: 25000);
5147: p_igf_ap_message_table(indx).field_name:='';
5148: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_LIVE_ON_FARM_NUM');

Line 5162: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_CITIZENSHIP_TYPE',

5158:
5159: IF NOT l_ret_val THEN
5160: p_status:=FALSE;
5161: indx:= indx+1;
5162: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_CITIZENSHIP_TYPE',
5163: 1000,
5164: 25000);
5165: p_igf_ap_message_table(indx).field_name:='';
5166: 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 5180: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_ONE_DIGIT',

5176:
5177: IF NOT l_ret_val THEN
5178: p_status:=FALSE;
5179: indx:= indx+1;
5180: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_ONE_DIGIT',
5181: 1000,
5182: 25000);
5183: p_igf_ap_message_table(indx).field_name:='';
5184: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('NUMBER_IN_COLLEGE_NUM');

Line 5198: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_ST_MARITAL_STAT_TYPE',

5194:
5195: IF NOT l_ret_val THEN
5196: p_status:=FALSE;
5197: indx:= indx+1;
5198: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_ST_MARITAL_STAT_TYPE',
5199: 1000,
5200: 25000);
5201: p_igf_ap_message_table(indx).field_name:='';
5202: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('MARITAL_STATUS_FLAG');

Line 5216: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_ST_MARITAL_STAT_TYPE',

5212:
5213: IF NOT l_ret_val THEN
5214: p_status:=FALSE;
5215: indx:= indx+1;
5216: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_ST_MARITAL_STAT_TYPE',
5217: 1000,
5218: 25000);
5219: p_igf_ap_message_table(indx).field_name:='';
5220: 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 5233: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);

5229: l_ret_val:=is_lookup_code_exist(p_profile_rec.TAX_FIGURES_TYPE,'IGF_TAX_FIGURES_0405');
5230: IF NOT l_ret_val THEN
5231: p_status:=FALSE;
5232: indx:= indx+1;
5233: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);
5234: p_igf_ap_message_table(indx).field_name:='';
5235: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('TAX_FIGURES_TYPE');
5236: END IF;
5237: ELSE

Line 5242: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);

5238: l_ret_val:=is_lookup_code_exist(p_profile_rec.TAX_FIGURES_TYPE,'IGF_TAX_FIGURES');
5239: IF NOT l_ret_val THEN
5240: p_status:=FALSE;
5241: indx:= indx+1;
5242: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);
5243: p_igf_ap_message_table(indx).field_name:='';
5244: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('TAX_FIGURES_TYPE');
5245: END IF;
5246: END IF;

Line 5255: l_hash_value := DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);

5251: l_ret_val := is_lookup_code_exist(p_profile_rec.p_tax_figures_num,'IGF_TAX_FIGURES_0405');
5252: IF NOT l_ret_val THEN
5253: p_status := FALSE;
5254: indx := indx + 1;
5255: l_hash_value := DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);
5256: p_igf_ap_message_table(indx).field_name := '';
5257: p_igf_ap_message_table(indx).msg_text := lookup_meaning_table(l_hash_value).msg_text || ' ' || p_l_to_i_col('P_TAX_FIGURES_NUM');
5258: END IF;
5259: ELSE

Line 5264: l_hash_value := DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);

5260: l_ret_val := is_lookup_code_exist(p_profile_rec.p_tax_figures_num,'IGF_TAX_FIGURES');
5261: IF NOT l_ret_val THEN
5262: p_status := FALSE;
5263: indx := indx + 1;
5264: l_hash_value := DBMS_UTILITY.get_hash_value('IGF_TAX_FIGURES',1000,25000);
5265: p_igf_ap_message_table(indx).field_name := '';
5266: p_igf_ap_message_table(indx).msg_text := lookup_meaning_table(l_hash_value).msg_text || ' ' || p_l_to_i_col('P_TAX_FIGURES_NUM');
5267: END IF;
5268: END IF;

Line 5277: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_VISA_CLASS',1000,25000);

5273: l_ret_val:=is_lookup_code_exist(p_profile_rec.VISA_CLASSIFICATION_TYPE,'IGF_VISA_CLASS_0405');
5274: IF NOT l_ret_val THEN
5275: p_status:=FALSE;
5276: indx:= indx+1;
5277: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_VISA_CLASS',1000,25000);
5278: p_igf_ap_message_table(indx).field_name:='';
5279: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('VISA_CLASSIFICATION_TYPE');
5280: END IF;
5281: ELSE

Line 5286: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_VISA_CLASS',1000,25000);

5282: l_ret_val:=is_lookup_code_exist(p_profile_rec.VISA_CLASSIFICATION_TYPE,'IGF_VISA_CLASS');
5283: IF NOT l_ret_val THEN
5284: p_status:=FALSE;
5285: indx:= indx+1;
5286: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_VISA_CLASS',1000,25000);
5287: p_igf_ap_message_table(indx).field_name:='';
5288: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('VISA_CLASSIFICATION_TYPE');
5289: END IF;
5290: END IF;

Line 5301: l_hash_value:=DBMS_UTILITY.get_hash_value('PARENTS_IN_COLLEGE',

5297:
5298: IF NOT l_ret_val THEN
5299: p_status:=FALSE;
5300: indx:= indx+1;
5301: l_hash_value:=DBMS_UTILITY.get_hash_value('PARENTS_IN_COLLEGE',
5302: 1000,
5303: 25000);
5304: p_igf_ap_message_table(indx).field_name:='';
5305: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('P_PARENTS_IN_COLLEGE_NUM');

Line 5319: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5315:
5316: IF NOT l_ret_val THEN
5317: p_status:=FALSE;
5318: indx:= indx+1;
5319: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5320: 1000,
5321: 25000);
5322: p_igf_ap_message_table(indx).field_name:='';
5323: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_1_TYPE');

Line 5337: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5333:
5334: IF NOT l_ret_val THEN
5335: p_status:=FALSE;
5336: indx:= indx+1;
5337: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5338: 1000,
5339: 25000);
5340: p_igf_ap_message_table(indx).field_name:='';
5341: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_2_TYPE');

Line 5355: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5351:
5352: IF NOT l_ret_val THEN
5353: p_status:=FALSE;
5354: indx:= indx+1;
5355: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5356: 1000,
5357: 25000);
5358: p_igf_ap_message_table(indx).field_name:='';
5359: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_3_TYPE');

Line 5373: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5369:
5370: IF NOT l_ret_val THEN
5371: p_status:=FALSE;
5372: indx:= indx+1;
5373: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5374: 1000,
5375: 25000);
5376: p_igf_ap_message_table(indx).field_name:='';
5377: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_4_TYPE');

Line 5391: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5387:
5388: IF NOT l_ret_val THEN
5389: p_status:=FALSE;
5390: indx:= indx+1;
5391: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5392: 1000,
5393: 25000);
5394: p_igf_ap_message_table(indx).field_name:='';
5395: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_5_TYPE');

Line 5409: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5405:
5406: IF NOT l_ret_val THEN
5407: p_status:=FALSE;
5408: indx:= indx+1;
5409: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5410: 1000,
5411: 25000);
5412: p_igf_ap_message_table(indx).field_name:='';
5413: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_6_TYPE');

Line 5427: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5423:
5424: IF NOT l_ret_val THEN
5425: p_status:=FALSE;
5426: indx:= indx+1;
5427: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5428: 1000,
5429: 25000);
5430: p_igf_ap_message_table(indx).field_name:='';
5431: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_7_TYPE');

Line 5445: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5441:
5442: IF NOT l_ret_val THEN
5443: p_status:=FALSE;
5444: indx:= indx+1;
5445: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5446: 1000,
5447: 25000);
5448: p_igf_ap_message_table(indx).field_name:='';
5449: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_8_TYPE');

Line 5463: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5459:
5460: IF NOT l_ret_val THEN
5461: p_status:=FALSE;
5462: indx:= indx+1;
5463: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5464: 1000,
5465: 25000);
5466: p_igf_ap_message_table(indx).field_name:='';
5467: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_9_TYPE');

Line 5481: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',

5477:
5478: IF NOT l_ret_val THEN
5479: p_status:=FALSE;
5480: indx:= indx+1;
5481: l_hash_value:=DBMS_UTILITY.get_hash_value('SCHOOL_HOUSE_CODES',
5482: 1000,
5483: 25000);
5484: p_igf_ap_message_table(indx).field_name:='';
5485: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('HOUSING_10_TYPE');

Line 5499: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',

5495:
5496: IF NOT l_ret_val THEN
5497: p_status:=FALSE;
5498: indx:= indx+1;
5499: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',
5500: 1000,
5501: 25000);
5502: p_igf_ap_message_table(indx).field_name:='';
5503: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_2_RELATION_TYPE');

Line 5517: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',

5513:
5514: IF NOT l_ret_val THEN
5515: p_status:=FALSE;
5516: indx:= indx+1;
5517: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',
5518: 1000,
5519: 25000);
5520: p_igf_ap_message_table(indx).field_name:='';
5521: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_3_RELATION_TYPE');

Line 5534: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',

5530:
5531: IF NOT l_ret_val THEN
5532: p_status:=FALSE;
5533: indx:= indx+1;
5534: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',
5535: 1000,
5536: 25000);
5537: p_igf_ap_message_table(indx).field_name:='';
5538: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_4_RELATION_TYPE');

Line 5552: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',

5548:
5549: IF NOT l_ret_val THEN
5550: p_status:=FALSE;
5551: indx:= indx+1;
5552: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',
5553: 1000,
5554: 25000);
5555: p_igf_ap_message_table(indx).field_name:='';
5556: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_5_RELATION_TYPE');

Line 5570: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',

5566:
5567: IF NOT l_ret_val THEN
5568: p_status:=FALSE;
5569: indx:= indx+1;
5570: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',
5571: 1000,
5572: 25000);
5573: p_igf_ap_message_table(indx).field_name:='';
5574: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_6_RELATION_TYPE');

Line 5588: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',

5584:
5585: IF NOT l_ret_val THEN
5586: p_status:=FALSE;
5587: indx:= indx+1;
5588: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',
5589: 1000,
5590: 25000);
5591: p_igf_ap_message_table(indx).field_name:='';
5592: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_7_RELATION_TYPE');

Line 5606: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',

5602:
5603: IF NOT l_ret_val THEN
5604: p_status:=FALSE;
5605: indx:= indx+1;
5606: l_hash_value:=DBMS_UTILITY.get_hash_value('STUDENT_RELATION',
5607: 1000,
5608: 25000);
5609: p_igf_ap_message_table(indx).field_name:='';
5610: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('LINE_8_RELATION_TYPE');

Line 5622: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_CSS_DEP_STATUS',1000,25000);

5618: l_ret_val:=is_lookup_code_exist(p_profile_rec.COMP_CSS_DEPENDCY_STATUS_TYPE,'IGF_AP_CSS_DEP_STATUS');
5619: IF NOT l_ret_val THEN
5620: p_status:=FALSE;
5621: indx:= indx+1;
5622: l_hash_value:=DBMS_UTILITY.get_hash_value('IGF_AP_CSS_DEP_STATUS',1000,25000);
5623: p_igf_ap_message_table(indx).field_name:='';
5624: p_igf_ap_message_table(indx).msg_text:=lookup_meaning_table(l_hash_value).msg_text||' '|| p_l_to_i_col('COMP_CSS_DEPENDCY_STATUS_TYPE');
5625: END IF;
5626: END IF;