1 Package PQP_UK_Union_Deduction AUTHID CURRENT_USER As
2 /* $Header: pqgbundf.pkh 115.4 2003/02/14 19:19:50 tmehra noship $ */
3
4 /*=======================================================================
5 * GET_UNION_ELE_EXTRA_INFO
6 *
7 * Formula Funtion, uses the context of element_type_id
8 *
9 * Extracts element type extra information for a give (union) element
10 * with an infomation type of PQP_UK_UNION_INFORMATION
11 *
12 *=======================================================================*/
13
14 FUNCTION get_uk_union_ele_extra_info
15 (p_element_type_id IN NUMBER -- Context
16 ,p_union_organization_id OUT NOCOPY NUMBER
17 ,p_union_level_balance_name OUT NOCOPY VARCHAR2
18 ,p_pension_rate_type_name OUT NOCOPY VARCHAR2
19 ,p_fund_list OUT NOCOPY VARCHAR2
20 ,p_ERROR_MESSAGE OUT NOCOPY VARCHAR2
21 )
22 RETURN NUMBER; -- Error code
23
24
25 /*=======================================================================
26 * GET_UK_UNION_ORG_INFO
27 *
28 * Formula Function
29 *
30 * Extracts Organization Information (type GB_TRADE_UNION_INFO) for a
31 * given Union type organization.
32 *
33 *=======================================================================*/
34
35 --
36 FUNCTION get_uk_union_org_info
37 (p_union_organization_id IN NUMBER
38 ,p_union_rates_table_id OUT NOCOPY NUMBER
39 ,p_union_rates_table_name OUT NOCOPY VARCHAR2
40 ,p_union_rates_table_type OUT NOCOPY VARCHAR2
41 ,p_union_recalculation_date OUT NOCOPY VARCHAR2
42 ,p_ERROR_MESSAGE OUT NOCOPY VARCHAR2
43 )
44 RETURN NUMBER;
45
46 /*=======================================================================
47 * GET_UK_UNION_ORGINFO_FNDDATE
48 *
49 * Formula Function :
50 *
51 * Extracts Organization Information (type 'GB_TRADE_UNION_INFO') for a
52 * given Union type organization.This function return p_union_recalculation_date
53 * as a date field. This function will now be used for all Union elements created
54 * using the deducation template.
55 *=======================================================================*/
56
57 FUNCTION get_uk_union_orginfo_fnddate
58 (p_union_organization_id IN NUMBER
59 ,p_union_rates_table_id OUT NOCOPY NUMBER
60 ,p_union_rates_table_name OUT NOCOPY VARCHAR2
61 ,p_union_rates_table_type OUT NOCOPY VARCHAR2
62 ,p_union_recalculation_date OUT NOCOPY date --Returned fnd_canonical_date
63 ,p_ERROR_MESSAGE OUT NOCOPY VARCHAR2
64 )
65 RETURN NUMBER;
66
67 /*=======================================================================
68 * CHK_UK_UNION_FUND_SELECTED
69 *
70 * Formula Function
71 *
72 * Validates that the given union fund name exists as a column on the
73 * given union rate table.
74 *
75 *=======================================================================*/
76
77 FUNCTION chk_uk_union_fund_selected
78 (p_union_rates_column_name IN VARCHAR2
79 ,p_union_rates_table_name IN VARCHAR2
80 ,p_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2
81 )
82 RETURN NUMBER;
83
84
85 /*=======================================================================
86 * GET_UK_UNION_RATES_TABLE_ROW
87 *
88 * Formula Function
89 *
90 * Returns the row value for a 'M'atch type union rates table.
91 * Additionally it validates that there must be exactly one and only
92 * one row in the table.
93 *
94 *======================================================================*/
95
96
97 FUNCTION get_uk_union_rates_table_row
98 (p_union_rates_table_name IN VARCHAR2
99 ,p_union_rates_row_value OUT NOCOPY VARCHAR2
100 ,p_ERROR_MESSAGE OUT NOCOPY VARCHAR2
101 )
102 RETURN NUMBER; -- error code, 0 is successful , -1 on Error.
103
104 /*=======================================================================
105 * GET_UK_UNION_RATES
106 *
107 * Formula Function
108 *
109 * Package wrapped call to Formula Function GET_TABLE_VALUE to handle
110 * potential exceptions (NO_DATA_FOUND and TOO_MANY_ROWS) and return
111 * appropriate user error messages.
112 *
113 *=======================================================================*/
114 FUNCTION get_uk_union_rates
115 (p_bus_group_id IN NUMBER -- Context
116 ,p_union_rates_table_name IN VARCHAR2
117 ,p_union_rates_column_name IN VARCHAR2
118 ,p_union_rates_row_value IN VARCHAR2
119 ,p_effective_date IN DATE DEFAULT NULL -- Sess Date
120 ,p_Union_Deduction_Value OUT NOCOPY NUMBER
121 ,p_ERROR_MESSAGE OUT NOCOPY VARCHAR2
122 )
123 RETURN NUMBER;
124
125 /*=======================================================================*/
126
127 END pqp_uk_union_deduction;