PACKAGE: APPS.GL_AUTOREV_CRITERIA_SETS_PKG

Source

1 PACKAGE GL_AUTOREV_CRITERIA_SETS_PKG as
2 /* $Header: glistcss.pls 120.0 2003/09/22 17:10:55 spala noship $ */
3 
4 
5   -- Procedure
6   --   insert_criteria_set
7   -- Purpose
8   --   insert a row for each new criteria set created in the Journal
9   --   Reversal Criteria form.
10   -- Access
11   --   Called from the Journal Reversal Criteria set form
12   --
13 
14   PROCEDURE insert_row(X_Criteria_Set_Id                NUMBER,
15                        X_Criteria_Set_Name              VARCHAR2,
16                        X_Criteria_Set_Desc              VARCHAR2,
17 		       X_Creation_Date                  DATE,
18                        X_Last_Update_Date               DATE,
19 		       X_Created_By                     NUMBER,
20                        X_Last_Updated_By                NUMBER,
21                        X_Last_Update_Login              NUMBER,
22                        X_Attribute1                     VARCHAR2,
23                        X_Attribute2                     VARCHAR2,
24                        X_Attribute3                     VARCHAR2,
25                        X_Attribute4                     VARCHAR2,
26                        X_Attribute5                     VARCHAR2,
27                        X_Attribute6                     VARCHAR2,
28                        X_Attribute7                     VARCHAR2,
29                        X_Attribute8                     VARCHAR2,
30                        X_Attribute9                     VARCHAR2,
31                        X_Attribute10                    VARCHAR2,
32                        X_Attribute11                    VARCHAR2,
33                        X_Attribute12                    VARCHAR2,
34                        X_Attribute13                    VARCHAR2,
35                        X_Attribute14                    VARCHAR2,
36                        X_Attribute15                    VARCHAR2,
37                        X_Context                        VARCHAR2,
38 	               X_Security_Flag                  VARCHAR2);
39 
40 
41   -- Function
42   --   get_criteria_set_id
43   -- Purpose
44   --   Gets a new Criteria set id for each new criteria set created from
45   --   Journal Reversal Criteria Set form
46   --   Reversal Criteria form.
47   -- Access
48   --   Called from the Journal Reversal Criteria Set
49   --
50 
51   Function get_criteria_set_id RETURN NUMBER;
52 
53   -- Procedure
54   --   Delete_row
55   -- Purpose
56   --   Deltes detail rows from the gl_autoreverse_options table when a
57   --   Criteria set is being deleted from gl_autorev_criteria_set
58   -- (master table)
59   --   Reversal Criteria form.
60   -- Access
61   --   Called from the Journal Reversal Criteria Set
62   --
63 
64 
65   PROCEDURE Delete_row( X_Criteria_set_Id NUMBER);
66 
67   -- Procedure
68   --   Check_Ledger_Assign
69   -- Purpose
70   --  This function checks whether the criteria set is assigned to any ledger
71   --  If so that criteria set can not be deleted.
72   --   Reversal Criteria form.
73   -- Access
74   --   Called from the Journal Reversal Criteria Set
75   --
76 
77   Function Check_Ledger_Assign( X_Criteria_set_Id NUMBER) Return Boolean;
78 
79 
80 END GL_AUTOREV_CRITERIA_SETS_PKG;