APPS.JL_ZZ_AR_TX_CATEG_PKG dependencies on JL_ZZ_AR_TX_CATEG_PKG

Line 1: PACKAGE BODY JL_ZZ_AR_TX_CATEG_PKG AS

1: PACKAGE BODY JL_ZZ_AR_TX_CATEG_PKG AS
2: /* $Header: jlzztctb.pls 120.4 2006/02/11 17:45:29 pla ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_rowid IN OUT NOCOPY VARCHAR2,

Line 66: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.INSERT_ROW<-' ||

62:
63: BEGIN
64: --Update the calling sequence
65:
66: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.INSERT_ROW<-' ||
67: X_calling_sequence;
68:
69: debug_info := 'Insert into JL_ZZ_AR_TX_CATEG ';
70: INSERT INTO JL_ZZ_AR_TX_CATEG (tax_category_id,

Line 294: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.LOCK_ROW<-' ||

290:
291: BEGIN
292: --Update the calling sequence
293: --
294: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.LOCK_ROW<-' ||
295: X_calling_sequence;
296: debug_info := 'Open cursor C';
297: OPEN C;
298: debug_info := 'Fetch cursor C';

Line 508: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.UPDATE_ROW' ||

504:
505: BEGIN
506: --Update the calling sequence
507: --
508: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.UPDATE_ROW' ||
509: X_calling_sequence;
510: debug_info := 'Update JL_ZZ_AR_TX_CATEG';
511:
512: UPDATE JL_ZZ_AR_TX_CATEG

Line 595: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.UPDATE_ROW' ||

591:
592: BEGIN
593: --Update the calling sequence
594: --
595: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.UPDATE_ROW' ||
596: X_calling_sequence;
597: debug_info := 'Open cursor C';
598:
599: DELETE FROM JL_ZZ_AR_TX_CATEG

Line 638: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.CHECK_UNIQUE<-' ||

634:
635: BEGIN
636: -- Update the calling sequence
637: --
638: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.CHECK_UNIQUE<-' ||
639: X_calling_sequence;
640: SELECT COUNT(1)
641: INTO l_dummy
642: FROM JL_ZZ_AR_TX_CATEG

Line 676: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.CHECK_UNIQUE<-' ||

672: BEGIN
673:
674: -- Update the calling sequence
675: --
676: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.CHECK_UNIQUE<-' ||
677: X_calling_sequence;
678: SELECT COUNT(1)
679: INTO l_dummy
680: FROM JL_ZZ_AR_TX_CATEG

Line 706: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.<-CHECK_OVERLAPPED_DATES' ||

702: RETURN;
703:
704: -- Update the calling sequence
705: --
706: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.<-CHECK_OVERLAPPED_DATES' ||
707: X_calling_sequence;
708: SELECT COUNT(1)
709: INTO l_dummy
710: FROM jl_zz_ar_tx_categ a

Line 751: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.CHECK_GAPS<-' ||

747:
748: BEGIN
749: -- Update the calling sequence
750: --
751: current_calling_sequence := 'JL_ZZ_AR_TX_CATEG_PKG.CHECK_GAPS<-' ||
752: X_calling_sequence;
753: --
754: -- Check if there is one row with it's end date exactly one day
755: -- less than the current row's start date

Line 804: END JL_ZZ_AR_TX_CATEG_PKG;

800: END;
801: END IF;
802: END Check_Gaps;
803:
804: END JL_ZZ_AR_TX_CATEG_PKG;