eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_RESOURCE_VALIDATIONS dependencies on WIP_JOB_DTLS_INTERFACE

Line 34: from wip_job_dtls_interface wjdi

30: p_operation_seq_num in number) IS
31:
32: cursor c_invalid_rows is
33: select interface_id
34: from wip_job_dtls_interface wjdi
35: where wjdi.group_id = p_group_id
36: and wjdi.process_phase = wip_constants.ml_validation
37: and wjdi.process_status in (wip_constants.running,
38: wip_constants.warning)

Line 66: update wip_job_dtls_interface wjdi

62: end if;
63: end loop;
64:
65: if(l_error_exists) then
66: update wip_job_dtls_interface wjdi
67: set process_status = wip_constants.error
68: where group_id = p_group_id
69: and process_phase = wip_constants.ml_validation
70: and process_status in (wip_constants.running,

Line 96: from wip_job_dtls_interface wjdi

92: -- Job/op_seq_num/resource_seq_num/resource_id_old all match
93: -- Validate only when delete/change resources
94: cursor c_invalid_rows is
95: select interface_id
96: from wip_job_dtls_interface wjdi
97: where wjdi.group_id = p_group_id
98: and wjdi.process_phase = wip_constants.ml_validation
99: and wjdi.process_status in (wip_constants.running,
100: wip_constants.warning)

Line 144: update wip_job_dtls_interface wjdi

140: end if;
141: end loop;
142:
143: if(l_error_exists) then
144: update wip_job_dtls_interface wjdi
145: set process_status = wip_constants.error
146: where group_id = p_group_id
147: and process_phase = wip_constants.ml_validation
148: and process_status in (wip_constants.running,

Line 187: from wip_job_dtls_interface wjdi, wip_operation_resources wor

183: p_resource_id_old number) IS
184:
185: cursor c_invalid_wor_rows is
186: select interface_id
187: from wip_job_dtls_interface wjdi, wip_operation_resources wor
188: where wjdi.group_id = p_group_id
189: and wjdi.process_phase = wip_constants.ml_validation
190: and wjdi.process_status in (wip_constants.running,
191: wip_constants.warning)

Line 206: from wip_job_dtls_interface wjdi

202: and wor.applied_resource_units <> 0;
203:
204: cursor c_invalid_txn_rows is
205: select interface_id
206: from wip_job_dtls_interface wjdi
207: where wjdi.group_id = p_group_id
208: and wjdi.process_phase = wip_constants.ml_validation
209: and wjdi.process_status in (wip_constants.running,
210: wip_constants.warning)

Line 254: update wip_job_dtls_interface wjdi

250: end if;
251: end loop;
252:
253: if(l_error_exists) then
254: update wip_job_dtls_interface wjdi
255: set wjdi.process_status = wip_constants.error
256: where wjdi.group_id = p_group_id
257: and wjdi.process_phase = wip_constants.ml_validation
258: and wjdi.process_status in (wip_constants.running,

Line 293: update wip_job_dtls_interface wjdi

289: end if;
290: end loop;
291:
292: if(l_error_exists) then
293: update wip_job_dtls_interface wjdi
294: set process_status = wip_constants.error
295: where wjdi.group_id = p_group_id
296: and wjdi.process_phase = wip_constants.ml_validation
297: and wjdi.process_status in (wip_constants.running,

Line 339: from wip_job_dtls_interface wjdi

335: /* Bug 5004087 (FP of 4747215): Added WIP_RESOURCE_SEQ_NUM condition when checking
336: for existing PO/REQ. */
337: cursor c_invalid_rows is
338: select interface_id
339: from wip_job_dtls_interface wjdi
340: where wjdi.group_id = p_group_id
341: and wjdi.process_phase = wip_constants.ml_validation
342: and wjdi.process_status in (wip_constants.running,
343: wip_constants.warning)

Line 454: update wip_job_dtls_interface wjdi

450: END IF; -- propagate_job_change_to_po check
451: end loop;
452:
453: if(l_warning_exists) then
454: update wip_job_dtls_interface wjdi
455: set process_status = wip_constants.warning
456: where wjdi.group_id = p_group_id
457: and wjdi.process_phase = wip_constants.ml_validation
458: and wjdi.process_status in (wip_constants.running,

Line 537: FROM WIP_JOB_DTLS_INTERFACE

533: start_date, completion_date,attribute_category, attribute1,
534: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
535: attribute8,attribute9,attribute10,attribute11,attribute12,
536: attribute13,attribute14,attribute15
537: FROM WIP_JOB_DTLS_INTERFACE
538: WHERE group_id = p_group_id
539: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
540: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
541: AND wip_entity_id = p_wip_entity_id

Line 618: from wip_job_dtls_interface wjdi

614: p_operation_seq_num number) IS
615:
616: cursor c_invalid_rows is
617: select interface_id
618: from wip_job_dtls_interface wjdi
619: where wjdi.group_id = p_group_id
620: and wjdi.process_phase = wip_constants.ml_validation
621: and wjdi.process_status in (wip_constants.running,
622: wip_constants.warning)

Line 650: update wip_job_dtls_interface wjdi

646: end if;
647: end loop;
648:
649: if(l_error_exists) then
650: update wip_job_dtls_interface wjdi
651: set process_status = wip_constants.error
652: where wjdi.group_id = p_group_id
653: and wjdi.process_phase = wip_constants.ml_validation
654: and wjdi.process_status in (wip_constants.running,

Line 677: from wip_job_dtls_interface wjdi

673:
674:
675: cursor c_invalid_rows is
676: select interface_id
677: from wip_job_dtls_interface wjdi
678: where wjdi.group_id = p_group_id
679: and wjdi.process_phase = wip_constants.ml_validation
680: and wjdi.process_status in (wip_constants.running,
681: wip_constants.warning)

Line 712: update wip_job_dtls_interface wjdi

708: end if;
709: end loop;
710:
711: if(l_error_exists) then
712: update wip_job_dtls_interface wjdi
713: set process_status = wip_constants.error
714: where wjdi.group_id = p_group_id
715: and wjdi.process_phase = wip_constants.ml_validation
716: and wjdi.process_status in (wip_constants.running,

Line 741: from wip_job_dtls_interface wjdi

737:
738:
739: cursor c_invalid_rows is
740: select interface_id
741: from wip_job_dtls_interface wjdi
742: where wjdi.group_id = p_group_id
743: and wjdi.process_phase = wip_constants.ml_validation
744: and wjdi.process_status in (wip_constants.running,
745: wip_constants.warning)

Line 786: update wip_job_dtls_interface wjdi

782: end if;
783: end loop;
784:
785: if(l_error_exists) then
786: update wip_job_dtls_interface wjdi
787: set process_status = wip_constants.error
788: where wjdi.group_id = p_group_id
789: and wjdi.process_phase = wip_constants.ml_validation
790: and wjdi.process_status in (wip_constants.running,

Line 826: from wip_job_dtls_interface wjdi, wip_operations wo

822:
823:
824: cursor c_invalid_rows is
825: select interface_id
826: from wip_job_dtls_interface wjdi, wip_operations wo
827: where wjdi.group_id = p_group_id
828: and wjdi.process_phase = wip_constants.ml_validation
829: and wjdi.process_status in (wip_constants.running,
830: wip_constants.warning)

Line 881: update wip_job_dtls_interface wjdi

877: end if;
878: end loop;
879:
880: if(l_error_exists) then
881: update wip_job_dtls_interface wjdi
882: set process_status = wip_constants.error
883: where wjdi.group_id = p_group_id
884: and wjdi.process_phase = wip_constants.ml_validation
885: and wjdi.process_status in (wip_constants.running,

Line 929: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

925: p_resource_seq_num number ) IS
926:
927: cursor c_invalid_rows is
928: select wjdi.interface_id
929: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi
930: where wjdi.group_id = p_group_id
931: and wjdi.process_phase = wip_constants.ml_validation
932: and wjdi.process_status in (wip_constants.running,
933: wip_constants.warning)

Line 983: update wip_job_dtls_interface wjdi

979: end if;
980: end loop;
981:
982: if(l_error_exists) then
983: update wip_job_dtls_interface wjdi
984: set process_status = wip_constants.error
985: where wjdi.group_id = p_group_id
986: and wjdi.process_phase = wip_constants.ml_validation
987: and wjdi.process_status in (wip_constants.running,

Line 1021: from wip_job_dtls_interface wjdi

1017: --the logic for invalid rows is actually in pl/sql for this procedure. This cursor
1018: --just selects all the rows that meet the parameter criteria.
1019: cursor c_invalid_rows is
1020: select interface_id, wjdi.usage_rate_or_amount
1021: from wip_job_dtls_interface wjdi
1022: where wjdi.group_id = p_group_id
1023: and wjdi.process_phase = wip_constants.ml_validation
1024: and wjdi.process_status in (wip_constants.running,
1025: wip_constants.warning)

Line 1086: update wip_job_dtls_interface wjdi

1082: end if;
1083: end loop;
1084:
1085: if(l_error_exists) then
1086: update wip_job_dtls_interface wjdi
1087: set process_status = wip_constants.error
1088: where wjdi.group_id = p_group_id
1089: and wjdi.process_phase = wip_constants.ml_validation
1090: and wjdi.process_status in (wip_constants.running,

Line 1128: update wip_job_dtls_interface wjdi

1124: end if;
1125: end loop;
1126:
1127: if(l_error_exists) then
1128: update wip_job_dtls_interface wjdi
1129: set process_status = wip_constants.error
1130: where wjdi.group_id = p_group_id
1131: and wjdi.process_phase = wip_constants.ml_validation
1132: and wjdi.process_status in (wip_constants.running,

Line 1168: from wip_job_dtls_interface wjdi

1164: l_check NUMBER:=0;
1165:
1166: cursor c_invalid_rows is
1167: select interface_id
1168: from wip_job_dtls_interface wjdi
1169: where wjdi.group_id = p_group_id
1170: and wjdi.process_phase = wip_constants.ml_validation
1171: and wjdi.process_status in (
1172: wip_constants.running,

Line 1261: update wip_job_dtls_interface wjdi

1257: end if;
1258: end loop;
1259:
1260: if(l_error_exists) then
1261: update wip_job_dtls_interface wjdi
1262: set wjdi.process_status = wip_constants.error
1263: where wjdi.group_id = p_group_id
1264: and wjdi.process_phase = wip_constants.ml_validation
1265: and wjdi.process_status in (wip_constants.running,

Line 1328: from WIP_JOB_DTLS_INTERFACE

1324:
1325: begin
1326: select nvl(max(resource_seq_num), 0)
1327: into x_res_seq_num
1328: from WIP_JOB_DTLS_INTERFACE
1329: where group_id = p_group_id
1330: and wip_entity_id = p_wip_entity_id
1331: and organization_id = p_organization_id
1332: and operation_seq_num = p_operation_seq_num

Line 1345: UPDATE WIP_JOB_DTLS_INTERFACE

1341: end if;
1342:
1343: x_res_seq_num_max := x_res_seq_num_max + 10;
1344:
1345: UPDATE WIP_JOB_DTLS_INTERFACE
1346: SET resource_seq_num = x_res_seq_num_max
1347: WHERE rowid = p_rowid;
1348:
1349: p_resource_seq_num := x_res_seq_num_max;

Line 1360: from wip_job_dtls_interface

1356: begin
1357: begin
1358: select schedule_seq_num
1359: into x_schedule_seq_num
1360: from wip_job_dtls_interface
1361: where group_id = p_group_id
1362: and wip_entity_id = p_wip_entity_id
1363: and organization_id = p_organization_id
1364: and operation_seq_num = p_operation_seq_num

Line 1386: UPDATE WIP_JOB_DTLS_INTERFACE

1382: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1383: end;
1384: end if;
1385: end;
1386: UPDATE WIP_JOB_DTLS_INTERFACE
1387: SET schedule_seq_num = x_schedule_seq_num
1388: WHERE rowid = p_rowid;
1389:
1390: end if;

Line 1405: UPDATE WIP_JOB_DTLS_INTERFACE

1401: when no_data_found then
1402: return;
1403: end;
1404:
1405: UPDATE WIP_JOB_DTLS_INTERFACE
1406: SET setup_id = nvl(setup_id, x_setup_id)
1407: WHERE rowid = p_rowid;
1408:
1409: end if;

Line 1446: FROM WIP_JOB_DTLS_INTERFACE

1442: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1443: attribute8,attribute9,attribute10,attribute11,attribute12,
1444: attribute13,attribute14,attribute15, schedule_seq_num,
1445: substitute_group_num, replacement_group_num, parent_seq_num, rowid
1446: FROM WIP_JOB_DTLS_INTERFACE
1447: WHERE group_id = p_group_id
1448: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1449: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1450: AND wip_entity_id = p_wip_entity_id

Line 1612: from wip_job_dtls_interface wjdi

1608: l_count number;
1609:
1610: cursor c_invalid_rows is
1611: select interface_id
1612: from wip_job_dtls_interface wjdi
1613: where wjdi.group_id = p_group_id
1614: and wjdi.process_phase = wip_constants.ml_validation
1615: and wjdi.process_status in (wip_constants.running,
1616: wip_constants.warning)

Line 1655: update wip_job_dtls_interface wjdi

1651: p_error_type => wip_jdi_utils.msg_error);
1652: end if;
1653: end loop;
1654: if(l_error_exists) then
1655: update wip_job_dtls_interface wjdi
1656: set process_status = wip_constants.error
1657: where wjdi.group_id = p_group_id
1658: and wjdi.process_phase = wip_constants.ml_validation
1659: and wjdi.process_status in (wip_constants.running,

Line 1679: from wip_job_dtls_interface wjdi

1675: p_substitution_type number,
1676: p_operation_seq_num number) IS
1677: cursor c_invalid_rows is
1678: select interface_id
1679: from wip_job_dtls_interface wjdi
1680: where wjdi.group_id = p_group_id
1681: and wjdi.process_phase = wip_constants.ml_validation
1682: and wjdi.process_status in (wip_constants.running,
1683: wip_constants.warning)

Line 1717: update wip_job_dtls_interface wjdi

1713: end if;
1714: end loop;
1715:
1716: if(l_error_exists) then
1717: update wip_job_dtls_interface wjdi
1718: set process_status = wip_constants.error
1719: where wjdi.group_id = p_group_id
1720: and wjdi.process_phase = wip_constants.ml_validation
1721: and wjdi.process_status in (wip_constants.running,

Line 1785: FROM WIP_JOB_DTLS_INTERFACE

1781: attribute8,attribute9,attribute10,attribute11,attribute12,
1782: attribute13,attribute14,attribute15,
1783: schedule_seq_num, substitute_group_num,
1784: replacement_group_num, parent_seq_num, rowid
1785: FROM WIP_JOB_DTLS_INTERFACE
1786: WHERE group_id = p_group_id
1787: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1788: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1789: AND wip_entity_id = p_wip_entity_id

Line 2004: FROM WIP_JOB_DTLS_INTERFACE

2000: BEGIN
2001:
2002: SELECT count(*)
2003: INTO x_count
2004: FROM WIP_JOB_DTLS_INTERFACE
2005: WHERE group_id = p_group_id
2006: AND process_status = WIP_CONSTANTS.ERROR
2007: AND wip_entity_id = p_wip_entity_id
2008: AND organization_id = p_organization_id

Line 2036: FROM WIP_JOB_DTLS_INTERFACE

2032:
2033: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
2034: SELECT count(*)
2035: INTO x_count
2036: FROM WIP_JOB_DTLS_INTERFACE
2037: WHERE group_id = p_group_id
2038: AND process_status = WIP_CONSTANTS.ERROR
2039: AND wip_entity_id = p_wip_entity_id
2040: AND organization_id = p_organization_id

Line 2050: FROM WIP_JOB_DTLS_INTERFACE

2046:
2047: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
2048: SELECT count(*)
2049: INTO x_count
2050: FROM WIP_JOB_DTLS_INTERFACE
2051: WHERE group_id = p_group_id
2052: AND process_status = WIP_CONSTANTS.ERROR
2053: AND wip_entity_id = p_wip_entity_id
2054: AND organization_id = p_organization_id

Line 2064: FROM WIP_JOB_DTLS_INTERFACE

2060:
2061: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
2062: SELECT count(*)
2063: INTO x_count
2064: FROM WIP_JOB_DTLS_INTERFACE
2065: WHERE group_id = p_group_id
2066: AND process_status = WIP_CONSTANTS.ERROR
2067: AND wip_entity_id = p_wip_entity_id
2068: AND organization_id = p_organization_id

Line 2108: FROM WIP_JOB_DTLS_INTERFACE

2104: start_date, completion_date,attribute_category, attribute1,
2105: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2106: attribute8,attribute9,attribute10,attribute11,attribute12,
2107: attribute13,attribute14,attribute15
2108: FROM WIP_JOB_DTLS_INTERFACE
2109: WHERE group_id = p_group_id
2110: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2111: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2112: AND wip_entity_id = p_wip_entity_id

Line 2158: from wip_job_dtls_interface wjdi

2154: p_resource_id_old number) IS
2155:
2156: cursor c_invalid_rows is
2157: select interface_id
2158: from wip_job_dtls_interface wjdi
2159: where wjdi.group_id = p_group_id
2160: and wjdi.process_phase = wip_constants.ml_validation
2161: and wjdi.process_status in (wip_constants.running,
2162: wip_constants.warning)

Line 2217: from wip_job_dtls_interface wjdi

2213:
2214: cursor c_not_sub_rows is
2215: select wjdi.substitute_group_num,
2216: wjdi.replacement_group_num
2217: from wip_job_dtls_interface wjdi
2218: where wjdi.group_id = p_group_id
2219: and wjdi.process_phase = wip_constants.ml_validation
2220: and wjdi.process_status in (wip_constants.running,
2221: wip_constants.warning)

Line 2256: from wip_job_dtls_interface

2252: resource_id_old,
2253: operation_seq_num,
2254: resource_seq_num,
2255: substitute_group_num
2256: from wip_job_dtls_interface
2257: where group_id = p_group_id
2258: and process_phase = wip_constants.ml_validation
2259: and process_status in (wip_constants.running,
2260: wip_constants.warning)

Line 2293: update wip_job_dtls_interface wjdi

2289: end if;
2290: end loop;
2291:
2292: if(l_error_exists) then
2293: update wip_job_dtls_interface wjdi
2294: set process_status = wip_constants.error
2295: where wjdi.group_id = p_group_id
2296: and wjdi.process_phase = wip_constants.ml_validation
2297: and wjdi.process_status in (wip_constants.running,

Line 2339: update wip_job_dtls_interface wjdi

2335: RETURN;
2336: end if;
2337:
2338: for l_ns_row in c_not_sub_rows loop
2339: update wip_job_dtls_interface wjdi
2340: set substitute_group_num = null,
2341: replacement_group_num = null
2342: where current of c_not_sub_rows;
2343: end loop;

Line 2355: update wip_job_dtls_interface

2351: and wor.organization_id = l_sub_row.organization_id
2352: and wor.resource_id = l_sub_row.resource_id_old
2353: and wor.operation_seq_num = l_sub_row.operation_seq_num
2354: and wor.resource_seq_num = l_sub_row.resource_seq_num;
2355: update wip_job_dtls_interface
2356: set substitute_group_num = l_sub_group_temp
2357: where current of c_sub_rows;
2358: end if;
2359: end loop;

Line 2371: from wip_job_dtls_interface wjdi

2367: p_operation_seq_num number,
2368: p_resource_seq_num number) IS
2369: cursor c_invalid_rows is
2370: select interface_id
2371: from wip_job_dtls_interface wjdi
2372: where wjdi.group_id = p_group_id
2373: and wjdi.process_phase = wip_constants.ml_validation
2374: and wjdi.process_status in (wip_constants.running,
2375: wip_constants.warning)

Line 2422: update wip_job_dtls_interface wjdi

2418: end if;
2419: end loop;
2420:
2421: if(l_error_exists) then
2422: update wip_job_dtls_interface wjdi
2423: set process_status = wip_constants.error
2424: where wjdi.group_id = p_group_id
2425: and wjdi.process_phase = wip_constants.ml_validation
2426: and wjdi.process_status in (wip_constants.running,

Line 2486: FROM WIP_JOB_DTLS_INTERFACE

2482: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2483: attribute8,attribute9,attribute10,attribute11,attribute12,
2484: attribute13,attribute14,attribute15,schedule_seq_num,
2485: substitute_group_num, replacement_group_num, parent_seq_num, rowid
2486: FROM WIP_JOB_DTLS_INTERFACE
2487: WHERE group_id = p_group_id
2488: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2489: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2490: AND wip_entity_id = p_wip_entity_id

Line 2663: FROM WIP_JOB_DTLS_INTERFACE

2659: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2660: attribute8,attribute9,attribute10,attribute11,attribute12,
2661: attribute13,attribute14,attribute15,schedule_seq_num,
2662: substitute_group_num, replacement_group_num
2663: FROM WIP_JOB_DTLS_INTERFACE
2664: WHERE group_id = p_group_id
2665: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2666: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2667: AND wip_entity_id = p_wip_entity_id

Line 2829: from wip_job_dtls_interface wjdi

2825: p_substitute_group_num number,
2826: p_replacement_group_num number) IS
2827: cursor sched_rows is
2828: select *
2829: from wip_job_dtls_interface wjdi
2830: where wjdi.group_id = p_group_id
2831: and wjdi.process_phase = wip_constants.ml_validation
2832: and wjdi.process_status in (wip_constants.running,
2833: wip_constants.warning)

Line 2878: update wip_job_dtls_interface

2874: p_text => substr(fnd_message.get,1,500),
2875: p_error_type => wip_jdi_utils.msg_error);
2876: end if;
2877:
2878: update wip_job_dtls_interface
2879: set process_status = wip_constants.error
2880: where current of sched_rows;
2881: return;
2882: end if;

Line 2899: update wip_job_dtls_interface

2895: when no_data_found then
2896: repl_group := 1;
2897: end;
2898:
2899: update wip_job_dtls_interface
2900: set replacement_group_num = repl_group
2901: where current of sched_rows;
2902:
2903: else

Line 2904: update wip_job_dtls_interface

2900: set replacement_group_num = repl_group
2901: where current of sched_rows;
2902:
2903: else
2904: update wip_job_dtls_interface
2905: set replacement_group_num = null
2906: where current of sched_rows;
2907: end if;
2908:

Line 2939: update wip_job_dtls_interface

2935: and resource_seq_num = p_resource_seq_num;
2936: end;
2937:
2938: if (sched_row.schedule_seq_num is null) then
2939: update wip_job_dtls_interface
2940: set schedule_seq_num = sched_seq
2941: where current of sched_rows;
2942: end if;
2943:

Line 2946: update wip_job_dtls_interface

2942: end if;
2943:
2944: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
2945:
2946: update wip_job_dtls_interface
2947: set replacement_group_num = fnd_api.g_miss_num
2948: where current of sched_rows;
2949: elsif (sched_row.substitute_group_num is not null) then
2950:

Line 2986: update wip_job_dtls_interface

2982: when no_data_found then
2983: repl_group := 1;
2984: end;
2985:
2986: update wip_job_dtls_interface
2987: set replacement_group_num = repl_group
2988: where current of sched_rows;
2989: end if;
2990: else

Line 2991: update wip_job_dtls_interface

2987: set replacement_group_num = repl_group
2988: where current of sched_rows;
2989: end if;
2990: else
2991: update wip_job_dtls_interface
2992: set replacement_group_num = repl_group,
2993: substitute_group_num = sub_group
2994: where current of sched_rows;
2995: end if;

Line 3011: from wip_job_dtls_interface wjdi

3007: p_substitute_group_num number,
3008: p_replacement_group_num number) IS
3009: cursor sched_rows is
3010: select *
3011: from wip_job_dtls_interface wjdi
3012: where wjdi.group_id = p_group_id
3013: and wjdi.process_phase = wip_constants.ml_validation
3014: and wjdi.process_status in (wip_constants.running,
3015: wip_constants.warning)

Line 3055: update wip_job_dtls_interface

3051: p_text => substr(fnd_message.get,1,500),
3052: p_error_type => wip_jdi_utils.msg_error);
3053: end if;
3054:
3055: update wip_job_dtls_interface
3056: set process_status = wip_constants.error
3057: where current of sched_rows;
3058:
3059: return;

Line 3076: update wip_job_dtls_interface

3072: p_text => substr(fnd_message.get,1,500),
3073: p_error_type => wip_jdi_utils.msg_error);
3074: end if;
3075:
3076: update wip_job_dtls_interface
3077: set process_status = wip_constants.error
3078: where current of sched_rows;
3079:
3080: return;

Line 3096: update wip_job_dtls_interface

3092: and operation_seq_num = p_operation_seq_num
3093: and resource_seq_num = p_resource_seq_num;
3094:
3095: if (sched_row.schedule_seq_num is null) then
3096: update wip_job_dtls_interface
3097: set schedule_seq_num = sched_seq
3098: where current of sched_rows;
3099: end if;
3100:

Line 3103: update wip_job_dtls_interface

3099: end if;
3100:
3101: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
3102: -- not allowed to erase the sub/repl group of an existing alt res
3103: update wip_job_dtls_interface
3104: set substitute_group_num = sub_group,
3105: replacement_group_num = repl_group
3106: where current of sched_rows;
3107: elsif (sched_row.substitute_group_num is not null) then

Line 3122: update wip_job_dtls_interface

3118: p_text => substr(fnd_message.get,1,500),
3119: p_error_type => wip_jdi_utils.msg_error);
3120: end if;
3121:
3122: update wip_job_dtls_interface
3123: set process_status = wip_constants.error
3124: where current of sched_rows;
3125:
3126: return;

Line 3138: from wip_job_dtls_interface wjdi

3134: p_organization_id NUMBER,
3135: p_wip_entity_id NUMBER) IS
3136: cursor c_invalid_rows (p_operation_seq_num NUMBER) is
3137: select interface_id
3138: from wip_job_dtls_interface wjdi
3139: where wjdi.group_id = p_group_id
3140: and wjdi.process_phase = wip_constants.ml_validation
3141: and wjdi.process_status in (wip_constants.running,
3142: wip_constants.warning)

Line 3167: update wip_job_dtls_interface wjdi

3163: p_error_type => wip_jdi_utils.msg_error);
3164: end if;
3165: end loop;
3166:
3167: update wip_job_dtls_interface wjdi
3168: set wjdi.process_status = wip_constants.error
3169: where wjdi.group_id = p_group_id
3170: and wjdi.process_phase = wip_constants.ml_validation
3171: and wjdi.process_status in (wip_constants.running,