APPS.JL_BR_AR_RET_INTERFACE_EXT_PKG dependencies on JL_BR_AR_RET_INTERFACE_EXT_PKG

Line 1: PACKAGE BODY JL_BR_AR_RET_INTERFACE_EXT_PKG AS

1: PACKAGE BODY JL_BR_AR_RET_INTERFACE_EXT_PKG AS
2: /*$Header: jlbrrcbb.pls 120.2 2005/02/23 23:28:15 vsidhart noship $*/
3: PROCEDURE Update_Row(X_Rowid VARCHAR2,
4: X_FILE_CONTROL VARCHAR2,
5: X_ENTRY_SEQUENTIAL_NUMBER NUMBER,

Line 46: CURRENT_CALLING_SEQUENCE := 'JL_BR_AR_RET_INTERFACE_EXT_PKG.UPDATE_ROW <-'||X_CALLING_SEQUENCE;

42: X_CALLING_SEQUENCE IN VARCHAR2) IS
43: CURRENT_CALLING_SEQUENCE VARCHAR2(2000);
44: DEBUG_INFO VARCHAR2(100);
45: BEGIN
46: CURRENT_CALLING_SEQUENCE := 'JL_BR_AR_RET_INTERFACE_EXT_PKG.UPDATE_ROW <-'||X_CALLING_SEQUENCE;
47: DEBUG_INFO := 'UPDATE JL_BR_AR_RET_INTERFACE_EXT';
48:
49: UPDATE JL_BR_AR_RET_INTERFACE_EXT
50: SET

Line 109: CURRENT_CALLING_SEQUENCE := 'JL_BR_AR_RET_INTERFACE_EXT_PKG.DELETE_ROW<-'||X_CALLING_SEQUENCE;

105: X_CALLING_SEQUENCE IN VARCHAR2) IS
106: CURRENT_CALLING_SEQUENCE VARCHAR2(2000);
107: DEBUG_INFO VARCHAR2(100);
108: BEGIN
109: CURRENT_CALLING_SEQUENCE := 'JL_BR_AR_RET_INTERFACE_EXT_PKG.DELETE_ROW<-'||X_CALLING_SEQUENCE;
110: DEBUG_INFO := 'DELETE FROM JL_BR_AR_RET_INTERFACE_EXT';
111: DELETE FROM JL_BR_AR_RET_INTERFACE_EXT
112: WHERE rowid = X_Rowid;
113: if (SQL%NOTFOUND) then

Line 181: current_calling_sequence := 'JL_BR_AR_RET_INTERFACE_EXT_PKG.LOCK_ROW<-' ||

177: debug_info VARCHAR2(100);
178:
179: BEGIN
180: -- Update the calling sequence
181: current_calling_sequence := 'JL_BR_AR_RET_INTERFACE_EXT_PKG.LOCK_ROW<-' ||
182: X_calling_sequence;
183: debug_info := 'Open cursor C';
184: OPEN C;
185: debug_info := 'Fetch cursor C';

Line 302: END JL_BR_AR_RET_INTERFACE_EXT_PKG;

298: APP_EXCEPTION.RAISE_EXCEPTION;
299: --
300: END Lock_Row;
301:
302: END JL_BR_AR_RET_INTERFACE_EXT_PKG;