APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_PRJ_DIM_TMP

Line 1849: DELETE PJI_PMV_PRJ_DIM_TMP;

1845: IF p_PA_DEBUG_MODE = 'Y' THEN
1846: Write2FWKLog('Entering Convert_Project...','Convert_Project');
1847: END IF;
1848:
1849: DELETE PJI_PMV_PRJ_DIM_TMP;
1850:
1851: IF p_Project_IDS IS NOT NULL THEN
1852: l_Dimension_List_Tab:=Decode_IDS(p_Project_IDS);
1853: ELSE

Line 1868: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)

1864: IF l_Dimension_List_Tab IS NULL THEN
1865: IF p_PA_DEBUG_MODE = 'Y' THEN
1866: Write2FWKLog('Creating ALL PJs, PJ array is empty');
1867: END IF;
1868: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)
1869: SELECT ID, DECODE(p_View_BY,'PJ',VALUE,'-1')
1870: FROM PJI_PROJECTS_V;
1871: */
1872: IF l_Dimension_List_Tab IS NOT NULL THEN

Line 1882: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)

1878: ** because of a bug in db (2596577).
1879: */
1880: /*
1881: FORALL i IN 1..l_Dimension_List_Tab.Last
1882: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)
1883: SELECT ID, DECODE(p_View_BY,'OU',VALUE,'-1')
1884: FROM PJI_PROJECTS_V
1885: WHERE
1886: ID=l_Dimension_List_Tab(i);

Line 1889: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)

1885: WHERE
1886: ID=l_Dimension_List_Tab(i);
1887: */
1888: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
1889: INSERT INTO PJI_PMV_PRJ_DIM_TMP (ID, NAME)
1890: SELECT ID, DECODE(p_View_BY,'OU',VALUE,'-1')
1891: FROM PJI_PROJECTS_V
1892: WHERE
1893: ID=l_Dimension_List_Tab(i);