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 880: update wip_job_dtls_interface wjdi

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

Line 927: from wip_job_dtls_interface wjdi, wip_job_schedule_interface wjsi

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

Line 981: update wip_job_dtls_interface wjdi

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

Line 1019: from wip_job_dtls_interface wjdi

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

Line 1083: update wip_job_dtls_interface wjdi

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

Line 1124: update wip_job_dtls_interface wjdi

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

Line 1160: from wip_job_dtls_interface wjdi

1156: l_maximum_assigned_units number;
1157:
1158: cursor c_invalid_rows is
1159: select interface_id
1160: from wip_job_dtls_interface wjdi
1161: where wjdi.group_id = p_group_id
1162: and wjdi.process_phase = wip_constants.ml_validation
1163: and wjdi.process_status in (
1164: wip_constants.running,

Line 1229: update wip_job_dtls_interface wjdi

1225: end if;
1226: end loop;
1227:
1228: if(l_error_exists) then
1229: update wip_job_dtls_interface wjdi
1230: set wjdi.process_status = wip_constants.error
1231: where wjdi.group_id = p_group_id
1232: and wjdi.process_phase = wip_constants.ml_validation
1233: and wjdi.process_status in (wip_constants.running,

Line 1296: from WIP_JOB_DTLS_INTERFACE

1292:
1293: begin
1294: select nvl(max(resource_seq_num), 0)
1295: into x_res_seq_num
1296: from WIP_JOB_DTLS_INTERFACE
1297: where group_id = p_group_id
1298: and wip_entity_id = p_wip_entity_id
1299: and organization_id = p_organization_id
1300: and operation_seq_num = p_operation_seq_num

Line 1313: UPDATE WIP_JOB_DTLS_INTERFACE

1309: end if;
1310:
1311: x_res_seq_num_max := x_res_seq_num_max + 10;
1312:
1313: UPDATE WIP_JOB_DTLS_INTERFACE
1314: SET resource_seq_num = x_res_seq_num_max
1315: WHERE rowid = p_rowid;
1316:
1317: p_resource_seq_num := x_res_seq_num_max;

Line 1328: from wip_job_dtls_interface

1324: begin
1325: begin
1326: select schedule_seq_num
1327: into x_schedule_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 1354: UPDATE WIP_JOB_DTLS_INTERFACE

1350: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1351: end;
1352: end if;
1353: end;
1354: UPDATE WIP_JOB_DTLS_INTERFACE
1355: SET schedule_seq_num = x_schedule_seq_num
1356: WHERE rowid = p_rowid;
1357:
1358: end if;

Line 1373: UPDATE WIP_JOB_DTLS_INTERFACE

1369: when no_data_found then
1370: return;
1371: end;
1372:
1373: UPDATE WIP_JOB_DTLS_INTERFACE
1374: SET setup_id = nvl(setup_id, x_setup_id)
1375: WHERE rowid = p_rowid;
1376:
1377: end if;

Line 1414: FROM WIP_JOB_DTLS_INTERFACE

1410: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
1411: attribute8,attribute9,attribute10,attribute11,attribute12,
1412: attribute13,attribute14,attribute15, schedule_seq_num,
1413: substitute_group_num, replacement_group_num, parent_seq_num, rowid
1414: FROM WIP_JOB_DTLS_INTERFACE
1415: WHERE group_id = p_group_id
1416: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1417: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1418: AND wip_entity_id = p_wip_entity_id

Line 1580: from wip_job_dtls_interface wjdi

1576: l_count number;
1577:
1578: cursor c_invalid_rows is
1579: select interface_id
1580: from wip_job_dtls_interface wjdi
1581: where wjdi.group_id = p_group_id
1582: and wjdi.process_phase = wip_constants.ml_validation
1583: and wjdi.process_status in (wip_constants.running,
1584: wip_constants.warning)

Line 1623: update wip_job_dtls_interface wjdi

1619: p_error_type => wip_jdi_utils.msg_error);
1620: end if;
1621: end loop;
1622: if(l_error_exists) then
1623: update wip_job_dtls_interface wjdi
1624: set process_status = wip_constants.error
1625: where wjdi.group_id = p_group_id
1626: and wjdi.process_phase = wip_constants.ml_validation
1627: and wjdi.process_status in (wip_constants.running,

Line 1647: from wip_job_dtls_interface wjdi

1643: p_substitution_type number,
1644: p_operation_seq_num number) IS
1645: cursor c_invalid_rows is
1646: select interface_id
1647: from wip_job_dtls_interface wjdi
1648: where wjdi.group_id = p_group_id
1649: and wjdi.process_phase = wip_constants.ml_validation
1650: and wjdi.process_status in (wip_constants.running,
1651: wip_constants.warning)

Line 1685: update wip_job_dtls_interface wjdi

1681: end if;
1682: end loop;
1683:
1684: if(l_error_exists) then
1685: update wip_job_dtls_interface wjdi
1686: set process_status = wip_constants.error
1687: where wjdi.group_id = p_group_id
1688: and wjdi.process_phase = wip_constants.ml_validation
1689: and wjdi.process_status in (wip_constants.running,

Line 1750: FROM WIP_JOB_DTLS_INTERFACE

1746: attribute8,attribute9,attribute10,attribute11,attribute12,
1747: attribute13,attribute14,attribute15,
1748: schedule_seq_num, substitute_group_num,
1749: replacement_group_num, parent_seq_num, rowid
1750: FROM WIP_JOB_DTLS_INTERFACE
1751: WHERE group_id = p_group_id
1752: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
1753: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
1754: AND wip_entity_id = p_wip_entity_id

Line 1958: FROM WIP_JOB_DTLS_INTERFACE

1954: BEGIN
1955:
1956: SELECT count(*)
1957: INTO x_count
1958: FROM WIP_JOB_DTLS_INTERFACE
1959: WHERE group_id = p_group_id
1960: AND process_status = WIP_CONSTANTS.ERROR
1961: AND wip_entity_id = p_wip_entity_id
1962: AND organization_id = p_organization_id

Line 1990: FROM WIP_JOB_DTLS_INTERFACE

1986:
1987: IF p_substitution_type = WIP_JOB_DETAILS.WIP_DELETE THEN
1988: SELECT count(*)
1989: INTO x_count
1990: FROM WIP_JOB_DTLS_INTERFACE
1991: WHERE group_id = p_group_id
1992: AND process_status = WIP_CONSTANTS.ERROR
1993: AND wip_entity_id = p_wip_entity_id
1994: AND organization_id = p_organization_id

Line 2004: FROM WIP_JOB_DTLS_INTERFACE

2000:
2001: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
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 2018: FROM WIP_JOB_DTLS_INTERFACE

2014:
2015: ELSIF p_substitution_type = WIP_JOB_DETAILS.WIP_CHANGE THEN
2016: SELECT count(*)
2017: INTO x_count
2018: FROM WIP_JOB_DTLS_INTERFACE
2019: WHERE group_id = p_group_id
2020: AND process_status = WIP_CONSTANTS.ERROR
2021: AND wip_entity_id = p_wip_entity_id
2022: AND organization_id = p_organization_id

Line 2064: FROM WIP_JOB_DTLS_INTERFACE

2060: start_date, completion_date,attribute_category, attribute1,
2061: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2062: attribute8,attribute9,attribute10,attribute11,attribute12,
2063: attribute13,attribute14,attribute15
2064: FROM WIP_JOB_DTLS_INTERFACE
2065: WHERE group_id = p_group_id
2066: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2067: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2068: AND wip_entity_id = p_wip_entity_id

Line 2114: from wip_job_dtls_interface wjdi

2110: p_resource_id_old number) IS
2111:
2112: cursor c_invalid_rows is
2113: select interface_id
2114: from wip_job_dtls_interface wjdi
2115: where wjdi.group_id = p_group_id
2116: and wjdi.process_phase = wip_constants.ml_validation
2117: and wjdi.process_status in (wip_constants.running,
2118: wip_constants.warning)

Line 2172: from wip_job_dtls_interface wjdi

2168:
2169: cursor c_not_sub_rows is
2170: select wjdi.substitute_group_num,
2171: wjdi.replacement_group_num
2172: from wip_job_dtls_interface wjdi
2173: where wjdi.group_id = p_group_id
2174: and wjdi.process_phase = wip_constants.ml_validation
2175: and wjdi.process_status in (wip_constants.running,
2176: wip_constants.warning)

Line 2211: from wip_job_dtls_interface

2207: resource_id_old,
2208: operation_seq_num,
2209: resource_seq_num,
2210: substitute_group_num
2211: from wip_job_dtls_interface
2212: where group_id = p_group_id
2213: and process_phase = wip_constants.ml_validation
2214: and process_status in (wip_constants.running,
2215: wip_constants.warning)

Line 2248: update wip_job_dtls_interface wjdi

2244: end if;
2245: end loop;
2246:
2247: if(l_error_exists) then
2248: update wip_job_dtls_interface wjdi
2249: set process_status = wip_constants.error
2250: where wjdi.group_id = p_group_id
2251: and wjdi.process_phase = wip_constants.ml_validation
2252: and wjdi.process_status in (wip_constants.running,

Line 2293: update wip_job_dtls_interface wjdi

2289: RETURN;
2290: end if;
2291:
2292: for l_ns_row in c_not_sub_rows loop
2293: update wip_job_dtls_interface wjdi
2294: set substitute_group_num = null,
2295: replacement_group_num = null
2296: where current of c_not_sub_rows;
2297: end loop;

Line 2309: update wip_job_dtls_interface

2305: and wor.organization_id = l_sub_row.organization_id
2306: and wor.resource_id = l_sub_row.resource_id_old
2307: and wor.operation_seq_num = l_sub_row.operation_seq_num
2308: and wor.resource_seq_num = l_sub_row.resource_seq_num;
2309: update wip_job_dtls_interface
2310: set substitute_group_num = l_sub_group_temp
2311: where current of c_sub_rows;
2312: end if;
2313: end loop;

Line 2325: from wip_job_dtls_interface wjdi

2321: p_operation_seq_num number,
2322: p_resource_seq_num number) IS
2323: cursor c_invalid_rows is
2324: select interface_id
2325: from wip_job_dtls_interface wjdi
2326: where wjdi.group_id = p_group_id
2327: and wjdi.process_phase = wip_constants.ml_validation
2328: and wjdi.process_status in (wip_constants.running,
2329: wip_constants.warning)

Line 2375: update wip_job_dtls_interface wjdi

2371: end if;
2372: end loop;
2373:
2374: if(l_error_exists) then
2375: update wip_job_dtls_interface wjdi
2376: set process_status = wip_constants.error
2377: where wjdi.group_id = p_group_id
2378: and wjdi.process_phase = wip_constants.ml_validation
2379: and wjdi.process_status in (wip_constants.running,

Line 2438: FROM WIP_JOB_DTLS_INTERFACE

2434: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2435: attribute8,attribute9,attribute10,attribute11,attribute12,
2436: attribute13,attribute14,attribute15,schedule_seq_num,
2437: substitute_group_num, replacement_group_num, parent_seq_num, rowid
2438: FROM WIP_JOB_DTLS_INTERFACE
2439: WHERE group_id = p_group_id
2440: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2441: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2442: AND wip_entity_id = p_wip_entity_id

Line 2615: FROM WIP_JOB_DTLS_INTERFACE

2611: attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,
2612: attribute8,attribute9,attribute10,attribute11,attribute12,
2613: attribute13,attribute14,attribute15,schedule_seq_num,
2614: substitute_group_num, replacement_group_num
2615: FROM WIP_JOB_DTLS_INTERFACE
2616: WHERE group_id = p_group_id
2617: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
2618: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
2619: AND wip_entity_id = p_wip_entity_id

Line 2781: from wip_job_dtls_interface wjdi

2777: p_substitute_group_num number,
2778: p_replacement_group_num number) IS
2779: cursor sched_rows is
2780: select *
2781: from wip_job_dtls_interface wjdi
2782: where wjdi.group_id = p_group_id
2783: and wjdi.process_phase = wip_constants.ml_validation
2784: and wjdi.process_status in (wip_constants.running,
2785: wip_constants.warning)

Line 2825: update wip_job_dtls_interface

2821: p_text => substr(fnd_message.get,1,500),
2822: p_error_type => wip_jdi_utils.msg_error);
2823: end if;
2824:
2825: update wip_job_dtls_interface
2826: set process_status = wip_constants.error
2827: where current of sched_rows;
2828:
2829: return;

