1 PACKAGE pay_fr_insurance_process AUTHID CURRENT_USER AS
2 /* $Header: pyfrtpin.pkh 115.2 2002/11/25 13:20:46 vsjain noship $ */
3
4 cs_FINAL CONSTANT NUMBER := 100; -- Final Run
5 --
6 --
7 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
8 -- Custom data types
9 -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
10 --
11
12 TYPE t_ins IS RECORD
13 ( assignment_id NUMBER
14 , base_net NUMBER
15 , element_entry_id NUMBER
16 , date_earned DATE
17 , insurance_subject NUMBER
18 , insurance_exempt NUMBER
19 , insurance_adjustment NUMBER
20 , insurance_reduction NUMBER);
21
22 --
23
24 TYPE t_ctl IS RECORD
25 (iter NUMBER
26 ,p_mode NUMBER);
27
28 --
29 FUNCTION iterate
30 (p_assignment_id NUMBER
31 ,p_element_entry_id NUMBER
32 ,p_date_earned DATE
33 ,p_net_pay NUMBER
34 ,p_subject_insurance NUMBER
35 ,p_exempt_insurance NUMBER
36 ,p_recipient VARCHAR2
37 ,p_stop_processing OUT NOCOPY VARCHAR2) RETURN NUMBER;
38
39 FUNCTION indirects
40 (p_ins_subject OUT NOCOPY NUMBER
41 ,p_ins_exempt OUT NOCOPY NUMBER
42 ,p_ins_adjustment OUT NOCOPY NUMBER
43 ,p_ins_reduction OUT NOCOPY NUMBER ) RETURN NUMBER ;
44
45 END pay_fr_insurance_process;