[Home] [Help]
PACKAGE: APPS.PAY_JP_FORMULA_FUNCTION_PKG
Source
1 PACKAGE pay_jp_formula_function_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyjpffuc.pkh 120.0.12010000.2 2009/02/09 05:49:22 keyazawa ship $ */
3 /* ------------------------------------------------------------------------------------ */
4 --
5 g_legislation_code per_business_groups.legislation_code%type;
6 g_business_group_id number;
7 g_effective_date date;
8 g_session_id number;
9 --
10 type t_glb_rec is record(
11 global_name ff_globals_f.global_name%type,
12 global_value ff_globals_f.global_value%type);
13 --
14 type t_glb_tbl is table of t_glb_rec index by binary_integer;
15 --
16 g_glb_tbl t_glb_tbl;
17 --
18 FUNCTION get_table_value_with_default(
19 p_business_group_id IN NUMBER,
20 p_table_name IN VARCHAR2,
21 p_column_name IN VARCHAR2,
22 p_row_value IN VARCHAR2,
23 p_effective_date IN DATE DEFAULT NULL,
24 p_default_value IN VARCHAR2,
25 p_default_by_row IN VARCHAR2 DEFAULT 'N')
26 RETURN VARCHAR2;
27 /* ------------------------------------------------------------------------------------ */
28 FUNCTION chk_smc(
29 p_table_name IN VARCHAR2,
30 p_column_name IN VARCHAR2,
31 p_effective_date IN DATE,
32 p_value IN VARCHAR2)
33 RETURN VARCHAR2;
34 /* ------------------------------------------------------------------------------------ */
35 -- ----------------------------------------------------------------------------
36 -- |----------------------------< get_jp_parameter >--------------------------|
37 -- ----------------------------------------------------------------------------
38 -- {Start Of Comments}
39 --
40 -- Description:
41 -- This function returns the parameter value of hr_jp_parameters.
42 --
43 -- Prerequisites:
44 -- None.
45 --
46 -- In Parameters:
47 -- Name Reqd Type Description
48 -- p_owner Yes VARCHAR2 owner of the parameter.
49 -- p_parameter_name Yes VARCHAR2 parameter name.
50 --
51 -- Post Success:
52 -- Returns the parameter value. If the specified parameter does not exist,
53 -- returns NULL.
54 --
55 -- Post Failure:
56 -- None.
57 --
58 -- Access Status:
59 -- Development Use.
60 --
61 -- {End Of Comments}
62 --
63 FUNCTION get_jp_parameter(
64 p_owner IN VARCHAR2,
65 p_parameter_name IN VARCHAR2) RETURN VARCHAR2;
66 --
67 --
68 function get_global_value(
69 p_business_group_id in number,
70 p_global_name in varchar2,
71 p_effective_date in date default null)
72 return varchar2;
73 --
74 END pay_jp_formula_function_pkg;