Line 2847: update wip_job_dtls_interface

2843: when no_data_found then
2844: repl_group := 1;
2845: end;
2846:
2847: update wip_job_dtls_interface
2848: set replacement_group_num = repl_group
2849: where current of sched_rows;
2850: else
2851: update wip_job_dtls_interface

Line 2851: update wip_job_dtls_interface

2847: update wip_job_dtls_interface
2848: set replacement_group_num = repl_group
2849: where current of sched_rows;
2850: else
2851: update wip_job_dtls_interface
2852: set replacement_group_num = null
2853: where current of sched_rows;
2854: end if;
2855: elsif (sched_row.substitution_type = wip_job_details.wip_change) then

Line 2869: update wip_job_dtls_interface

2865: and operation_seq_num = p_operation_seq_num
2866: and resource_seq_num = p_resource_seq_num;
2867:
2868: if (sched_row.schedule_seq_num is null) then
2869: update wip_job_dtls_interface
2870: set schedule_seq_num = sched_seq
2871: where current of sched_rows;
2872: end if;
2873:

Line 2875: update wip_job_dtls_interface

2871: where current of sched_rows;
2872: end if;
2873:
2874: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
2875: update wip_job_dtls_interface
2876: set replacement_group_num = fnd_api.g_miss_num
2877: where current of sched_rows;
2878: elsif (sched_row.substitute_group_num is not null) then
2879: l_res_sub := 0;

