APPS.JL_BR_AP_COLLECTION_DOCS_PKG dependencies on JL_BR_AP_COLLECTION_DOCS

Line 1: PACKAGE BODY JL_BR_AP_COLLECTION_DOCS_PKG as

1: PACKAGE BODY JL_BR_AP_COLLECTION_DOCS_PKG as
2: /* $Header: jlbrpecb.pls 120.4 2006/02/24 03:46:56 amohiudd ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 85: CURSOR C IS SELECT rowid FROM JL_BR_AP_COLLECTION_DOCS

81: X_ORG_ID NUMBER DEFAULT NULL,
82:
83: X_calling_sequence IN VARCHAR2
84: ) IS
85: CURSOR C IS SELECT rowid FROM JL_BR_AP_COLLECTION_DOCS
86: WHERE bank_collection_id = X_bank_collection_id;
87: current_calling_sequence VARCHAR2(2000);
88: debug_info VARCHAR2(100);
89:

Line 93: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||

89:
90: BEGIN
91: -- Update the calling sequence
92: --
93: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||
94: X_calling_sequence;
95:
96: debug_info := 'Insert into JL_BR_AP_COLLECTION_DOCS';
97: INSERT INTO JL_BR_AP_COLLECTION_DOCS

Line 96: debug_info := 'Insert into JL_BR_AP_COLLECTION_DOCS';

92: --
93: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||
94: X_calling_sequence;
95:
96: debug_info := 'Insert into JL_BR_AP_COLLECTION_DOCS';
97: INSERT INTO JL_BR_AP_COLLECTION_DOCS
98: (
99: BANK_COLLECTION_ID,
100: LAST_UPDATED_BY,

Line 97: INSERT INTO JL_BR_AP_COLLECTION_DOCS

93: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||
94: X_calling_sequence;
95:
96: debug_info := 'Insert into JL_BR_AP_COLLECTION_DOCS';
97: INSERT INTO JL_BR_AP_COLLECTION_DOCS
98: (
99: BANK_COLLECTION_ID,
100: LAST_UPDATED_BY,
101: LAST_UPDATE_DATE,

Line 364: FROM JL_BR_AP_COLLECTION_DOCS

360: X_calling_sequence IN VARCHAR2
361: ) IS
362: CURSOR C IS
363: SELECT *
364: FROM JL_BR_AP_COLLECTION_DOCS
365: WHERE rowid = X_Rowid
366: FOR UPDATE of bank_collection_id NOWAIT;
367: Recinfo C%ROWTYPE;
368:

Line 375: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.LOCK_ROW<-' ||

371:
372: BEGIN
373: -- Update the calling sequence
374: --
375: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.LOCK_ROW<-' ||
376: X_calling_sequence;
377: debug_info := 'Open cursor C';
378: OPEN C;
379: debug_info := 'Fetch cursor C';

Line 614: END JL_BR_AP_COLLECTION_DOCS_PKG;

610:
611: END Lock_Row;
612:
613:
614: END JL_BR_AP_COLLECTION_DOCS_PKG;