[Home] [Help]
PACKAGE: APPS.PAY_BALANCE_FEEDS_F_PKG
Source
1 PACKAGE PAY_BALANCE_FEEDS_F_PKG AUTHID CURRENT_USER as
2 /* $Header: pyblf01t.pkh 115.1 2003/12/08 03:56 thabara ship $ */
3 --
4 /*==========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +===========================================================================+
9 Name
10 pay_balance_feeds_f_pkg
11 Purpose
12 Used by PAYWSDBT (Define Balance Type) for the balance feeds block (BLF).
13 Notes
14
15 History
16 01-Mar-94 J.S.Hobbs 40.0 Date created.
17 01-Feb-95 J.S.Hobbs 40.4 Removed aol WHO columns.
18 19-Jul-95 D.Kerr 40.5 Changes to support initial balance
19 upload
20 Added X_Initial_Balance_Feed parameter
21 to insert,update and delete procedures.
22 New procedure check_run_result_usage.
23 02-Oct-95 D.Kerr 40.6 310643 Added overloads to insert_row,
24 update_row and delete_row
25 08-Dec-03 T.Habara 115.1 Added nocopy.
26 Added commit, dbdrv, whenever oserror.
27
28 ============================================================================*/
29 --
30 -----------------------------------------------------------------------------
31 -- Name --
32 -- Insert_Row --
33 -- Purpose --
34 -- Table handler procedure that supports the insert of a balance feed --
35 -- via the Define Balance Type form. --
36 -- Arguments --
37 -- See below. --
38 -- Notes --
39 -- --
40 -----------------------------------------------------------------------------
41 --
42 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
43 X_Balance_Feed_Id IN OUT NOCOPY NUMBER,
44 X_Effective_Start_Date DATE,
45 X_Effective_End_Date DATE,
46 X_Business_Group_Id NUMBER,
47 X_Legislation_Code VARCHAR2,
48 X_Balance_Type_Id NUMBER,
49 X_Input_Value_Id NUMBER,
50 X_Scale NUMBER,
51 X_Legislation_Subgroup VARCHAR2);
52 --
53 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
54 X_Balance_Feed_Id IN OUT NOCOPY NUMBER,
55 X_Effective_Start_Date DATE,
56 X_Effective_End_Date DATE,
57 X_Business_Group_Id NUMBER,
58 X_Legislation_Code VARCHAR2,
59 X_Balance_Type_Id NUMBER,
60 X_Input_Value_Id NUMBER,
61 X_Scale NUMBER,
62 X_Legislation_Subgroup VARCHAR2,
63 X_Initial_Balance_Feed BOOLEAN ) ;
64 --
65 -----------------------------------------------------------------------------
66 -- Name --
67 -- Lock_Row --
68 -- Purpose --
69 -- Table handler procedure that supports the insert , update and delete --
70 -- of a balance feed by applying a lock on a balance feed in the Define --
71 -- Balance Type form. --
72 -- Arguments --
73 -- See below. --
74 -- Notes --
75 -- None. --
76 -----------------------------------------------------------------------------
77 --
78 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
79 X_Balance_Feed_Id NUMBER,
80 X_Effective_Start_Date DATE,
81 X_Effective_End_Date DATE,
82 X_Business_Group_Id NUMBER,
83 X_Legislation_Code VARCHAR2,
84 X_Balance_Type_Id NUMBER,
85 X_Input_Value_Id NUMBER,
86 X_Scale NUMBER,
87 X_Legislation_Subgroup VARCHAR2);
88 --
89 -----------------------------------------------------------------------------
90 -- Name --
91 -- Update_Row --
92 -- Purpose --
93 -- Table handler procedure that supports the update of a balance feed --
94 -- via the Define Balance Type form. --
95 -- Arguments --
96 -- See below. --
97 -- Notes --
98 -- --
99 -----------------------------------------------------------------------------
100 --
101 PROCEDURE Update_Row(X_Rowid VARCHAR2,
102 X_Balance_Feed_Id NUMBER,
103 X_Effective_Start_Date DATE,
104 X_Effective_End_Date DATE,
105 X_Business_Group_Id NUMBER,
106 X_Legislation_Code VARCHAR2,
107 X_Balance_Type_Id NUMBER,
108 X_Input_Value_Id NUMBER,
109 X_Scale NUMBER,
110 X_Legislation_Subgroup VARCHAR2);
111 --
112 PROCEDURE Update_Row(X_Rowid VARCHAR2,
113 X_Balance_Feed_Id NUMBER,
114 X_Effective_Start_Date DATE,
115 X_Effective_End_Date DATE,
116 X_Business_Group_Id NUMBER,
117 X_Legislation_Code VARCHAR2,
118 X_Balance_Type_Id NUMBER,
119 X_Input_Value_Id NUMBER,
120 X_Scale NUMBER,
121 X_Legislation_Subgroup VARCHAR2,
122 X_Initial_Balance_Feed BOOLEAN ) ;
123 --
124 -----------------------------------------------------------------------------
125 -- Name --
126 -- Delete_Row --
127 -- Purpose --
128 -- Table handler procedure that supports the delete of a balance feed --
129 -- 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_Balance_Type_Id NUMBER ) ;
139 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
140 -- Extra Columns
141 X_Balance_Type_Id NUMBER,
142 X_Input_Value_Id NUMBER,
143 X_Initial_Balance_Feed BOOLEAN) ;
144 --
145 -----------------------------------------------------------------------------
146 -- Name --
147 -- check_run_result_usage --
148 -- Purpose --
149 -- Checks to see whether the given input value has produced any run --
150 -- results. This is used to prevent an initial balance feed from being --
151 -- updated or deleted. --
152 -- --
153 -- The function version returns FALSE if the input value is in use and --
154 -- TRUE otherwise --
155 -- The procedure version raises an error if the input value is in use. --
156 -- Arguments --
157 -- See below. --
158 -- Notes --
159 -- --
160 -----------------------------------------------------------------------------
161 FUNCTION check_run_result_usage ( X_Input_Value_Id IN NUMBER )
162 RETURN BOOLEAN ;
163 PROCEDURE check_run_result_usage ( X_Input_Value_Id IN NUMBER ) ;
164 --
165 END PAY_BALANCE_FEEDS_F_PKG;