Line 2913: update wip_job_dtls_interface

2909: when no_data_found then
2910: repl_group := 1;
2911: end;
2912:
2913: update wip_job_dtls_interface
2914: set replacement_group_num = repl_group
2915: where current of sched_rows;
2916: end if;
2917: else

Line 2918: update wip_job_dtls_interface

2914: set replacement_group_num = repl_group
2915: where current of sched_rows;
2916: end if;
2917: else
2918: update wip_job_dtls_interface
2919: set replacement_group_num = repl_group,
2920: substitute_group_num = sub_group
2921: where current of sched_rows;
2922: end if;

Line 2938: from wip_job_dtls_interface wjdi

2934: p_substitute_group_num number,
2935: p_replacement_group_num number) IS
2936: cursor sched_rows is
2937: select *
2938: from wip_job_dtls_interface wjdi
2939: where wjdi.group_id = p_group_id
2940: and wjdi.process_phase = wip_constants.ml_validation
2941: and wjdi.process_status in (wip_constants.running,
2942: wip_constants.warning)

Line 2982: update wip_job_dtls_interface

2978: p_text => substr(fnd_message.get,1,500),
2979: p_error_type => wip_jdi_utils.msg_error);
2980: end if;
2981:
2982: update wip_job_dtls_interface
2983: set process_status = wip_constants.error
2984: where current of sched_rows;
2985:
2986: return;

