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.PJI_PMV_ENGINE dependencies on PJI_PMV_ET_RT_DIM_TMP

Line 594: DELETE PJI_PMV_ET_RT_DIM_TMP where record_type = 'RT';

590: Write2FWKLog('Entering Convert_Event_Revenue_Type...','Convert_Event_Revenue_Type');
591: END IF;
592:
593: DELETE PJI_PMV_EC_RC_DIM_TMP where record_type = 'RC';
594: DELETE PJI_PMV_ET_RT_DIM_TMP where record_type = 'RT';
595:
596: IF p_Revenue_Category IS NOT NULL THEN
597: l_RCate_Dimension_List_Tab:=Decode_VARS(p_Revenue_Category);
598: ELSE

Line 641: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

637: IF p_PA_DEBUG_MODE = 'Y' THEN
638: Write2FWKLog('Creating RT rows, View BY RT and RC is not specified.');
639: END IF;
640:
641: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
642: SELECT ID, VALUE,'RT'
643: FROM pji_exp_evt_types_v ;
644: l_RT_Parsed_Flag:='Y';
645: ELSIF l_RC_Parsed_Flag IS NOT NULL THEN

Line 649: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

645: ELSIF l_RC_Parsed_Flag IS NOT NULL THEN
646: IF p_PA_DEBUG_MODE = 'Y' THEN
647: Write2FWKLog('Creating RT rows, RC is specified.');
648: END IF;
649: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
650: SELECT rtyp.id, DECODE(p_View_BY,'RC',usrx.name,'RT',rtyp.value,'-1'),'RT'
651: FROM pji_exp_evt_types_v rtyp
652: , PJI_PMV_EC_RC_DIM_TMP usrx
653: WHERE rtyp.revenue_category_code = usrx.id

Line 666: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

662: IF p_PA_DEBUG_MODE = 'Y' THEN
663: Write2FWKLog('Creating RT rows, RC is not specified.');
664: END IF;
665: FOR i IN 1..l_RType_Dimension_List_Tab.Last LOOP
666: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
667: SELECT id, DECODE(p_View_BY,'RT',value,'-1'),'RT'
668: FROM pji_exp_evt_types_v
669: WHERE
670: id = l_RType_Dimension_List_Tab(i);

Line 678: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

674: IF p_PA_DEBUG_MODE = 'Y' THEN
675: Write2FWKLog('Creating RT rows, RC is specified.');
676: END IF;
677: FOR i IN 1..l_RType_Dimension_List_Tab.Last LOOP
678: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
679: SELECT rtyp.id, DECODE(p_View_BY,'RC',usrx.name,'RT',rtyp.value,'-1'),'RT'
680: FROM pji_exp_evt_types_v rtyp
681: , PJI_PMV_EC_RC_DIM_TMP usrx
682: WHERE rtyp.id = l_RType_Dimension_List_Tab(i)

Line 766: DELETE PJI_PMV_ET_RT_DIM_TMP where record_type = 'ET';

762: IF p_PA_DEBUG_MODE = 'Y' THEN
763: Write2FWKLog('Entering Convert_Expenditure_Category...','Convert_Expenditure_Category');
764: END IF;
765:
766: DELETE PJI_PMV_ET_RT_DIM_TMP where record_type = 'ET';
767: DELETE PJI_PMV_EC_RC_DIM_TMP where record_type = 'EC';
768:
769: IF p_Expenditure_Category IS NOT NULL THEN
770: l_ECate_Dimension_List_Tab:=Decode_VARS(p_Expenditure_Category);

Line 815: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

811: IF p_PA_DEBUG_MODE = 'Y' THEN
812: Write2FWKLog('Creating ET rows, View BY ET and EC is not specified.');
813: END IF;
814:
815: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
816: SELECT EXPENDITURE_TYPE_ID, EXPENDITURE_TYPE,'ET'
817: FROM PA_EXPENDITURE_TYPES ;
818: l_ET_Parsed_Flag:='Y';
819: ELSIF l_EC_Parsed_Flag IS NOT NULL THEN

Line 823: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

819: ELSIF l_EC_Parsed_Flag IS NOT NULL THEN
820: IF p_PA_DEBUG_MODE = 'Y' THEN
821: Write2FWKLog('Creating ET rows, EC is specified.');
822: END IF;
823: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
824: SELECT etyp.expenditure_type_id,
825:
826: DECODE(p_View_BY,'EC',usrx.name,'ET',etyp.expenditure_type,'-1'),'ET'
827: FROM pa_expenditure_types etyp

Line 842: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

838: IF p_PA_DEBUG_MODE = 'Y' THEN
839: Write2FWKLog('Creating ET rows, EC is not specified.');
840: END IF;
841: FOR i IN 1..l_EType_Dimension_List_Tab.Last LOOP
842: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
843: SELECT expenditure_type_id, DECODE(p_View_BY,'ET',expenditure_type,'-1'),'ET'
844: FROM pa_expenditure_types
845: WHERE
846: expenditure_type_id = l_EType_Dimension_List_Tab(i);

Line 854: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)

850: IF p_PA_DEBUG_MODE = 'Y' THEN
851: Write2FWKLog('Creating ET rows, EC is specified.');
852: END IF;
853: FOR i IN 1..l_EType_Dimension_List_Tab.Last LOOP
854: INSERT INTO PJI_PMV_ET_RT_DIM_TMP (ID, NAME,RECORD_TYPE)
855: SELECT etyp.expenditure_type_id,
856:
857: DECODE(p_View_BY,'EC',usrx.name,'ET',etyp.expenditure_type,'-1'),'ET'
858: FROM pa_expenditure_types etyp