APPS.JL_AR_AR_DOC_LETTER_PKG dependencies on JL_AR_AR_DOC_LETTER_PKG

Line 1: PACKAGE BODY JL_AR_AR_DOC_LETTER_PKG as

1: PACKAGE BODY JL_AR_AR_DOC_LETTER_PKG as
2: /* $Header: jlarrdob.pls 120.3 2003/07/11 18:52:23 appradha ship $ */
3:
4: PROCEDURE Insert_Row(X_rowid IN OUT NOCOPY VARCHAR2,
5: X_tax_category_id NUMBER,

Line 51: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.INSERT_ROW<-' ||

47:
48: BEGIN
49: -- Update the calling sequence
50: --
51: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.INSERT_ROW<-' ||
52: X_calling_sequence;
53: --
54: debug_info := 'Insert into JL_AR_AR_DOC_LETTER';
55: insert into jl_ar_ar_doc_letter(

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

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

Line 427: 'JL_AR_AR_DOC_LETTER_PKG.<-CHECK_OVERLAPPED_DATES' ||

423: BEGIN
424: -- Update the calling sequence
425: --
426: current_calling_sequence :=
427: 'JL_AR_AR_DOC_LETTER_PKG.<-CHECK_OVERLAPPED_DATES' ||
428: X_calling_sequence;
429: SELECT COUNT(1)
430: INTO l_dummy
431: FROM jl_ar_ar_doc_letter a

Line 480: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.CHECK_GAPS<-' ||

476: debug_info VARCHAR2(100);
477: BEGIN
478: -- Update the calling sequence
479: --
480: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.CHECK_GAPS<-' ||
481: X_calling_sequence;
482: --
483: -- Check if there is one row with it's end date exactly one day
484: -- less than the current row's start date

Line 548: END JL_AR_AR_DOC_LETTER_PKG;

544: END;
545: END IF;
546: END Check_Gaps;
547:
548: END JL_AR_AR_DOC_LETTER_PKG;