eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_AP_INT_COLLECT_EXT_PKG dependencies on JL_BR_AP_INT_COLLECT_EXT

Line 1: PACKAGE BODY JL_BR_AP_INT_COLLECT_EXT_PKG as

1: PACKAGE BODY JL_BR_AP_INT_COLLECT_EXT_PKG as
2: /* $Header: jlbrpccb.pls 120.3.12010000.2 2009/11/19 16:09:33 gmeni ship $ */
3:
4: PROCEDURE Insert_Row (X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_FILE_CONTROL VARCHAR2,

Line 82: CURSOR C IS SELECT rowid FROM JL_BR_AP_INT_COLLECT_EXT

78: X_BARCODE VARCHAR2 DEFAULT NULL,
79: X_ELECTRONIC_FORMAT_FLAG VARCHAR2 DEFAULT NULL
80: ) IS
81:
82: CURSOR C IS SELECT rowid FROM JL_BR_AP_INT_COLLECT_EXT
83: WHERE file_control = X_file_control
84: AND entry_sequential_number = X_entry_sequential_number;
85: current_calling_sequence VARCHAR2(2000);
86: debug_info VARCHAR2(100);

Line 91: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.INSERT_ROW<-' ||

87:
88: BEGIN
89: -- Update the calling sequence
90: --
91: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.INSERT_ROW<-' ||
92: X_calling_sequence;
93:
94: debug_info := 'Insert into JL_BR_AP_INT_COLLECT_EXT';
95: INSERT INTO JL_BR_AP_INT_COLLECT_EXT(

Line 94: debug_info := 'Insert into JL_BR_AP_INT_COLLECT_EXT';

90: --
91: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.INSERT_ROW<-' ||
92: X_calling_sequence;
93:
94: debug_info := 'Insert into JL_BR_AP_INT_COLLECT_EXT';
95: INSERT INTO JL_BR_AP_INT_COLLECT_EXT(
96: FILE_CONTROL,
97: ENTRY_SEQUENTIAL_NUMBER,
98: REGISTRY_CODE,

Line 95: INSERT INTO JL_BR_AP_INT_COLLECT_EXT(

91: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.INSERT_ROW<-' ||
92: X_calling_sequence;
93:
94: debug_info := 'Insert into JL_BR_AP_INT_COLLECT_EXT';
95: INSERT INTO JL_BR_AP_INT_COLLECT_EXT(
96: FILE_CONTROL,
97: ENTRY_SEQUENTIAL_NUMBER,
98: REGISTRY_CODE,
99: RETURN_CODE,

Line 356: FROM JL_BR_AP_INT_COLLECT_EXT

352: X_ELECTRONIC_FORMAT_FLAG VARCHAR2 DEFAULT NULL
353: ) IS
354: CURSOR C IS
355: SELECT *
356: FROM JL_BR_AP_INT_COLLECT_EXT
357: WHERE rowid = X_Rowid
358: FOR UPDATE OF file_control NOWAIT;
359:
360: Recinfo C%ROWTYPE;

Line 368: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.LOCK_ROW<-' ||

364:
365: BEGIN
366: -- Update the calling sequence
367: --
368: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.LOCK_ROW<-' ||
369: X_calling_sequence;
370: debug_info := 'Open cursor C';
371: OPEN C;
372: debug_info := 'Fetch cursor C';

Line 677: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.UPDATE_ROW<-' ||

673: debug_info VARCHAR2(100);
674: BEGIN
675: -- Update the calling sequence
676: --
677: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.UPDATE_ROW<-' ||
678: X_calling_sequence;
679: debug_info := 'Update JL_BR_AP_INT_COLLECT_EXT';
680: UPDATE JL_BR_AP_INT_COLLECT_EXT
681: SET

Line 679: debug_info := 'Update JL_BR_AP_INT_COLLECT_EXT';

675: -- Update the calling sequence
676: --
677: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.UPDATE_ROW<-' ||
678: X_calling_sequence;
679: debug_info := 'Update JL_BR_AP_INT_COLLECT_EXT';
680: UPDATE JL_BR_AP_INT_COLLECT_EXT
681: SET
682: FILE_CONTROL = X_FILE_CONTROL,
683: ENTRY_SEQUENTIAL_NUMBER = X_ENTRY_SEQUENTIAL_NUMBER,

Line 680: UPDATE JL_BR_AP_INT_COLLECT_EXT

676: --
677: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.UPDATE_ROW<-' ||
678: X_calling_sequence;
679: debug_info := 'Update JL_BR_AP_INT_COLLECT_EXT';
680: UPDATE JL_BR_AP_INT_COLLECT_EXT
681: SET
682: FILE_CONTROL = X_FILE_CONTROL,
683: ENTRY_SEQUENTIAL_NUMBER = X_ENTRY_SEQUENTIAL_NUMBER,
684: REGISTRY_CODE = X_REGISTRY_CODE,

Line 784: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.DELETE_ROW<-' ||

780: debug_info VARCHAR2(100);
781: BEGIN
782: -- Update the calling sequence
783: --
784: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.DELETE_ROW<-' ||
785: X_calling_sequence;
786: debug_info := 'Delete from JL_BR_AP_INT_COLLECT_EXT';
787: DELETE FROM JL_BR_AP_INT_COLLECT_EXT
788: WHERE rowid = X_Rowid;

Line 786: debug_info := 'Delete from JL_BR_AP_INT_COLLECT_EXT';

782: -- Update the calling sequence
783: --
784: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.DELETE_ROW<-' ||
785: X_calling_sequence;
786: debug_info := 'Delete from JL_BR_AP_INT_COLLECT_EXT';
787: DELETE FROM JL_BR_AP_INT_COLLECT_EXT
788: WHERE rowid = X_Rowid;
789:
790: IF (SQL%NOTFOUND) THEN

Line 787: DELETE FROM JL_BR_AP_INT_COLLECT_EXT

783: --
784: current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.DELETE_ROW<-' ||
785: X_calling_sequence;
786: debug_info := 'Delete from JL_BR_AP_INT_COLLECT_EXT';
787: DELETE FROM JL_BR_AP_INT_COLLECT_EXT
788: WHERE rowid = X_Rowid;
789:
790: IF (SQL%NOTFOUND) THEN
791: Raise NO_DATA_FOUND;

Line 807: END JL_BR_AP_INT_COLLECT_EXT_PKG;

803: APP_EXCEPTION.RAISE_EXCEPTION;
804:
805: END Delete_Row;
806:
807: END JL_BR_AP_INT_COLLECT_EXT_PKG;