[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
2175: --check for only shop floor transactions
2176:
2177: cursor check_discrete_charges_1 is
2178: SELECT DISTINCT 'X'
2179: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
2180: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
2181: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
2182: AND DJ.WIP_ENTITY_ID = p_wip_entity_id
2183: AND DJ.ORGANIZATION_ID = p_organization_id
4459:
4460: /* commented out by BBK as per Hari to remove dual usage.
4461: select 1 into l_dummy from dual where exists (
4462: select 1
4463: from wip_discrete_jobs
4464: where
4465: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4466: organization_id = v_wlji_org(v_index) and
4467: status_type in (
4472: );
4473: */
4474: -- added by BBK.
4475: select 1 into l_dummy
4476: from wip_discrete_jobs
4477: where
4478: wip_entity_id = v_wlji_wip_entity_id(v_index) and
4479: status_type in (
4480: WIP_CONSTANTS.UNRELEASED,
5297: -- *** validate schedule_group_id begin ***
5298: if (v_wlji_load_type(v_index) = 6 and v_wlji_schedule_group_id(v_index) is NULL) then
5299: select schedule_group_id
5300: into v_wlji_schedule_group_id(v_index)
5301: from wip_discrete_jobs
5302: where wip_entity_id = v_wlji_wip_entity_id(v_index)
5303: and organization_id = v_wlji_org(v_index);
5304: end if;
5305:
5382: l_build_sequence,
5383: l_line_id,
5384: l_schedule_group_id
5385: from
5386: wip_discrete_jobs WDJ
5387: where
5388: WDJ.wip_entity_id = v_wlji_wip_entity_id(v_index);
5389: exception
5390: when no_data_found then null;
5482: v_wlji_kanban_card_id(v_index),
5483: p_old_completion_subinv,
5484: p_old_completion_locator,
5485: p_old_date_released
5486: from wip_discrete_jobs
5487: where wip_entity_id = v_wlji_wip_entity_id(v_index)
5488: and organization_id = v_wlji_org(v_index);
5489:
5490: /* *** Bug 2762029 commenting begins
6557: wdj.start_quantity, v_wlji_start_quantity(v_index),
6558: least(wdj.net_quantity,
6559: nvl(v_wlji_start_quantity(v_index), wdj.net_quantity))))
6560: into v_wlji_net_quantity(v_index)
6561: from wip_discrete_jobs wdj
6562: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_index)
6563: and wdj.organization_id = v_wlji_org(v_index);
6564: exception
6565: when others then
7077: handle_error(x_return_status, x_msg_data, l_stmt_num);
7078: l_error_count := l_error_count + 1;
7079: GOTO skip_other_steps;
7080: else
7081: update wip_discrete_jobs wdj
7082: set status_type = 7
7083: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_index);
7084: if lbji_debug = 'Y' then
7085: fnd_file.put_line(fnd_file.log, 'Updated status type to 7 in wdj');
7134: l_error_count := l_error_count + 1;
7135: GOTO skip_other_steps;
7136: end if;
7137:
7138: update wip_discrete_jobs
7139: set kanban_card_id = null
7140: where wip_entity_id = v_wlji_wip_entity_id(v_index);
7141:
7142: end if;
7145:
7146: else
7147: l_stmt_num := 1073;
7148: -- bug 2762029 modification begin
7149: UPDATE WIP_DISCRETE_JOBS WDJ
7150: set last_updated_by = v_wlji_last_updt_by(v_index),
7151: last_update_login = v_wlji_last_updt_login(v_index),
7152: request_id = v_wlji_request_id(v_index),
7153: program_application_id = v_wlji_program_application_id(v_index),
7560: handle_error(l_error_code, l_error_msg, l_stmt_num);
7561: l_error_count := l_error_count + 1;
7562: end if;
7563:
7564: update wip_discrete_jobs
7565: set kanban_card_id = null
7566: where wip_entity_id = v_wlji_wip_entity_id(v_index);
7567:
7568: end if;