DBA Data[Home] [Help]

APPS.MST_RELEASE dependencies on DUAL

Line 931: from dual;

927:
928: if l_group_id is null then
929: select mst_release_seq.nextval
930: into l_group_id
931: from dual;
932: end if;
933:
934: --update mst_release_temp_gt so that it would not be selected during next round of cursor opening
935: update mst_release_temp_gt

Line 2576: from dual;

2572: if cur_check_error%notfound then
2573: l_error_found := 0; -- release was successful
2574: select sysdate
2575: into l_date
2576: from dual;
2577: g_cnt_group_released := g_cnt_group_released + 1;
2578: else
2579: l_error_found := 1; -- release was failed
2580: l_date := p_release_start_date; -- release start datetime

Line 3014: from dual;

3010: set_concurrent_status('WARNING', get_seeded_message('MST_REL_BK_MESSAGE_38'));
3011: else
3012: select sysdate
3013: into l_release_start_date
3014: from dual;
3015:
3016: remove_unqualified_trips(l_return_status, p_plan_id, p_release_id);
3017: if l_return_status = fnd_api.g_ret_sts_success then
3018: populate_related_trips(l_return_status, p_plan_id, p_release_id);