[Home] [Help]
PACKAGE: APPS.PAY_ADVANCE_PAY_PKG
Source
1 package PAY_ADVANCE_PAY_PKG AUTHID CURRENT_USER as
2 /* $Header: paywsahp.pkh 120.0 2005/05/29 02:44:37 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 PAY_ADVANCE_PAY_PKG
13 Purpose
14 Server agent for PAYWSAHP form.
15 History
16 18 Feb 97 40.0 M. Lisiecki Created
17 40.1 M. Lisiecki Pre release changes.
18 17 Jun 97 40.2 M. Lisiecki Added pragma to
19 advanced_periods
20 25 Jun 97 40.3 M.Lisiecki Changed get_balance and
21 advance_amount to return char
22 values.
23 25 Jun 97 40.4 M.Lisiecki Changed get_balance return
24 statement back to number
25 value.
26 10 Feb 98 110.2 T.Battoo Added parameter to
27 advance_amount and
28 get_processed_flag function
29
30 21 Jul 04 115.1 SuSivasu Fixes for GSCC errors.
31 17 Aug 04 115.2 SuSivasu Added get_advance_period_start_date
32 and get_advance_period_end_date.
33
34 */
35 --------------------------------------------------------------------------------
36 function advance_amount
37 (
38 p_advance_pay_start_date date,
39 p_target_entry_id number,
40 p_assignment_id number
41 )
42 return varchar2;
43 pragma restrict_references (advance_amount,WNPS,WNDS);
44 --------------------------------------------------------------------------------
45 function get_balance
46 (
47 p_legislation_code varchar2,
48 p_balance_lookup_name varchar2,
49 p_assignment_id number,
50 p_session_date date
51 )
52 return number;
53 --------------------------------------------------------------------------------
54 function get_processed_flag
55 (
56 p_advance_pay_start_date date,
57 p_target_entry_id number,
58 p_assignment_id number
59 )
60 return varchar2;
61 pragma restrict_references (get_processed_flag,WNPS,WNDS);
62 --------------------------------------------------------------------------------
63 function advanced_periods
64 (
65 p_assignment_id number,
66 p_advance_pay_start_date date,
67 p_advance_pay_end_date date
68 )
69 return number;
70 pragma restrict_references (advanced_periods,WNPS,WNDS);
71 --------------------------------------------------------------------------------
72 function get_period_start_date
73 (
74 p_assignment_id number,
75 p_session_date date
76 )
77 return date;
78 --------------------------------------------------------------------------------
79 function get_period_end_date
80 (
81 p_assignment_id number,
82 p_session_date date
83 )
84 return date;
85 --------------------------------------------------------------------------------
86 function get_advance_period_start_date
87 (
88 p_assignment_id number,
89 p_session_date date,
90 p_flag varchar2
91 )
92 return date;
93 --------------------------------------------------------------------------------
94 function get_advance_period_end_date
95 (
96 p_assignment_id number,
97 p_session_date date,
98 p_flag varchar2
99 )
100 return date;
101 --------------------------------------------------------------------------------
102 procedure insert_indicator_entries
103 (
104 p_defer_flag in varchar2,
105 p_assignment_id in number,
106 p_session_date in out nocopy date,
107 p_pai_element_entry_id in out nocopy number,
108 p_pai_element_type_id in number,
109 p_pai_sd_input_value_id in number,
110 p_pai_ed_input_value_id in number,
111 p_pai_start_date in date,
112 p_pai_end_date in date,
113 p_advance_pay_start_date in date,
114 p_advance_pay_end_date in date,
115 p_arrears_flag in varchar2,
116 p_periods_advanced in number,
117 p_ai_element_type_id in number,
118 p_ai_af_input_value_id in number,
119 p_ai_dpf_input_value_id in number
120 );
121 --------------------------------------------------------------------------------
122 procedure delete_indicator_entries
123 (
124 p_assignment_id in number,
125 p_legislation_code in varchar2,
126 p_session_date in date,
127 p_pai_element_entry_id in number,
128 p_arrears_flag in varchar2
129 );
130 --------------------------------------------------------------------------------
131 end PAY_ADVANCE_PAY_PKG;