APPS.JL_ZZ_AR_TX_CAT_DTL_PKG dependencies on JL_ZZ_AR_TX_CAT_DTL_PKG

Line 1: PACKAGE BODY JL_ZZ_AR_TX_CAT_DTL_PKG AS

1: PACKAGE BODY JL_ZZ_AR_TX_CAT_DTL_PKG AS
2: /* $Header: jlzztcdb.pls 120.2 2003/03/03 19:34:17 opedrega ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_rowid IN OUT NOCOPY VARCHAR2,

Line 51: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_DTL_PKG.INSERT_ROW<-' ||X_calling_sequence;

47:
48: BEGIN
49: --Update the calling sequence
50: --
51: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_DTL_PKG.INSERT_ROW<-' ||X_calling_sequence;
52:
53: debug_info := 'Insert into JL_ZZ_AR_TX_CAT_DTL';
54: INSERT INTO jl_zz_ar_tx_cat_dtl (tax_categ_dtl_id,
55: tax_category_id,

Line 226: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_DTL_PKG.LOCK_ROW<-' ||X_calling_sequence;

222:
223: BEGIN
224: -- Update the calling sequence
225: --
226: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_DTL_PKG.LOCK_ROW<-' ||X_calling_sequence;
227: debug_info := 'Open cursor C';
228: OPEN C;
229: debug_info := 'Fetch cursor C';
230: FETCH C INTO Recinfo;

Line 533: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_DTL_PKG.<-CHECK_OVERLAPPED_DATES' ||

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

Line 576: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_DTL_PKG.CHECK_GAPS<-' ||

572:
573: BEGIN
574: -- Update the calling sequence
575: --
576: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_DTL_PKG.CHECK_GAPS<-' ||
577: X_calling_sequence;
578: --
579: -- Check if there is one row with it's end date exactly one day
580: -- less than the current row's start date

Line 633: END JL_ZZ_AR_TX_CAT_DTL_PKG;

629: END;
630: END IF;
631: END Check_Gaps;
632:
633: END JL_ZZ_AR_TX_CAT_DTL_PKG;