APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_CLS_DIM_TMP

Line 418: DELETE PJI_PMV_CLS_DIM_TMP;

414: IF p_PA_DEBUG_MODE = 'Y' THEN
415: Write2FWKLog('Entering Convert_Classification...','Convert_Classification');
416: END IF;
417:
418: DELETE PJI_PMV_CLS_DIM_TMP;
419: IF p_Classification_ID IS NOT NULL THEN
420: IF p_PA_DEBUG_MODE = 'Y' THEN
421: Write2FWKLog('Classification IS NOT NULL...');
422: END IF;

Line 434: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

430: IF p_Classification_ID = '$PROJECT_TYPE$ALL' THEN
431: IF p_PA_DEBUG_MODE = 'Y' THEN
432: Write2FWKLog('All Project Types are selected.');
433: END IF;
434: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
435: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
436: FROM PJI_CLASS_CODES CLS
437: , PA_PROJECT_TYPES_ALL PJT
438: , PJI_PMV_ORG_DIM_TMP ORG

Line 446: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

442: ELSIF p_Classification_ID LIKE '$PROJECT_TYPE$%' THEN
443: IF p_PA_DEBUG_MODE = 'Y' THEN
444: Write2FWKLog('All '||p_Classification_ID||' Project Type is selected.');
445: END IF;
446: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
447: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
448: FROM PJI_CLASS_CODES CLS
449: , PA_PROJECT_TYPES_ALL PJT
450: , PJI_PMV_ORG_DIM_TMP ORG

Line 458: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

454: ELSE
455: IF p_PA_DEBUG_MODE = 'Y' THEN
456: Write2FWKLog('All class codes for '||p_Classification_ID||' Project type or Classification are selected.');
457: END IF;
458: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
459: SELECT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
460: FROM PJI_CLASS_CODES CLS
461: WHERE CLS.CLASS_CATEGORY = p_Classification_ID;
462: END IF;

Line 474: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

470: ** because of a bug in db (2596577).
471: */
472: /*
473: FORALL i IN 1..l_Dimension_List_Tab.Last
474: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
475: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
476: FROM PJI_CLASS_CODES CLS
477: , PA_PROJECT_TYPES_ALL PJT
478: , PJI_PMV_ORG_DIM_TMP ORG

Line 485: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

481: AND CLS.RECORD_TYPE = 'T'
482: AND CLS.CLASS_ID = l_Dimension_List_Tab(i);
483: */
484: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
485: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
486: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
487: FROM PJI_CLASS_CODES CLS
488: , PA_PROJECT_TYPES_ALL PJT
489: , PJI_PMV_ORG_DIM_TMP ORG

Line 502: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

498: ** because of a bug in db (2596577).
499: */
500: /*
501: FORALL i IN 1..l_Dimension_List_Tab.Last
502: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
503: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
504: FROM PJI_CLASS_CODES CLS
505: , PA_PROJECT_TYPES_ALL PJT
506: , PJI_PMV_ORG_DIM_TMP ORG

Line 512: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

508: AND CLS.CLASS_CODE = PJT.PROJECT_TYPE
509: AND CLS.CLASS_ID = l_Dimension_List_Tab(i);
510: */
511: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
512: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
513: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
514: FROM PJI_CLASS_CODES CLS
515: , PA_PROJECT_TYPES_ALL PJT
516: , PJI_PMV_ORG_DIM_TMP ORG

Line 528: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

524: ** because of a bug in db (2596577).
525: */
526: /*
527: FORALL i IN 1..l_Dimension_List_Tab.Last
528: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
529: SELECT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
530: FROM PJI_CLASS_CODES CLS
531: WHERE CLS.CLASS_CATEGORY = p_Classification_ID
532: AND CLS.CLASS_ID = l_Dimension_List_Tab(i);

Line 535: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

531: WHERE CLS.CLASS_CATEGORY = p_Classification_ID
532: AND CLS.CLASS_ID = l_Dimension_List_Tab(i);
533: */
534: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
535: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
536: SELECT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
537: FROM PJI_CLASS_CODES CLS
538: WHERE CLS.CLASS_CATEGORY = p_Classification_ID
539: AND CLS.CLASS_ID = l_Dimension_List_Tab(i);

Line 548: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)

544: IF p_PA_DEBUG_MODE = 'Y' THEN
545: Write2FWKLog('A class code was selected without corresponding category.');
546: END IF;
547: l_Parse_Status:='Y';
548: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
549: SELECT -1, '-1'
550: FROM SYS.DUAL; -- REMOVE THIS COMMENT WHEN THE ISSUE WITH DUAL IS RESOLVED.
551: ELSE
552: IF p_PA_DEBUG_MODE = 'Y' THEN