DBA Data[Home] [Help]

PACKAGE: APPS.BEN_IRC_UTIL

Source


1 PACKAGE ben_irc_util
2 /* $Header: beircutl.pkh 120.3.12000000.1 2007/01/19 10:52:24 appldev noship $ */
3 AS
4 
5 
6 --
7    FUNCTION pay_proposal_rec_change (
8       p_pay_proposal_rec_old   IN   per_pay_proposals%ROWTYPE,
9       p_pay_proposal_rec_new   IN   per_pay_proposals%ROWTYPE
10    )
11       RETURN BOOLEAN;
12 
13 --
14    FUNCTION offer_assignment_rec_change (
15       p_offer_assignment_rec_old   IN   per_all_assignments_f%ROWTYPE,
16       p_offer_assignment_rec_new   IN   per_all_assignments_f%ROWTYPE
17    )
18       RETURN BOOLEAN;
19 
20 --
21    FUNCTION is_benmngle_for_irec_reqd (
22       p_person_id                  IN   NUMBER,
23       p_assignment_id              IN   NUMBER,
24       p_business_group_id          IN   NUMBER,
25       p_effective_date             IN   DATE,
26       p_pay_proposal_rec_old       IN   per_pay_proposals%ROWTYPE,
27       p_pay_proposal_rec_new       IN   per_pay_proposals%ROWTYPE,
28       p_offer_assignment_rec_old   IN   per_all_assignments_f%ROWTYPE,
29       p_offer_assignment_rec_new   IN   per_all_assignments_f%ROWTYPE
30    )
31       RETURN VARCHAR2;
32 
33 --
34    PROCEDURE post_irec_process_update (
35       p_person_id           IN   NUMBER,
36       p_business_group_id   IN   NUMBER,
37       p_assignment_id       IN   NUMBER,
38       p_effective_date      IN   DATE
39    );
40 
41 --
42    PROCEDURE void_or_restore_life_event (
43       p_person_id               IN   NUMBER,
44       p_assignment_id           IN   NUMBER,
45       p_offer_assignment_id     IN   NUMBER DEFAULT NULL,
46       p_void_per_in_ler_id      IN   NUMBER DEFAULT NULL,
47       p_restore_per_in_ler_id   IN   NUMBER DEFAULT NULL,
48       p_status_cd               IN   VARCHAR2 DEFAULT NULL,
49       p_effective_date          IN   DATE
50    );
51 --
52 END ben_irc_util;