APPS.JL_ZZ_AR_TX_FSC_CLS_PKG dependencies on JL_ZZ_AR_TX_FSC_CLS_PKG

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 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 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 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 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 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 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 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;