APPS.BIS_TARGET_UTIL dependencies on BIS_TARGET_LEVELS

Line 52: 'BIS_business_plans plan,BIS_target_levels lvl ';

48: l_cursor Integer;
49: l_sql_result Integer := 0;
50:
51: l_view_from_stmt Varchar2(2000) := ' from BIS_target_values val, '||
52: 'BIS_business_plans plan,BIS_target_levels lvl ';
53:
54: l_view_from_stmt2 Varchar2(2000);
55:
56: l_view_from_stmt3 Varchar2(2000) := ' val.target_level_id = lvl.target_level_id ' ||

Line 80: l_trg_lvl_rec BIS_TARGET_LEVELS%ROWTYPE;

76: 'val.role1,'||
77: 'val.role2,'||
78: 'val.role3';
79: l_level_select_list3 Varchar2(2000);
80: l_trg_lvl_rec BIS_TARGET_LEVELS%ROWTYPE;
81: l_level_name Varchar2(30);
82: l_period_type Varchar2(15);
83: l_year number(15);
84: l_calendar Varchar2(15);

Line 98: BIS_debug_pub.add('Selecting row from BIS_target_levels for : '

94: if p_msg_init = FND_API.G_TRUE then
95: FND_MSG_PUB.initialize;
96: end if;
97:
98: BIS_debug_pub.add('Selecting row from BIS_target_levels for : '
99: || p_ind_level_name);
100:
101: select *
102: into l_trg_lvl_rec

Line 103: from BIS_target_levels

99: || p_ind_level_name);
100:
101: select *
102: into l_trg_lvl_rec
103: from BIS_target_levels
104: where short_name = p_ind_level_name;
105:
106: -- Time dimension
107: BIS_debug_pub.add('Select Level Name For Time');

Line 409: from BIS_target_levels lvl,

405: ,x_msg_data OUT Varchar2)
406: is
407: Cursor C_levels(p_indicator_name Varchar2) is
408: select lvl.short_name
409: from BIS_target_levels lvl,
410: BIS_indicators ind
411: where lvl.indicator_id = ind.indicator_id
412: and ind.short_name = p_indicator_name;
413: l_return_status varchar2(10);

Line 574: select short_name into l_view_name from bis_target_levels

570: l_rtn_val Varchar2(80);
571: begin
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573:
574: select short_name into l_view_name from bis_target_levels
575: where target_level_id = p_target_level_id;
576: -- open cursor
577: l_cursor := dbms_sql.open_cursor;
578: