APPS.INV_KANBAN_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 2104: -- to upload the data from WIP_JOB_SCHEDULE_INTERFACE

2100: end Create_Transfer_Order;
2101:
2102: --
2103: -- Launch_MLP() : This program will launch the WIP Mass load program to
2104: -- to upload the data from WIP_JOB_SCHEDULE_INTERFACE
2105: -- table.
2106: --
2107:
2108: Function Launch_MLP(p_group_id IN Number) return BOOLEAN IS

Line 2198: Insert into WIP_JOB_SCHEDULE_INTERFACE

2194: l_last_unit_completion_date := NULL;
2195: END IF;
2196:
2197:
2198: Insert into WIP_JOB_SCHEDULE_INTERFACE
2199: (LAST_UPDATE_DATE,
2200: LAST_UPDATED_BY,
2201: CREATION_DATE,
2202: CREATED_BY,

Line 2309: from WIP_JOB_SCHEDULE_INTERFACE

2305:
2306: /*
2307: begin
2308: select 'Y' into rep_sched_exist
2309: from WIP_JOB_SCHEDULE_INTERFACE
2310: where
2311: primary_item_id = p_kanban_card_rec_tbl(1).inventory_item_id AND
2312: organization_id = p_kanban_card_rec_tbl(1).organization_id AND
2313: line_id = p_kanban_card_rec_tbl(1).wip_line_id AND

Line 2377: Insert into WIP_JOB_SCHEDULE_INTERFACE

2373: ELSE
2374: l_first_unit_start_date := Sysdate;
2375: l_last_unit_completion_date := NULL;
2376: END IF;
2377: Insert into WIP_JOB_SCHEDULE_INTERFACE
2378: ( LAST_UPDATE_DATE,
2379: LAST_UPDATED_BY,
2380: CREATION_DATE,
2381: CREATED_BY,

Line 2435: Update WIP_JOB_SCHEDULE_INTERFACE

2431: -- End if;
2432:
2433: p_kanban_card_rec_tbl(1).document_type := 6;
2434: if ( rep_sched_exist = 'Y' ) then
2435: Update WIP_JOB_SCHEDULE_INTERFACE
2436: set START_QUANTITY = START_QUANTITY + total_qty ,
2437: -- LAST_UNIT_COMPLETION_DATE = SYSDATE + (p_fixed_lead_time +
2438: -- p_var_lead_time*(START_QUANTITY + total_qty)),
2439: PROCESSING_WORK_DAYS = (START_QUANTITY + total_qty)/ line_rate,