[Home] [Help]
726: if(x_return_status <> fnd_api.g_ret_sts_success) then
727: raise fnd_api.g_exc_unexpected_error;
728: end if;
729: end if;
730: update wip_operations
731: set employee_id = null
732: where wip_entity_id = p_wip_entity_id
733: and operation_seq_num = p_operation_seq_num
734: and employee_id is not null;
1060: and wrat.start_date is not null
1061: and wrat.end_date is null
1062: and wrat.process_status <> 4);
1063:
1064: update wip_operations wo
1065: set
1066: wo.actual_completion_date =
1067: nvl(greatest( ( select max(wor.actual_completion_date)
1068: from wip_operation_resources wor
1187: l_curr_op number;
1188:
1189: cursor op_seq_num_cursor is
1190: select operation_seq_num
1191: from wip_operations
1192: where wip_entity_id = p_wip_entity_id
1193: and operation_seq_num >= p_from_op
1194: and operation_seq_num <= p_to_op;
1195: BEGIN
1758: l_organization_id number;
1759: l_department_id number;
1760:
1761: cursor org_dept_cursor is select wo.organization_id, wo.department_id
1762: from wip_operations wo
1763: where wo.wip_entity_id = p_wip_entity_id
1764: and wo.operation_seq_num = p_operation_seq_num;
1765: BEGIN
1766: open org_dept_cursor;
1800: and wor.operation_seq_num = p_operation_seq_num
1801: and wor.actual_start_date is not null;
1802:
1803: cursor min_start_date_wo_cursor is select min(wo.actual_start_date)
1804: from wip_operations wo
1805: where wo.wip_entity_id = p_wip_entity_id
1806: and wo.actual_start_date is not null;
1807: BEGIN
1808:
1848: from dual;
1849: end if;
1850:
1851: if l_min_start_date is not null then
1852: update wip_operations set
1853: actual_start_date = l_min_start_date
1854: where wip_entity_id = p_wip_entity_id
1855: and operation_seq_num = p_operation_seq_num;
1856: end if;
1957: open max_end_date_wor_cursor;
1958: fetch max_end_date_wor_cursor into l_max_end_date;
1959: if max_end_date_wor_cursor%FOUND then
1960: if l_max_end_date is not null then
1961: update wip_operations set
1962: actual_completion_date = l_max_end_date
1963: where wip_entity_id = p_wip_entity_id
1964: and operation_seq_num = p_operation_seq_num;
1965: end if;
2028: p_resource_seq_num => null,
2029: p_resource_id => null,
2030: p_instance_id => null,
2031: p_start_date => p_start_date);
2032: update wip_operations set
2033: projected_completion_date = l_projected_completion_date
2034: where wip_entity_id = p_wip_entity_id
2035: and operation_seq_num = p_operation_seq_num;
2036: if (l_logLevel <= wip_constants.trace_logging) then
2046: IS
2047: l_job_status varchar2(1);
2048: l_employee_id number;
2049: cursor job_on_off_status_cursor is select employee_id
2050: from wip_operations wo
2051: where wo.wip_entity_id = p_wip_entity_id;
2052: BEGIN
2053: l_job_status := 'N';
2054: open job_on_off_status_cursor;
2073: l_job_status varchar2(1);
2074: l_employee_id number;
2075:
2076: cursor job_status_cursor is select employee_id
2077: from wip_operations wo
2078: where wo.wip_entity_id = p_wip_entity_id
2079: and wo.operation_seq_num = p_operation_seq_num;
2080:
2081: BEGIN
2131:
2132: if (l_job_status = 'Y') then
2133: l_status := 'O';
2134: elsif (l_job_status = 'N') then
2135: update wip_operations set
2136: employee_id = p_employee_id
2137: where wip_entity_id = p_wip_entity_id
2138: and operation_seq_num = p_operation_seq_num;
2139: l_status := 'S';
3234: l_last_op_qty number;
3235:
3236: cursor last_op_qty_cursor is
3237: select (wo.quantity_in_queue + wo.quantity_running)
3238: from wip_operations wo
3239: where wo.wip_entity_id = p_wip_entity_id
3240: and wo.operation_seq_num = p_operation_seq_num;
3241: BEGIN
3242: open last_op_qty_cursor;
3252: l_last_job_qty number;
3253:
3254: cursor last_job_qty_cursor is
3255: select (wo.scheduled_quantity - wo.quantity_completed - nvl(wo.cumulative_scrap_quantity, 0))
3256: from wip_operations wo
3257: where wo.wip_entity_id = p_wip_entity_id
3258: and wo.operation_seq_num = p_operation_seq_num;
3259: BEGIN
3260: open last_job_qty_cursor;
3595: -- Bug 13481688 @End
3596: --Bug 10097774 get department_id and department_code
3597: select wo.department_id, bd.department_code
3598: into l_department_id, l_department_code
3599: from wip_operations wo, bom_departments bd
3600: where wo.wip_entity_id = p_wip_entity_id
3601: and wo.operation_seq_num = p_operation_seq_num
3602: and wo.department_id = bd.department_id;
3603:
3859: wti.created_by,
3860: wti.last_update_login,
3861: wo.first_unit_start_date,
3862: wo.last_unit_completion_date
3863: from wip_operations wo,
3864: wip_cost_txn_interface wti,
3865: bom_resources br
3866: where wti.group_id = x_group_id
3867: and wti.process_phase = 2