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_FSC_CLS_PKG dependencies on JL_ZZ_AR_TX_FSC_CLS

Line 1: PACKAGE BODY JL_ZZ_AR_TX_FSC_CLS_PKG as

1: PACKAGE BODY JL_ZZ_AR_TX_FSC_CLS_PKG as
2: /* $Header: jlzztfcb.pls 120.3 2005/02/02 19:12:03 pla ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_Rowid IN OUT NOCOPY VARCHAR2,

Line 40: FROM JL_ZZ_AR_TX_FSC_CLS

36: X_calling_sequence VARCHAR2) IS
37:
38: CURSOR C IS
39: SELECT rowid
40: FROM JL_ZZ_AR_TX_FSC_CLS
41: WHERE fiscal_classification_code = X_fiscal_classification_code
42: AND tax_category_id = X_tax_category_id
43: AND end_date_active = X_end_date_active;
44:

Line 51: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||

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

Line 54: debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';

50: --
51: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||
52: X_calling_sequence;
53:
54: debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';
55: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,
56: fiscal_classification_code,
57: tax_category_id,
58: tax_code,

Line 55: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,

51: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||
52: X_calling_sequence;
53:
54: debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';
55: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,
56: fiscal_classification_code,
57: tax_category_id,
58: tax_code,
59: end_date_active,

Line 208: FROM JL_ZZ_AR_TX_FSC_CLS

204: ATTRIBUTE12,
205: ATTRIBUTE13,
206: ATTRIBUTE14,
207: ATTRIBUTE15
208: FROM JL_ZZ_AR_TX_FSC_CLS
209: WHERE rowid = X_Rowid
210: FOR UPDATE of fiscal_classification_code,
211: tax_category_id,
212: end_date_active,

Line 222: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.LOCK_ROW<-' ||

218:
219: BEGIN
220: -- Update the calling sequence
221: --
222: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.LOCK_ROW<-' ||
223: X_calling_sequence;
224: debug_info := 'Open cursor C';
225: OPEN C;
226: debug_info := 'Fetch cursor C';

Line 365: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||

361:
362: BEGIN
363: -- Update the calling sequence
364: --
365: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
366: X_calling_sequence;
367: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
368:
369: UPDATE JL_ZZ_AR_TX_FSC_CLS

Line 367: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';

363: -- Update the calling sequence
364: --
365: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
366: X_calling_sequence;
367: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
368:
369: UPDATE JL_ZZ_AR_TX_FSC_CLS
370: SET fsc_cls_id = X_fsc_cls_id,
371: fiscal_classification_code = X_fiscal_classification_code,

Line 369: UPDATE JL_ZZ_AR_TX_FSC_CLS

365: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
366: X_calling_sequence;
367: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
368:
369: UPDATE JL_ZZ_AR_TX_FSC_CLS
370: SET fsc_cls_id = X_fsc_cls_id,
371: fiscal_classification_code = X_fiscal_classification_code,
372: tax_category_id = X_tax_category_id,
373: end_date_active = X_end_date_active,

Line 430: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||

426:
427: BEGIN
428: -- Update the calling sequence
429: --
430: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
431: X_calling_sequence;
432: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
433:
434: DELETE FROM JL_ZZ_AR_TX_FSC_CLS

Line 432: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';

428: -- Update the calling sequence
429: --
430: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
431: X_calling_sequence;
432: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
433:
434: DELETE FROM JL_ZZ_AR_TX_FSC_CLS
435: WHERE rowid = X_Rowid;
436:

Line 434: DELETE FROM JL_ZZ_AR_TX_FSC_CLS

430: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
431: X_calling_sequence;
432: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
433:
434: DELETE FROM JL_ZZ_AR_TX_FSC_CLS
435: WHERE rowid = X_Rowid;
436:
437: IF (SQL%NOTFOUND) THEN
438: RAISE NO_DATA_FOUND;

Line 470: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_UNIQUE<-' ||

466:
467: BEGIN
468: -- Update the calling sequence
469: --
470: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_UNIQUE<-' ||
471: X_calling_sequence;
472: SELECT COUNT(1)
473: INTO l_dummy
474: FROM jl_zz_ar_tx_fsc_cls

Line 474: FROM jl_zz_ar_tx_fsc_cls

470: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_UNIQUE<-' ||
471: X_calling_sequence;
472: SELECT COUNT(1)
473: INTO l_dummy
474: FROM jl_zz_ar_tx_fsc_cls
475: WHERE fiscal_classification_code = X_fiscal_classification_code
476: AND tax_category_id = X_tax_category_id
477: AND end_date_active = X_end_date_active
478: AND org_id = X_org_id

Line 510: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.<-CHECK_OVERLAPPED_DATES' ||

506:
507: BEGIN
508: -- Update the calling sequence
509: --
510: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.<-CHECK_OVERLAPPED_DATES' ||
511: X_calling_sequence;
512: SELECT COUNT(1)
513: INTO l_dummy
514: FROM jl_zz_ar_tx_fsc_cls a

Line 514: FROM jl_zz_ar_tx_fsc_cls a

510: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.<-CHECK_OVERLAPPED_DATES' ||
511: X_calling_sequence;
512: SELECT COUNT(1)
513: INTO l_dummy
514: FROM jl_zz_ar_tx_fsc_cls a
515: WHERE a.fiscal_classification_code = X_fiscal_classification_code
516: AND a.tax_category_id = X_tax_category_id
517: AND ((a.end_date_active <= X_end_date_active AND
518: a.end_date_active >= X_start_date_active) OR

Line 558: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_GAPS<-' ||

554:
555: BEGIN
556: -- Update the calling sequence
557: --
558: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_GAPS<-' ||
559: X_calling_sequence;
560: --
561: -- Check if there is one row with it's end date exactly one day
562: -- less than the current row's start date

Line 566: FROM jl_zz_ar_tx_fsc_cls a

562: -- less than the current row's start date
563: --
564: SELECT COUNT(1)
565: INTO l_dummy
566: FROM jl_zz_ar_tx_fsc_cls a
567: WHERE a.fiscal_classification_code = X_fiscal_classification_code
568: AND a.tax_category_id = X_tax_category_id
569: AND trunc(a.end_date_active) = (trunc(X_start_date_active) -1)
570: AND org_id = X_org_id

Line 581: FROM jl_zz_ar_tx_fsc_cls a

577: -- the current row's end-date
578: --
579: SELECT COUNT(1)
580: INTO l_dummy1
581: FROM jl_zz_ar_tx_fsc_cls a
582: WHERE a.fiscal_classification_code = X_fiscal_classification_code
583: AND a.tax_category_id = X_tax_category_id
584: AND (trunc(a.start_date_active) = (trunc(X_end_date_active) + 1))
585: AND org_id = X_org_id

Line 595: FROM jl_zz_ar_tx_fsc_cls a

591: IF (l_dummy1 = 0) THEN
592: BEGIN
593: SELECT COUNT(1)
594: INTO l_dummy2
595: FROM jl_zz_ar_tx_fsc_cls a
596: WHERE a.fiscal_classification_code = X_fiscal_classification_code
597: AND a.tax_category_id = X_tax_category_id
598: AND org_id = X_org_id
599: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));

Line 660: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY<-' ||

656:
657: BEGIN
658: -- Update the calling sequence
659: --
660: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY<-' ||
661: X_calling_sequence;
662:
663: debug_info := 'calling INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY';
664:

Line 796: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_CATEGORY<-' ||

792:
793: BEGIN
794: -- Update the calling sequence
795: --
796: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_CATEGORY<-' ||
797: X_calling_sequence;
798:
799: debug_info := 'calling INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY';
800:

Line 891: END JL_ZZ_AR_TX_FSC_CLS_PKG;

887: APP_EXCEPTION.RAISE_EXCEPTION;
888: END Update_Category;
889:
890:
891: END JL_ZZ_AR_TX_FSC_CLS_PKG;