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.12010000.2 2009/06/16 11:44:31 ssohal ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement NUMBER;

Line 47: FROM JL_ZZ_AR_TX_FSC_CLS

43: X_calling_sequence VARCHAR2) IS
44:
45: CURSOR C IS
46: SELECT rowid
47: FROM JL_ZZ_AR_TX_FSC_CLS
48: WHERE fiscal_classification_code = X_fiscal_classification_code
49: AND tax_category_id = X_tax_category_id
50: AND end_date_active = X_end_date_active;
51:

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

54:
55: BEGIN
56: -- Update the calling sequence
57: --
58: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||
59: X_calling_sequence;
60:
61: debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';
62: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,

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

57: --
58: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||
59: X_calling_sequence;
60:
61: debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';
62: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,
63: fiscal_classification_code,
64: tax_category_id,
65: tax_code,

Line 62: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,

58: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||
59: X_calling_sequence;
60:
61: debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';
62: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,
63: fiscal_classification_code,
64: tax_category_id,
65: tax_code,
66: end_date_active,

Line 215: FROM JL_ZZ_AR_TX_FSC_CLS

211: ATTRIBUTE12,
212: ATTRIBUTE13,
213: ATTRIBUTE14,
214: ATTRIBUTE15
215: FROM JL_ZZ_AR_TX_FSC_CLS
216: WHERE rowid = X_Rowid
217: FOR UPDATE of fiscal_classification_code,
218: tax_category_id,
219: end_date_active,

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

225:
226: BEGIN
227: -- Update the calling sequence
228: --
229: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.LOCK_ROW<-' ||
230: X_calling_sequence;
231: debug_info := 'Open cursor C';
232: OPEN C;
233: debug_info := 'Fetch cursor C';

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

368:
369: BEGIN
370: -- Update the calling sequence
371: --
372: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
373: X_calling_sequence;
374: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
375:
376: UPDATE JL_ZZ_AR_TX_FSC_CLS

Line 374: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';

370: -- Update the calling sequence
371: --
372: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
373: X_calling_sequence;
374: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
375:
376: UPDATE JL_ZZ_AR_TX_FSC_CLS
377: SET fsc_cls_id = X_fsc_cls_id,
378: fiscal_classification_code = X_fiscal_classification_code,

Line 376: UPDATE JL_ZZ_AR_TX_FSC_CLS

372: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
373: X_calling_sequence;
374: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
375:
376: UPDATE JL_ZZ_AR_TX_FSC_CLS
377: SET fsc_cls_id = X_fsc_cls_id,
378: fiscal_classification_code = X_fiscal_classification_code,
379: tax_category_id = X_tax_category_id,
380: end_date_active = X_end_date_active,

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

433:
434: BEGIN
435: -- Update the calling sequence
436: --
437: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
438: X_calling_sequence;
439: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
440:
441: DELETE FROM JL_ZZ_AR_TX_FSC_CLS

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

435: -- Update the calling sequence
436: --
437: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
438: X_calling_sequence;
439: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
440:
441: DELETE FROM JL_ZZ_AR_TX_FSC_CLS
442: WHERE rowid = X_Rowid;
443:

Line 441: DELETE FROM JL_ZZ_AR_TX_FSC_CLS

437: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
438: X_calling_sequence;
439: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
440:
441: DELETE FROM JL_ZZ_AR_TX_FSC_CLS
442: WHERE rowid = X_Rowid;
443:
444: IF (SQL%NOTFOUND) THEN
445: RAISE NO_DATA_FOUND;

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

473:
474: BEGIN
475: -- Update the calling sequence
476: --
477: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_UNIQUE<-' ||
478: X_calling_sequence;
479: SELECT COUNT(1)
480: INTO l_dummy
481: FROM jl_zz_ar_tx_fsc_cls

Line 481: FROM jl_zz_ar_tx_fsc_cls

477: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_UNIQUE<-' ||
478: X_calling_sequence;
479: SELECT COUNT(1)
480: INTO l_dummy
481: FROM jl_zz_ar_tx_fsc_cls
482: WHERE fiscal_classification_code = X_fiscal_classification_code
483: AND tax_category_id = X_tax_category_id
484: AND end_date_active = X_end_date_active
485: AND org_id = X_org_id

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

