1 PACKAGE pay_in_med_web_adi AS
2 /* $Header: pyinmadi.pkh 120.1.12010000.1 2008/07/27 22:53:32 appldev ship $ */
3 --Global Variable
4 g_assessment_year VARCHAR2(20);
5
6 --------------------------------------------------------------------------
7 -- --
8 -- Name : GET_BG_ID --
9 -- Type : FUNCTION --
10 -- Access : Public --
11 -- Description : Function to return the business group id --
12 -- --
13 -- Parameters : --
14 -- IN : --
15 -- RETURN : VARCHAR2 --
16 ---------------------------------------------------------------------------
17 FUNCTION get_bg_id RETURN NUMBER ;
18
19
20 --------------------------------------------------------------------------
21 -- --
22 -- Name : CREATE_MEDICAL --
23 -- Type : PROCEDURE --
24 -- Access : Public --
25 -- Description : Function to create and update the Medical Bill and --
26 -- Benefit element enrty as per the Med Bill details --
27 -- passed from the Web ADI Excel Sheet. --
28 -- --
29 ---------------------------------------------------------------------------
30
31 PROCEDURE create_medical
32 (P_TAX_YEAR IN VARCHAR2
33 ,P_MONTH IN VARCHAR2 DEFAULT NULL
34 ,P_BILL_DATE IN DATE
35 ,P_NAME IN VARCHAR2
36 ,P_BILL_NUMBER IN VARCHAR2 DEFAULT NULL
37 ,P_BILL_AMOUNT IN NUMBER DEFAULT NULL
38 ,P_APPROVED_BILL_AMOUNT IN NUMBER
39 ,P_EMPLOYEE_REMARKS IN VARCHAR2 DEFAULT NULL
40 ,P_EMPLOYER_REMARKS IN VARCHAR2 DEFAULT NULL
41 ,P_ELEMENT_ENTRY_ID IN NUMBER DEFAULT NULL
42 ,P_LAST_UPDATED_DATE IN DATE DEFAULT NULL
43 ,P_ASSIGNMENT_ID IN NUMBER
44 ,P_EMPLOYEE_ID IN NUMBER
45 ,P_EMPLOYEE_NAME IN VARCHAR2
46 ,P_ASSIGNMENT_EXTRA_INFO_ID IN NUMBER
47 ,P_ENTRY_DATE IN DATE DEFAULT NULL
48 );
49
50 --------------------------------------------------------------------------
51 -- --
52 -- Name : CREATE_MEDICAL_BEN --
53 -- Type : PROCEDURE --
54 -- Access : Public --
55 -- Description : Function to update the Med Ben element enrty as per --
56 -- the details passed from the Web ADI Excel Sheet. --
57 -- --
58 ---------------------------------------------------------------------------
59
60 PROCEDURE create_medical_ben
61 ( P_employee_number IN VARCHAR2
62 ,P_full_name IN VARCHAR2
63 ,P_effective_start_date IN DATE
64 ,P_effective_end_date IN DATE DEFAULT NULL
65 ,P_Benefit IN NUMBER
66 ,P_Add_to_NetPay IN VARCHAR2
67 ,P_AnnualLimit IN NUMBER DEFAULT NULL
68 ,P_assignment_id IN NUMBER
69 ,P_element_entry_id IN NUMBER DEFAULT NULL
70 );
71
72 --------------------------------------------------------------------------
73 -- --
74 -- Name : CREATE_LTC_ELEMENT --
75 -- Type : PROCEDURE --
76 -- Access : Public --
77 -- Description : Function to create and update the LTC element enrty --
78 -- as per the LTC Bill details passed from the Web ADI --
79 -- Excel Sheet. --
80 -- --
81 ---------------------------------------------------------------------------
82
83
84 PROCEDURE create_ltc_element
85 (
86 P_LTCBLOCK IN VARCHAR2
87 ,P_PLACE_FROM IN VARCHAR2
88 ,P_PLACE_TO IN VARCHAR2
89 ,P_MODE_CLASS IN VARCHAR2
90 ,P_CARRY_OVER IN VARCHAR2 DEFAULT NULL
91 ,P_SUBMITTED IN NUMBER
92 ,P_EXEMPTED IN NUMBER DEFAULT NULL
93 ,P_ELEMENT_ENTRY_ID IN NUMBER
94 ,P_START_DATE IN DATE
95 ,P_END_DATE IN DATE
96 ,P_BILL_NUM IN VARCHAR2 DEFAULT NULL
97 ,P_EE_COMMENTS IN VARCHAR2 DEFAULT NULL
98 ,P_ER_COMMENTS IN VARCHAR2 DEFAULT NULL
99 ,P_LAST_UPDATED_DATE IN DATE
100 ,P_ASSIGNMENT_ID IN NUMBER
101 ,P_EMPLOYEE_ID IN NUMBER
102 ,P_ASSIGNMENT_EXTRA_INFO_ID IN NUMBER
103 ,P_ENTRY_DATE IN DATE DEFAULT NULL
104
105 );
106
107
108 --------------------------------------------------------------------------
109 -- --
110 -- Name : UPDATE_LTC_ELEMENT --
111 -- Type : PROCEDURE --
112 -- Access : Public --
113 -- Description : Function to update the LTC element enrty as per the --
114 -- details passed from the Web ADI Excel Sheet. --
115 -- --
116 ---------------------------------------------------------------------------
117
118 PROCEDURE update_ltc_element
119 (
120 p_employee_number IN VARCHAR2
121 ,p_full_name IN VARCHAR2
122 ,p_start_date IN DATE
123 ,p_effective_end_date IN DATE DEFAULT NULL
124 ,p_fare IN NUMBER
125 ,p_blockYr IN VARCHAR2
126 ,p_carry IN VARCHAR2
127 ,p_benefit IN NUMBER
128 ,p_assignment_id IN NUMBER
129 ,p_element_entry_id IN NUMBER DEFAULT NULL
130 );
131
132 END ;
133