DBA Data[Home] [Help]

PACKAGE: APPS.IGF_SE_GEN_001

Source


1 PACKAGE igf_se_gen_001 AS
2 /* $Header: IGFSE01S.pls 120.1 2005/08/18 03:23:10 appldev ship $ */
3 
4   ------------------------------------------------------------------------------------
5   -- Created by  :
6   -- Date created:
7   -- Purpose:
8   --
9   --
10   --
11   -- Known limitations/enhancements and/or remarks:
12   -- Change History:
13   -- Who         When            What
14   --ridas        29/Jul/2005     Bug #3536039. New exception (IGFSEGEN001) added.
15   --veramach     July 2004       FA 151 HR Integration (Bug# 3709292) Changes
16   --                             New parameter(AUTH_DATE) added to send_work_auth
17   --                             New parameter(p_dummy) added to send_work_auth_job
18   --                             New parameter(AWARD_ID) added to se_notify
19   -------------------------------------------------------------------------------------
20 
21   IGFSEGEN001     EXCEPTION;
22 
23   PROCEDURE send_work_auth(
24                            p_base_id      IN  igf_ap_fa_base_rec.base_id%TYPE,
25                            p_person_id    IN  hz_parties.party_id%TYPE,
26                            p_fund_id      IN  igf_aw_fund_mast.fund_id%TYPE,
27                            p_award_id     IN  igf_aw_award.award_id%TYPE,
28                            p_ld_cal_type  IN  igs_ca_inst.cal_type%TYPE,
29                            p_ld_seq_no    IN  igs_ca_inst.sequence_number%TYPE,
30                            p_call         IN  VARCHAR2 DEFAULT 'FORM',
31                            p_auth_date    IN DATE DEFAULT SYSDATE
32                           );
33 
34 
35   PROCEDURE send_work_auth_job(
36                                errbuf     OUT NOCOPY VARCHAR2,
37                                retcode    OUT NOCOPY NUMBER,
38                                p_awd_cal  IN  VARCHAR2,
39                                p_fund_id  IN  igf_aw_fund_mast_all.fund_id%TYPE,
40                                p_dummy    IN  NUMBER,
41                                p_base_id  IN  igf_ap_fa_base_rec_all.base_id%TYPE
42                               ) ;
43 
44   PROCEDURE payroll_uplaod(
45                            errbuf      OUT NOCOPY varchar2,
46                            retcode     OUT NOCOPY number,
47                            p_batch_id  IN  igf_se_payment_int.batch_id%TYPE,
48                            p_auth_id   IN  igf_se_auth.auth_id%TYPE,
49                            p_level     IN  VARCHAR2 DEFAULT 'N'
50                           ) ;
51 
52   PROCEDURE payroll_adjust(
53                            p_payment_rec  IN  igf_se_payment%ROWTYPE,
54                            p_status       OUT NOCOPY igf_se_payment_int.status%TYPE,
55                            p_error_cd     OUT NOCOPY igf_se_payment_int.error_code%TYPE
56                           );
57 
58 
59   PROCEDURE se_notify(
60                       p_person_id    IN  hz_parties.party_id%TYPE,
61                       p_fund_id      IN  igf_aw_fund_mast.fund_id%TYPE,
62                       p_ld_cal_type  IN  igs_ca_inst.cal_type%TYPE,
63                       p_ld_seq_no    IN  igs_ca_inst.sequence_number%TYPE,
64                       p_award_id     IN  igf_aw_award_all.award_id%TYPE
65                      );
66 
67 
68 END igf_se_gen_001;