735: fnd_global.user_id,
736: sysdate,
737: fnd_global.user_id
738: FROM
739: DUAL;
740:
741: END IF;
742: END IF;--demand > 0
743: END LOOP;
1197: fnd_global.user_id,
1198: sysdate,
1199: fnd_global.user_id
1200: FROM
1201: DUAL;
1202:
1203: END IF;
1204:
1205: ELSIF l_rate_end_date IS NOT NULL THEN
1734: fnd_global.user_id,
1735: sysdate,
1736: fnd_global.user_id
1737: FROM
1738: DUAL;
1739:
1740: END IF;
1741: END LOOP;-- end of my cursor
1742: IF parent_schedule_entries%ISOPEN THEN
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.user_id
2225: FROM
2226: DUAL;
2227:
2228: END IF;
2229: END LOOP;-- end of my cursor
2230: IF parent_schedule_entries%ISOPEN THEN
2351: )
2352: )
2353: */ --bug 5237549
2354: AND FORECAST_DESIGNATOR in (
2355: select g_kanban_info_rec.input_designator from dual
2356: union all
2357: SELECT FORECAST_DESIGNATOR
2358: FROM MRP_FORECAST_DESIGNATORS
2359: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )
3189: )
3190: )
3191: */ --bug 5237549
3192: AND FORECAST_DESIGNATOR in (
3193: select g_kanban_info_rec.input_designator from dual
3194: union all
3195: SELECT FORECAST_DESIGNATOR
3196: FROM MRP_FORECAST_DESIGNATORS
3197: WHERE FORECAST_SET = g_kanban_info_rec.input_designator )
3702: l_pull_sequence_rec.last_update_date,
3703: l_pull_sequence_rec.last_updated_by,
3704: l_pull_sequence_rec.creation_date,
3705: l_pull_sequence_rec.created_by
3706: FROM dual;
3707:
3708: l_pull_sequence_rec.organization_id := g_kanban_info_rec.organization_id;
3709: l_pull_sequence_rec.kanban_plan_id := g_kanban_info_rec.kanban_plan_id;
3710: l_pull_sequence_rec.inventory_item_id := l_item_id;