APPS.IEU_WP_SECTIONS_PKG dependencies on IEU_WP_SECTIONS_B

Line 17: cursor C is select ROWID from IEU_WP_SECTIONS_B

13: P_LAST_UPDATE_DATE in DATE,
14: P_LAST_UPDATED_BY in NUMBER,
15: P_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from IEU_WP_SECTIONS_B
18: where SECTION_ID = P_SECTION_ID
19: ;
20: begin
21: insert into IEU_WP_SECTIONS_B (

Line 21: insert into IEU_WP_SECTIONS_B (

17: cursor C is select ROWID from IEU_WP_SECTIONS_B
18: where SECTION_ID = P_SECTION_ID
19: ;
20: begin
21: insert into IEU_WP_SECTIONS_B (
22: SECTION_ID,
23: OBJECT_VERSION_NUMBER,
24: SECURITY_GROUP_ID,
25: SECTION_CODE,

Line 99: from IEU_WP_SECTIONS_B

95: cursor c is select
96: OBJECT_VERSION_NUMBER,
97: SECURITY_GROUP_ID,
98: SECTION_CODE
99: from IEU_WP_SECTIONS_B
100: where SECTION_ID = P_SECTION_ID
101: for update of SECTION_ID nowait;
102: recinfo c%rowtype;
103:

Line 160: update IEU_WP_SECTIONS_B set

156: P_LAST_UPDATED_BY in NUMBER,
157: P_LAST_UPDATE_LOGIN in NUMBER
158: ) is
159: begin
160: update IEU_WP_SECTIONS_B set
161: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
162: SECURITY_GROUP_ID = P_SECURITY_GROUP_ID,
163: SECTION_CODE = P_SECTION_CODE,
164: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 199: delete from IEU_WP_SECTIONS_B

195: if (sql%notfound) then
196: raise no_data_found;
197: end if;
198:
199: delete from IEU_WP_SECTIONS_B
200: where SECTION_ID = P_SECTION_ID;
201:
202: if (sql%notfound) then
203: raise no_data_found;

Line 213: from IEU_WP_SECTIONS_B B

209: begin
210: delete from IEU_WP_SECTIONS_TL T
211: where not exists
212: (select NULL
213: from IEU_WP_SECTIONS_B B
214: where B.SECTION_ID = T.SECTION_ID
215: );
216:
217: update IEU_WP_SECTIONS_TL T set (