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_AR_SELECT_CONTROLS_PKG dependencies on JL_BR_AR_SELECT_CONTROLS

Line 1: PACKAGE BODY JL_BR_AR_SELECT_CONTROLS_PKG as

1: PACKAGE BODY JL_BR_AR_SELECT_CONTROLS_PKG as
2: /* $Header: jlbrrscb.pls 120.4 2003/07/11 18:58:15 appradha ship $ */
3:
4: PROCEDURE Insert_Row ( X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 54: CURSOR C IS SELECT rowid FROM JL_BR_AR_SELECT_CONTROLS

50:
51: X_calling_sequence VARCHAR2,
52: X_ORG_ID NUMBER
53: ) IS
54: CURSOR C IS SELECT rowid FROM JL_BR_AR_SELECT_CONTROLS
55: WHERE selection_control_id = X_selection_control_id;
56: current_calling_sequence VARCHAR2(2000);
57: debug_info VARCHAR2(100);
58:

Line 62: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.INSERT_ROW<-' ||

58:
59: BEGIN
60: -- Update the calling sequence
61: --
62: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.INSERT_ROW<-' ||
63: X_calling_sequence;
64:
65: debug_info := 'Insert into JL_BR_AR_SELECT_CONTROLS';
66: INSERT INTO JL_BR_AR_SELECT_CONTROLS

Line 65: debug_info := 'Insert into JL_BR_AR_SELECT_CONTROLS';

61: --
62: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.INSERT_ROW<-' ||
63: X_calling_sequence;
64:
65: debug_info := 'Insert into JL_BR_AR_SELECT_CONTROLS';
66: INSERT INTO JL_BR_AR_SELECT_CONTROLS
67: (
68: SELECTION_CONTROL_ID,
69: SELECTION_STATUS,

Line 66: INSERT INTO JL_BR_AR_SELECT_CONTROLS

62: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.INSERT_ROW<-' ||
63: X_calling_sequence;
64:
65: debug_info := 'Insert into JL_BR_AR_SELECT_CONTROLS';
66: INSERT INTO JL_BR_AR_SELECT_CONTROLS
67: (
68: SELECTION_CONTROL_ID,
69: SELECTION_STATUS,
70: SELECTION_TYPE,

Line 240: FROM JL_BR_AR_SELECT_CONTROLS

236: X_calling_sequence VARCHAR2
237: ) IS
238: CURSOR C IS
239: SELECT *
240: FROM JL_BR_AR_SELECT_CONTROLS
241: WHERE rowid = X_Rowid
242: FOR UPDATE of selection_control_id NOWAIT;
243: Recinfo C%ROWTYPE;
244:

Line 251: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.LOCK_ROW<-' ||

247:
248: BEGIN
249: -- Update the calling sequence
250: --
251: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.LOCK_ROW<-' ||
252: X_calling_sequence;
253: debug_info := 'Open cursor C';
254: OPEN C;
255: debug_info := 'Fetch cursor C';

Line 455: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.UPDATE_ROW<-' ||

451: debug_info VARCHAR2(100);
452: BEGIN
453: -- Update the calling sequence
454: --
455: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.UPDATE_ROW<-' ||
456: X_calling_sequence;
457: debug_info := 'Update JL_BR_AR_SELECT_CONTROLS';
458: UPDATE JL_BR_AR_SELECT_CONTROLS
459: SET

Line 457: debug_info := 'Update JL_BR_AR_SELECT_CONTROLS';

453: -- Update the calling sequence
454: --
455: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.UPDATE_ROW<-' ||
456: X_calling_sequence;
457: debug_info := 'Update JL_BR_AR_SELECT_CONTROLS';
458: UPDATE JL_BR_AR_SELECT_CONTROLS
459: SET
460: SELECTION_CONTROL_ID = X_SELECTION_CONTROL_ID ,
461: SELECTION_STATUS = X_SELECTION_STATUS ,

Line 458: UPDATE JL_BR_AR_SELECT_CONTROLS

454: --
455: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.UPDATE_ROW<-' ||
456: X_calling_sequence;
457: debug_info := 'Update JL_BR_AR_SELECT_CONTROLS';
458: UPDATE JL_BR_AR_SELECT_CONTROLS
459: SET
460: SELECTION_CONTROL_ID = X_SELECTION_CONTROL_ID ,
461: SELECTION_STATUS = X_SELECTION_STATUS ,
462: SELECTION_TYPE = X_SELECTION_TYPE ,

Line 532: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.DELETE_ROW<-' ||

528: debug_info VARCHAR2(100);
529: BEGIN
530: -- Update the calling sequence
531: --
532: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.DELETE_ROW<-' ||
533: X_calling_sequence;
534: debug_info := 'Delete from JL_BR_AR_SELECT_CONTROLS';
535: DELETE FROM JL_BR_AR_SELECT_CONTROLS
536: WHERE rowid = X_Rowid;

Line 534: debug_info := 'Delete from JL_BR_AR_SELECT_CONTROLS';

530: -- Update the calling sequence
531: --
532: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.DELETE_ROW<-' ||
533: X_calling_sequence;
534: debug_info := 'Delete from JL_BR_AR_SELECT_CONTROLS';
535: DELETE FROM JL_BR_AR_SELECT_CONTROLS
536: WHERE rowid = X_Rowid;
537:
538: if (SQL%NOTFOUND) then

Line 535: DELETE FROM JL_BR_AR_SELECT_CONTROLS

531: --
532: current_calling_sequence := 'JL_BR_AR_SELECT_CONTROLS_PKG.DELETE_ROW<-' ||
533: X_calling_sequence;
534: debug_info := 'Delete from JL_BR_AR_SELECT_CONTROLS';
535: DELETE FROM JL_BR_AR_SELECT_CONTROLS
536: WHERE rowid = X_Rowid;
537:
538: if (SQL%NOTFOUND) then
539: Raise NO_DATA_FOUND;

Line 556: END JL_BR_AR_SELECT_CONTROLS_PKG;

552:
553: END Delete_Row;
554:
555:
556: END JL_BR_AR_SELECT_CONTROLS_PKG;