DBA Data[Home] [Help]

APPS.IGF_AP_CALC_IM_EFC dependencies on IGF_LOOKUPS_VIEW

Line 53: l_param_pass_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

49: --Change History:
50: --Who When What
51: -------------------------------------------------------------------
52:
53: l_param_pass_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
54: l_awd_yr_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
55: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
56: l_pers_id_grp_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
57:

Line 54: l_awd_yr_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');

50: --Who When What
51: -------------------------------------------------------------------
52:
53: l_param_pass_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
54: l_awd_yr_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
55: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
56: l_pers_id_grp_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
57:
58: -- Get alternate code

Line 55: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');

51: -------------------------------------------------------------------
52:
53: l_param_pass_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
54: l_awd_yr_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
55: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
56: l_pers_id_grp_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
57:
58: -- Get alternate code
59: CURSOR c_alternate_code(

Line 56: l_pers_id_grp_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');

52:
53: l_param_pass_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
54: l_awd_yr_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','AWARD_YEAR');
55: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER');
56: l_pers_id_grp_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
57:
58: -- Get alternate code
59: CURSOR c_alternate_code(
60: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 129: l_internal_id_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','INTERNAL_ID') || ' ';

125: -- brajendr 2-Dec-2003 Bug # 3026594
126: -- Removed the Code to updated the FA Base record with the calculated ned
127: -------------------------------------------------------------------
128:
129: l_internal_id_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','INTERNAL_ID') || ' ';
130: l_fnar_rec_fnd BOOLEAN := FALSE;
131:
132: -- Get all PROFILES of a given base_id
133: CURSOR c_all_profiles(

Line 1061: l_processing_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' ';

1057: -------------------------------------------------------------------
1058: lv_status VARCHAR2(1);
1059: l_list VARCHAR2(32767);
1060:
1061: l_processing_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' ';
1062: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' ';
1063:
1064: -- Get base_ids from person id group
1065: CURSOR c_base_id(

Line 1062: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' ';

1058: lv_status VARCHAR2(1);
1059: l_list VARCHAR2(32767);
1060:
1061: l_processing_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING') || ' ';
1062: l_pers_number_log igf_lookups_view.meaning%TYPE DEFAULT igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' ';
1063:
1064: -- Get base_ids from person id group
1065: CURSOR c_base_id(
1066: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,