APPS.ASO_SUP_TEMPLATE_PKG dependencies on ASO_SUP_TEMPLATE_B

Line 46: from ASO_SUP_TEMPLATE_B

42: IS
43:
44: cursor c is
45: select ROWID
46: from ASO_SUP_TEMPLATE_B
47: where TEMPLATE_ID = PX_TEMPLATE_ID ;
48:
49: cursor CU_TEMPLATE_ID IS
50: select ASO_SUP_TEMPLATE_B_S.NEXTVAL from sys.dual;

Line 50: select ASO_SUP_TEMPLATE_B_S.NEXTVAL from sys.dual;

46: from ASO_SUP_TEMPLATE_B
47: where TEMPLATE_ID = PX_TEMPLATE_ID ;
48:
49: cursor CU_TEMPLATE_ID IS
50: select ASO_SUP_TEMPLATE_B_S.NEXTVAL from sys.dual;
51:
52: Begin
53:
54: IF (PX_TEMPLATE_ID IS NULL) OR (PX_TEMPLATE_ID = FND_API.G_MISS_NUM) THEN

Line 63: insert into ASO_SUP_TEMPLATE_B (

59: END IF;
60:
61: -- added new column as per bug 2940126
62:
63: insert into ASO_SUP_TEMPLATE_B (
64: TEMPLATE_ID,
65: created_by ,
66: creation_date ,
67: last_updated_by ,

Line 205: update ASO_SUP_TEMPLATE_B

201: IS
202:
203: Begin
204: -- added new column as per bug 2940126
205: update ASO_SUP_TEMPLATE_B
206: set
207: last_updated_by = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
208: last_update_date = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
209: last_update_login = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 275: delete from ASO_SUP_TEMPLATE_B

271: raise no_data_found;
272: end if;
273:
274:
275: delete from ASO_SUP_TEMPLATE_B
276: where TEMPLATE_ID = P_TEMPLATE_ID;
277:
278: if (sql%notfound) then
279: raise no_data_found;

Line 344: from ASO_SUP_TEMPLATE_B a

340: ATTRIBUTE13 ,
341: ATTRIBUTE14 ,
342: ATTRIBUTE15
343:
344: from ASO_SUP_TEMPLATE_B a
345: where a.TEMPLATE_ID = P_TEMPLATE_ID
346: for update of a.TEMPLATE_ID nowait;
347:
348: recinfo i_csr%rowtype;

Line 476: from ASO_SUP_TEMPLATE_B B

472:
473: delete from ASO_SUP_TEMPLATE_TL T
474: where not exists
475: ( select NULL
476: from ASO_SUP_TEMPLATE_B B
477: where B.TEMPLATE_ID = T.TEMPLATE_ID
478: );
479:
480: update ASO_SUP_TEMPLATE_TL T set (