APPS.IGF_AP_LG_VER_IMP dependencies on IGF_AP_ISIR_MATCHED

Line 146: CURSOR chk_dup ( cp_base_id igf_ap_isir_matched.base_id%TYPE,

142: || Who When What
143: || (reverse chronological order - newest change first)
144: */
145:
146: CURSOR chk_dup ( cp_base_id igf_ap_isir_matched.base_id%TYPE,
147: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
148: SELECT 1
149: FROM igf_ap_inst_ver_item_all
150: WHERE base_id = cp_base_id

Line 444: l_pay_isir_id igf_ap_isir_matched.isir_id%TYPE ;

440: l_last_person_number igf_ap_li_vern_ints.person_number%TYPE ;
441: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
442: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
443: l_dup_item_found BOOLEAN;
444: l_pay_isir_id igf_ap_isir_matched.isir_id%TYPE ;
445: l_act_isir_id igf_ap_isir_matched.isir_id%TYPE ;
446: l_error igf_lookups_view.meaning%TYPE ;
447: l_person_number igf_lookups_view.meaning%TYPE ;
448: l_token VARCHAR2(60) ;

Line 445: l_act_isir_id igf_ap_isir_matched.isir_id%TYPE ;

441: l_fa_base_id igf_ap_fa_base_rec.base_id%TYPE;
442: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
443: l_dup_item_found BOOLEAN;
444: l_pay_isir_id igf_ap_isir_matched.isir_id%TYPE ;
445: l_act_isir_id igf_ap_isir_matched.isir_id%TYPE ;
446: l_error igf_lookups_view.meaning%TYPE ;
447: l_person_number igf_lookups_view.meaning%TYPE ;
448: l_token VARCHAR2(60) ;
449: l_corr_exist BOOLEAN ;

Line 502: CURSOR c_act_pay_isir ( cp_base_id igf_ap_isir_matched.base_id%TYPE ) IS

498: l_sar_num igf_fc_sar_cd_mst.sar_field_number%TYPE;
499:
500:
501: -- get active and payment ISIR
502: CURSOR c_act_pay_isir ( cp_base_id igf_ap_isir_matched.base_id%TYPE ) IS
503: SELECT isir_id, active_isir, payment_isir
504: FROM igf_ap_isir_matched
505: WHERE base_id = cp_base_id
506: AND (active_isir = 'Y' OR payment_isir = 'Y' ) ;

Line 504: FROM igf_ap_isir_matched

500:
501: -- get active and payment ISIR
502: CURSOR c_act_pay_isir ( cp_base_id igf_ap_isir_matched.base_id%TYPE ) IS
503: SELECT isir_id, active_isir, payment_isir
504: FROM igf_ap_isir_matched
505: WHERE base_id = cp_base_id
506: AND (active_isir = 'Y' OR payment_isir = 'Y' ) ;
507: act_pay_isir_rec c_act_pay_isir%ROWTYPE ;
508:

Line 834: lv_stmt := 'SELECT ' || person_rec.sar_field_label_code || ' FROM igf_ap_isir_matched WHERE isir_id = :l_isir_id' ;

830: IF g_award_year_status = 'LD' THEN
831: -- get the existing value for the item ....
832: IF person_rec.sar_field_label_code IS NOT NULL THEN
833: lv_cur := DBMS_SQL.OPEN_CURSOR;
834: lv_stmt := 'SELECT ' || person_rec.sar_field_label_code || ' FROM igf_ap_isir_matched WHERE isir_id = :l_isir_id' ;
835:
836: DBMS_SQL.PARSE(lv_cur,lv_stmt,2);
837: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', TO_CHAR(l_pay_isir_id));
838: