416: update wip_requirement_operations --try to update an existing requirement
417: set quantity_issued = quantity_issued + nvl(p_issueQty, p_issueRec.primaryQty),
418: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
421: last_update_login = fnd_global.conc_login_id,
422: request_id = fnd_global.conc_request_id,
423: program_id = fnd_global.conc_program_id,
424: program_application_id = fnd_global.prog_appl_id
417: set quantity_issued = quantity_issued + nvl(p_issueQty, p_issueRec.primaryQty),
418: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
421: last_update_login = fnd_global.conc_login_id,
422: request_id = fnd_global.conc_request_id,
423: program_id = fnd_global.conc_program_id,
424: program_application_id = fnd_global.prog_appl_id
425: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
418: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
421: last_update_login = fnd_global.conc_login_id,
422: request_id = fnd_global.conc_request_id,
423: program_id = fnd_global.conc_program_id,
424: program_application_id = fnd_global.prog_appl_id
425: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
426:
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
421: last_update_login = fnd_global.conc_login_id,
422: request_id = fnd_global.conc_request_id,
423: program_id = fnd_global.conc_program_id,
424: program_application_id = fnd_global.prog_appl_id
425: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
426:
427: end if;
420: last_updated_by = fnd_global.user_id,
421: last_update_login = fnd_global.conc_login_id,
422: request_id = fnd_global.conc_request_id,
423: program_id = fnd_global.conc_program_id,
424: program_application_id = fnd_global.prog_appl_id
425: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
426:
427: end if;
428: else
445: update wip_requirement_operations --try to update an existing requirement
446: set quantity_issued = quantity_issued + nvl(p_issueQty, p_issueRec.primaryQty),
447: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
448: last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: request_id = fnd_global.conc_request_id,
452: program_id = fnd_global.conc_program_id,
453: program_application_id = fnd_global.prog_appl_id
446: set quantity_issued = quantity_issued + nvl(p_issueQty, p_issueRec.primaryQty),
447: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
448: last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: request_id = fnd_global.conc_request_id,
452: program_id = fnd_global.conc_program_id,
453: program_application_id = fnd_global.prog_appl_id
454: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
447: quantity_allocated = greatest(0, least(quantity_allocated, quantity_allocated - nvl(p_issueQty, p_issueRec.primaryQty))),
448: last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: request_id = fnd_global.conc_request_id,
452: program_id = fnd_global.conc_program_id,
453: program_application_id = fnd_global.prog_appl_id
454: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
455:
448: last_update_date = sysdate,
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: request_id = fnd_global.conc_request_id,
452: program_id = fnd_global.conc_program_id,
453: program_application_id = fnd_global.prog_appl_id
454: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
455:
456: end if;
449: last_updated_by = fnd_global.user_id,
450: last_update_login = fnd_global.conc_login_id,
451: request_id = fnd_global.conc_request_id,
452: program_id = fnd_global.conc_program_id,
453: program_application_id = fnd_global.prog_appl_id
454: where rowid = l_rowid returning quantity_issued, required_quantity into l_newIssuedQty, l_newRequiredQty;
455:
456: end if;
457: end if;
529: p_issueRec.wipEntityID,
530: p_issueRec.opSeqNum,
531: p_repSchedID, --5
532: sysdate,
533: fnd_global.user_id,
534: fnd_global.login_id,
535: sysdate,
536: fnd_global.user_id, --10
537: nvl(p_issueRec.deptID, l_dept_id), /* Bugfix 5401362 l_dept_id if null */
530: p_issueRec.opSeqNum,
531: p_repSchedID, --5
532: sysdate,
533: fnd_global.user_id,
534: fnd_global.login_id,
535: sysdate,
536: fnd_global.user_id, --10
537: nvl(p_issueRec.deptID, l_dept_id), /* Bugfix 5401362 l_dept_id if null */
538: p_issueRec.txnDate,
532: sysdate,
533: fnd_global.user_id,
534: fnd_global.login_id,
535: sysdate,
536: fnd_global.user_id, --10
537: nvl(p_issueRec.deptID, l_dept_id), /* Bugfix 5401362 l_dept_id if null */
538: p_issueRec.txnDate,
539: 0, --required_quantity
540: nvl(p_issueQty, p_issueRec.primaryQty),
540: nvl(p_issueQty, p_issueRec.primaryQty),
541: 0, --quantity_per_assembly 15
542: nvl(p_issueRec.wipSupplyType, wip_constants.push),
543: wip_constants.yes,
544: fnd_global.conc_request_id,
545: fnd_global.prog_appl_id,
546: fnd_global.conc_program_id, --20
547: sysdate,
548: p_issueRec.supplySub,
541: 0, --quantity_per_assembly 15
542: nvl(p_issueRec.wipSupplyType, wip_constants.push),
543: wip_constants.yes,
544: fnd_global.conc_request_id,
545: fnd_global.prog_appl_id,
546: fnd_global.conc_program_id, --20
547: sysdate,
548: p_issueRec.supplySub,
549: p_issueRec.supplyLocID,
542: nvl(p_issueRec.wipSupplyType, wip_constants.push),
543: wip_constants.yes,
544: fnd_global.conc_request_id,
545: fnd_global.prog_appl_id,
546: fnd_global.conc_program_id, --20
547: sysdate,
548: p_issueRec.supplySub,
549: p_issueRec.supplyLocID,
550: p_issueRec.txnDate,
1102: (p_issueRec.mtlTxnID,
1103: l_mmta_schedIdTbl(i),
1104: p_issueRec.orgID,
1105: sysdate,
1106: fnd_global.user_id,
1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.conc_login_id,
1110: fnd_global.conc_request_id,
1104: p_issueRec.orgID,
1105: sysdate,
1106: fnd_global.user_id,
1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.conc_login_id,
1110: fnd_global.conc_request_id,
1111: fnd_global.prog_appl_id,
1112: fnd_global.conc_program_id,
1105: sysdate,
1106: fnd_global.user_id,
1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.conc_login_id,
1110: fnd_global.conc_request_id,
1111: fnd_global.prog_appl_id,
1112: fnd_global.conc_program_id,
1113: sysdate,
1106: fnd_global.user_id,
1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.conc_login_id,
1110: fnd_global.conc_request_id,
1111: fnd_global.prog_appl_id,
1112: fnd_global.conc_program_id,
1113: sysdate,
1114: l_mmta_priQtyTbl(i),
1107: sysdate,
1108: fnd_global.user_id,
1109: fnd_global.conc_login_id,
1110: fnd_global.conc_request_id,
1111: fnd_global.prog_appl_id,
1112: fnd_global.conc_program_id,
1113: sysdate,
1114: l_mmta_priQtyTbl(i),
1115: l_mmta_txnQtyTbl(i),
1108: fnd_global.user_id,
1109: fnd_global.conc_login_id,
1110: fnd_global.conc_request_id,
1111: fnd_global.prog_appl_id,
1112: fnd_global.conc_program_id,
1113: sysdate,
1114: l_mmta_priQtyTbl(i),
1115: l_mmta_txnQtyTbl(i),
1116: p_issueRec.txnDate);