APPS.EGO_ITEM_WS_PVT dependencies on DUAL

Line 544: FROM dual;

540: v_extension_id AS "EXTENSION_ID",
541: v_data_level_name AS "DATA_LEVEL_NAME"
542: ).getclobval() ,
543: SYSDATE
544: FROM dual;
545:
546: END LOOP;
547: CLOSE v_dynamic_cursor;
548: EXCEPTION

Line 1640: FROM dual ;

1636: l_is_inherited AS "Inherited",
1637: l_is_modified AS "Modified"
1638: ).getclobval()
1639: ,SYSDATE
1640: FROM dual ;
1641: END LOOP; -- loop i
1642: END IF; -- end of if (l_ta_entered_count = 0 OR l_ta_count <> 0)
1643: END LOOP; -- loop k
1644: END IF;

Line 2263: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;

2259: -- Bug 8706557 : Start - Raise the business event for bacth mode
2260: IF (l_batch_id <> -1) THEN
2261: l_event_name := 'oracle.apps.ego.item.FreezePublishedItems' ;
2262:
2263: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;
2264:
2265: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
2266:
2267: wf_event.AddParameterToList( p_name => 'BATCH_ID'

Line 4509: SELECT SYSDATE INTO v_current_date from dual;

4505: IF (v_impl_date IS NULL ) THEN
4506: RAISE e_unimpl_revision;
4507: END IF;
4508:
4509: SELECT SYSDATE INTO v_current_date from dual;
4510:
4511: IF(v_end_date <= v_current_date) THEN
4512: p_revision_date := v_end_date;
4513: ELSE