APPS.CSP_PART_PRIORITIES_PKG dependencies on CSP_PART_PRIORITIES

Line 1: PACKAGE BODY CSP_PART_PRIORITIES_PKG as

1: PACKAGE BODY CSP_PART_PRIORITIES_PKG as
2: /* $Header: csptpapb.pls 115.0 2003/06/10 19:49:19 ajosephg noship $ */
3: -- Start of Comments
4: -- Package name : CSP_PART_PRIORITIES_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_PART_PRIORITIES_PKG

1: PACKAGE BODY CSP_PART_PRIORITIES_PKG as
2: /* $Header: csptpapb.pls 115.0 2003/06/10 19:49:19 ajosephg noship $ */
3: -- Start of Comments
4: -- Package name : CSP_PART_PRIORITIES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PART_PRIORITIES_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PART_PRIORITIES_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptpapb.pls';
12:
13: PROCEDURE Insert_Row(
14: px_PART_PRIORITY_ID IN OUT NOCOPY NUMBER,

Line 25: CURSOR C2 IS SELECT CSP_PART_PRIORITIES_S1.nextval FROM sys.dual;

21: p_LAST_UPDATE_DATE DATE,
22: p_LAST_UPDATE_LOGIN NUMBER)
23:
24: IS
25: CURSOR C2 IS SELECT CSP_PART_PRIORITIES_S1.nextval FROM sys.dual;
26: BEGIN
27: If (px_PART_PRIORITY_ID IS NULL) OR (px_PART_PRIORITY_ID = FND_API.G_MISS_NUM) then
28: OPEN C2;
29: FETCH C2 INTO px_PART_PRIORITY_ID;

Line 33: INSERT INTO CSP_PART_PRIORITIES(

29: FETCH C2 INTO px_PART_PRIORITY_ID;
30: CLOSE C2;
31: End If;
32:
33: INSERT INTO CSP_PART_PRIORITIES(
34: PART_PRIORITY_ID,
35: PRIORITY,
36: LOWER_RANGE,
37: UPPER_RANGE,

Line 68: Update CSP_PART_PRIORITIES

64: p_LAST_UPDATE_LOGIN NUMBER)
65:
66: IS
67: BEGIN
68: Update CSP_PART_PRIORITIES
69: SET PRIORITY = decode( p_PRIORITY, FND_API.G_MISS_CHAR, PRIORITY, p_PRIORITY),
70: LOWER_RANGE = decode( p_LOWER_RANGE, FND_API.G_MISS_NUM, LOWER_RANGE, p_LOWER_RANGE),
71: UPPER_RANGE = decode( p_UPPER_RANGE, FND_API.G_MISS_NUM, UPPER_RANGE, p_UPPER_RANGE),
72: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 88: DELETE FROM CSP_PART_PRIORITIES

84: PROCEDURE Delete_Row(
85: p_PART_PRIORITY_ID NUMBER)
86: IS
87: BEGIN
88: DELETE FROM CSP_PART_PRIORITIES
89: WHERE PART_PRIORITY_ID = p_PART_PRIORITY_ID;
90: If (SQL%NOTFOUND) then
91: RAISE NO_DATA_FOUND;
92: End If;

Line 109: FROM CSP_PART_PRIORITIES

105:
106: IS
107: CURSOR C IS
108: SELECT *
109: FROM CSP_PART_PRIORITIES
110: WHERE PART_PRIORITY_ID = p_PART_PRIORITY_ID
111: FOR UPDATE of PART_PRIORITY_ID NOWAIT;
112: Recinfo C%ROWTYPE;
113: BEGIN

Line 157: End CSP_PART_PRIORITIES_PKG;

153: APP_EXCEPTION.RAISE_EXCEPTION;
154: End If;
155: END Lock_Row;
156:
157: End CSP_PART_PRIORITIES_PKG;