APPS.JL_BR_AR_BANK_RETURNS_PKG dependencies on JL_BR_AR_BANK_RETURNS

Line 1: PACKAGE BODY JL_BR_AR_BANK_RETURNS_PKG as

1: PACKAGE BODY JL_BR_AR_BANK_RETURNS_PKG as
2: /* $Header: jlbrremb.pls 120.4 2003/09/15 21:51:54 vsidhart ship $ */
3:
4: PROCEDURE Insert_Row(X_rowid IN OUT NOCOPY VARCHAR2,
5:

Line 41: FROM jl_br_ar_bank_returns

37: X_calling_sequence IN VARCHAR2,
38: X_ORG_ID NUMBER
39: ) IS
40: CURSOR C IS SELECT rowid
41: FROM jl_br_ar_bank_returns
42: WHERE return_id = X_return_id;
43:
44: current_calling_sequence VARCHAR2(2000);
45: debug_info VARCHAR2(100);

Line 50: current_calling_sequence := 'JL_BR_AR_BANK_RETURNS_PKG.INSERT_ROW<-' ||

46:
47: BEGIN
48: -- Update the calling sequence
49: --
50: current_calling_sequence := 'JL_BR_AR_BANK_RETURNS_PKG.INSERT_ROW<-' ||
51: X_calling_sequence;
52: --
53: debug_info := 'Insert into JL_BR_AR_BANK_RETURNS';
54: insert into jl_br_ar_bank_returns(

Line 53: debug_info := 'Insert into JL_BR_AR_BANK_RETURNS';

49: --
50: current_calling_sequence := 'JL_BR_AR_BANK_RETURNS_PKG.INSERT_ROW<-' ||
51: X_calling_sequence;
52: --
53: debug_info := 'Insert into JL_BR_AR_BANK_RETURNS';
54: insert into jl_br_ar_bank_returns(
55: RETURN_ID,
56: BANK_OCCURRENCE_CODE,
57: OCCURRENCE_DATE,

Line 54: insert into jl_br_ar_bank_returns(

50: current_calling_sequence := 'JL_BR_AR_BANK_RETURNS_PKG.INSERT_ROW<-' ||
51: X_calling_sequence;
52: --
53: debug_info := 'Insert into JL_BR_AR_BANK_RETURNS';
54: insert into jl_br_ar_bank_returns(
55: RETURN_ID,
56: BANK_OCCURRENCE_CODE,
57: OCCURRENCE_DATE,
58: FILE_CONTROL,

Line 184: FROM jl_br_ar_bank_returns

180:
181: X_calling_sequence IN VARCHAR2
182: ) IS
183: CURSOR C IS SELECT *
184: FROM jl_br_ar_bank_returns
185: WHERE return_id = X_return_id
186: FOR UPDATE of return_id
187: NOWAIT;
188:

Line 197: current_calling_sequence := 'JL_BR_AR_BANK_RETURNS_PKG.LOCK_ROW<-' ||

193:
194: BEGIN
195: -- Update the calling sequence
196: --
197: current_calling_sequence := 'JL_BR_AR_BANK_RETURNS_PKG.LOCK_ROW<-' ||
198: X_calling_sequence;
199: debug_info := 'Open cursor C';
200: OPEN C;
201: debug_info := 'Fetch cursor C';

Line 326: UPDATE jl_br_ar_bank_returns

322: X_calling_sequence IN VARCHAR2
323: ) IS
324:
325: BEGIN
326: UPDATE jl_br_ar_bank_returns
327: SET RETURN_ID = X_RETURN_ID,
328: BANK_OCCURRENCE_CODE = X_BANK_OCCURRENCE_CODE,
329: OCCURRENCE_DATE = X_OCCURRENCE_DATE,
330: FILE_CONTROL = X_FILE_CONTROL,

Line 370: FROM jl_br_ar_bank_returns

366: PROCEDURE Delete_Row( X_rowid VARCHAR2
367: ) IS
368: BEGIN
369: DELETE
370: FROM jl_br_ar_bank_returns
371: WHERE rowid = X_rowid;
372:
373: IF (SQL%NOTFOUND)
374: THEN

Line 379: END JL_BR_AR_BANK_RETURNS_PKG;

375: raise NO_DATA_FOUND;
376: END IF;
377: END Delete_Row;
378:
379: END JL_BR_AR_BANK_RETURNS_PKG;