PACKAGE: APPS.PAY_DYNDBI_CHANGES_PKG

Source

1 package pay_dyndbi_changes_pkg AUTHID CURRENT_USER as
2 /* $Header: pydbichg.pkh 120.2 2005/11/07 09:13:55 arashid noship $ */
3 
4 -- ========= --
5 -- Constants --
6 -- ========= --
7 C_DEFINED_BALANCE constant varchar2(16) := 'DB';
8 C_ELEMENT_TYPE    constant varchar2(16) := 'ET';
9 C_INPUT_VALUE     constant varchar2(16) := 'EIV';
10 
11 ------------------------------- insert_row -------------------------------
12 --
13 -- NAME
14 --   insert_row
15 --
16 -- DESCRIPTION
17 --   Inserts a row into PAY_DYNDBI_CHANGES. No insert is performed if
18 --   an identical row already exists.
19 --
20 procedure insert_row
21 (p_id in varchar2
22 ,p_type in varchar2
23 ,p_language in varchar2
24 );
25 
26 ------------------------------ insert_rows -------------------------------
27 --
28 -- NAME
29 --   insert_rows
30 --
31 -- DESCRIPTION
32 --   Inserts rows into PAY_DYNDBI_CHANGES. No insert is performed if
33 --   an identical row already exists.
34 --
35 procedure insert_rows
36 (p_id in varchar2
37 ,p_type in varchar2
38 ,p_languages in dbms_sql.varchar2s
39 );
40 
41 -------------------------- element_type_change ---------------------------
42 --
43 -- NAME
44 --   element_type_change
45 --
46 -- DESCRIPTION
47 --   Inserts rows into PAY_DYNDBI_CHANGES to record database items to be
48 --   regenerated after an element name translation has changed.
49 --
50 procedure element_type_change
51 (p_element_type_id in number
52 ,p_languages       in dbms_sql.varchar2s
53 );
54 
55 -------------------------- balance_type_change ---------------------------
56 --
57 -- NAME
58 --   insert_row
59 --
60 -- DESCRIPTION
61 --   Inserts rows into PAY_DYNDBI_CHANGES to record database items to be
62 --   regenerated after a balance name translation has changed.
63 --
64 procedure balance_type_change
65 (p_balance_type_id in number
66 ,p_languages       in dbms_sql.varchar2s
67 );
68 
69 --------------------------- input_value_change ---------------------------
70 --
71 -- NAME
72 --   insert_row
73 --
74 -- DESCRIPTION
75 --   Inserts rows into PAY_DYNDBI_CHANGES to record database items to be
76 --   regenerated after an element input value name translation has
77 --   changed.
78 --
79 procedure input_value_change
80 (p_input_value_id in number
81 ,p_languages      in dbms_sql.varchar2s
82 );
83 
84 ------------------------ balance_dimension_change ------------------------
85 --
86 -- NAME
87 --   insert_row
88 --
89 -- DESCRIPTION
90 --   Inserts rows into PAY_DYNDBI_CHANGES to record database items to be
91 --   regenerated after a balance dimension translation has changed.
92 --
93 procedure balance_dimension_change
94 (p_balance_dimension_id in number
95 ,p_languages            in dbms_sql.varchar2s
96 );
97 
98 ------------------------------- delete_row -------------------------------
99 --
100 -- NAME
101 --   delete_row
102 --
103 -- DESCRIPTION
104 --   Deletes a row from PAY_DYNDBI_CHANGES.
105 --
106 procedure delete_row
107 (p_id in varchar2
108 ,p_type in varchar2
109 ,p_language in varchar2
110 );
111 
112 ------------------------------ delete_rows -------------------------------
113 --
114 -- NAME
115 --   delete_row
116 --
117 -- DESCRIPTION
118 --   Deletes rows from PAY_DYNDBI_CHANGES according to id and type.
119 --
120 procedure delete_rows
121 (p_id in number
122 ,p_type in varchar2
123 );
124 
125 end pay_dyndbi_changes_pkg;