DBA Data[Home] [Help]

APPS.IGF_SL_CL_ORIG_ACK dependencies on IGS_CA_INST

Line 268: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,

264: p_c_student_created IN VARCHAR2,
265: p_c_rel_created IN VARCHAR2
266: );
267:
268: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
269: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,

Line 269: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,

265: p_c_rel_created IN VARCHAR2
266: );
267:
268: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
269: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,

Line 270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,

266: );
267:
268: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
269: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,

Line 617: igs_ca_inst ci,

613: awd.accepted_amt accepted_amt
614: FROM igf_aw_award_all awd,
615: igf_aw_fund_mast_all fmast,
616: igf_aw_fund_cat_all fcat,
617: igs_ca_inst ci,
618: igf_ap_fa_base_rec facon,
619: (SELECT api_person_id,
620: pe_person_id
621: FROM igs_pe_person_id_typ pit_2,

Line 6362: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,

6358: l_wf_parameter_list_t.DELETE;
6359:
6360: END raise_scr_event;
6361:
6362: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
6363: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,

Line 6363: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,

6359:
6360: END raise_scr_event;
6361:
6362: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
6363: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,

Line 6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,

6360: END raise_scr_event;
6361:
6362: PROCEDURE raise_gamt_event ( p_v_ci_alternate_code IN igs_ca_inst_all.alternate_code%TYPE,
6363: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,