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_CAT_DTL_PKG dependencies on JL_ZZ_AR_TX_CAT_DTL

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 40: FROM jl_zz_ar_tx_cat_dtl

36: X_calling_sequence IN VARCHAR2) IS
37:
38: CURSOR C IS
39: SELECT rowid
40: FROM jl_zz_ar_tx_cat_dtl
41: WHERE tax_category_id = X_tax_category_id
42: AND tax_categ_dtl_id = X_tax_categ_dtl_id;
43: --AND end_date_active = X_end_date_active;
44:

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 53: debug_info := 'Insert into JL_ZZ_AR_TX_CAT_DTL';

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,
56: end_date_active,
57: min_taxable_basis,

Line 54: INSERT INTO jl_zz_ar_tx_cat_dtl (tax_categ_dtl_id,

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,
56: end_date_active,
57: min_taxable_basis,
58: last_update_date,

Line 210: FROM JL_ZZ_AR_TX_CAT_DTL

206: ATTRIBUTE12,
207: ATTRIBUTE13,
208: ATTRIBUTE14,
209: ATTRIBUTE15
210: FROM JL_ZZ_AR_TX_CAT_DTL
211: WHERE rowid = X_rowid
212: --AND tax_category_id = X_tax_category_id
213: --AND tax_categ_dtl_id = X_tax_categ_dtl_id
214: --AND end_date_active = X_end_date_active

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 384: UPDATE jl_zz_ar_tx_cat_dtl

380: current_calling_sequence VARCHAR2(2000);
381: debug_info VARCHAR2(100);
382:
383: BEGIN
384: UPDATE jl_zz_ar_tx_cat_dtl
385: SET tax_categ_dtl_id = X_tax_categ_dtl_id,
386: tax_category_id = X_tax_category_id,
387: end_date_active = X_end_date_active,
388: min_taxable_basis = X_min_taxable_basis,

Line 453: DELETE FROM jl_zz_ar_tx_cat_dtl

449: current_calling_sequence VARCHAR2(2000);
450: debug_info VARCHAR2(100);
451:
452: BEGIN
453: DELETE FROM jl_zz_ar_tx_cat_dtl
454: WHERE rowid = X_rowid
455: AND tax_category_id = X_tax_category_id
456: AND tax_categ_dtl_id = X_tax_categ_dtl_id;
457:

Line 499: FROM jl_zz_ar_tx_cat_dtl

495: current_calling_sequence :='JL_ZZ_AR_TX_CAT_PKG.CHECK_UNIQUE<-' ||
496: X_calling_sequence;
497: SELECT COUNT(1)
498: INTO l_dummy
499: FROM jl_zz_ar_tx_cat_dtl
500: WHERE tax_category_id = X_tax_category_id
501: AND tax_categ_dtl_id = X_tax_categ_dtl_id
502: AND end_date_active = X_end_date_active
503: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));

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 537: FROM jl_zz_ar_tx_cat_dtl a

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
538: WHERE tax_category_id = X_tax_category_id
539: AND tax_categ_dtl_id = X_tax_categ_dtl_id
540: AND ((a.end_date_active <= X_end_date_active AND a.end_date_active >= X_start_date_active) OR
541: (a.start_date_active <= X_end_date_active AND a.start_date_active >= X_start_date_active) OR

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 584: FROM jl_zz_ar_tx_cat_dtl a

580: -- less than the current row's start date
581: --
582: SELECT COUNT(1)
583: INTO l_dummy
584: FROM jl_zz_ar_tx_cat_dtl a
585: WHERE tax_category_id = X_tax_category_id
586: AND tax_categ_dtl_id = X_tax_categ_dtl_id
587: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
588:

Line 597: FROM jl_zz_ar_tx_cat_dtl a

593: -- the current row's end-date
594: --
595: SELECT COUNT(1)
596: INTO l_dummy1
597: FROM jl_zz_ar_tx_cat_dtl a
598: WHERE tax_category_id = X_tax_category_id
599: AND tax_categ_dtl_id = X_tax_categ_dtl_id
600: AND (trunc(a.start_date_active) = (trunc(X_end_date_active) + 1))
601: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));

Line 610: FROM jl_zz_ar_tx_cat_dtl a

606: IF (l_dummy1 = 0) THEN
607: BEGIN
608: SELECT COUNT(1)
609: INTO l_dummy2
610: FROM jl_zz_ar_tx_cat_dtl a
611: WHERE tax_category_id = X_tax_category_id
612: AND tax_categ_dtl_id = X_tax_categ_dtl_id
613: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
614:

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;