DBA Data[Home] [Help]

PACKAGE: APPS.IGF_AW_LI_IMPORT

Source


1 PACKAGE igf_aw_li_import AUTHID CURRENT_USER AS
2 /* $Header: IGFAW15S.pls 115.2 2003/12/08 04:44:09 veramach noship $ */
3 
4   PROCEDURE main(errbuf            OUT NOCOPY  VARCHAR2,
5                  retcode           OUT NOCOPY  NUMBER,
6                  p_award_year      IN VARCHAR2,
7                  p_batch_number    IN NUMBER,
8                  p_delete_flag     IN VARCHAR2
9             );
10 
11   PROCEDURE validate_awdyear_int_rec(li_awd_rec IN OUT NOCOPY igf_aw_li_awd_ints%ROWTYPE, l_return_value OUT NOCOPY VARCHAR2);
12 
13   PROCEDURE validate_disburs_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE, p_return_status OUT NOCOPY VARCHAR2);
14 
15   PROCEDURE validate_disb_act_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,
16                                       li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,
17                           p_return_status OUT NOCOPY VARCHAR2
18                                      );
19   PROCEDURE validate_disb_hold_int_rec(li_awd_rec igf_aw_li_awd_ints%ROWTYPE,
20                                        li_awd_disb_rec igf_aw_li_disb_ints%ROWTYPE,
21                        p_return_status OUT NOCOPY VARCHAR2
22                                        );
23 
24   FUNCTION get_base_id_from_per_num (p_person_number IN hz_parties.party_number%TYPE,
25                      p_cal_type IN igs_ca_inst.cal_type%TYPE,
26                      p_sequence_number IN igs_ca_inst.sequence_number%TYPE)
27                      RETURN NUMBER;
28 
29   PROCEDURE run( errbuf            OUT NOCOPY  VARCHAR2,
30                  retcode           OUT NOCOPY  NUMBER,
31                  p_award_year      IN VARCHAR2,
32                  p_batch_number    IN NUMBER,
33                  p_delete_flag     IN VARCHAR2
34             );
35 
36 END igf_aw_li_import;