APPS.CSD_TASKS_PKG dependencies on CSD_TASKS

Line 1: PACKAGE BODY CSD_TASKS_PKG as

1: PACKAGE BODY CSD_TASKS_PKG as
2: /* $Header: csdttskb.pls 120.0 2005/06/26 14:57:49 sangigup noship $ csdtactb.pls */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_TASKS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtaskb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_TASKS_PKG';

1: PACKAGE BODY CSD_TASKS_PKG as
2: /* $Header: csdttskb.pls 120.0 2005/06/26 14:57:49 sangigup noship $ csdtactb.pls */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_TASKS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtaskb.pls';
6: l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
7:
8: -- Global variable for storing the debug level

Line 26: CURSOR C2 IS SELECT CSD_TASKS_S.nextval FROM sys.dual;

22: )
23:
24: IS
25:
26: CURSOR C2 IS SELECT CSD_TASKS_S.nextval FROM sys.dual;
27: BEGIN
28:
29: If (px_REPAIR_TASK_ID IS NULL) OR (px_REPAIR_TASK_ID = FND_API.G_MISS_NUM) then
30: OPEN C2;

Line 35: INSERT INTO CSD_TASKS(

31: FETCH C2 INTO px_repair_task_ID;
32: CLOSE C2;
33: End If;
34:
35: INSERT INTO CSD_TASKS(
36: REPAIR_TASK_ID
37: ,TASK_ID
38: ,OBJECT_VERSION_NUMBER
39: ,REPAIR_LINE_ID

Line 75: Update CSD_TASKS

71: )
72:
73: IS
74: BEGIN
75: Update CSD_TASKS
76: SET
77:
78: TASK_ID = decode( p_TASK_ID, FND_API.G_MISS_NUM, NULL, NULL, TASK_ID, p_TASK_ID)
79: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)

Line 99: DELETE FROM CSD_TASKS

95: PROCEDURE Delete_Row(
96: p_repair_TASK_ID NUMBER)
97: IS
98: BEGIN
99: DELETE FROM CSD_TASKS
100: WHERE REPAIR_TASK_ID = p_REPAIR_TASK_ID;
101:
102: If (SQL%NOTFOUND) then
103: RAISE NO_DATA_FOUND;

Line 115: FROM CSD_TASKS

111:
112: IS
113: CURSOR C IS
114: SELECT *
115: FROM CSD_TASKS
116: WHERE REPAIR_TASK_ID = p_REPAIR_TASK_ID
117: FOR UPDATE of REPAIR_TASK_ID NOWAIT;
118: Recinfo C%ROWTYPE;
119: BEGIN

Line 138: End CSD_TASKS_PKG;

134: END Lock_Row;
135:
136:
137:
138: End CSD_TASKS_PKG;