APPS.IGF_GR_GEN dependencies on IGF_AP_ISIR_MATCHED

Line 96: p_transaction_num IN igf_ap_ISIR_matched.transaction_num%TYPE)

92:
93: g_batch_dt VARCHAR2(20);
94:
95: FUNCTION chk_orig_isir_exists( p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
96: p_transaction_num IN igf_ap_ISIR_matched.transaction_num%TYPE)
97: RETURN BOOLEAN
98: AS
99: --------------------------------------------------------------------------------------------------------
100: -- Created By : rasahoo

Line 110: cp_transaction_num igf_ap_ISIR_matched.transaction_num%TYPE)

106: --
107: ----------------------------------------------------------------------------------------------------------
108: -- retrieves records for which RFMS Originations exists in status Accepted or Sent, with a different Transaction Number
109: CURSOR chk_ex_orig_rec (cp_base_id igf_ap_fa_base_rec.base_id%TYPE,
110: cp_transaction_num igf_ap_ISIR_matched.transaction_num%TYPE)
111: IS
112: SELECT 'X'
113: FROM igf_gr_rfms rfms
114: WHERE rfms.base_id = cp_base_id

Line 2737: p_cur_ssn IN igf_ap_isir_matched_all.current_ssn%TYPE,

2733:
2734: END get_base_id;
2735:
2736: PROCEDURE update_current_ssn (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
2737: p_cur_ssn IN igf_ap_isir_matched_all.current_ssn%TYPE,
2738: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE)
2739: IS
2740: --
2741: -- sjadhav,2/4/03