APPS.ASO_SUP_SECTION_PKG dependencies on ASO_SUP_SECTION_B

Line 44: from ASO_SUP_SECTION_B

40: IS
41:
42: cursor c is
43: select ROWID
44: from ASO_SUP_SECTION_B
45: where SECTION_ID = PX_SECTION_ID ;
46:
47: cursor CU_SECTION_ID IS
48: select ASO_SUP_SECTION_B_S.NEXTVAL from sys.dual;

Line 48: select ASO_SUP_SECTION_B_S.NEXTVAL from sys.dual;

44: from ASO_SUP_SECTION_B
45: where SECTION_ID = PX_SECTION_ID ;
46:
47: cursor CU_SECTION_ID IS
48: select ASO_SUP_SECTION_B_S.NEXTVAL from sys.dual;
49:
50: Begin
51:
52: IF (PX_SECTION_ID IS NULL) OR (PX_SECTION_ID = FND_API.G_MISS_NUM) THEN

Line 59: insert into ASO_SUP_SECTION_B (

55: CLOSE CU_SECTION_ID;
56:
57: END IF;
58:
59: insert into ASO_SUP_SECTION_B (
60: SECTION_ID,
61: created_by ,
62: creation_date ,
63: last_updated_by ,

Line 195: update ASO_SUP_SECTION_B

191: IS
192:
193: Begin
194:
195: update ASO_SUP_SECTION_B
196: set
197: last_updated_by = P_last_updated_by,
198: last_update_date = P_last_update_date,
199: last_update_login = P_last_update_login,

Line 263: delete from ASO_SUP_SECTION_B

259: raise no_data_found;
260: end if;
261:
262:
263: delete from ASO_SUP_SECTION_B
264: where SECTION_ID = P_SECTION_ID;
265:
266: if (sql%notfound) then
267: raise no_data_found;

Line 328: from ASO_SUP_SECTION_B a

324: ATTRIBUTE13 ,
325: ATTRIBUTE14 ,
326: ATTRIBUTE15
327:
328: from ASO_SUP_SECTION_B a
329: where a.SECTION_ID = P_SECTION_ID
330: for update of a.SECTION_ID nowait;
331:
332: recinfo i_csr%rowtype;

Line 450: from ASO_SUP_SECTION_B B

446:
447: delete from ASO_SUP_SECTION_TL T
448: where not exists
449: ( select NULL
450: from ASO_SUP_SECTION_B B
451: where B.SECTION_ID = T.SECTION_ID
452: );
453:
454: update ASO_SUP_SECTION_TL T set (