APPS.JL_BR_AR_COLLECTION_DOCS_PKG dependencies on JL_BR_AR_COLLECTION_DOCS

Line 1: PACKAGE BODY JL_BR_AR_COLLECTION_DOCS_PKG as

1: PACKAGE BODY JL_BR_AR_COLLECTION_DOCS_PKG as
2: /* $Header: jlbrrcdb.pls 120.5 2003/09/15 21:52:25 vsidhart ship $ */
3:
4: PROCEDURE Insert_Row ( X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 73: CURSOR C IS SELECT rowid FROM JL_BR_AR_COLLECTION_DOCS

69:
70: X_calling_sequence VARCHAR2,
71: X_ORG_ID NUMBER
72: ) IS
73: CURSOR C IS SELECT rowid FROM JL_BR_AR_COLLECTION_DOCS
74: WHERE document_id = X_document_id;
75: current_calling_sequence VARCHAR2(2000);
76: debug_info VARCHAR2(100);
77:

Line 81: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||

77:
78: BEGIN
79: -- Update the calling sequence
80: --
81: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||
82: X_calling_sequence;
83:
84: debug_info := 'Insert into JL_BR_AR_COLLECTION_DOCS';
85: INSERT INTO JL_BR_AR_COLLECTION_DOCS

Line 84: debug_info := 'Insert into JL_BR_AR_COLLECTION_DOCS';

80: --
81: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||
82: X_calling_sequence;
83:
84: debug_info := 'Insert into JL_BR_AR_COLLECTION_DOCS';
85: INSERT INTO JL_BR_AR_COLLECTION_DOCS
86: (
87: DOCUMENT_ID,
88: BORDERO_ID,

Line 85: INSERT INTO JL_BR_AR_COLLECTION_DOCS

81: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||
82: X_calling_sequence;
83:
84: debug_info := 'Insert into JL_BR_AR_COLLECTION_DOCS';
85: INSERT INTO JL_BR_AR_COLLECTION_DOCS
86: (
87: DOCUMENT_ID,
88: BORDERO_ID,
89: PAYMENT_SCHEDULE_ID,

Line 318: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||

314: debug_info VARCHAR2(100);
315: BEGIN
316: -- Update the calling sequence
317: --
318: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||
319: X_calling_sequence;
320: debug_info := 'Update JL_BR_AR_COLLECTION_DOCS';
321: UPDATE JL_BR_AR_COLLECTION_DOCS
322: SET

Line 320: debug_info := 'Update JL_BR_AR_COLLECTION_DOCS';

316: -- Update the calling sequence
317: --
318: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||
319: X_calling_sequence;
320: debug_info := 'Update JL_BR_AR_COLLECTION_DOCS';
321: UPDATE JL_BR_AR_COLLECTION_DOCS
322: SET
323: DOCUMENT_ID = X_DOCUMENT_ID ,
324: BORDERO_ID = X_BORDERO_ID ,

Line 321: UPDATE JL_BR_AR_COLLECTION_DOCS

317: --
318: current_calling_sequence := 'JL_BR_AR_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||
319: X_calling_sequence;
320: debug_info := 'Update JL_BR_AR_COLLECTION_DOCS';
321: UPDATE JL_BR_AR_COLLECTION_DOCS
322: SET
323: DOCUMENT_ID = X_DOCUMENT_ID ,
324: BORDERO_ID = X_BORDERO_ID ,
325: PAYMENT_SCHEDULE_ID = X_PAYMENT_SCHEDULE_ID ,

Line 406: END JL_BR_AR_COLLECTION_DOCS_PKG;

402: APP_EXCEPTION.RAISE_EXCEPTION;
403:
404: END Update_Row;
405:
406: END JL_BR_AR_COLLECTION_DOCS_PKG;