[Home] [Help]
12: | This file creates the utilities that are required to create |
13: | work orders for ATO configurations. |
14: | |
15: | insert_wip_interface - inserts a record into |
16: | WIP_JOB_SCHEDULE_INTERFACE for |
17: | WIP_MASS_LOAD to create work orders |
18: | |
19: | To Do: Handle Errors. Need to discuss with Usha and Girish what |
20: | error information to include in Notification. |
35: | comparing with get_reserved_qty. |
36: | |
37: | Oct 25, 02 Kundan Sarkar Bugfix 2644849 (2620282 in br)|
38: | Insert bom revision info in |
39: | wip_job_schedule_interface |
40: |
41: | DEC 12, 2002 Kiran Konada
42: | Added code for ML SUPPLy fetaure
43: |
65: x_message_name - name of error message if insert
66: fails
67:
68: Description: This function inserts a record into the
69: WIP_JOB_SCHEDULE_INTERFACE table for the creation of
70: work orders.
71:
72: *****************************************************************************/
73:
260:
261: -- Fixed bug 5346922
262: -- Removed the decode stmt for status type column in the insert
263: l_stmt_num := 150;
264: insert into wip_job_schedule_interface
265: (last_update_date,
266: last_updated_by,
267: creation_date,
268: created_by,
477:
478: -- Fixed bug 5346922
479: -- Removed the decode for supply type
480: l_stmt_num := 170;
481: insert into wip_job_schedule_interface
482: (last_update_date,
483: last_updated_by,
484: creation_date,
485: created_by,