APPS.CSD_PRODUCT_TRANSACTIONS_PKG dependencies on CSD_PRODUCT_TRANSACTIONS

Line 1: PACKAGE BODY CSD_PRODUCT_TRANSACTIONS_PKG as

1: PACKAGE BODY CSD_PRODUCT_TRANSACTIONS_PKG as
2: /* $Header: csdtptxb.pls 120.3.12010000.2 2008/09/18 18:46:31 nnadig ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_PRODUCT_TRANSACTIONS_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_PRODUCT_TRANSACTIONS_PKG';

1: PACKAGE BODY CSD_PRODUCT_TRANSACTIONS_PKG as
2: /* $Header: csdtptxb.pls 120.3.12010000.2 2008/09/18 18:46:31 nnadig ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_PRODUCT_TRANSACTIONS_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtptxb.pls';
7: l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
8:
9: PROCEDURE Insert_Row(

Line 66: CURSOR C2 IS SELECT CSD_PRODUCT_TRANSACTIONS_S1.nextval FROM sys.dual;

62: P_INTERNAL_PO_HEADER_ID NUMBER -- swai: bug 6148019
63: )
64:
65: IS
66: CURSOR C2 IS SELECT CSD_PRODUCT_TRANSACTIONS_S1.nextval FROM sys.dual;
67: BEGIN
68: -- Since Product transaction id is a primary key, it is good if value is always
69: -- generated from a sequence. This is to fix bug 3215153 saupadhy
70: -- If (px_PRODUCT_TRANSACTION_ID IS NULL) OR (px_PRODUCT_TRANSACTION_ID = FND_API.G_MISS_NUM) then

Line 75: INSERT INTO CSD_PRODUCT_TRANSACTIONS(

71: OPEN C2;
72: FETCH C2 INTO px_PRODUCT_TRANSACTION_ID;
73: CLOSE C2;
74: -- End If;
75: INSERT INTO CSD_PRODUCT_TRANSACTIONS(
76: PRODUCT_TRANSACTION_ID,
77: REPAIR_LINE_ID,
78: ESTIMATE_DETAIL_ID,
79: ACTION_TYPE,

Line 247: Update CSD_PRODUCT_TRANSACTIONS

243: )
244: IS
245: BEGIN
246: NULL ;
247: Update CSD_PRODUCT_TRANSACTIONS
248: SET
249: REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID),
250: ESTIMATE_DETAIL_ID = decode( p_ESTIMATE_DETAIL_ID, FND_API.G_MISS_NUM, ESTIMATE_DETAIL_ID, p_ESTIMATE_DETAIL_ID),
251: ACTION_TYPE = decode( p_ACTION_TYPE, FND_API.G_MISS_CHAR, ACTION_TYPE, p_ACTION_TYPE),

Line 314: DELETE FROM CSD_PRODUCT_TRANSACTIONS

310: PROCEDURE Delete_Row(
311: p_PRODUCT_TRANSACTION_ID NUMBER)
312: IS
313: BEGIN
314: DELETE FROM CSD_PRODUCT_TRANSACTIONS
315: WHERE PRODUCT_TRANSACTION_ID = p_PRODUCT_TRANSACTION_ID;
316: If (SQL%NOTFOUND) then
317: RAISE NO_DATA_FOUND;
318: End If;

Line 327: FROM CSD_PRODUCT_TRANSACTIONS

323: p_OBJECT_VERSION_NUMBER NUMBER)
324: IS
325: CURSOR C IS
326: SELECT *
327: FROM CSD_PRODUCT_TRANSACTIONS
328: WHERE PRODUCT_TRANSACTION_ID = p_PRODUCT_TRANSACTION_ID
329: FOR UPDATE of PRODUCT_TRANSACTION_ID NOWAIT;
330: Recinfo C%ROWTYPE;
331: BEGIN

Line 342: csd_gen_utility_pvt.add('CSD_PRODUCT_TRANSACTIONS_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);

338: End If;
339: CLOSE C;
340:
341: IF l_debug > 0 THEN
342: csd_gen_utility_pvt.add('CSD_PRODUCT_TRANSACTIONS_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
343: csd_gen_utility_pvt.add('CSD_PRODUCT_TRANSACTIONS_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
344: END IF;
345:
346: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then

Line 343: csd_gen_utility_pvt.add('CSD_PRODUCT_TRANSACTIONS_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);

339: CLOSE C;
340:
341: IF l_debug > 0 THEN
342: csd_gen_utility_pvt.add('CSD_PRODUCT_TRANSACTIONS_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
343: csd_gen_utility_pvt.add('CSD_PRODUCT_TRANSACTIONS_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
344: END IF;
345:
346: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then
347: return;

Line 354: End CSD_PRODUCT_TRANSACTIONS_PKG;

350: APP_EXCEPTION.RAISE_EXCEPTION;
351: End If;
352: END Lock_Row;
353:
354: End CSD_PRODUCT_TRANSACTIONS_PKG;