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_REC_MET_ACCTS_EXT_PKG dependencies on JL_BR_AR_REC_MET_ACCTS_EXT

Line 1: PACKAGE BODY JL_BR_AR_REC_MET_ACCTS_EXT_PKG as

1: PACKAGE BODY JL_BR_AR_REC_MET_ACCTS_EXT_PKG as
2: /* $Header: jlbrrdpb.pls 120.6 2005/06/22 04:25:15 appradha ship $ */
3:
4: PROCEDURE Insert_Row ( X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 58: CURSOR C IS SELECT rowid FROM JL_BR_AR_REC_MET_ACCTS_EXT

54: X_MAX_COLLECTION_DOCS NUMBER,
55: X_calling_sequence VARCHAR2,
56: X_ORG_ID NUMBER
57: ) IS
58: CURSOR C IS SELECT rowid FROM JL_BR_AR_REC_MET_ACCTS_EXT
59: WHERE receipt_method_id = X_receipt_method_id
60: AND bank_acct_use_id = X_bank_acct_use_id;
61: current_calling_sequence VARCHAR2(2000);
62: debug_info VARCHAR2(100);

Line 67: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.INSERT_ROW<-' ||

63:
64: BEGIN
65: -- Update the calling sequence
66: --
67: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.INSERT_ROW<-' ||
68: X_calling_sequence;
69:
70: debug_info := 'Insert into JL_BR_AR_REC_MET_ACCTS_EXT';
71: INSERT INTO JL_BR_AR_REC_MET_ACCTS_EXT

Line 70: debug_info := 'Insert into JL_BR_AR_REC_MET_ACCTS_EXT';

66: --
67: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.INSERT_ROW<-' ||
68: X_calling_sequence;
69:
70: debug_info := 'Insert into JL_BR_AR_REC_MET_ACCTS_EXT';
71: INSERT INTO JL_BR_AR_REC_MET_ACCTS_EXT
72: (
73: BANK_ACCT_USE_ID,
74: RECEIPT_METHOD_ID,

Line 71: INSERT INTO JL_BR_AR_REC_MET_ACCTS_EXT

67: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.INSERT_ROW<-' ||
68: X_calling_sequence;
69:
70: debug_info := 'Insert into JL_BR_AR_REC_MET_ACCTS_EXT';
71: INSERT INTO JL_BR_AR_REC_MET_ACCTS_EXT
72: (
73: BANK_ACCT_USE_ID,
74: RECEIPT_METHOD_ID,
75: BANK_CHARGES_CCID,

Line 259: FROM JL_BR_AR_REC_MET_ACCTS_EXT

255: X_calling_sequence VARCHAR2
256: ) IS
257: CURSOR C IS
258: SELECT *
259: FROM JL_BR_AR_REC_MET_ACCTS_EXT
260: WHERE rowid = X_Rowid
261: FOR UPDATE of receipt_method_id NOWAIT;
262: Recinfo C%ROWTYPE;
263:

Line 270: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.LOCK_ROW<-' ||

266:
267: BEGIN
268: -- Update the calling sequence
269: --
270: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.LOCK_ROW<-' ||
271: X_calling_sequence;
272: debug_info := 'Open cursor C';
273: OPEN C;
274: debug_info := 'Fetch cursor C';

Line 476: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.UPDATE_ROW<-' ||

472: debug_info VARCHAR2(100);
473: BEGIN
474: -- Update the calling sequence
475: --
476: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.UPDATE_ROW<-' ||
477: X_calling_sequence;
478: debug_info := 'Update JL_BR_AR_REC_MET_ACCTS_EXT';
479: UPDATE JL_BR_AR_REC_MET_ACCTS_EXT
480: SET

Line 478: debug_info := 'Update JL_BR_AR_REC_MET_ACCTS_EXT';

474: -- Update the calling sequence
475: --
476: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.UPDATE_ROW<-' ||
477: X_calling_sequence;
478: debug_info := 'Update JL_BR_AR_REC_MET_ACCTS_EXT';
479: UPDATE JL_BR_AR_REC_MET_ACCTS_EXT
480: SET
481: BANK_ACCT_USE_ID = X_BANK_ACCT_USE_ID ,
482: RECEIPT_METHOD_ID = X_RECEIPT_METHOD_ID ,

Line 479: UPDATE JL_BR_AR_REC_MET_ACCTS_EXT

475: --
476: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.UPDATE_ROW<-' ||
477: X_calling_sequence;
478: debug_info := 'Update JL_BR_AR_REC_MET_ACCTS_EXT';
479: UPDATE JL_BR_AR_REC_MET_ACCTS_EXT
480: SET
481: BANK_ACCT_USE_ID = X_BANK_ACCT_USE_ID ,
482: RECEIPT_METHOD_ID = X_RECEIPT_METHOD_ID ,
483: BANK_CHARGES_CCID = X_BANK_CHARGES_CCID ,

Line 563: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.DELETE_ROW<-' ||

559: debug_info VARCHAR2(100);
560: BEGIN
561: -- Update the calling sequence
562: --
563: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.DELETE_ROW<-' ||
564: X_calling_sequence;
565: debug_info := 'Delete from JL_BR_AR_REC_MET_ACCTS_EXT';
566: DELETE FROM JL_BR_AR_REC_MET_ACCTS_EXT
567: WHERE rowid = X_Rowid;

Line 565: debug_info := 'Delete from JL_BR_AR_REC_MET_ACCTS_EXT';

561: -- Update the calling sequence
562: --
563: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.DELETE_ROW<-' ||
564: X_calling_sequence;
565: debug_info := 'Delete from JL_BR_AR_REC_MET_ACCTS_EXT';
566: DELETE FROM JL_BR_AR_REC_MET_ACCTS_EXT
567: WHERE rowid = X_Rowid;
568:
569: if (SQL%NOTFOUND) then

Line 566: DELETE FROM JL_BR_AR_REC_MET_ACCTS_EXT

562: --
563: current_calling_sequence := 'JL_BR_AR_REC_MET_ACCTS_EXT_PKG.DELETE_ROW<-' ||
564: X_calling_sequence;
565: debug_info := 'Delete from JL_BR_AR_REC_MET_ACCTS_EXT';
566: DELETE FROM JL_BR_AR_REC_MET_ACCTS_EXT
567: WHERE rowid = X_Rowid;
568:
569: if (SQL%NOTFOUND) then
570: Raise NO_DATA_FOUND;

Line 588: END JL_BR_AR_REC_MET_ACCTS_EXT_PKG;

584: END Delete_Row;
585:
586:
587:
588: END JL_BR_AR_REC_MET_ACCTS_EXT_PKG;