Line 3003: update wip_job_dtls_interface

2999: p_text => substr(fnd_message.get,1,500),
3000: p_error_type => wip_jdi_utils.msg_error);
3001: end if;
3002:
3003: update wip_job_dtls_interface
3004: set process_status = wip_constants.error
3005: where current of sched_rows;
3006:
3007: return;

Line 3023: update wip_job_dtls_interface

3019: and operation_seq_num = p_operation_seq_num
3020: and resource_seq_num = p_resource_seq_num;
3021:
3022: if (sched_row.schedule_seq_num is null) then
3023: update wip_job_dtls_interface
3024: set schedule_seq_num = sched_seq
3025: where current of sched_rows;
3026: end if;
3027:

Line 3030: update wip_job_dtls_interface

3026: end if;
3027:
3028: if (sched_row.substitute_group_num = fnd_api.g_miss_num) then
3029: -- not allowed to erase the sub/repl group of an existing alt res
3030: update wip_job_dtls_interface
3031: set substitute_group_num = sub_group,
3032: replacement_group_num = repl_group
3033: where current of sched_rows;
3034: elsif (sched_row.substitute_group_num is not null) then

Line 3049: update wip_job_dtls_interface

3045: p_text => substr(fnd_message.get,1,500),
3046: p_error_type => wip_jdi_utils.msg_error);
3047: end if;
3048:
3049: update wip_job_dtls_interface
3050: set process_status = wip_constants.error
3051: where current of sched_rows;
3052:
3053: return;

Line 3065: from wip_job_dtls_interface wjdi

3061: p_organization_id NUMBER,
3062: p_wip_entity_id NUMBER) IS
3063: cursor c_invalid_rows (p_operation_seq_num NUMBER) is
3064: select interface_id
3065: from wip_job_dtls_interface wjdi
3066: where wjdi.group_id = p_group_id
3067: and wjdi.process_phase = wip_constants.ml_validation
3068: and wjdi.process_status in (wip_constants.running,
3069: wip_constants.warning)

Line 3094: update wip_job_dtls_interface wjdi

3090: p_error_type => wip_jdi_utils.msg_error);
3091: end if;
3092: end loop;
3093:
3094: update wip_job_dtls_interface wjdi
3095: set wjdi.process_status = wip_constants.error
3096: where wjdi.group_id = p_group_id
3097: and wjdi.process_phase = wip_constants.ml_validation
3098: and wjdi.process_status in (wip_constants.running,