DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on DUAL

Line 3168: FROM dual;

3164: --end bug 3783650
3165:
3166: SELECT mrp_form_query_s.nextval
3167: INTO l_query_id1
3168: FROM dual;
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: FOR loop in 1..7 LOOP

Line 5110: FROM DUAL;

5106:
5107: BEGIN
5108: SELECT mrp_form_query_s.nextval
5109: INTO p_query_id
5110: FROM DUAL;
5111:
5112: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
5113: AND p_category_set_id IS NOT NULL THEN
5114:

Line 5350: FROM DUAL;

5346: BEGIN
5347:
5348: SELECT mrp_form_query_s.nextval
5349: INTO p_query_id
5350: FROM DUAL;
5351:
5352: IF (p_from_category IS NOT NULL OR p_to_category IS NOT NULL)
5353: AND p_category_set_id IS NOT NULL THEN
5354:

Line 6160: FROM dual;

6156: FND_MESSAGE.set_name('MRP','EC_DATE');
6157: l_trans_var1 := FND_MESSAGE.get;
6158: SELECT to_char(sysdate)
6159: INTO l_trans_var2
6160: FROM dual;
6161: l_out_message := l_trans_var1 || ': ' || l_trans_var2;
6162: MRP_UTIL.MRP_OUT(l_out_message);
6163:
6164: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_REPORT');