[Home] [Help]
59: p_resource_seq_num => cur_row.resource_seq_num,
60: p_organization_id => p_organization_id
61: );
62:
63: DELETE FROM WIP_OPERATION_RESOURCES
64: WHERE wip_entity_id = p_wip_entity_id
65: AND organization_id = p_organization_id
66: AND operation_seq_num = cur_row.operation_seq_num
67: AND resource_seq_num = cur_row.resource_seq_num
130: p_wip_entity_id,
131: p_organization_id) LOOP
132: -- if adding setup resource, delete all existing setup resources
133: if (cur_row.parent_seq_num is not null) then
134: DELETE FROM WIP_OPERATION_RESOURCES
135: WHERE wip_entity_id = p_wip_entity_id
136: AND organization_id = p_organization_id
137: AND operation_seq_num = cur_row.operation_seq_num
138: AND parent_resource_seq = cur_row.parent_seq_num;
144: p_organization_id) LOOP
145:
146:
147: /* insert into table */
148: INSERT INTO WIP_OPERATION_RESOURCES(
149: wip_entity_id,
150: organization_id,
151: operation_seq_num,
152: resource_seq_num,
385: cursor missing_res_csr
386: is
387: select wo.first_unit_start_date,
388: rowidtochar(wor.rowid)
389: from wip_operation_resources wor,
390: wip_operations wo
391: where wo.wip_entity_id = wor.wip_entity_id
392: and wo.organization_id = wor.organization_id
393: and wo.operation_seq_num = wor.operation_seq_num
436: l_replace_res := 0;
437: /*
438: select substitute_group_num
439: into l_current_sub
440: from wip_operation_resources
441: where wip_entity_id = p_wip_entity_id
442: and operation_seq_num = cur_row.operation_seq_num
443: and resource_seq_num = cur_row.resource_seq_num; Changed for FP of bug#11679430 - 11844798
444: */
472: nvl(cur_row.replacement_group_num,0),
473: x_status,
474: x_msg_count,
475: x_msg_data);
476: UPDATE WIP_OPERATION_RESOURCES
477: SET start_date = NVL(cur_row.start_date,start_date),
478: completion_date = NVL(cur_row.completion_date,completion_date),
479: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
480: WHERE wip_entity_id = p_wip_entity_id
495: P_ORGANIZATION_ID => P_ORGANIZATION_ID
496: );
497: END IF;
498:
499: UPDATE WIP_OPERATION_RESOURCES
500: SET resource_id = cur_row.resource_id_new,
501: usage_rate_or_amount = nvl(cur_row.usage_rate_or_amount,
502: usage_rate_or_amount),
503: last_update_date = sysdate,/*BUG 6721823*/
669: bulk collect into l_fusdTbl, l_rowidTbl ;
670: close missing_res_csr ;
671:
672: forall i in 1..l_fusdTbl.count
673: update wip_operation_resources
674: set start_date = l_fusdTbl(i),
675: completion_date = l_fusdTbl(i),
676: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
677: where rowid = chartorowid(l_rowidTbl(i)) ;
1988: So compare the WOR dates with the WO dates and update the WOR dates so that the validation does not fail */
1989: DECLARE
1990: CURSOR C_WOR IS
1991: select start_date, completion_date, rowid
1992: from wip_operation_resources wor
1993: where wor.wip_entity_id = p_wip_entity_id
1994: and wor.organization_id = p_organization_id
1995: and wor.operation_seq_num = cur_oper.operation_seq_num;
1996:
2009: l_wor_completion_date := l_last_unit_completion_date;
2010: END IF;
2011:
2012: IF ((l_wor_start_date IS NOT NULL) OR (l_wor_completion_date IS NOT NULL)) THEN
2013: UPDATE WIP_OPERATION_RESOURCES
2014: SET start_date = nvl(l_wor_start_date, start_date),
2015: completion_date = nvl(l_wor_completion_date, completion_date),
2016: LAST_UPDATE_DATE=sysdate/*BUG 6721823*/
2017: WHERE rowid = rec.rowid;
2442: and wo.organization_id = p_organization_id
2443: and wo.operation_seq_num = wjdi.operation_seq_num
2444: and (wo.first_unit_start_date >
2445: (select min(start_date)
2446: from wip_operation_resources wor
2447: where wor.wip_entity_id = p_wip_entity_id
2448: and wor.organization_id = p_organization_id
2449: and wor.operation_seq_num = wo.operation_seq_num)
2450: or
2449: and wor.operation_seq_num = wo.operation_seq_num)
2450: or
2451: wo.last_unit_completion_date <
2452: (select max(completion_date)
2453: from wip_operation_resources wor
2454: where wor.wip_entity_id = p_wip_entity_id
2455: and wor.organization_id = p_organization_id
2456: and wor.operation_seq_num = wo.operation_seq_num)));
2457:
2494: and wo.organization_id = p_organization_id
2495: and wo.operation_seq_num = wjdi.operation_seq_num
2496: and (wo.first_unit_start_date >
2497: (select min(start_date)
2498: from wip_operation_resources wor
2499: where wor.wip_entity_id = p_wip_entity_id
2500: and wor.organization_id = p_organization_id
2501: and wor.operation_seq_num = wo.operation_seq_num)
2502: or
2501: and wor.operation_seq_num = wo.operation_seq_num)
2502: or
2503: wo.last_unit_completion_date <
2504: (select max(completion_date)
2505: from wip_operation_resources wor
2506: where wor.wip_entity_id = p_wip_entity_id
2507: and wor.organization_id = p_organization_id
2508: and wor.operation_seq_num = wo.operation_seq_num)));
2509:
2768: PROGRAM_UPDATE_DATE,
2769: START_DATE,
2770: COMPLETION_DATE,
2771: ASSIGNED_UNITS
2772: FROM WIP_OPERATION_RESOURCES
2773: WHERE wip_entity_id = p_wip_entity_id
2774: AND organization_id = p_organization_id
2775: AND operation_seq_num = p_operation_seq_num
2776: AND resource_seq_num = p_resource_seq_num;