APPS.IGF_DB_SF_INTEGRATION dependencies on IGS_FI_CONTROL_ALL

Line 93: cp_manage_accounts igs_fi_control_all.manage_accounts%TYPE

89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,
90: cp_person_id igf_aw_award_v.person_id%TYPE,
91: cp_tp_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
92: cp_tp_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE,
93: cp_manage_accounts igs_fi_control_all.manage_accounts%TYPE
94: ) IS
95: SELECT disb_dlt.award_id,disb_dlt.disb_num,disb_dlt.disb_seq_num,disb_dlt.disb_date,
96: fab.person_id,fcat.fed_fund_code fed_fund_code,fnd.fee_type,fnd.party_id,fnd.spnsr_fee_type,
97: fcat.sys_fund_type sys_fund_type,fnd.ci_cal_type,fnd.ci_sequence_number,fnd.credit_type_id,

Line 128: g_v_currency igs_fi_control_all.currency_cd%TYPE := NULL;

124: g_aid_adj CONSTANT VARCHAR2(10) :='AID_ADJ';
125: g_separator CONSTANT VARCHAR2(5) := ' : ';
126: g_chgadj CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_CREDIT_CLASS','CHGADJ');
127: g_null CONSTANT VARCHAR2(6) := NULL;
128: g_v_currency igs_fi_control_all.currency_cd%TYPE := NULL;
129: g_print_msg VARCHAR2(200);
130: lv_locking_success VARCHAR2(1);
131:
132: FUNCTION validate_award_year(p_cal_type igf_ap_award_year_v.cal_type%TYPE,

Line 665: l_v_currency igs_fi_control_all.currency_cd%TYPE;

661: l_invoice_desc igs_fi_inv_int.invoice_desc%TYPE;
662: l_amount igf_db_awd_disb_dtl.disb_net_amt%TYPE;
663: l_transaction_type igs_lookups_view.lookup_code%TYPE;
664:
665: l_v_currency igs_fi_control_all.currency_cd%TYPE;
666: l_v_message_name fnd_new_messages.message_name%TYPE;
667: l_n_waiver_amount igs_fi_credits_all.amount%TYPE;
668:
669:

Line 1479: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;

1475: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;
1476:
1477: l_exp_err_exception EXCEPTION;
1478: l_v_curr_desc fnd_currencies_tl.name%TYPE;
1479: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
1480: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
1481: lv_profile_value VARCHAR2(30);
1482: lv_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
1483: lv_group_type igs_pe_persid_group_v.group_type%TYPE;