eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_AR_TX_GROUPS_PKG dependencies on JL_ZZ_AR_TX_GROUPS

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 52: FROM JL_ZZ_AR_TX_GROUPS

48: X_calling_sequence IN VARCHAR2) IS
49:
50: CURSOR C IS
51: SELECT rowid
52: FROM JL_ZZ_AR_TX_GROUPS
53: WHERE group_tax_id = X_group_tax_id
54: AND tax_category_id = X_tax_category_id
55: AND tax_group_record_id = X_tax_group_record_id
56: AND transaction_nature = X_transaction_nature

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 71: debug_info := 'Insert into JL_ZZ_AR_TX_GROUPS ';

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,
73: tax_category_id,
74: tax_group_record_id,
75: establishment_type,

Line 72: INSERT INTO JL_ZZ_AR_TX_GROUPS (group_tax_id,

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,
73: tax_category_id,
74: tax_group_record_id,
75: establishment_type,
76: contributor_type,

Line 272: FROM JL_ZZ_AR_TX_GROUPS

268: ATTRIBUTE13,
269: ATTRIBUTE14,
270: ATTRIBUTE15,
271: BASE_RATE
272: FROM JL_ZZ_AR_TX_GROUPS
273: WHERE rowid = X_rowid
274: FOR UPDATE OF group_tax_id
275: NOWAIT;
276:

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 490: UPDATE JL_ZZ_AR_TX_GROUPS

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
491: SET group_tax_id = X_group_tax_id,
492: tax_category_id = X_tax_category_id,
493: tax_group_record_id = X_tax_group_record_id,
494: establishment_type = X_establishment_type,

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 573: DELETE FROM JL_ZZ_AR_TX_GROUPS

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
574: WHERE rowid = X_rowid;
575:
576: IF (SQL%NOTFOUND) THEN
577: raise NO_DATA_FOUND;

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 614: FROM JL_ZZ_AR_TX_GROUPS

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
615: WHERE group_tax_id = X_group_tax_id
616: AND tax_category_id = X_tax_category_id
617: AND tax_group_record_id = X_tax_group_record_id
618: AND transaction_nature = X_transaction_nature

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 660: FROM jl_zz_ar_tx_GROUPS a

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
661: WHERE group_tax_id = X_group_tax_id
662: AND tax_category_id = X_tax_category_id
663: AND tax_group_record_id = X_tax_group_record_id
664: AND transaction_nature = X_transaction_nature

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 718: FROM jl_zz_ar_tx_GROUPS a

714: -- less than the current row's start date
715: --
716: SELECT COUNT(1)
717: INTO l_dummy
718: FROM jl_zz_ar_tx_GROUPS a
719: WHERE group_tax_id = X_group_tax_id
720: AND tax_category_id = X_tax_category_id
721: AND tax_group_record_id = X_tax_group_record_id
722: AND transaction_nature = X_transaction_nature

Line 736: FROM jl_zz_ar_tx_GROUPS a

732: -- the current row's end-date
733: --
734: SELECT COUNT(1)
735: INTO l_dummy1
736: FROM jl_zz_ar_tx_GROUPS a
737: WHERE group_tax_id = X_group_tax_id
738: AND tax_category_id = X_tax_category_id
739: AND tax_group_record_id = X_tax_group_record_id
740: AND transaction_nature = X_transaction_nature

Line 753: FROM jl_zz_ar_tx_GROUPS a

749: IF (l_dummy1 = 0) THEN
750: BEGIN
751: SELECT COUNT(1)
752: INTO l_dummy2
753: FROM jl_zz_ar_tx_GROUPS a
754: WHERE group_tax_id = X_group_tax_id
755: AND tax_category_id = X_tax_category_id
756: AND tax_group_record_id = X_tax_group_record_id
757: AND transaction_nature = X_transaction_nature

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;