PACKAGE: APPS.PAY_JP_RETRO_PKG

Source

1 package pay_jp_retro_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpretr.pkh 120.1 2005/09/05 19:08:52 hikubo noship $ */
3 	--
4 -------------------------------------------------------------
5 	FUNCTION get_retropayments
6 -------------------------------------------------------------
7 	(
8 		p_assignment_id in number,
9 		p_date_earned   in date
10 	) RETURN number;
11 	--
12 -------------------------------------------------------------
13 	FUNCTION GET_PLSQL_GLOBAL
14 -------------------------------------------------------------
15 	(
16 		p_global_name in varchar2,
17 		p_mth_ago     in number,
18 		p_type        in varchar2
19 	) return number;
20 --	PRAGMA RESTRICT_REFERENCES (get_plsql_global, WNDS, WNPS);
21 	--
22 -------------------------------------------------------------
23 	FUNCTION get_retro_mth
24 -------------------------------------------------------------
25 	(
26 		p_mth_ago in number
27 	) RETURN number;
28 	--
29 -------------------------------------------------------------
30 	FUNCTION get_first_retro_amt
31 -------------------------------------------------------------
32 	RETURN number;
33 	--
34 -------------------------------------------------------------
35 	FUNCTION get_first_retro_mth
36 -------------------------------------------------------------
37 	RETURN number;
38 	--
39 -------------------------------------------------------------
40 	FUNCTION get_last_assact
41 -------------------------------------------------------------
42 	(
43 		p_assignment_id       IN NUMBER,
44 		p_effective_date_from IN DATE,
45 		p_effective_date_to   IN DATE
46 	) RETURN NUMBER;
47 	--
48 -------------------------------------------------------------
49 	FUNCTION balance_fetch
50 -------------------------------------------------------------
51 	(
52 		p_assignment_id  in number,
53 		p_item_name      in varchar2,
54 		p_effective_date in date
55 	) RETURN number;
56 	--
57 -------------------------------------------------------------
58 	FUNCTION get_balance_value
59 -------------------------------------------------------------
60 	(
61 		p_business_group_id    IN NUMBER,
62 		p_item_name            IN VARCHAR2,
63 		p_assignment_action_id IN NUMBER
64 	) RETURN NUMBER;
65 	--
66 END;