[Home] [Help]
PACKAGE: APPS.RG_DSS_HIERARCHY_DETAILS_PKG
Source
1 PACKAGE RG_DSS_HIERARCHY_DETAILS_PKG as
2 /* $Header: rgidhrds.pls 120.2 2002/11/14 02:58:44 djogg ship $ */
3
4 /* Name: check_unique
5 * Desc: Check if the sequence already exists. If it does,
6 * raise an exception. If it doesn't, do nothing.
7 *
8 * History:
9 * 06/26/95 S. Rahman Created.
10 */
11 PROCEDURE check_unique_sequence(X_Rowid VARCHAR2,
12 X_Hierarchy_Id NUMBER,
13 X_Sequence NUMBER);
14
15 /* Name: check_unique
16 * Desc: Check if the segment already exists. If it does,
17 * raise an exception. If it doesn't, do nothing.
18 *
19 * History:
20 * 06/26/95 S. Rahman Created.
21 */
22 PROCEDURE check_unique_segment(X_Rowid VARCHAR2,
23 X_Hierarchy_Id NUMBER,
24 X_Application_Column_Name VARCHAR2);
25
26 /* Name: insert_row
27 * Desc: Insert a row into rg_dss_hierarchy_details. Ensure that the
28 * hierarchy name doesn't exist already. Assign the
29 * primary key (hierarchy_id). Return the rowid of the inserted
30 * row to the form.
31 *
32 * History:
33 * 06/26/95 S. Rahman Created.
34 */
35 PROCEDURE Insert_Row(X_Master_Hierarchy_Id IN OUT NOCOPY NUMBER,
36 X_Rowid IN OUT NOCOPY VARCHAR2,
37 X_Hierarchy_Id IN OUT NOCOPY NUMBER,
38 X_Sequence NUMBER,
39 X_Application_Column_Name VARCHAR2,
40 X_Root_Node VARCHAR2,
41 X_Last_Update_Date DATE,
42 X_Last_Updated_By NUMBER,
43 X_Last_Update_Login NUMBER,
44 X_Creation_Date DATE,
45 X_Created_By NUMBER,
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 );
63
64 /* Name: lock_row
65 * Desc: Lock the row specified by X_Rowid.
66 *
67 * History:
68 * 06/26/95 S. Rahman Created.
69 */
70 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
71 X_Hierarchy_Id NUMBER,
72 X_Sequence NUMBER,
73 X_Application_Column_Name VARCHAR2,
74 X_Root_Node VARCHAR2,
75 X_Context VARCHAR2,
76 X_Attribute1 VARCHAR2,
77 X_Attribute2 VARCHAR2,
78 X_Attribute3 VARCHAR2,
79 X_Attribute4 VARCHAR2,
80 X_Attribute5 VARCHAR2,
81 X_Attribute6 VARCHAR2,
82 X_Attribute7 VARCHAR2,
83 X_Attribute8 VARCHAR2,
84 X_Attribute9 VARCHAR2,
85 X_Attribute10 VARCHAR2,
86 X_Attribute11 VARCHAR2,
87 X_Attribute12 VARCHAR2,
88 X_Attribute13 VARCHAR2,
89 X_Attribute14 VARCHAR2,
90 X_Attribute15 VARCHAR2
91 );
92
93 /* Name: update_row
94 * Desc: Update the row specified by X_Rowid.
95 *
96 * History:
97 * 06/26/95 S. Rahman Created.
98 */
99 PROCEDURE Update_Row(X_Rowid VARCHAR2,
100 X_Hierarchy_Id NUMBER,
101 X_Sequence NUMBER,
102 X_Application_Column_Name VARCHAR2,
103 X_Root_Node VARCHAR2,
104 X_Last_Update_Date DATE,
105 X_Last_Updated_By NUMBER,
106 X_Last_Update_Login NUMBER,
107 X_Context VARCHAR2,
108 X_Attribute1 VARCHAR2,
109 X_Attribute2 VARCHAR2,
110 X_Attribute3 VARCHAR2,
111 X_Attribute4 VARCHAR2,
112 X_Attribute5 VARCHAR2,
113 X_Attribute6 VARCHAR2,
114 X_Attribute7 VARCHAR2,
115 X_Attribute8 VARCHAR2,
116 X_Attribute9 VARCHAR2,
117 X_Attribute10 VARCHAR2,
118 X_Attribute11 VARCHAR2,
119 X_Attribute12 VARCHAR2,
120 X_Attribute13 VARCHAR2,
121 X_Attribute14 VARCHAR2,
122 X_Attribute15 VARCHAR2
123 );
124
125 /* Name: delete_row
126 * Desc: Delete the row specified by X_Rowid.
127 *
128 * History:
129 * 06/26/95 S. Rahman Created.
130 */
131 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Hierarchy_Id NUMBER);
132
133
134 END RG_DSS_HIERARCHY_DETAILS_PKG;