APPS.JL_ZZ_AR_TX_EXC_ITM_PKG dependencies on JL_ZZ_AR_TX_EXC_ITM_PKG

Line 1: PACKAGE BODY JL_ZZ_AR_TX_EXC_ITM_PKG as

1: PACKAGE BODY JL_ZZ_AR_TX_EXC_ITM_PKG as
2: /* $Header: jlzzteib.pls 120.3 2003/09/02 21:59:22 opedrega ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_rowid IN OUT NOCOPY VARCHAR2,

Line 56: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.INSERT_ROW<-' ||

52:
53: BEGIN
54: -- Update the calling sequence
55: --
56: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.INSERT_ROW<-' ||
57: X_calling_sequence;
58:
59: debug_info := 'Insert into JL_ZZ_AR_TX_EXC_ITM ';
60: insert into jl_zz_ar_tx_exc_itm(exc_itm_id,

Line 251: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.LOCK_ROW<-' ||

247:
248: BEGIN
249: -- Update the calling sequence
250: --
251: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.LOCK_ROW<-' ||
252: X_calling_sequence;
253: debug_info := 'Open cursor C';
254: OPEN C;
255: debug_info := 'Fetch cursor C';

Line 482: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.CHECK_UNIQUE<-' ||

478:
479: BEGIN
480: -- Update the calling sequence
481: --
482: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.CHECK_UNIQUE<-' ||
483: X_calling_sequence;
484: SELECT COUNT(1)
485: INTO l_dummy
486: FROM jl_zz_ar_tx_exc_itm

Line 533: 'JL_ZZ_AR_TX_EXC_ITM_PKG.<-CHECK_OVERLAPPED_DATES' ||

529: BEGIN
530: -- Update the calling sequence
531: --
532: current_calling_sequence :=
533: 'JL_ZZ_AR_TX_EXC_ITM_PKG.<-CHECK_OVERLAPPED_DATES' ||
534: X_calling_sequence;
535: SELECT COUNT(1)
536: INTO l_dummy
537: FROM jl_zz_ar_tx_exc_itm a

Line 590: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.CHECK_GAPS<-' ||

586:
587: BEGIN
588: -- Update the calling sequence
589: --
590: current_calling_sequence := 'JL_ZZ_AR_TX_EXC_ITM_PKG.CHECK_GAPS<-' ||
591: X_calling_sequence;
592: --
593: -- Check if there is one row with it's end date exactly one day
594: -- less than the current row's start date

Line 662: END JL_ZZ_AR_TX_EXC_ITM_PKG;

658: END IF;
659: END;
660: END IF;
661: END Check_Gaps;
662: END JL_ZZ_AR_TX_EXC_ITM_PKG;