APPS.JL_ZZ_AR_TX_GROUPS_PKG dependencies on JL_ZZ_AR_TX_GROUPS_PKG

Line 1: PACKAGE BODY JL_ZZ_AR_TX_GROUPS_PKG AS

1: PACKAGE BODY JL_ZZ_AR_TX_GROUPS_PKG AS
2: /* $Header: jlzzttgb.pls 120.5 2005/03/31 23:34:33 nipatel ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_rowid IN OUT NOCOPY VARCHAR2,

Line 68: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.INSERT_ROW<-' ||

64:
65: BEGIN
66: -- Update the calling sequence
67: --
68: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.INSERT_ROW<-' ||
69: X_calling_sequence;
70:
71: debug_info := 'Insert into JL_ZZ_AR_TX_GROUPS ';
72: INSERT INTO JL_ZZ_AR_TX_GROUPS (group_tax_id,

Line 285: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.LOCK_ROW<-' ||

281:
282: BEGIN
283: -- Update the calling sequence
284: --
285: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.LOCK_ROW<-' ||
286: X_calling_sequence;
287: debug_info := 'Open cursor C';
288: OPEN C;
289: debug_info := 'Fetch cursor C';

Line 486: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.UPDATE_ROW' ||

482:
483: BEGIN
484: --Update the calling sequence
485: --
486: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.UPDATE_ROW' ||
487: X_calling_sequence;
488:
489: debug_info := 'Open cursor C';
490: UPDATE JL_ZZ_AR_TX_GROUPS

Line 569: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.UPDATE_ROW' ||

565:
566: BEGIN
567: --Update the calling sequence
568: --
569: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.UPDATE_ROW' ||
570: X_calling_sequence;
571: debug_info := 'Open cursor C';
572:
573: DELETE FROM JL_ZZ_AR_TX_GROUPS

Line 610: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.CHECK_UNIQUE<-' ||

606:
607: BEGIN
608: -- Update the calling sequence
609: --
610: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.CHECK_UNIQUE<-' ||
611: X_calling_sequence;
612: SELECT COUNT(1)
613: INTO l_dummy
614: FROM JL_ZZ_AR_TX_GROUPS

Line 656: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.<-CHECK_OVERLAPPED_DATES' ||

652: debug_info VARCHAR2(100);
653: BEGIN
654: -- Update the calling sequence
655: --
656: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.<-CHECK_OVERLAPPED_DATES' ||
657: X_calling_sequence;
658: SELECT COUNT(1)
659: INTO l_dummy
660: FROM jl_zz_ar_tx_GROUPS a

Line 710: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.CHECK_GAPS<-' ||

706:
707: BEGIN
708: -- Update the calling sequence
709: --
710: current_calling_sequence := 'JL_ZZ_AR_TX_GROUPS_PKG.CHECK_GAPS<-' ||
711: X_calling_sequence;
712: --
713: -- Check if there is one row with it's end date exactly one day
714: -- less than the current row's start date

Line 780: END JL_ZZ_AR_TX_GROUPS_PKG;

776: END;
777: END IF;
778: END Check_Gaps;
779:
780: END JL_ZZ_AR_TX_GROUPS_PKG;