APPS.ASO_SUP_TMPL_INSTANCE_PKG dependencies on ASO_SUP_TMPL_INSTANCE

Line 1: Package Body ASO_SUP_TMPL_INSTANCE_PKG AS

1: Package Body ASO_SUP_TMPL_INSTANCE_PKG AS
2: /* $Header: asosptib.pls 120.1 2005/06/29 12:38:22 appldev ship $*/
3:
4: /* procedure to insert INSERT_ROW */
5:

Line 45: from ASO_SUP_TMPL_INSTANCE

41: IS
42:
43: cursor c is
44: select ROWID
45: from ASO_SUP_TMPL_INSTANCE
46: where TEMPLATE_INSTANCE_ID = PX_TEMPLATE_INSTANCE_ID ;
47:
48: cursor CU_TEMPLATE_INSTANCE_ID IS
49: select ASO_SUP_TMPL_INSTANCE_S.NEXTVAL from sys.dual;

Line 49: select ASO_SUP_TMPL_INSTANCE_S.NEXTVAL from sys.dual;

45: from ASO_SUP_TMPL_INSTANCE
46: where TEMPLATE_INSTANCE_ID = PX_TEMPLATE_INSTANCE_ID ;
47:
48: cursor CU_TEMPLATE_INSTANCE_ID IS
49: select ASO_SUP_TMPL_INSTANCE_S.NEXTVAL from sys.dual;
50:
51: Begin
52:
53: IF (PX_TEMPLATE_INSTANCE_ID IS NULL) OR (PX_TEMPLATE_INSTANCE_ID = FND_API.G_MISS_NUM) THEN

Line 60: insert into ASO_SUP_TMPL_INSTANCE (

56: CLOSE CU_TEMPLATE_INSTANCE_ID;
57:
58: END IF;
59:
60: insert into ASO_SUP_TMPL_INSTANCE (
61: TEMPLATE_INSTANCE_ID,
62: TEMPLATE_ID,
63: Owner_Table_Name,
64: Owner_Table_Id,

Line 179: update ASO_SUP_TMPL_INSTANCE

175: IS
176:
177: Begin
178:
179: update ASO_SUP_TMPL_INSTANCE
180: set
181: TEMPLATE_ID = P_TEMPLATE_ID,
182: Owner_Table_Name = P_Owner_Table_Name ,
183: Owner_Table_Id = P_Owner_Table_Id ,

Line 230: delete from ASO_SUP_TMPL_INSTANCE

226: IS
227:
228: Begin
229:
230: delete from ASO_SUP_TMPL_INSTANCE
231: where TEMPLATE_INSTANCE_ID = P_TEMPLATE_INSTANCE_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 303: from ASO_SUP_TMPL_INSTANCE a

299: ATTRIBUTE12 ,
300: ATTRIBUTE13 ,
301: ATTRIBUTE14 ,
302: ATTRIBUTE15
303: from ASO_SUP_TMPL_INSTANCE a
304: where a.TEMPLATE_INSTANCE_ID = P_TEMPLATE_INSTANCE_ID
305: for update of a.TEMPLATE_INSTANCE_ID nowait;
306:
307: recinfo i_csr%rowtype;

Line 405: END; -- Package Body ASO_SUP_TMPL_INSTANCE_PKG

401:
402:
403:
404:
405: END; -- Package Body ASO_SUP_TMPL_INSTANCE_PKG