APPS.IGF_AP_GEN dependencies on IGF_AP_FA_BASE_REC_ALL

Line 56: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,

52: PROCEDURE check_person(
53: p_person_number IN igf_aw_li_coa_ints.person_number%TYPE,
54: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
55: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
56: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
57: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
58: );
59:
60:

Line 57: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE

53: p_person_number IN igf_aw_li_coa_ints.person_number%TYPE,
54: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
55: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
56: p_person_id OUT NOCOPY igf_ap_fa_base_rec_all.person_id%TYPE,
57: p_fa_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE
58: );
59:
60:
61: FUNCTION VALIDATE_CAL_INST(

Line 75: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

71: p_batch_type IN VARCHAR2
72: ) RETURN VARCHAR2;
73:
74: FUNCTION get_isir_value(
75: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
76: p_sar_field_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE
77: ) RETURN VARCHAR2;
78:
79: FUNCTION get_indv_efc_4_term(

Line 80: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

76: p_sar_field_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE
77: ) RETURN VARCHAR2;
78:
79: FUNCTION get_indv_efc_4_term(
80: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
81: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
82: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
83: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
84: ) RETURN NUMBER;

Line 81: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

77: ) RETURN VARCHAR2;
78:
79: FUNCTION get_indv_efc_4_term(
80: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
81: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
82: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
83: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
84: ) RETURN NUMBER;
85:

Line 82: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

78:
79: FUNCTION get_indv_efc_4_term(
80: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
81: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
82: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
83: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
84: ) RETURN NUMBER;
85:
86: FUNCTION get_individual_coa_amt(

Line 88: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

84: ) RETURN NUMBER;
85:
86: FUNCTION get_individual_coa_amt(
87: p_ld_start_dt IN DATE,
88: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
89: ) RETURN NUMBER;
90:
91: FUNCTION get_cumulative_coa_amt(
92: p_ld_start_dt IN DATE,

Line 93: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

89: ) RETURN NUMBER;
90:
91: FUNCTION get_cumulative_coa_amt(
92: p_ld_start_dt IN DATE,
93: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
94: ) RETURN NUMBER;
95:
96: PROCEDURE update_td_status(
97: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

Line 97: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

93: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
94: ) RETURN NUMBER;
95:
96: PROCEDURE update_td_status(
97: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
98: p_item_sequence_number IN igf_ap_td_item_inst_all.item_sequence_number%TYPE,
99: p_status IN igf_ap_td_item_inst_all.status%TYPE,
100: p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,
101: p_return_status OUT NOCOPY VARCHAR2

Line 104: PROCEDURE update_preflend_todo_status ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,

100: p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,
101: p_return_status OUT NOCOPY VARCHAR2
102: );
103:
104: PROCEDURE update_preflend_todo_status ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
105: p_return_status OUT NOCOPY VARCHAR2
106: ) ;
107:
108: END igf_ap_gen;