[Home] [Help]
PACKAGE: APPS.PAY_CN_REPORT_PKG
Source
1 PACKAGE pay_cn_report_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycnrept.pkh 120.0.12000000.1 2007/01/17 17:57:04 appldev noship $ */
3
4 g_package_name VARCHAR2(18):= 'pay_cn_report_pkg.';
5
6 --------------------------------------------------------------------------
7 -- --
8 -- Name : GET_BALANCE_VALUE --
9 -- Type : FUNCTION --
10 -- Access : Public --
11 -- Description : Function to return the value of a particular --
12 -- balance from PAY_ACTION_INFORMATION
13 -- --
14 -- Parameters : --
15 -- IN : p_assignment_action_id NUMBER --
16 -- p_balance_name VARCHAR2 --
17 -- p_dimension_name VARCHAR2 --
18 -- OUT : N/A --
19 -- RETURN : NUMBER --
20 --------------------------------------------------------------------------
21 FUNCTION get_balance_value
22 (p_assignment_action_id IN NUMBER
23 ,p_balance_name IN VARCHAR2
24 ,p_dimension_name IN VARCHAR2 DEFAULT 'PTD'
25 )
26 RETURN NUMBER;
27
28 --------------------------------------------------------------------------
29 -- --
30 -- Name : GET_ELEMENT_VALUE --
31 -- Type : FUNCTION --
32 -- Access : Public --
33 -- Description : Function to return the 'Pay Value' of a particular --
34 -- element from PAY_ACTION_INFORMATION --
35 -- --
36 -- Parameters : --
37 -- IN : p_assignment_action_id NUMBER --
38 -- p_element_name VARCHAR2 --
39 -- OUT : N/A --
40 -- RETURN : NUMBER --
41 --------------------------------------------------------------------------
42 FUNCTION get_element_value
43 (p_assignment_action_id IN NUMBER
44 ,p_element_name IN VARCHAR2
45 )
46 RETURN NUMBER;
47
48 --------------------------------------------------------------------------
49 -- --
50 -- Name : GET_ELEMENT_VALUE --
51 -- Type : FUNCTION --
52 -- Access : Public --
53 -- Description : Function to return the specified input value of a --
54 -- particular element from PAY_ACTION_INFORMATION --
55 -- --
56 -- Parameters : --
57 -- IN : p_assignment_action_id NUMBER --
58 -- p_element_name VARCHAR2 --
59 -- p_input_value_name VARCHAR2 --
60 -- OUT : N/A --
61 -- RETURN : NUMBER --
62 --------------------------------------------------------------------------
63 FUNCTION get_element_value
64 (p_assignment_action_id IN NUMBER
65 ,p_element_name IN VARCHAR2
66 ,p_input_value_name IN VARCHAR2
67 )
68 RETURN NUMBER;
69
70 END pay_cn_report_pkg;