[Home] [Help]
PACKAGE: APPS.PAY_DEFINED_BALANCES_PKG
Source
1 PACKAGE PAY_DEFINED_BALANCES_PKG AUTHID CURRENT_USER as
2 /* $Header: pydfb01t.pkh 115.7 2004/01/06 07:06:06 rthirlby ship $ */
3 --
4 -----------------------------------------------------------------------------
5 -- Name --
6 -- chk_delete_defined_balance --
7 -- Purpose --
8 -- Check to see if it valid to remove a defined balance. --
9 -- Arguments --
10 -- See below. --
11 -- Notes --
12 -- --
13 -----------------------------------------------------------------------------
14 --
15 procedure chk_delete_defined_balance
16 (
17 p_defined_balance_id number
18 );
19 --
20 -----------------------------------------------------------------------------
21 -- function set_save_run_bals_flag
22 -- Description - sets the value of save_run_balance on pay_defined_balances,
23 -- the value is determined by the values of save_run_balance_enabled on
24 -- pay_balance_categories_f and pay_balance_dimensions.
25 -----------------------------------------------------------------------------
26 function set_save_run_bals_flag(p_balance_category_id number
27 ,p_effective_date date
28 ,p_balance_dimension_id number)
29 return varchar2;
30 -----------------------------------------------------------------------------
31 -- insert_default_attrib_wrapper
32 -- wrapper procedure insert_default_attributes used when not called directly
33 -- from forms.
34 -----------------------------------------------------------------------------
35 procedure insert_default_attrib_wrapper(p_balance_dimension_id number
36 ,p_balance_category_id number
37 ,p_def_bal_bg_id number
38 ,p_def_bal_leg_code varchar2
39 ,p_defined_balance_id number
40 ,p_effective_date date);
41 -----------------------------------------------------------------------------
42 -- procedure insert_default_attributes
43 -- Called directly when called from forms, or using the wrapper procedure
44 -- insert_default_attrib_wrapper when called from serverside code.
45 -----------------------------------------------------------------------------
46 procedure insert_default_attributes(p_balance_dimension_id number
47 ,p_balance_category_id number
48 ,p_ctl_bg_id number
49 ,p_ctl_leg_code varchar2
50 ,p_ctl_sess_date date
51 ,p_defined_balance_id number
52 ,p_dfbl_bg_id number
53 ,p_dfbl_leg_code varchar2);
54 -----------------------------------------------------------------------------
55 -- Name --
56 -- Insert_Row --
57 -- Purpose --
58 -- Table handler procedure that supports the insert of a defined --
59 -- balance via the Define Balance Type form. --
60 -- Arguments --
61 -- See below. --
62 -- Notes --
63 -- --
64 -----------------------------------------------------------------------------
65 --
66 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
67 X_Defined_Balance_Id IN OUT NOCOPY NUMBER,
68 X_Business_Group_Id NUMBER,
69 X_Legislation_Code VARCHAR2,
70 X_Balance_Type_Id NUMBER,
71 X_Balance_Dimension_Id NUMBER,
72 X_Force_Latest_Balance_Flag VARCHAR2,
73 X_Legislation_Subgroup VARCHAR2,
74 X_Grossup_Allowed_Flag VARCHAR2 DEFAULT 'N',
75 x_balance_category_id number default null,
76 x_effective_date date default null,
77 x_mode varchar2 default null);
78 --
79 -----------------------------------------------------------------------------
80 -- Name --
81 -- Lock_Row --
82 -- Purpose --
83 -- Table handler procedure that supports the insert , update and delete --
84 -- of a defined balance by applying a lock on a defined balance in the --
85 -- Define Balance Type form. --
86 -- Arguments --
87 -- See below. --
88 -- Notes --
89 -- None. --
90 -----------------------------------------------------------------------------
91 --
92 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
93 X_Defined_Balance_Id NUMBER,
94 X_Business_Group_Id NUMBER,
95 X_Legislation_Code VARCHAR2,
96 X_Balance_Type_Id NUMBER,
97 X_Balance_Dimension_Id NUMBER,
98 X_Force_Latest_Balance_Flag VARCHAR2,
99 X_Legislation_Subgroup VARCHAR2,
100 X_Grossup_Allowed_Flag VARCHAR2 DEFAULT 'N');
101 --
102 -----------------------------------------------------------------------------
103 -- Name --
104 -- Update_Row --
105 -- Purpose --
106 -- Table handler procedure that supports the update of a defined --
107 -- balance via the Define Balance Type form. --
108 -- Arguments --
109 -- See below. --
110 -- Notes --
111 -- --
112 -----------------------------------------------------------------------------
113 --
114 PROCEDURE Update_Row(X_Rowid VARCHAR2,
115 X_Defined_Balance_Id NUMBER,
116 X_Business_Group_Id NUMBER,
117 X_Legislation_Code VARCHAR2,
118 X_Balance_Type_Id NUMBER,
119 X_Balance_Dimension_Id NUMBER,
120 X_Force_Latest_Balance_Flag VARCHAR2,
121 X_Legislation_Subgroup VARCHAR2,
122 X_Grossup_Allowed_Flag VARCHAR2 DEFAULT 'N');
123 --
124 -----------------------------------------------------------------------------
125 -- Name --
126 -- Delete_Row --
127 -- Purpose --
128 -- Table handler procedure that supports the delete of a defined --
129 -- balance via the Define Balance Type form. --
130 -- Arguments --
131 -- See below. --
132 -- Notes --
133 -- --
134 -----------------------------------------------------------------------------
135 --
136 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
137 -- Extra Columns
138 X_Defined_Balance_Id NUMBER);
139 --
140 -----------------------------------------------------------------------------
141 -- Name --
142 -- verify_save_run_bal_flag_upd --
143 -- Purpose --
144 -- Called from trigger pay_defined_balances_bru to prevent the update of --
145 -- SAVE_RUN_BALANCE flag from 'Y' to 'N' or null, when valid run --
146 -- balances exist for the defined balance.
147 -- Arguments --
148 -- See below. --
149 -- Notes --
150 -----------------------------------------------------------------------------
151 PROCEDURE verify_save_run_bal_flag_upd(p_defined_balance_id number
152 ,p_old_save_run_bal_flag varchar2
153 ,p_new_save_run_bal_flag varchar2);
154 --
156 END PAY_DEFINED_BALANCES_PKG;
155 -----------------------------------------------------------------------------