APPS.BOM_SETUP_TYPES_PKG dependencies on BOM_SETUP_TYPES

Line 1: PACKAGE BODY BOM_SETUP_TYPES_PKG as

1: PACKAGE BODY BOM_SETUP_TYPES_PKG as
2: /* $Header: bompstpb.pls 120.1 2005/06/21 03:25:56 appldev ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Setup_ID IN OUT NOCOPY NUMBER,

Line 32: CURSOR C IS SELECT rowid FROM BOM_SETUP_TYPES

28: X_Attribute14 VARCHAR2 DEFAULT NULL,
29: X_Attribute15 VARCHAR2 DEFAULT NULL
30: ) IS
31:
32: CURSOR C IS SELECT rowid FROM BOM_SETUP_TYPES
33: WHERE setup_id = x_setup_id;
34: CURSOR C2 IS SELECT bom_setup_types_s.nextval FROM sys.dual;
35:
36: BEGIN

Line 34: CURSOR C2 IS SELECT bom_setup_types_s.nextval FROM sys.dual;

30: ) IS
31:
32: CURSOR C IS SELECT rowid FROM BOM_SETUP_TYPES
33: WHERE setup_id = x_setup_id;
34: CURSOR C2 IS SELECT bom_setup_types_s.nextval FROM sys.dual;
35:
36: BEGIN
37: if (x_setup_id is NULL) then
38: OPEN C2;

Line 42: INSERT INTO BOM_SETUP_TYPES(

38: OPEN C2;
39: FETCH C2 INTO x_setup_id;
40: CLOSE C2;
41: end if;
42: INSERT INTO BOM_SETUP_TYPES(
43: setup_id,
44: setup_code,
45: organization_id,
46: last_update_date,

Line 129: CURSOR C IS SELECT * FROM BOM_SETUP_TYPES

125: X_Attribute13 VARCHAR2 DEFAULT NULL,
126: X_Attribute14 VARCHAR2 DEFAULT NULL,
127: X_Attribute15 VARCHAR2 DEFAULT NULL
128: ) IS
129: CURSOR C IS SELECT * FROM BOM_SETUP_TYPES
130: WHERE rowid = X_Rowid FOR UPDATE of Setup_Id NOWAIT;
131: Recinfo C%ROWTYPE;
132: BEGIN
133: OPEN C;

Line 232: UPDATE BOM_SETUP_TYPES

228: X_Attribute14 VARCHAR2 DEFAULT NULL,
229: X_Attribute15 VARCHAR2 DEFAULT NULL
230: ) IS
231: BEGIN
232: UPDATE BOM_SETUP_TYPES
233: SET
234: setup_id = X_Setup_Id,
235: setup_code = X_Setup_Code,
236: organization_id = X_Organization_Id,

Line 267: DELETE FROM BOM_SETUP_TYPES

263:
264:
265: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
266: BEGIN
267: DELETE FROM BOM_SETUP_TYPES
268: WHERE rowid = X_rowid;
269:
270: if (SQL%NOTFOUND) then
271: Raise NO_DATA_FOUND;

Line 281: (SELECT 1 FROM BOM_SETUP_TYPES

277: X_Setup_Code VARCHAR2) IS
278: dummy NUMBER;
279: BEGIN
280: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
281: (SELECT 1 FROM BOM_SETUP_TYPES
282: WHERE Organization_Id = X_Organization_Id
283: AND Setup_Code = X_Setup_Code
284: );
285:

Line 296: /* GRANT EXECUTE ON BOM_SETUP_TYPES_PKG TO MFG; */

292: END Check_Unique;
293:
294:
295:
296: /* GRANT EXECUTE ON BOM_SETUP_TYPES_PKG TO MFG; */
297:
298:
299:
300: END BOM_SETUP_TYPES_PKG;

Line 300: END BOM_SETUP_TYPES_PKG;

296: /* GRANT EXECUTE ON BOM_SETUP_TYPES_PKG TO MFG; */
297:
298:
299:
300: END BOM_SETUP_TYPES_PKG;