APPS.JL_BR_AR_OCCURRENCE_DOCS_PKG dependencies on JL_BR_AR_OCCURRENCE_DOCS

Line 1: PACKAGE BODY JL_BR_AR_OCCURRENCE_DOCS_PKG as

1: PACKAGE BODY JL_BR_AR_OCCURRENCE_DOCS_PKG as
2: /* $Header: jlbrriob.pls 120.5 2003/09/15 21:56:33 vsidhart ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Occurrence_Id NUMBER,

Line 76: FROM JL_BR_AR_OCCURRENCE_DOCS

72: X_ORG_ID NUMBER) IS
73: --
74: CURSOR C IS
75: SELECT rowid
76: FROM JL_BR_AR_OCCURRENCE_DOCS
77: WHERE document_id = X_Document_Id;
78: --
79: current_calling_sequence VARCHAR2(2000);
80: debug_info VARCHAR2(100);

Line 84: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.INSERT_ROW<-' ||

80: debug_info VARCHAR2(100);
81: --
82: BEGIN
83: -- Update the calling sequence
84: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.INSERT_ROW<-' ||
85: X_calling_sequence;
86:
87: debug_info := 'Insert into JL_BR_AR_OCCURRENCE_DOCS';
88: INSERT INTO JL_BR_AR_OCCURRENCE_DOCS(

Line 87: debug_info := 'Insert into JL_BR_AR_OCCURRENCE_DOCS';

83: -- Update the calling sequence
84: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.INSERT_ROW<-' ||
85: X_calling_sequence;
86:
87: debug_info := 'Insert into JL_BR_AR_OCCURRENCE_DOCS';
88: INSERT INTO JL_BR_AR_OCCURRENCE_DOCS(
89: occurrence_id,
90: document_id,
91: bank_occurrence_code,

Line 88: INSERT INTO JL_BR_AR_OCCURRENCE_DOCS(

84: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.INSERT_ROW<-' ||
85: X_calling_sequence;
86:
87: debug_info := 'Insert into JL_BR_AR_OCCURRENCE_DOCS';
88: INSERT INTO JL_BR_AR_OCCURRENCE_DOCS(
89: occurrence_id,
90: document_id,
91: bank_occurrence_code,
92: --bank_number,

Line 325: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.UPDATE_ROW<-' ||

321: debug_info VARCHAR2(100);
322: BEGIN
323: -- Update the calling sequence
324: --
325: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.UPDATE_ROW<-' ||
326: X_calling_sequence;
327: debug_info := 'Update JL_BR_AR_OCCURRENCE_DOCS';
328: UPDATE JL_BR_AR_OCCURRENCE_DOCS
329: SET Occurrence_Id = X_Occurrence_Id,

Line 327: debug_info := 'Update JL_BR_AR_OCCURRENCE_DOCS';

323: -- Update the calling sequence
324: --
325: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.UPDATE_ROW<-' ||
326: X_calling_sequence;
327: debug_info := 'Update JL_BR_AR_OCCURRENCE_DOCS';
328: UPDATE JL_BR_AR_OCCURRENCE_DOCS
329: SET Occurrence_Id = X_Occurrence_Id,
330: Document_Id = X_Document_Id,
331: bank_occurrence_Code = X_Bank_Occurrence_Code,

Line 328: UPDATE JL_BR_AR_OCCURRENCE_DOCS

324: --
325: current_calling_sequence := 'JL_BR_AR_OCCURRENCE_DOCS_PKG.UPDATE_ROW<-' ||
326: X_calling_sequence;
327: debug_info := 'Update JL_BR_AR_OCCURRENCE_DOCS';
328: UPDATE JL_BR_AR_OCCURRENCE_DOCS
329: SET Occurrence_Id = X_Occurrence_Id,
330: Document_Id = X_Document_Id,
331: bank_occurrence_Code = X_Bank_Occurrence_Code,
332: --Bank_Number = X_Bank_Number,

Line 414: END JL_BR_AR_OCCURRENCE_DOCS_PKG;

410: END IF;
411: APP_EXCEPTION.RAISE_EXCEPTION;
412: --
413: END Update_Row;
414: END JL_BR_AR_OCCURRENCE_DOCS_PKG;