513:
514: BEGIN
515: -- Update the calling sequence
516: --
517: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.<-CHECK_OVERLAPPED_DATES' ||
518: X_calling_sequence;
519: SELECT COUNT(1)
520: INTO l_dummy
521: FROM jl_zz_ar_tx_fsc_cls a

Line 521: FROM jl_zz_ar_tx_fsc_cls a

517: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.<-CHECK_OVERLAPPED_DATES' ||
518: X_calling_sequence;
519: SELECT COUNT(1)
520: INTO l_dummy
521: FROM jl_zz_ar_tx_fsc_cls a
522: WHERE a.fiscal_classification_code = X_fiscal_classification_code
523: AND a.tax_category_id = X_tax_category_id
524: AND ((a.end_date_active <= X_end_date_active AND
525: a.end_date_active >= X_start_date_active) OR

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

561:
562: BEGIN
563: -- Update the calling sequence
564: --
565: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_GAPS<-' ||
566: X_calling_sequence;
567: --
568: -- Check if there is one row with it's end date exactly one day
569: -- less than the current row's start date

Line 573: FROM jl_zz_ar_tx_fsc_cls a

569: -- less than the current row's start date
570: --
571: SELECT COUNT(1)
572: INTO l_dummy
573: FROM jl_zz_ar_tx_fsc_cls a
574: WHERE a.fiscal_classification_code = X_fiscal_classification_code
575: AND a.tax_category_id = X_tax_category_id
576: AND trunc(a.end_date_active) = (trunc(X_start_date_active) -1)
577: AND org_id = X_org_id

Line 588: FROM jl_zz_ar_tx_fsc_cls a

584: -- the current row's end-date
585: --
586: SELECT COUNT(1)
587: INTO l_dummy1
588: FROM jl_zz_ar_tx_fsc_cls a
589: WHERE a.fiscal_classification_code = X_fiscal_classification_code
590: AND a.tax_category_id = X_tax_category_id
591: AND (trunc(a.start_date_active) = (trunc(X_end_date_active) + 1))
592: AND org_id = X_org_id

Line 602: FROM jl_zz_ar_tx_fsc_cls a

598: IF (l_dummy1 = 0) THEN
599: BEGIN
600: SELECT COUNT(1)
601: INTO l_dummy2
602: FROM jl_zz_ar_tx_fsc_cls a
603: WHERE a.fiscal_classification_code = X_fiscal_classification_code
604: AND a.tax_category_id = X_tax_category_id
605: AND org_id = X_org_id
606: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));

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

665: -- Update the calling sequence
666: --
667: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
668:
669: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY<-' ||
670: X_calling_sequence;
671:
672: l_category_rec.structure_id := X_structure_id;
673: l_category_rec.segment1 := X_segment1;

Line 738: 'JL.PLSQL.JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY',

734: END IF;
735:
736: IF (g_level_procedure >= g_current_runtime_level ) THEN
737: FND_LOG.STRING(g_level_procedure,
738: 'JL.PLSQL.JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY',
739: 'New Category created in MTL_CATEGORIES_B. '||
740: 'Category_Id : '||l_category_id);
741: END IF;
742:

Line 746: 'JL.PLSQL.JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY',

742:
743: ELSE -- Category already exists
744: IF (g_level_procedure >= g_current_runtime_level ) THEN
745: FND_LOG.STRING(g_level_procedure,
746: 'JL.PLSQL.JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY',
747: 'Category Already Exists in MTL_CATEGORIES_B. '||
748: 'Category_Id : '||l_category_id);
749: END IF;
750: END IF;

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

838:
839: BEGIN
840: -- Update the calling sequence
841: --
842: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_CATEGORY<-' ||
843: X_calling_sequence;
844:
845: debug_info := 'calling INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY';
846:

Line 944: END JL_ZZ_AR_TX_FSC_CLS_PKG;

940: g_level_event := FND_LOG.LEVEL_EVENT;
941: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
942: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
943:
944: END JL_ZZ_AR_TX_FSC_CLS_PKG;