[Home] [Help]
PACKAGE: APPS.GL_LEDGER_SET_NORM_ASSIGN_PKG
Source
1 PACKAGE GL_LEDGER_SET_NORM_ASSIGN_PKG AS
2 /* $Header: glistlas.pls 120.6 2005/05/05 01:23:30 kvora ship $ */
3 --
4 -- Package
5 -- GL_LEDGER_SET_NORM_ASSIGN_PKG
6 -- Purpose
7 -- To create GL_LEDGER_SET_NORM_ASSIGN_PKG package.
8 -- History
9 -- 02-MAR-2001 K Vora Created
10 --
11
12 --
13 -- Procedure
14 -- check_unique
15 -- Purpose
16 -- Ensure that ledger or ledger set has not already been assigned to
17 -- the ledger set.
18 -- History
19 -- 02-MAR-2001 K Vora Created
20 -- Arguments
21 -- x_name The ledger/ledger set name to be checked
22 -- Example
23 -- GL_LEDGER_SET_NORM_ASSIGN_PKG.check_unique( 'LSET 1' );
24 -- Notes
25 --
26 PROCEDURE check_unique(X_Rowid VARCHAR2,
27 X_Ledger_Set_Id NUMBER,
28 X_Ledger_Id NUMBER);
29
30 -- *********************************************************************
31
32 -- The following procedures are necessary to handle insert/delete operations
33 -- in the base table.
34
35 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
36 X_Ledger_Set_Id NUMBER,
37 X_Ledger_Id NUMBER,
38 X_Object_Type_Code VARCHAR2,
39 X_Last_Update_Date DATE,
40 X_Last_Updated_By NUMBER,
41 X_Creation_Date DATE,
42 X_Created_By NUMBER,
43 X_Last_Update_Login NUMBER,
44 X_Start_Date DATE,
45 X_End_Date DATE,
46 X_Context VARCHAR2,
47 X_Attribute1 VARCHAR2,
48 X_Attribute2 VARCHAR2,
49 X_Attribute3 VARCHAR2,
50 X_Attribute4 VARCHAR2,
51 X_Attribute5 VARCHAR2,
52 X_Attribute6 VARCHAR2,
53 X_Attribute7 VARCHAR2,
54 X_Attribute8 VARCHAR2,
55 X_Attribute9 VARCHAR2,
56 X_Attribute10 VARCHAR2,
57 X_Attribute11 VARCHAR2,
58 X_Attribute12 VARCHAR2,
59 X_Attribute13 VARCHAR2,
60 X_Attribute14 VARCHAR2,
61 X_Attribute15 VARCHAR2,
62 X_Request_Id NUMBER
63 );
64
65 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
66 X_Ledger_Set_Id NUMBER,
67 X_Ledger_Id NUMBER,
68 X_Start_Date DATE,
69 X_End_Date DATE,
70 X_Context VARCHAR2,
71 X_Attribute1 VARCHAR2,
72 X_Attribute2 VARCHAR2,
73 X_Attribute3 VARCHAR2,
74 X_Attribute4 VARCHAR2,
75 X_Attribute5 VARCHAR2,
76 X_Attribute6 VARCHAR2,
77 X_Attribute7 VARCHAR2,
78 X_Attribute8 VARCHAR2,
79 X_Attribute9 VARCHAR2,
80 X_Attribute10 VARCHAR2,
81 X_Attribute11 VARCHAR2,
82 X_Attribute12 VARCHAR2,
83 X_Attribute13 VARCHAR2,
84 X_Attribute14 VARCHAR2,
85 X_Attribute15 VARCHAR2,
86 X_Request_Id NUMBER
87 );
88
89 /* This routine should be deleted if it is not required. The Ledger Sets
90 form does not use this routine. */
91 PROCEDURE Update_Row(X_Rowid VARCHAR2,
92 X_Ledger_Set_Id NUMBER,
93 X_Ledger_Id NUMBER,
94 X_Last_Update_Date DATE,
95 X_Last_Updated_By NUMBER,
96 X_Last_Update_Login NUMBER,
97 X_Start_Date DATE,
98 X_End_Date DATE,
99 X_Context VARCHAR2,
100 X_Attribute1 VARCHAR2,
101 X_Attribute2 VARCHAR2,
102 X_Attribute3 VARCHAR2,
103 X_Attribute4 VARCHAR2,
104 X_Attribute5 VARCHAR2,
105 X_Attribute6 VARCHAR2,
106 X_Attribute7 VARCHAR2,
107 X_Attribute8 VARCHAR2,
108 X_Attribute9 VARCHAR2,
109 X_Attribute10 VARCHAR2,
110 X_Attribute11 VARCHAR2,
111 X_Attribute12 VARCHAR2,
112 X_Attribute13 VARCHAR2,
113 X_Attribute14 VARCHAR2,
114 X_Attribute15 VARCHAR2,
115 X_Request_Id NUMBER
116 );
117
118 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
119
120 FUNCTION Check_Assignments_Exist(X_Ledger_Set_Id NUMBER)
121 RETURN BOOLEAN;
122
123 -- *********************************************************************
124 -- The following procedure is for the Ledger Set iSetup API.
125
126 --
127 -- Procedure
128 -- validate_ledger_assignment
129 -- Purpose
130 -- For iSetup API: validate the ledger detail assignment
131 -- History
132 -- 06-16-2004 T Cheng Created
133 -- Notes
134 --
135 PROCEDURE validate_ledger_assignment(X_Ls_Coa_Id NUMBER,
136 X_Ls_Period_Set_Name VARCHAR2,
137 X_Ls_Period_Type VARCHAR2,
138 X_Ledger_Id NUMBER);
139
140 -- *********************************************************************
141
142 END GL_LEDGER_SET_NORM_ASSIGN_PKG;