[Home] [Help]
PACKAGE: APPS.PAY_BAL_CLASSIFICATIONS_PKG
Source
1 PACKAGE PAY_BAL_CLASSIFICATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: pyblc01t.pkh 115.4 2002/12/06 14:20:15 alogue ship $ */
3 --
4 /*==========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +===========================================================================+
9 Name
10 pay_bal_classifications_pkg
11 Purpose
12 Used by PAYWSDBT (Define Balance Type) for the balance classification
13 block (BLC).
14 Notes
15
16 History
17 01-Mar-94 J.S.Hobbs 40.0 Date created.
18 01-Feb-95 J.S.Hobbs 40.4 Removed aol WHO columns.
19 16-NOV-2001 RThirlby 115.1 930964 New parameter X_mode added to procedure
20 delivered in patch 2000669 insert_row so that the startup mode
21 (either GENERIC, STARTUP or USER) can
22 be identified. This is required, as a
23 enhancement request was made where by
24 functionality for chk_bal_clasification
25 if different depending on what mode
26 you are in. In USER mode there is no
27 change. In STARTUP mode, it is now
28 possible to feed a balance from more
29 than one secondary classifcation.
30 16-NOV-2001 RThirlby 115.2 Added commit to end of file for GSCC
31 standards.
32 01-JUL-2002 RCallaghan 115.3 Added checkfile line
33 06-DEC-2002 ALogue 115.4 NOCOPY changes. Bug 2692195.
34 ============================================================================*/
35 --
36 -----------------------------------------------------------------------------
37 -- Name --
38 -- Insert_Row --
39 -- Purpose --
40 -- Table handler procedure that supports the insert of a balance --
41 -- classification via the Define Balance Type form. --
42 -- Arguments --
43 -- See below. --
44 -- Bug 930964 - new parameter X_mode, to enable different functionality --
45 -- in chk_balance_classification depending on the startup --
46 -- mode.
47 -- Notes --
48 -- --
49 -----------------------------------------------------------------------------
50 --
51 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
52 X_Balance_Classification_Id IN OUT NOCOPY NUMBER,
53 X_Business_Group_Id NUMBER,
54 X_Legislation_Code VARCHAR2,
55 X_Balance_Type_Id NUMBER,
56 X_Classification_Id NUMBER,
57 X_Scale NUMBER,
58 X_Legislation_Subgroup VARCHAR2,
59 X_mode VARCHAR2 default null);
60 --
61 -----------------------------------------------------------------------------
62 -- Name --
63 -- Lock_Row --
64 -- Purpose --
65 -- Table handler procedure that supports the insert , update and delete --
66 -- of a balance classification by applying a lock on a balance --
67 -- classification in the Define Balance Type form. --
68 -- Arguments --
69 -- See below. --
70 -- Notes --
71 -- None. --
72 -----------------------------------------------------------------------------
73 --
74 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
75 X_Balance_Classification_Id NUMBER,
76 X_Business_Group_Id NUMBER,
77 X_Legislation_Code VARCHAR2,
78 X_Balance_Type_Id NUMBER,
79 X_Classification_Id NUMBER,
80 X_Scale NUMBER,
81 X_Legislation_Subgroup VARCHAR2);
82 --
83 -----------------------------------------------------------------------------
84 -- Name --
85 -- Update_Row --
86 -- Purpose --
87 -- Table handler procedure that supports the update of a balance --
88 -- classification via the Define Balance Type form. --
89 -- Arguments --
90 -- See below. --
91 -- Notes --
92 -- None. --
93 -----------------------------------------------------------------------------
94 --
95 PROCEDURE Update_Row(X_Rowid VARCHAR2,
96 X_Balance_Classification_Id NUMBER,
97 X_Business_Group_Id NUMBER,
98 X_Legislation_Code VARCHAR2,
99 X_Balance_Type_Id NUMBER,
100 X_Classification_Id NUMBER,
101 X_Scale NUMBER,
102 X_Legislation_Subgroup VARCHAR2);
103 --
104 -----------------------------------------------------------------------------
105 -- Name --
106 -- Delete_Row --
107 -- Purpose --
108 -- Table handler procedure that supports the delete of a balance --
109 -- classification via the Define Balance Type form. --
110 -- Arguments --
111 -- See below. --
112 -- Notes --
113 -- None. --
114 -----------------------------------------------------------------------------
115 --
116 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
117 -- Extra Columns
118 X_Balance_Classification_Id NUMBER);
119 --
120 END PAY_BAL_CLASSIFICATIONS_PKG;