APPS.CSI_MASS_EDIT_ENTRIES_B_PKG dependencies on CSI_MASS_EDIT_ENTRIES_B

Line 1: PACKAGE BODY CSI_MASS_EDIT_ENTRIES_B_PKG as

1: PACKAGE BODY CSI_MASS_EDIT_ENTRIES_B_PKG as
2: /* $Header: csitmedb.pls 120.2.12010000.2 2008/11/06 20:28:59 mashah ship $ */
3: -- Start of Comments
4: -- Package name : CSI_MASS_EDIT_ENTRIES_B_PKG
5: -- Purpose :

Line 4: -- Package name : CSI_MASS_EDIT_ENTRIES_B_PKG

1: PACKAGE BODY CSI_MASS_EDIT_ENTRIES_B_PKG as
2: /* $Header: csitmedb.pls 120.2.12010000.2 2008/11/06 20:28:59 mashah ship $ */
3: -- Start of Comments
4: -- Package name : CSI_MASS_EDIT_ENTRIES_B_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 52: INSERT INTO CSI_MASS_EDIT_ENTRIES_B(

48: SELECT CSI_T_TRANSACTION_LINES_S.nextval
49: INTO px_TXN_LINE_ID
50: FROM SYS.Dual;
51:
52: INSERT INTO CSI_MASS_EDIT_ENTRIES_B(
53: ENTRY_ID,
54: TXN_LINE_ID,
55: STATUS_CODE,
56: BATCH_TYPE,

Line 199: Update CSI_MASS_EDIT_ENTRIES_B

195: )
196:
197: IS
198: BEGIN
199: Update CSI_MASS_EDIT_ENTRIES_B
200: SET
201: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
202: SCHEDULE_DATE = decode( p_SCHEDULE_DATE, FND_API.G_MISS_DATE, SCHEDULE_DATE, p_SCHEDULE_DATE),
203: START_DATE = decode( p_START_DATE, FND_API.G_MISS_DATE, START_DATE, p_START_DATE),

Line 242: --raise_application_error( -20000, 'Cannot delete Entry from CSI_MASS_EDIT_ENTRIES_B_PKG.DELETE_ROW' ); uncommented for mass update r12

238: BEGIN
239:
240: -- DELETE_ROW cannot be used to delete Item records.
241:
242: --raise_application_error( -20000, 'Cannot delete Entry from CSI_MASS_EDIT_ENTRIES_B_PKG.DELETE_ROW' ); uncommented for mass update r12
243:
244: DELETE FROM CSI_MASS_EDIT_ENTRIES_B
245: WHERE ENTRY_ID = p_ENTRY_ID;
246: If (SQL%NOTFOUND) then

Line 244: DELETE FROM CSI_MASS_EDIT_ENTRIES_B

240: -- DELETE_ROW cannot be used to delete Item records.
241:
242: --raise_application_error( -20000, 'Cannot delete Entry from CSI_MASS_EDIT_ENTRIES_B_PKG.DELETE_ROW' ); uncommented for mass update r12
243:
244: DELETE FROM CSI_MASS_EDIT_ENTRIES_B
245: WHERE ENTRY_ID = p_ENTRY_ID;
246: If (SQL%NOTFOUND) then
247: RAISE NO_DATA_FOUND;
248: End If;

Line 278: FROM CSI_MASS_EDIT_ENTRIES_B

274:
275: IS
276: CURSOR C IS
277: SELECT *
278: FROM CSI_MASS_EDIT_ENTRIES_B
279: WHERE ENTRY_ID = p_ENTRY_ID
280: FOR UPDATE of ENTRY_ID NOWAIT;
281: Recinfo C%ROWTYPE;
282:

Line 370: FROM CSI_MASS_EDIT_ENTRIES_B B

366: /********* COMMENTED FOR BUG 4238439 (Refer 3723612 for solution)
367: DELETE FROM CSI_MASS_EDIT_ENTRIES_TL T
368: WHERE NOT EXISTS
369: (SELECT NULL
370: FROM CSI_MASS_EDIT_ENTRIES_B B
371: WHERE B.ENTRY_ID = T.ENTRY_ID
372: );
373:
374: UPDATE CSI_MASS_EDIT_ENTRIES_TL T SET (

Line 453: End CSI_MASS_EDIT_ENTRIES_B_PKG;

449: END TRANSLATE_ROW;
450:
451:
452:
453: End CSI_MASS_EDIT_ENTRIES_B_PKG;