[Home] [Help]
1144:
1145: --fix for bug5990761 allow update of job name for unreleased jobs
1146: select decode(wdj.status_type, WIP_CONSTANTS.UNRELEASED,NVL(p_job_name,we.wip_entity_name),we.wip_entity_name),we.wip_entity_name
1147: into p_job_name,l_old_job_name
1148: from wip_discrete_jobs wdj,
1149: wip_entities we
1150: where wdj.wip_entity_id = p_wip_entity_id
1151: and wdj.status_type in (
1152: WIP_CONSTANTS.UNRELEASED,
2335: select scheduled_start_date,
2336: scheduled_completion_date
2337: into l_job_start_date,
2338: l_job_compl_date
2339: from wip_discrete_jobs
2340: where wip_entity_id = p_wip_entity_id
2341: and organization_id = p_org_id;
2342:
2343: if(v_wljdi_op_start_date(l_d) IS NOT NULL and v_wljdi_op_completion_date(l_d) IS NOT NULL) then
5802: select 1
5803: into l_comp_exist
5804: from dual
5805: where exists ( select 1
5806: from wip_discrete_jobs
5807: where wip_entity_id = p_wip_entity_id
5808: and organization_id = p_org_id
5809: and job_type = WIP_CONSTANTS.STANDARD
5810: and primary_item_id = l_item_id );
7589: l_stmt_num := 140.2;
7590: -- For unreleased jobs allow job name update if wip_entity_id is not null - fix for bug5990761
7591: select decode(wdj.status_type, WIP_CONSTANTS.UNRELEASED, NVL(v_wlji_job_name(v_idx),we.wip_entity_name), we.wip_entity_name)
7592: into v_wlji_job_name(v_idx)
7593: from wip_discrete_jobs wdj,
7594: wip_entities we
7595: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
7596: and wdj.status_type in (
7597: WIP_CONSTANTS.UNRELEASED,
7762: l_cur_date_released,
7763: l_cur_schedule_group_id,
7764: l_cur_build_sequence,
7765: l_cur_line_id
7766: from wip_discrete_jobs
7767: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
7768: and organization_id = v_wlji_org_id(v_idx);
7769:
7770: -- BA: bug 3423195
10054: least(wdj.net_quantity,
10055: nvl(v_wlji_start_quantity(v_idx),
10056: wdj.net_quantity))))
10057: into v_wlji_net_quantity(v_idx)
10058: from wip_discrete_jobs wdj
10059: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
10060: and wdj.organization_id = v_wlji_org_id(v_idx);
10061: exception
10062: when others then
10084:
10085: BEGIN
10086: select msi.serial_number_control_code
10087: into l_serial_ctrl_code
10088: from mtl_system_items_kfv msi,wip_discrete_jobs wdj
10089: where msi.inventory_item_id = wdj.primary_item_id
10090: and msi.organization_id = v_wlji_org_id(v_idx)
10091: and wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
10092: and wdj.organization_id = v_wlji_org_id(v_idx);
11198: end if;
11199:
11200: --Added for Fixing bug 5242298
11201: l_stmt_num := 950.5;
11202: update wip_discrete_jobs wdj
11203: set status_type = 7
11204: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx);
11205: if lbji_debug = 'Y' then
11206: fnd_file.put_line(fnd_file.log,
11233: l_error_count := l_error_count + 1;
11234: GOTO abort_this_job;
11235: end if;
11236:
11237: update wip_discrete_jobs
11238: set kanban_card_id = null
11239: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11240:
11241: end if;
11254: )
11255: then
11256: select net_quantity
11257: into l_net_qty_old
11258: from WIP_DISCRETE_JOBS
11259: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11260:
11261: if v_wlji_net_quantity(v_idx) < l_net_qty_old then --net qty has become lesser.So reduce rsvtn
11262:
11280: end if;
11281:
11282: END;
11283: --AH Add:SO LBJ changes--
11284: UPDATE WIP_DISCRETE_JOBS WDJ
11285: set last_updated_by = v_wlji_last_updt_by(v_idx),
11286: last_update_login = v_wlji_last_updt_login(v_idx),
11287: request_id = v_wlji_request_id(v_idx),
11288: program_application_id = v_wlji_program_appl_id(v_idx),
11854: handle_error(l_error_code, l_error_msg, l_stmt_num);
11855: l_error_count := l_error_count + 1;
11856: end if;
11857:
11858: update wip_discrete_jobs
11859: set kanban_card_id = null
11860: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11861:
11862: end if;
15251: quantity_scrapped
15252: into l_job_status,
15253: l_job_start_qty,
15254: l_job_qty_scrapped
15255: from wip_discrete_jobs
15256: where wip_entity_id = p_wip_entity_id;
15257:
15258: if(l_job_status = WIP_CONSTANTS.UNRELEASED) then
15259: l_cur_job_op_seq_num := g_op_seq_incr;
15314: select scheduled_start_date,
15315: scheduled_completion_date
15316: into l_job_start_date,
15317: l_job_compl_date
15318: from wip_discrete_jobs
15319: where wip_entity_id = p_wip_entity_id;
15320: end if;
15321:
15322: -----------------------------------------------------
20244: l_stmt_num number;
20245:
20246: cursor check_discrete_charges is
20247: select distinct 'x'
20248: from wip_discrete_jobs wdj,
20249: wip_period_balances wpb
20250: where wdj.wip_entity_id = wpb.wip_entity_id
20251: and wdj.organization_id = wpb.organization_id
20252: and wdj.wip_entity_id = p_wip_entity_id
20330: --check for only shop floor transactions
20331:
20332: cursor check_discrete_charges_1 is
20333: select distinct 'x'
20334: from wip_discrete_jobs wdj,
20335: wip_period_balances wpb
20336: where wdj.wip_entity_id = wpb.wip_entity_id
20337: and wdj.organization_id = wpb.organization_id
20338: and wdj.wip_entity_id = p_wip_entity_id
21039:
21040:
21041: l_stmt_num := 130;
21042: -- insert into WDJ
21043: insert into wip_discrete_jobs (
21044: wip_entity_id,
21045: organization_id,
21046: last_update_date,
21047: last_updated_by,