APPS.ASO_SUP_INSTANCE_VALUE_PKG dependencies on ASO_SUP_INSTANCE_VALUE

Line 1: Package Body ASO_SUP_INSTANCE_VALUE_PKG AS

1: Package Body ASO_SUP_INSTANCE_VALUE_PKG AS
2: /* $Header: asospivb.pls 120.1 2005/06/29 15:58:50 appldev ship $*/
3:
4: /* procedure to insert INSERT_ROW */
5:

Line 48: from ASO_SUP_INSTANCE_VALUE

44: IS
45:
46: cursor c is
47: select ROWID
48: from ASO_SUP_INSTANCE_VALUE
49: where INSTANCE_VALUE_ID = PX_INSTANCE_VALUE_ID ;
50:
51: cursor CU_VALUE_ID IS
52: select ASO_SUP_INST_VALUE_S.NEXTVAL from sys.dual;

Line 63: insert into ASO_SUP_INSTANCE_VALUE (

59: CLOSE CU_VALUE_ID;
60:
61: END IF;
62:
63: insert into ASO_SUP_INSTANCE_VALUE (
64: INSTANCE_VALUE_ID,
65: SECT_COMP_MAP_ID,
66: Template_Instance_ID,
67: Value,

Line 188: update ASO_SUP_INSTANCE_VALUE

184: IS
185:
186: Begin
187:
188: update ASO_SUP_INSTANCE_VALUE
189: set
190: SECT_COMP_MAP_ID = P_SECT_COMP_MAP_ID,
191: Template_Instance_ID = P_Template_Instance_ID,
192: Value = P_Value ,

Line 241: delete from ASO_SUP_INSTANCE_VALUE

237: IS
238:
239: Begin
240:
241: delete from ASO_SUP_INSTANCE_VALUE
242: where INSTANCE_VALUE_ID = P_INSTANCE_VALUE_ID;
243:
244: if (sql%notfound) then
245: raise no_data_found;

Line 319: from ASO_SUP_INSTANCE_VALUE a

315: ATTRIBUTE13 ,
316: ATTRIBUTE14 ,
317: ATTRIBUTE15
318:
319: from ASO_SUP_INSTANCE_VALUE a
320: where a.INSTANCE_VALUE_ID = P_INSTANCE_VALUE_ID
321: for update of a.INSTANCE_VALUE_ID nowait;
322:
323: recinfo i_csr%rowtype;

Line 424: END; -- Package Body ASO_SUP_INSTANCE_VALUE_PKG

420:
421:
422:
423:
424: END; -- Package Body ASO_SUP_INSTANCE_VALUE_PKG