[Home] [Help]
PACKAGE: APPS.PAY_PAYWSDAS_PKG
Source
1 package PAY_PAYWSDAS_PKG as
2 /* $Header: pywsdas1.pkh 120.1 2005/12/23 02:43:54 arashid noship $ */
3 --
4 --
5 function get_formula_type return number;
6 --
7 --
8 function get_formula_id(p_assignment_set_id in number) return number;
9 --
10 --
11 function get_assignment_sets_s return number;
12 --
13 --
14 procedure get_min_max_line(p_assignment_set_id in number,
15 p_min_line_no in out nocopy number,
16 p_max_line_no in out nocopy number);
17 --
18 --
19 function no_criteria_exists(p_assignment_set_id in number) return boolean;
20 --
21 --
22 procedure check_amendment_exists(p_assignment_set_id in number);
23 --
24 --
25 procedure check_unq_amendment(p_assignment_set_id in number,
26 p_assignment_id in number,
27 p_rowid in varchar2);
28 --
29 --
30 procedure check_amd_inc_exc(p_assignment_set_id in number);
31 --
32 --
33 procedure check_include_exclude(p_assignment_set_id in number,
34 p_include_exclude in varchar2,
35 p_rowid in varchar2);
36 --
37 --
38 procedure check_criteria_exists(p_assignment_set_id in number,
39 p_line_no in number default 0);
40 --
41 --
42 procedure check_operand(p_business_group_id in number,
43 p_legislation_code in varchar2,
44 p_formula_type_id in number,
45 p_data_type in out nocopy varchar2,
46 p_operand in varchar2);
47 --
48 --
49 procedure check_unique_name(p_assignment_set_name in varchar2,
50 p_business_group_id in number,
51 p_rowid in varchar2,
52 p_formula_type_id in number,
53 p_legislation_code in varchar2);
54 --
55 --
56 procedure check_line_no(p_assignment_set_id in number,
57 p_line_no in number,
58 p_rowid in varchar2);
59 --
60 --
61 procedure delete_formula(p_formula_id in number,
62 p_formula_type_id in number);
63 --
64 --
65 /*
66 * NAME
67 * fetch_dbi_info
68 *
69 * DESCRIPTION
70 * Fetches database item information given the ASSIGNMENT_SET_ID,
71 * FORMULA_TYPE_ID, and OPERAND_VALUE (database item name). This
72 * will replace FF_DATABASE_ITEMS query in the ASSIGNMENT_SET
73 * user-exit C code.
74 */
75 procedure fetch_dbi_info
76 (p_assignment_set_id in number
77 ,p_formula_type_id in number
78 ,p_date_format in varchar2
79 ,p_operand_value in varchar2
80 ,p_data_type out nocopy varchar2
81 ,p_null_allowed out nocopy varchar2
82 ,p_notfound_allowed out nocopy varchar2
83 ,p_start_of_time out nocopy varchar2
84 );
85 --
86 --
87
88 end PAY_PAYWSDAS_PKG;