[Home] [Help]
PACKAGE: APPS.PSB_ENTITY_SET_PVT
Source
1 package PSB_ENTITY_SET_PVT as
2 /* $Header: PSBVESPS.pls 120.5 2005/03/16 05:32:46 shtripat ship $ */
3
4 procedure INSERT_ROW (
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 p_return_status OUT NOCOPY VARCHAR2,
10 p_msg_count OUT NOCOPY NUMBER,
11 p_msg_data OUT NOCOPY VARCHAR2,
12 --
13 P_ROWID in OUT NOCOPY VARCHAR2,
14 P_ENTITY_SET_ID in NUMBER,
15 P_ENTITY_TYPE in VARCHAR2,
16 P_NAME in VARCHAR2,
17 P_DESCRIPTION in VARCHAR2,
18 P_BUDGET_GROUP_ID in NUMBER,
19 P_SET_OF_BOOKS_ID in NUMBER,
20 P_DATA_EXTRACT_ID IN NUMBER,
21 P_CONSTRAINT_THRESHOLD in NUMBER,
22 /* Budget Revision Rules Enhancement Start */
23 P_ENABLE_FLAG in VARCHAR2,
24 /* Budget Revision Rules Enhancement End */
25 /* Bug 4151746 Start */
26 P_EXECUTABLE_FROM_POSITION IN VARCHAR2 DEFAULT NULL,
27 /* Bug 4151746 End */
28 P_ATTRIBUTE1 in VARCHAR2,
29 P_ATTRIBUTE2 in VARCHAR2,
30 P_ATTRIBUTE3 in VARCHAR2,
31 P_ATTRIBUTE4 in VARCHAR2,
32 P_ATTRIBUTE5 in VARCHAR2,
33 P_ATTRIBUTE6 in VARCHAR2,
34 P_ATTRIBUTE7 in VARCHAR2,
35 P_ATTRIBUTE8 in VARCHAR2,
36 P_ATTRIBUTE9 in VARCHAR2,
37 P_ATTRIBUTE10 in VARCHAR2,
38 P_CONTEXT in VARCHAR2,
39 p_Last_Update_Date DATE,
40 p_Last_Updated_By NUMBER,
41 p_Last_Update_Login NUMBER,
42 p_Created_By NUMBER,
43 p_Creation_Date DATE
44 );
45
46 procedure LOCK_ROW (
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 p_return_status OUT NOCOPY VARCHAR2,
52 p_msg_count OUT NOCOPY NUMBER,
53 p_msg_data OUT NOCOPY VARCHAR2,
54 p_lock_row OUT NOCOPY VARCHAR2,
55 --
56 P_ENTITY_SET_ID in NUMBER,
57 P_ENTITY_TYPE in VARCHAR2,
58 P_NAME in VARCHAR2,
59 P_DESCRIPTION in VARCHAR2,
60 P_BUDGET_GROUP_ID in NUMBER,
61 P_SET_OF_BOOKS_ID in NUMBER,
62 P_DATA_EXTRACT_ID IN NUMBER,
63 P_CONSTRAINT_THRESHOLD in NUMBER,
64 /* Budget Revision Rules Enhancement Start */
65 P_ENABLE_FLAG in VARCHAR2,
66 /* Budget Revision Rules Enhancement End */
67 /* Bug 4151746 Start */
68 P_EXECUTABLE_FROM_POSITION IN VARCHAR2 DEFAULT NULL,
69 /* Bug 4151746 End */
70 P_ATTRIBUTE1 in VARCHAR2,
71 P_ATTRIBUTE2 in VARCHAR2,
72 P_ATTRIBUTE3 in VARCHAR2,
73 P_ATTRIBUTE4 in VARCHAR2,
74 P_ATTRIBUTE5 in VARCHAR2,
75 P_ATTRIBUTE6 in VARCHAR2,
76 P_ATTRIBUTE7 in VARCHAR2,
77 P_ATTRIBUTE8 in VARCHAR2,
78 P_ATTRIBUTE9 in VARCHAR2,
79 P_ATTRIBUTE10 in VARCHAR2,
80 P_CONTEXT in VARCHAR2
81 );
82
83 procedure UPDATE_ROW (
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 p_return_status OUT NOCOPY VARCHAR2,
89 p_msg_count OUT NOCOPY NUMBER,
90 p_msg_data OUT NOCOPY VARCHAR2,
91 --
92 P_ENTITY_SET_ID in NUMBER,
93 P_ENTITY_TYPE in VARCHAR2,
94 P_NAME in VARCHAR2,
95 P_DESCRIPTION in VARCHAR2,
96 P_BUDGET_GROUP_ID in NUMBER,
97 P_SET_OF_BOOKS_ID in NUMBER,
98 P_DATA_EXTRACT_ID IN NUMBER,
99 P_CONSTRAINT_THRESHOLD in NUMBER,
100 /* Budget Revision Rules Enhancement Start */
101 P_ENABLE_FLAG in VARCHAR2,
102 /* Budget Revision Rules Enhancement End */
103 /* Bug 4151746 Start */
104 P_EXECUTABLE_FROM_POSITION IN VARCHAR2 DEFAULT NULL,
105 /* Bug 4151746 End */
106 P_ATTRIBUTE1 in VARCHAR2,
107 P_ATTRIBUTE2 in VARCHAR2,
108 P_ATTRIBUTE3 in VARCHAR2,
109 P_ATTRIBUTE4 in VARCHAR2,
110 P_ATTRIBUTE5 in VARCHAR2,
111 P_ATTRIBUTE6 in VARCHAR2,
112 P_ATTRIBUTE7 in VARCHAR2,
113 P_ATTRIBUTE8 in VARCHAR2,
114 P_ATTRIBUTE9 in VARCHAR2,
115 P_ATTRIBUTE10 in VARCHAR2,
116 P_CONTEXT in VARCHAR2,
117 p_Last_Update_Date DATE,
118 p_Last_Updated_By NUMBER,
119 p_Last_Update_Login NUMBER
120 );
121
122 procedure DELETE_ROW (
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 p_return_status OUT NOCOPY VARCHAR2,
128 p_msg_count OUT NOCOPY NUMBER,
129 p_msg_data OUT NOCOPY VARCHAR2,
130 --
131 P_ENTITY_SET_ID in NUMBER
132 );
133
134 PROCEDURE Copy_Entity_Set
135 ( p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137 p_commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 p_return_status OUT NOCOPY VARCHAR2,
140 p_msg_count OUT NOCOPY NUMBER,
141 p_msg_data OUT NOCOPY VARCHAR2,
142 p_source_entity_set_id IN NUMBER,
143 p_target_entity_set_id IN NUMBER,
144 p_target_data_extract_id IN NUMBER,
145 p_entity_type IN VARCHAR2
146 );
147
148 /*For Bug No : 2397852 Start*/
149 PROCEDURE Check_References
150 (
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2,
153 p_commit IN VARCHAR2,
154 p_validation_level IN NUMBER,
155 p_return_status OUT NOCOPY VARCHAR2,
156 p_msg_count OUT NOCOPY NUMBER,
157 p_msg_data OUT NOCOPY VARCHAR2,
158 --
159 p_entity_set_id IN NUMBER,
160 p_return_value OUT NOCOPY VARCHAR2
161 );
162 /*For Bug No : 2397852 End*/
163
164 end PSB_ENTITY_SET_PVT;