DBA Data[Home] [Help]

PACKAGE: APPS.PAY_FR_INSURANCE_PROCESS

Source


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;