[Home] [Help]
9: /* This package defaults all the column values in the wip mass load process. */
10: -- procedure row_by_row ;
11: procedure created_by_name;
12: procedure last_updated_by_name;
13: procedure organization; --should be first after standard who columns
14: procedure job_name;
15: procedure wip_entity_id;
16: procedure repetitive_schedule_id;
17: procedure kanban_card_id; --may default job properties based on kanban id
612: wjsi_row.processing_work_days := l_defaulted_sched.processing_work_days;
613: wjsi_row.first_unit_completion_date := l_defaulted_sched.first_unit_cpl_date;
614: wjsi_row.daily_production_rate := l_defaulted_sched.daily_production_rate;
615: else
616: -- A kanban reference makes sense only on a standard job or schedule
617: -- creation request.
618: raise fnd_api.g_exc_unexpected_error;
619: end if ;
620: exception when others then
1208: and bor.assembly_item_id = wjsi_row.primary_item_id
1209: and nvl(bor.alternate_routing_designator,'@@@') =
1210: nvl(wjsi_row.alternate_routing_designator,'@@@');
1211: /*Fix for Bug#9765343 (FP of 9668143) Derive Completion Subinventory based on routing_reference_id
1212: for a Non-Standard Job*/
1213: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then
1214: select bor.completion_subinventory
1215: into wjsi_row.completion_subinventory
1216: from bom_operational_routings bor
1258: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.
1259: */
1260: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1261: /*Fix for Bug#9765343 (FP of 9668143) Derive Completion Locator based on routing_reference_id
1262: for a Non-Standard Job*/
1263: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then
1264: select bor.completion_locator_id
1265: into wjsi_row.completion_locator_id
1266: from bom_operational_routings bor