APPS.CSD_SO_ORCHESTRATION_PKG dependencies on CSD_SO_ORCHESTRATION

Line 1: PACKAGE BODY CSD_SO_ORCHESTRATION_PKG as

1: PACKAGE BODY CSD_SO_ORCHESTRATION_PKG as
2: /* $Header: csdtsoob.pls 120.0.12020000.1 2013/01/09 02:27:38 vicli noship $ */
3: -- Start of Comments
4: -- Package name : CSD_SO_ORCHESTRATION_PKG
5: -- Purpose :

Line 4: -- Package name : CSD_SO_ORCHESTRATION_PKG

1: PACKAGE BODY CSD_SO_ORCHESTRATION_PKG as
2: /* $Header: csdtsoob.pls 120.0.12020000.1 2013/01/09 02:27:38 vicli noship $ */
3: -- Start of Comments
4: -- Package name : CSD_SO_ORCHESTRATION_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_SO_ORCHESTRATION_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtsoob.pls';
13: l_debug NUMBER ;
14:
15: PROCEDURE Insert_Row(

Line 52: CURSOR C2 IS SELECT CSD_SO_ORCHESTRATION_S1.nextval FROM sys.dual;

48: ,p_PARAMN1 NUMBER
49: )
50:
51: IS
52: CURSOR C2 IS SELECT CSD_SO_ORCHESTRATION_S1.nextval FROM sys.dual;
53: BEGIN
54: If (px_ORCHESTRATION_ID IS NULL) OR (px_ORCHESTRATION_ID = FND_API.G_MISS_NUM) then
55: OPEN C2;
56: FETCH C2 INTO px_ORCHESTRATION_ID;

Line 59: INSERT INTO CSD_SO_ORCHESTRATION(

55: OPEN C2;
56: FETCH C2 INTO px_ORCHESTRATION_ID;
57: CLOSE C2;
58: End If;
59: INSERT INTO CSD_SO_ORCHESTRATION(
60: ORCHESTRATION_ID
61: ,REPAIR_LINE_ID
62: ,OBJECT_VERSION_NUMBER
63: ,CREATED_BY

Line 133: Description: Procedure to update a row in the CSD_SO_ORCHESTRATION table,which stores SOO documents.

129:
130:
131: /*
132: Name: Update_Row
133: Description: Procedure to update a row in the CSD_SO_ORCHESTRATION table,which stores SOO documents.
134: */
135: PROCEDURE Update_Row(
136: p_ORCHESTRATION_ID NUMBER
137: ,p_REPAIR_LINE_ID NUMBER

Line 173: Update CSD_SO_ORCHESTRATION

169: )
170:
171: IS
172: BEGIN
173: Update CSD_SO_ORCHESTRATION
174: SET
175: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
176: ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
177: ,CREATED_BY = decode( P_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, P_CREATED_BY)

Line 219: DELETE FROM CSD_SO_ORCHESTRATION

215: PROCEDURE Delete_Row(
216: p_ORCHESTRATION_ID NUMBER)
217: IS
218: BEGIN
219: DELETE FROM CSD_SO_ORCHESTRATION
220: WHERE ORCHESTRATION_ID = p_ORCHESTRATION_ID;
221: If (SQL%NOTFOUND) then
222: RAISE NO_DATA_FOUND;
223: End If;

Line 235: FROM CSD_SO_ORCHESTRATION

231:
232: IS
233: CURSOR C IS
234: SELECT *
235: FROM CSD_SO_ORCHESTRATION
236: WHERE ORCHESTRATION_ID = p_ORCHESTRATION_ID
237: FOR UPDATE of ORCHESTRATION_ID NOWAIT;
238: Recinfo C%ROWTYPE;
239: BEGIN

Line 251: csd_gen_utility_pvt.add('CSD_SO_ORCHESTRATION_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);

247: CLOSE C;
248:
249: l_debug := csd_gen_utility_pvt.g_debug_level;
250: IF l_debug > 0 THEN
251: csd_gen_utility_pvt.add('CSD_SO_ORCHESTRATION_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
252: csd_gen_utility_pvt.add('CSD_SO_ORCHESTRATION_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
253: END IF;
254:
255: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then

Line 252: csd_gen_utility_pvt.add('CSD_SO_ORCHESTRATION_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);

248:
249: l_debug := csd_gen_utility_pvt.g_debug_level;
250: IF l_debug > 0 THEN
251: csd_gen_utility_pvt.add('CSD_SO_ORCHESTRATION_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
252: csd_gen_utility_pvt.add('CSD_SO_ORCHESTRATION_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
253: END IF;
254:
255: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then
256: return;

Line 264: End CSD_SO_ORCHESTRATION_PKG;

260: End If;
261:
262: END Lock_Row;
263:
264: End CSD_SO_ORCHESTRATION_PKG;