APPS.BIS_PMF_MIGRATION_PVT dependencies on BIS_TARGET_LEVELS

Line 33: REM | order in bis_target_levels. |

29: REM | accordingly changed |
30: REM | 03-JUN-2004 ankgoel Modified for bug#3583357. Added procedures for |
31: REM | re-sequencing dimensions in |
32: REM | bis_indicator_dimensions using the dim level |
33: REM | order in bis_target_levels. |
34: REM | 21-MAR-2005 ankagarw bug#4235732 - changing count(*) to count(1) |
35: REM | 19-OCT-2005 ppandey Enh 4618419- SQL Literal Fix |
36: REM | 15-DEC-2005 ankgoel Bug 4879417- Execute dynamic SQL with a NULL check |
37: REM +=======================================================================+

Line 134: FROM bis_target_levels

130: SELECT dimension1_level_id, dimension2_level_id,
131: dimension3_level_id, dimension4_level_id,
132: dimension5_level_id, dimension6_level_id,
133: dimension7_level_id
134: FROM bis_target_levels
135: WHERE indicator_id = p_ind_id
136: AND org_level_id IS NOT NULL
137: AND time_level_id IS NOT NULL
138: AND rownum < 2;

Line 210: FROM bis_target_levels

206: This is assumed for old measures.
207: */
208: CURSOR c_ind_id IS
209: SELECT indicator_id
210: FROM bis_target_levels
211: WHERE org_level_id IS NOT NULL
212: AND time_level_id IS NOT NULL
213: GROUP BY indicator_id;
214:

Line 502: FROM bis_target_levels

498: SELECT target_level_id, indicator_id, short_name
499: ,time_level_id, org_level_id, dimension1_level_id
500: ,dimension2_level_id, dimension3_level_id, dimension4_level_id
501: ,dimension5_level_id, dimension6_level_id, dimension7_level_id
502: FROM bis_target_levels
503: WHERE (NVL(dimension1_level_id,-9999) <> time_level_id AND NVL(dimension1_level_id,-9999) <> org_level_id)
504: AND (NVL(dimension2_level_id,-9999) <> time_level_id AND NVL(dimension2_level_id,-9999) <> org_level_id)
505: AND (NVL(dimension3_level_id,-9999) <> time_level_id AND NVL(dimension3_level_id,-9999) <> org_level_id)
506: AND (NVL(dimension4_level_id,-9999) <> time_level_id AND NVL(dimension4_level_id,-9999) <> org_level_id)

Line 661: l_sqlstmt := 'UPDATE bis_target_levels SET ' ||

657: END IF;
658: END LOOP;
659: END IF;
660: IF (l_dim_count = l_dimlevel_count) THEN
661: l_sqlstmt := 'UPDATE bis_target_levels SET ' ||
662: l_reseq_dims(1).dim_level_col ||' = :1 ' ||
663: ' , '||l_reseq_dims(2).dim_level_col ||' = :2 '||
664: ' , '||l_reseq_dims(3).dim_level_col ||' = :3 '||
665: ' , '||l_reseq_dims(4).dim_level_col ||' = :4 '||

Line 880: SELECT COUNT(1) FROM bis_target_levels

876: l_dim6_id NUMBER;
877: l_dim7_id NUMBER;
878:
879: CURSOR c_target_lvl_exists(cp_tl_rec IN BIS_TARGET_LEvel_PUB.TARGET_LEVEL_REC_TYPE) IS
880: SELECT COUNT(1) FROM bis_target_levels
881: WHERE indicator_id = cp_tl_rec.measure_id
882: AND ( cp_tl_rec.dimension1_level_id IS NULL OR
883: dimension1_level_id = cp_tl_rec.dimension1_level_id
884: )