[Home] [Help]
1149:
1150: --fix for bug5990761 allow update of job name for unreleased jobs
1151: select decode(wdj.status_type, WIP_CONSTANTS.UNRELEASED,NVL(p_job_name,we.wip_entity_name),we.wip_entity_name),we.wip_entity_name
1152: into p_job_name,l_old_job_name
1153: from wip_discrete_jobs wdj,
1154: wip_entities we
1155: where wdj.wip_entity_id = p_wip_entity_id
1156: and wdj.status_type in (
1157: WIP_CONSTANTS.UNRELEASED,
2340: select scheduled_start_date,
2341: scheduled_completion_date
2342: into l_job_start_date,
2343: l_job_compl_date
2344: from wip_discrete_jobs
2345: where wip_entity_id = p_wip_entity_id
2346: and organization_id = p_org_id;
2347:
2348: if(v_wljdi_op_start_date(l_d) IS NOT NULL and v_wljdi_op_completion_date(l_d) IS NOT NULL) then
5808: select 1
5809: into l_comp_exist
5810: from dual
5811: where exists ( select 1
5812: from wip_discrete_jobs
5813: where wip_entity_id = p_wip_entity_id
5814: and organization_id = p_org_id
5815: and job_type = WIP_CONSTANTS.STANDARD
5816: and primary_item_id = l_item_id );
7605: l_stmt_num := 140.2;
7606: -- For unreleased jobs allow job name update if wip_entity_id is not null - fix for bug5990761
7607: select decode(wdj.status_type, WIP_CONSTANTS.UNRELEASED, NVL(v_wlji_job_name(v_idx),we.wip_entity_name), we.wip_entity_name)
7608: into v_wlji_job_name(v_idx)
7609: from wip_discrete_jobs wdj,
7610: wip_entities we
7611: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
7612: and wdj.status_type in (
7613: WIP_CONSTANTS.UNRELEASED,
7778: l_cur_date_released,
7779: l_cur_schedule_group_id,
7780: l_cur_build_sequence,
7781: l_cur_line_id
7782: from wip_discrete_jobs
7783: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
7784: and organization_id = v_wlji_org_id(v_idx);
7785:
7786: -- BA: bug 3423195
10152: least(wdj.net_quantity,
10153: nvl(v_wlji_start_quantity(v_idx),
10154: wdj.net_quantity))))
10155: into v_wlji_net_quantity(v_idx)
10156: from wip_discrete_jobs wdj
10157: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
10158: and wdj.organization_id = v_wlji_org_id(v_idx);
10159: exception
10160: when others then
10182:
10183: BEGIN
10184: select msi.serial_number_control_code
10185: into l_serial_ctrl_code
10186: from mtl_system_items_kfv msi,wip_discrete_jobs wdj
10187: where msi.inventory_item_id = wdj.primary_item_id
10188: and msi.organization_id = v_wlji_org_id(v_idx)
10189: and wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
10190: and wdj.organization_id = v_wlji_org_id(v_idx);
11300: end if;
11301:
11302: --Added for Fixing bug 5242298
11303: l_stmt_num := 950.5;
11304: update wip_discrete_jobs wdj
11305: set status_type = 7
11306: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx);
11307: if lbji_debug = 'Y' then
11308: fnd_file.put_line(fnd_file.log,
11335: l_error_count := l_error_count + 1;
11336: GOTO abort_this_job;
11337: end if;
11338:
11339: update wip_discrete_jobs
11340: set kanban_card_id = null
11341: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11342:
11343: end if;
11356: )
11357: then
11358: select net_quantity
11359: into l_net_qty_old
11360: from WIP_DISCRETE_JOBS
11361: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11362:
11363: if v_wlji_net_quantity(v_idx) < l_net_qty_old then --net qty has become lesser.So reduce rsvtn
11364:
11382: end if;
11383:
11384: END;
11385: --AH Add:SO LBJ changes--
11386: UPDATE WIP_DISCRETE_JOBS WDJ
11387: set last_updated_by = v_wlji_last_updt_by(v_idx),
11388: last_update_login = v_wlji_last_updt_login(v_idx),
11389: request_id = v_wlji_request_id(v_idx),
11390: program_application_id = v_wlji_program_appl_id(v_idx),
11958: handle_error(l_error_code, l_error_msg, l_stmt_num);
11959: l_error_count := l_error_count + 1;
11960: end if;
11961:
11962: update wip_discrete_jobs
11963: set kanban_card_id = null
11964: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11965:
11966: end if;
15373: quantity_scrapped
15374: into l_job_status,
15375: l_job_start_qty,
15376: l_job_qty_scrapped
15377: from wip_discrete_jobs
15378: where wip_entity_id = p_wip_entity_id;
15379:
15380: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then
15381: l_cur_job_op_seq_num := g_op_seq_incr;
15690: select scheduled_start_date,
15691: scheduled_completion_date
15692: into l_job_start_date,
15693: l_job_compl_date
15694: from wip_discrete_jobs
15695: where wip_entity_id = p_wip_entity_id;
15696: end if;
15697:
15698: -----------------------------------------------------
20900: l_stmt_num number;
20901:
20902: cursor check_discrete_charges is
20903: select distinct 'x'
20904: from wip_discrete_jobs wdj,
20905: wip_period_balances wpb
20906: where wdj.wip_entity_id = wpb.wip_entity_id
20907: and wdj.organization_id = wpb.organization_id
20908: and wdj.wip_entity_id = p_wip_entity_id
20995: --check for only shop floor transactions
20996:
20997: cursor check_discrete_charges_1 is
20998: select distinct 'x'
20999: from wip_discrete_jobs wdj,
21000: wip_period_balances wpb
21001: where wdj.wip_entity_id = wpb.wip_entity_id
21002: and wdj.organization_id = wpb.organization_id
21003: and wdj.wip_entity_id = p_wip_entity_id
21705:
21706: l_stmt_num := 130;
21707: -- insert into WDJ
21708: -- Modified for Bug 13073424.
21709: insert into wip_discrete_jobs (
21710: wip_entity_id,
21711: organization_id,
21712: last_update_date,
21713: last_updated_by,