APPS.ASO_SUP_RESPONSE_PKG dependencies on ASO_SUP_RESPONSE_B

Line 44: from aso_sup_response_B

40: IS
41:
42: cursor c is
43: select ROWID
44: from aso_sup_response_B
45: where RESPONSE_ID = PX_RESPONSE_ID ;
46:
47: cursor CU_RESPONSE_ID IS
48: select aso_sup_response_B_S.NEXTVAL from sys.dual;

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

44: from aso_sup_response_B
45: where RESPONSE_ID = PX_RESPONSE_ID ;
46:
47: cursor CU_RESPONSE_ID IS
48: select aso_sup_response_B_S.NEXTVAL from sys.dual;
49:
50: Begin
51:
52: IF (PX_RESPONSE_ID IS NULL) OR (PX_RESPONSE_ID = FND_API.G_MISS_NUM) THEN

Line 59: insert into ASO_SUP_RESPONSE_B (

55: CLOSE CU_RESPONSE_ID;
56:
57: END IF;
58:
59: insert into ASO_SUP_RESPONSE_B (
60: RESPONSE_ID,
61: created_by ,
62: creation_date ,
63: last_updated_by ,

Line 194: update ASO_SUP_RESPONSE_B

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

Line 262: delete from ASO_SUP_RESPONSE_B

258: raise no_data_found;
259: end if;
260:
261:
262: delete from ASO_SUP_RESPONSE_B
263: where RESPONSE_ID = P_RESPONSE_ID;
264:
265: if (sql%notfound) then
266: raise no_data_found;

Line 328: from ASO_SUP_RESPONSE_B a

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

Line 450: from ASO_SUP_RESPONSE_B B

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