APPS.ASO_SUP_SECT_COMP_MAP_PKG dependencies on ASO_SUP_SECT_COMP_MAP

Line 1: Package Body ASO_SUP_SECT_COMP_MAP_PKG AS

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

Line 50: from ASO_SUP_SECT_COMP_MAP

46: IS
47:
48: cursor c is
49: select ROWID
50: from ASO_SUP_SECT_COMP_MAP
51: where SECT_COMP_MAP_ID = PX_SECT_COMP_MAP_ID ;
52:
53: cursor CU_SECT_COMP_MAP_ID IS
54: select ASO_SUP_SECT_COMP_MAP_S.NEXTVAL from sys.dual;

Line 54: select ASO_SUP_SECT_COMP_MAP_S.NEXTVAL from sys.dual;

50: from ASO_SUP_SECT_COMP_MAP
51: where SECT_COMP_MAP_ID = PX_SECT_COMP_MAP_ID ;
52:
53: cursor CU_SECT_COMP_MAP_ID IS
54: select ASO_SUP_SECT_COMP_MAP_S.NEXTVAL from sys.dual;
55:
56: Begin
57:
58: IF (PX_SECT_COMP_MAP_ID IS NULL) OR (PX_SECT_COMP_MAP_ID = FND_API.G_MISS_NUM) THEN

Line 65: insert into ASO_SUP_SECT_COMP_MAP (

61: CLOSE CU_SECT_COMP_MAP_ID;
62:
63: END IF;
64:
65: insert into ASO_SUP_SECT_COMP_MAP (
66: SECT_COMP_MAP_ID,
67: COMPONENT_ID,
68: SECTION_ID ,
69: DISPLAY_SEQUENCE,

Line 194: update ASO_SUP_SECT_COMP_MAP

190: IS
191:
192: Begin
193:
194: update ASO_SUP_SECT_COMP_MAP
195: set
196: COMPONENT_ID = P_COMPONENT_ID,
197: SECTION_ID = P_SECTION_ID,
198: DISPLAY_SEQUENCE = P_DISPLAY_SEQUENCE,

Line 249: delete from ASO_SUP_SECT_COMP_MAP

245: IS
246:
247: Begin
248:
249: delete from ASO_SUP_SECT_COMP_MAP
250: where SECT_COMP_MAP_ID = P_SECT_COMP_MAP_ID;
251:
252: if (sql%notfound) then
253: raise no_data_found;

Line 331: from ASO_SUP_SECT_COMP_MAP a

327: ATTRIBUTE13 ,
328: ATTRIBUTE14 ,
329: ATTRIBUTE15
330:
331: from ASO_SUP_SECT_COMP_MAP a
332: where a.SECT_COMP_MAP_ID = P_SECT_COMP_MAP_ID
333: for update of a.SECT_COMP_MAP_ID nowait;
334:
335: recinfo i_csr%rowtype;

Line 437: END; -- Package Body ASO_SUP_SECT_COMP_MAP_PKG

433:
434: End Lock_Row;
435:
436:
437: END; -- Package Body ASO_SUP_SECT_COMP_MAP_PKG