APPS.BIS_PMF_MIGRATION_PVT dependencies on BIS_TARGET_LEVEL_PUB

Line 558: l_target_level_rec_new BIS_TARget_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;

554: l_dim_level_name VARCHAR2(32000);
555: l_ret_status VARCHAR2(32000);
556: l_userind_org_name VARCHAR2(32000);
557: l_userind_org_value VARCHAR2(32000);
558: l_target_level_rec_new BIS_TARget_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
559: -- meastmon 06/21/2001
560: l_userind_current_org_value VARCHAR2(32000);
561: BEGIN
562: --Loop thru the cursor and resequence the dimension levels

Line 864: (p_target_level_rec IN BIS_TARGET_LEvel_PUB.TARGET_LEVEL_REC_TYPE

860:
861:
862:
863: FUNCTION NEEDS_MIGRATION
864: (p_target_level_rec IN BIS_TARGET_LEvel_PUB.TARGET_LEVEL_REC_TYPE
865: )
866: RETURN BOOLEAN
867: IS
868: l_org_time_exists BOOLEAN;

Line 879: CURSOR c_target_lvl_exists(cp_tl_rec IN BIS_TARGET_LEvel_PUB.TARGET_LEVEL_REC_TYPE) IS

875: l_dim5_id NUMBER;
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

Line 906: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;

902: );
903:
904: l_tl_count NUMBER := 0;
905: l_mig_target_level_rec BIS_PMF_MIGRATION_PVT.target_level_rec;
906: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
907: l_reseq_dims BIS_PMF_MIGRATION_PVT.resequenced_dimensions_Array;
908: l_return_status NUMBER;
909: l_dim_count NUMBER;
910: