[Home] [Help]
975: l_stmt_num := 120;
976:
977: Begin
978:
979: INSERT INTO WIP_DISCRETE_JOBS (
980: wip_entity_id,
981: organization_id,
982: last_update_date,
983: last_updated_by,
2110: l_stmt_num NUMBER;
2111:
2112: cursor check_discrete_charges is
2113: SELECT DISTINCT 'X'
2114: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
2115: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
2116: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
2117: AND DJ.WIP_ENTITY_ID = p_wip_entity_id
2118: AND DJ.ORGANIZATION_ID = p_organization_id
2181: --check for only shop floor transactions
2182:
2183: cursor check_discrete_charges_1 is
2184: SELECT DISTINCT 'X'
2185: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
2186: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
2187: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
2188: AND DJ.WIP_ENTITY_ID = p_wip_entity_id
2189: AND DJ.ORGANIZATION_ID = p_organization_id
4465:
4466: /* commented out by BBK as per Hari to remove dual usage.
4467: select 1 into l_dummy from dual where exists (
4468: select 1
4469: from wip_discrete_jobs
4470: where
4471: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4472: organization_id = v_wlji_org(v_index) and
4473: status_type in (
4478: );
4479: */
4480: -- added by BBK.
4481: select 1 into l_dummy
4482: from wip_discrete_jobs
4483: where
4484: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4485: status_type in (
4486: WIP_CONSTANTS.UNRELEASED,
5303: -- *** validate schedule_group_id begin ***
5304: if (v_wlji_load_type(v_index) = 6 and v_wlji_schedule_group_id(v_index) is NULL) then
5305: select schedule_group_id
5306: into v_wlji_schedule_group_id(v_index)
5307: from wip_discrete_jobs
5308: where wip_entity_id = v_wlji_wip_entity_id(v_index)
5309: and organization_id = v_wlji_org(v_index);
5310: end if;
5311:
5388: l_build_sequence,
5389: l_line_id,
5390: l_schedule_group_id
5391: from
5392: wip_discrete_jobs WDJ
5393: where
5394: WDJ.wip_entity_id = v_wlji_wip_entity_id(v_index);
5395: exception
5396: when no_data_found then null;
5488: v_wlji_kanban_card_id(v_index),
5489: p_old_completion_subinv,
5490: p_old_completion_locator,
5491: p_old_date_released
5492: from wip_discrete_jobs
5493: where wip_entity_id = v_wlji_wip_entity_id(v_index)
5494: and organization_id = v_wlji_org(v_index);
5495:
5496: /* *** Bug 2762029 commenting begins
6563: wdj.start_quantity, v_wlji_start_quantity(v_index),
6564: least(wdj.net_quantity,
6565: nvl(v_wlji_start_quantity(v_index), wdj.net_quantity))))
6566: into v_wlji_net_quantity(v_index)
6567: from wip_discrete_jobs wdj
6568: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_index)
6569: and wdj.organization_id = v_wlji_org(v_index);
6570: exception
6571: when others then
7083: handle_error(x_return_status, x_msg_data, l_stmt_num);
7084: l_error_count := l_error_count + 1;
7085: GOTO skip_other_steps;
7086: else
7087: update wip_discrete_jobs wdj
7088: set status_type = 7
7089: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_index);
7090: if lbji_debug = 'Y' then
7091: fnd_file.put_line(fnd_file.log, 'Updated status type to 7 in wdj');
7140: l_error_count := l_error_count + 1;
7141: GOTO skip_other_steps;
7142: end if;
7143:
7144: update wip_discrete_jobs
7145: set kanban_card_id = null
7146: where wip_entity_id = v_wlji_wip_entity_id(v_index);
7147:
7148: end if;
7151:
7152: else
7153: l_stmt_num := 1073;
7154: -- bug 2762029 modification begin
7155: UPDATE WIP_DISCRETE_JOBS WDJ
7156: set last_updated_by = v_wlji_last_updt_by(v_index),
7157: last_update_login = v_wlji_last_updt_login(v_index),
7158: request_id = v_wlji_request_id(v_index),
7159: program_application_id = v_wlji_program_application_id(v_index),
7566: handle_error(l_error_code, l_error_msg, l_stmt_num);
7567: l_error_count := l_error_count + 1;
7568: end if;
7569:
7570: update wip_discrete_jobs
7571: set kanban_card_id = null
7572: where wip_entity_id = v_wlji_wip_entity_id(v_index);
7573:
7574: end if;