APPS.CSP_PRODUCT_TASKS_PKG dependencies on CSP_PRODUCT_TASKS

Line 1: PACKAGE BODY CSP_PRODUCT_TASKS_PKG as

1: PACKAGE BODY CSP_PRODUCT_TASKS_PKG as
2: /* $Header: csptptab.pls 115.2 2002/11/26 06:31:18 hhaugeru noship $ */
3: -- Start of Comments
4: -- Package name : CSP_PRODUCT_TASKS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_PRODUCT_TASKS_PKG

1: PACKAGE BODY CSP_PRODUCT_TASKS_PKG as
2: /* $Header: csptptab.pls 115.2 2002/11/26 06:31:18 hhaugeru noship $ */
3: -- Start of Comments
4: -- Package name : CSP_PRODUCT_TASKS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PRODUCT_TASKS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_PRODUCT_TASKS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptptab.pls';
13:
14: PROCEDURE Insert_Row(
15: px_PRODUCT_TASK_ID IN OUT NOCOPY NUMBER,

Line 44: CURSOR C2 IS SELECT CSP_PRODUCT_TASKS_S1.nextval FROM sys.dual;

40: p_LAST_UPDATE_DATE DATE,
41: p_LAST_UPDATE_LOGIN NUMBER)
42:
43: IS
44: CURSOR C2 IS SELECT CSP_PRODUCT_TASKS_S1.nextval FROM sys.dual;
45: BEGIN
46: If (px_PRODUCT_TASK_ID IS NULL) OR (px_PRODUCT_TASK_ID = FND_API.G_MISS_NUM) then
47: OPEN C2;
48: FETCH C2 INTO px_PRODUCT_TASK_ID;

Line 51: INSERT INTO CSP_PRODUCT_TASKS(

47: OPEN C2;
48: FETCH C2 INTO px_PRODUCT_TASK_ID;
49: CLOSE C2;
50: End If;
51: INSERT INTO CSP_PRODUCT_TASKS(
52: PRODUCT_TASK_ID,
53: PRODUCT_ID,
54: TASK_TEMPLATE_ID,
55: AUTO_MANUAL,

Line 140: Update CSP_PRODUCT_TASKS

136: p_LAST_UPDATE_LOGIN NUMBER)
137:
138: IS
139: BEGIN
140: Update CSP_PRODUCT_TASKS
141: SET
142: PRODUCT_ID = decode( p_PRODUCT_ID, FND_API.G_MISS_NUM, PRODUCT_ID, p_PRODUCT_ID),
143: TASK_TEMPLATE_ID = decode( p_TASK_TEMPLATE_ID, FND_API.G_MISS_NUM, TASK_TEMPLATE_ID, p_TASK_TEMPLATE_ID),
144: AUTO_MANUAL = decode( p_AUTO_MANUAL, FND_API.G_MISS_CHAR, AUTO_MANUAL, p_AUTO_MANUAL),

Line 179: DELETE FROM CSP_PRODUCT_TASKS

175: PROCEDURE Delete_Row(
176: p_PRODUCT_TASK_ID NUMBER)
177: IS
178: BEGIN
179: DELETE FROM CSP_PRODUCT_TASKS
180: WHERE PRODUCT_TASK_ID = p_PRODUCT_TASK_ID;
181: If (SQL%NOTFOUND) then
182: RAISE NO_DATA_FOUND;
183: End If;

Line 218: FROM CSP_PRODUCT_TASKS

214:
215: IS
216: CURSOR C IS
217: SELECT *
218: FROM CSP_PRODUCT_TASKS
219: WHERE PRODUCT_TASK_ID = p_PRODUCT_TASK_ID
220: FOR UPDATE of PRODUCT_TASK_ID NOWAIT;
221: Recinfo C%ROWTYPE;
222: BEGIN

Line 319: End CSP_PRODUCT_TASKS_PKG;

315: APP_EXCEPTION.RAISE_EXCEPTION;
316: End If;
317: END Lock_Row;
318:
319: End CSP_PRODUCT_TASKS_PKG;