398: update wip_discrete_jobs --increase the qty completed
399: set quantity_completed = l_qtyCompleted + p_cplRec.priQty, --remember txn qty is negative for returns
400: date_completed = l_cplDate,
401: status_type = nvl(l_jobStatus, status_type),
402: last_updated_by = fnd_global.user_id,
403: last_update_date = sysdate,
404: request_id = fnd_global.conc_request_id,
405: program_application_id = fnd_global.prog_appl_id,
406: program_id = fnd_global.conc_program_id,
400: date_completed = l_cplDate,
401: status_type = nvl(l_jobStatus, status_type),
402: last_updated_by = fnd_global.user_id,
403: last_update_date = sysdate,
404: request_id = fnd_global.conc_request_id,
405: program_application_id = fnd_global.prog_appl_id,
406: program_id = fnd_global.conc_program_id,
407: program_update_date = sysdate
408: where rowid = l_rowid;
401: status_type = nvl(l_jobStatus, status_type),
402: last_updated_by = fnd_global.user_id,
403: last_update_date = sysdate,
404: request_id = fnd_global.conc_request_id,
405: program_application_id = fnd_global.prog_appl_id,
406: program_id = fnd_global.conc_program_id,
407: program_update_date = sysdate
408: where rowid = l_rowid;
409:
402: last_updated_by = fnd_global.user_id,
403: last_update_date = sysdate,
404: request_id = fnd_global.conc_request_id,
405: program_application_id = fnd_global.prog_appl_id,
406: program_id = fnd_global.conc_program_id,
407: program_update_date = sysdate
408: where rowid = l_rowid;
409:
410: --if there exists a routing, lock the last operation
424: end if;
425: update wip_operations --lower the quantity available to complete
426: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
427: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
428: last_updated_by = fnd_global.user_id,
429: last_update_date = sysdate,
430: request_id = fnd_global.conc_request_id,
431: program_application_id = fnd_global.prog_appl_id,
432: program_id = fnd_global.conc_program_id,
426: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
427: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
428: last_updated_by = fnd_global.user_id,
429: last_update_date = sysdate,
430: request_id = fnd_global.conc_request_id,
431: program_application_id = fnd_global.prog_appl_id,
432: program_id = fnd_global.conc_program_id,
433: program_update_date = sysdate
434: where rowid = l_rowid;
427: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
428: last_updated_by = fnd_global.user_id,
429: last_update_date = sysdate,
430: request_id = fnd_global.conc_request_id,
431: program_application_id = fnd_global.prog_appl_id,
432: program_id = fnd_global.conc_program_id,
433: program_update_date = sysdate
434: where rowid = l_rowid;
435: else -- Fix BUG 4869979 (FP 5107900)
428: last_updated_by = fnd_global.user_id,
429: last_update_date = sysdate,
430: request_id = fnd_global.conc_request_id,
431: program_application_id = fnd_global.prog_appl_id,
432: program_id = fnd_global.conc_program_id,
433: program_update_date = sysdate
434: where rowid = l_rowid;
435: else -- Fix BUG 4869979 (FP 5107900)
436: -- If routing does not exist, validate if quantity is available on the job for completion
611: if(l_schedRecTbl.woRowID(i) is not null) then
612: update wip_operations
613: set quantity_waiting_to_move = quantity_waiting_to_move - l_schedRecTbl.preAlcQty(i),
614: date_last_moved = sysdate,
615: last_updated_by = fnd_global.user_id,
616: last_update_date = sysdate,
617: request_id = fnd_global.conc_request_id,
618: program_application_id = fnd_global.prog_appl_id,
619: program_id = fnd_global.conc_program_id,
613: set quantity_waiting_to_move = quantity_waiting_to_move - l_schedRecTbl.preAlcQty(i),
614: date_last_moved = sysdate,
615: last_updated_by = fnd_global.user_id,
616: last_update_date = sysdate,
617: request_id = fnd_global.conc_request_id,
618: program_application_id = fnd_global.prog_appl_id,
619: program_id = fnd_global.conc_program_id,
620: program_update_date = sysdate
621: where rowid = chartorowid(l_schedRecTbl.woRowID(i))
614: date_last_moved = sysdate,
615: last_updated_by = fnd_global.user_id,
616: last_update_date = sysdate,
617: request_id = fnd_global.conc_request_id,
618: program_application_id = fnd_global.prog_appl_id,
619: program_id = fnd_global.conc_program_id,
620: program_update_date = sysdate
621: where rowid = chartorowid(l_schedRecTbl.woRowID(i))
622: returning quantity_waiting_to_move into l_newSchedQty;
615: last_updated_by = fnd_global.user_id,
616: last_update_date = sysdate,
617: request_id = fnd_global.conc_request_id,
618: program_application_id = fnd_global.prog_appl_id,
619: program_id = fnd_global.conc_program_id,
620: program_update_date = sysdate
621: where rowid = chartorowid(l_schedRecTbl.woRowID(i))
622: returning quantity_waiting_to_move into l_newSchedQty;
623:
646:
647: update wip_repetitive_schedules
648: set quantity_completed = quantity_completed + l_schedRecTbl.preAlcQty(i),
649: status_type = l_status,
650: last_updated_by = fnd_global.user_id,
651: last_update_date = sysdate,
652: request_id = fnd_global.conc_request_id,
653: program_application_id = fnd_global.prog_appl_id,
654: program_id = fnd_global.conc_program_id,
648: set quantity_completed = quantity_completed + l_schedRecTbl.preAlcQty(i),
649: status_type = l_status,
650: last_updated_by = fnd_global.user_id,
651: last_update_date = sysdate,
652: request_id = fnd_global.conc_request_id,
653: program_application_id = fnd_global.prog_appl_id,
654: program_id = fnd_global.conc_program_id,
655: program_update_date = sysdate
656: where rowid = chartorowid(l_schedRecTbl.wrsRowID(i));
649: status_type = l_status,
650: last_updated_by = fnd_global.user_id,
651: last_update_date = sysdate,
652: request_id = fnd_global.conc_request_id,
653: program_application_id = fnd_global.prog_appl_id,
654: program_id = fnd_global.conc_program_id,
655: program_update_date = sysdate
656: where rowid = chartorowid(l_schedRecTbl.wrsRowID(i));
657:
650: last_updated_by = fnd_global.user_id,
651: last_update_date = sysdate,
652: request_id = fnd_global.conc_request_id,
653: program_application_id = fnd_global.prog_appl_id,
654: program_id = fnd_global.conc_program_id,
655: program_update_date = sysdate
656: where rowid = chartorowid(l_schedRecTbl.wrsRowID(i));
657:
658: if(l_status = wip_constants.comp_chrg) then
687: select p_cplRec.mtlAlcTmpID,
688: wmat.repetitive_schedule_id,
689: wmat.organization_id,
690: sysdate,
691: fnd_global.user_id,
692: sysdate,
693: fnd_global.user_id,
694: fnd_global.login_id,
695: wmat.primary_quantity,
689: wmat.organization_id,
690: sysdate,
691: fnd_global.user_id,
692: sysdate,
693: fnd_global.user_id,
694: fnd_global.login_id,
695: wmat.primary_quantity,
696: wmat.transaction_quantity,
697: fnd_global.conc_request_id,
690: sysdate,
691: fnd_global.user_id,
692: sysdate,
693: fnd_global.user_id,
694: fnd_global.login_id,
695: wmat.primary_quantity,
696: wmat.transaction_quantity,
697: fnd_global.conc_request_id,
698: fnd_global.prog_appl_id,
693: fnd_global.user_id,
694: fnd_global.login_id,
695: wmat.primary_quantity,
696: wmat.transaction_quantity,
697: fnd_global.conc_request_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_program_id,
700: wmat.transaction_date
701: from wip_mtl_allocations_temp wmat
694: fnd_global.login_id,
695: wmat.primary_quantity,
696: wmat.transaction_quantity,
697: fnd_global.conc_request_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_program_id,
700: wmat.transaction_date
701: from wip_mtl_allocations_temp wmat
702: where wmat.transaction_temp_id = p_txnTmpID;
695: wmat.primary_quantity,
696: wmat.transaction_quantity,
697: fnd_global.conc_request_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_program_id,
700: wmat.transaction_date
701: from wip_mtl_allocations_temp wmat
702: where wmat.transaction_temp_id = p_txnTmpID;
703:
825: p_cpl_profile => wip_constants.online,
826: p_oc_txn_id => p_cplRec.overCplTxnID,
827: p_parent_cpl_txn_id => p_cplRec.cplTxnID,
828: p_first_schedule_id => l_firstSchedID,
829: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
830: p_login_id => fnd_global.conc_login_id,
831: p_req_id => fnd_global.conc_request_id,
832: p_appl_id => fnd_global.prog_appl_id,
833: p_prog_id => fnd_global.conc_program_id,
826: p_oc_txn_id => p_cplRec.overCplTxnID,
827: p_parent_cpl_txn_id => p_cplRec.cplTxnID,
828: p_first_schedule_id => l_firstSchedID,
829: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
830: p_login_id => fnd_global.conc_login_id,
831: p_req_id => fnd_global.conc_request_id,
832: p_appl_id => fnd_global.prog_appl_id,
833: p_prog_id => fnd_global.conc_program_id,
834: p_child_txn_id => p_cplrec.movTxnID,
827: p_parent_cpl_txn_id => p_cplRec.cplTxnID,
828: p_first_schedule_id => l_firstSchedID,
829: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
830: p_login_id => fnd_global.conc_login_id,
831: p_req_id => fnd_global.conc_request_id,
832: p_appl_id => fnd_global.prog_appl_id,
833: p_prog_id => fnd_global.conc_program_id,
834: p_child_txn_id => p_cplrec.movTxnID,
835: p_first_operation_seq_num => l_firstOpSeq,
828: p_first_schedule_id => l_firstSchedID,
829: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
830: p_login_id => fnd_global.conc_login_id,
831: p_req_id => fnd_global.conc_request_id,
832: p_appl_id => fnd_global.prog_appl_id,
833: p_prog_id => fnd_global.conc_program_id,
834: p_child_txn_id => p_cplrec.movTxnID,
835: p_first_operation_seq_num => l_firstOpSeq,
836: p_err_mesg => l_errMsg);
829: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
830: p_login_id => fnd_global.conc_login_id,
831: p_req_id => fnd_global.conc_request_id,
832: p_appl_id => fnd_global.prog_appl_id,
833: p_prog_id => fnd_global.conc_program_id,
834: p_child_txn_id => p_cplrec.movTxnID,
835: p_first_operation_seq_num => l_firstOpSeq,
836: p_err_mesg => l_errMsg);
837:
1205: p_cplTxnID,
1206: l_schedRecTbl.repSchedID(j),
1207: l_txnRecTbl.orgID(i),
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: fnd_global.conc_request_id,
1207: l_txnRecTbl.orgID(i),
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: fnd_global.conc_request_id,
1214: fnd_global.prog_appl_id,
1215: fnd_global.conc_program_id,
1208: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: fnd_global.conc_request_id,
1214: fnd_global.prog_appl_id,
1215: fnd_global.conc_program_id,
1216: sysdate,
1209: fnd_global.user_id,
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: fnd_global.conc_request_id,
1214: fnd_global.prog_appl_id,
1215: fnd_global.conc_program_id,
1216: sysdate,
1217: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty
1210: sysdate,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: fnd_global.conc_request_id,
1214: fnd_global.prog_appl_id,
1215: fnd_global.conc_program_id,
1216: sysdate,
1217: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty
1218: l_schedQty,
1211: fnd_global.user_id,
1212: fnd_global.login_id,
1213: fnd_global.conc_request_id,
1214: fnd_global.prog_appl_id,
1215: fnd_global.conc_program_id,
1216: sysdate,
1217: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty
1218: l_schedQty,
1219: l_txnRecTbl.txnDate(i));
1295: p_cplTxnID,
1296: l_lastSchedID,
1297: l_txnRecTbl.orgID(i),
1298: sysdate,
1299: fnd_global.user_id,
1300: sysdate,
1301: fnd_global.user_id,
1302: fnd_global.login_id,
1303: fnd_global.conc_request_id,
1297: l_txnRecTbl.orgID(i),
1298: sysdate,
1299: fnd_global.user_id,
1300: sysdate,
1301: fnd_global.user_id,
1302: fnd_global.login_id,
1303: fnd_global.conc_request_id,
1304: fnd_global.prog_appl_id,
1305: fnd_global.conc_program_id,
1298: sysdate,
1299: fnd_global.user_id,
1300: sysdate,
1301: fnd_global.user_id,
1302: fnd_global.login_id,
1303: fnd_global.conc_request_id,
1304: fnd_global.prog_appl_id,
1305: fnd_global.conc_program_id,
1306: sysdate,
1299: fnd_global.user_id,
1300: sysdate,
1301: fnd_global.user_id,
1302: fnd_global.login_id,
1303: fnd_global.conc_request_id,
1304: fnd_global.prog_appl_id,
1305: fnd_global.conc_program_id,
1306: sysdate,
1307: l_txnRecTbl.txnQty(i),
1300: sysdate,
1301: fnd_global.user_id,
1302: fnd_global.login_id,
1303: fnd_global.conc_request_id,
1304: fnd_global.prog_appl_id,
1305: fnd_global.conc_program_id,
1306: sysdate,
1307: l_txnRecTbl.txnQty(i),
1308: l_txnRecTbl.priQty(i),
1301: fnd_global.user_id,
1302: fnd_global.login_id,
1303: fnd_global.conc_request_id,
1304: fnd_global.prog_appl_id,
1305: fnd_global.conc_program_id,
1306: sysdate,
1307: l_txnRecTbl.txnQty(i),
1308: l_txnRecTbl.priQty(i),
1309: l_txnRecTbl.txnDate(i));
1436: select mmtt.transaction_temp_id,
1437: l_schedID,
1438: mmtt.organization_id,
1439: sysdate,
1440: fnd_global.user_id,
1441: sysdate,
1442: fnd_global.user_id,
1443: fnd_global.login_id,
1444: fnd_global.conc_request_id,
1438: mmtt.organization_id,
1439: sysdate,
1440: fnd_global.user_id,
1441: sysdate,
1442: fnd_global.user_id,
1443: fnd_global.login_id,
1444: fnd_global.conc_request_id,
1445: fnd_global.prog_appl_id,
1446: fnd_global.conc_program_id,
1439: sysdate,
1440: fnd_global.user_id,
1441: sysdate,
1442: fnd_global.user_id,
1443: fnd_global.login_id,
1444: fnd_global.conc_request_id,
1445: fnd_global.prog_appl_id,
1446: fnd_global.conc_program_id,
1447: sysdate,
1440: fnd_global.user_id,
1441: sysdate,
1442: fnd_global.user_id,
1443: fnd_global.login_id,
1444: fnd_global.conc_request_id,
1445: fnd_global.prog_appl_id,
1446: fnd_global.conc_program_id,
1447: sysdate,
1448: mmtt.transaction_quantity,
1441: sysdate,
1442: fnd_global.user_id,
1443: fnd_global.login_id,
1444: fnd_global.conc_request_id,
1445: fnd_global.prog_appl_id,
1446: fnd_global.conc_program_id,
1447: sysdate,
1448: mmtt.transaction_quantity,
1449: mmtt.primary_quantity,
1442: fnd_global.user_id,
1443: fnd_global.login_id,
1444: fnd_global.conc_request_id,
1445: fnd_global.prog_appl_id,
1446: fnd_global.conc_program_id,
1447: sysdate,
1448: mmtt.transaction_quantity,
1449: mmtt.primary_quantity,
1450: mmtt.transaction_date
1472: select mti.transaction_interface_id,
1473: l_schedID,
1474: mti.organization_id,
1475: sysdate,
1476: fnd_global.user_id,
1477: sysdate,
1478: fnd_global.user_id,
1479: fnd_global.login_id,
1480: fnd_global.conc_request_id,
1474: mti.organization_id,
1475: sysdate,
1476: fnd_global.user_id,
1477: sysdate,
1478: fnd_global.user_id,
1479: fnd_global.login_id,
1480: fnd_global.conc_request_id,
1481: fnd_global.prog_appl_id,
1482: fnd_global.conc_program_id,
1475: sysdate,
1476: fnd_global.user_id,
1477: sysdate,
1478: fnd_global.user_id,
1479: fnd_global.login_id,
1480: fnd_global.conc_request_id,
1481: fnd_global.prog_appl_id,
1482: fnd_global.conc_program_id,
1483: sysdate,
1476: fnd_global.user_id,
1477: sysdate,
1478: fnd_global.user_id,
1479: fnd_global.login_id,
1480: fnd_global.conc_request_id,
1481: fnd_global.prog_appl_id,
1482: fnd_global.conc_program_id,
1483: sysdate,
1484: mti.transaction_quantity,
1477: sysdate,
1478: fnd_global.user_id,
1479: fnd_global.login_id,
1480: fnd_global.conc_request_id,
1481: fnd_global.prog_appl_id,
1482: fnd_global.conc_program_id,
1483: sysdate,
1484: mti.transaction_quantity,
1485: mti.primary_quantity,
1478: fnd_global.user_id,
1479: fnd_global.login_id,
1480: fnd_global.conc_request_id,
1481: fnd_global.prog_appl_id,
1482: fnd_global.conc_program_id,
1483: sysdate,
1484: mti.transaction_quantity,
1485: mti.primary_quantity,
1486: mti.transaction_date