[Home] [Help]
PACKAGE: APPS.IGF_SL_DL_VALIDATION
Source
1 PACKAGE igf_sl_dl_validation AS
2 /* $Header: IGFSL02S.pls 120.0 2005/06/02 15:51:33 appldev noship $ */
3
4 /*************************************************************
5 Created By : venagara
6 Date Created On : 2000/11/07
7 Purpose :
8 Know limitations, enhancements or remarks
9 Change History
10 Who When What
11 ugummall 01-OCT-2004 FA149-COD-XML. Added check_full_participant and cod_loan_validations functions.
12 ugummall 22-OCT-2003 Bug 3102439. FA 126 - Multiple FA Offices.
13 Added one parameter to the function dl_lar_validate function.
14 (reverse chronological order - newest change first)
15 ***************************************************************/
16
17 FUNCTION dl_lar_validate(p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
18 p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
19 p_loan_catg fnd_lookups.lookup_code%TYPE,
20 p_loan_number igf_sl_loans_all.loan_number%TYPE,
21 p_call_mode VARCHAR2 DEFAULT 'JOB',
22 p_school_code VARCHAR2 DEFAULT NULL)
23 RETURN BOOLEAN;
24
25 FUNCTION check_full_participant (
26 p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
27 p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
28 p_fund_type IN VARCHAR2 DEFAULT NULL
29 )
30 RETURN BOOLEAN;
31
32 FUNCTION cod_loan_validations ( p_loan_rec igf_sl_dl_gen_xml.cur_pick_loans%ROWTYPE,
33 p_call_from VARCHAR2,
34 p_isir_ssn OUT NOCOPY VARCHAR2,
35 p_isir_dob OUT NOCOPY DATE,
36 p_isir_lname OUT NOCOPY VARCHAR2,
37 p_isir_dep OUT NOCOPY VARCHAR2,
38 p_isir_tnum OUT NOCOPY NUMBER,
39 p_acad_begin OUT NOCOPY DATE,
40 p_acad_end OUT NOCOPY DATE,
41 p_s_phone OUT NOCOPY VARCHAR2,
42 p_p_phone OUT NOCOPY VARCHAR2 )
43 RETURN BOOLEAN;
44
45 FUNCTION validate_id (p_entity_id VARCHAR2)
46 RETURN BOOLEAN;
47
48 FUNCTION cod_loan_validations ( p_cal_type VARCHAR2, p_seq_number NUMBER,
49 p_base_id NUMBER,
50 p_report_id VARCHAR2,
51 p_attend_id VARCHAR2,
52 p_fund_id NUMBER,
53 p_loan_id NUMBER)
54 RETURN BOOLEAN;
55
56 END igf_sl_dl_validation;