DBA Data[Home] [Help]

APPS.WIP_MTLPROC_PRIV dependencies on FND_GLOBAL

Line 420: last_updated_by = fnd_global.user_id,

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

Line 421: last_update_login = fnd_global.conc_login_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;

Line 422: request_id = fnd_global.conc_request_id,

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:

Line 423: program_id = fnd_global.conc_program_id,

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;

Line 424: program_application_id = fnd_global.prog_appl_id

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

Line 449: last_updated_by = fnd_global.user_id,

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

Line 450: last_update_login = fnd_global.conc_login_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;

Line 451: request_id = fnd_global.conc_request_id,

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:

Line 452: program_id = fnd_global.conc_program_id,

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;

Line 453: program_application_id = fnd_global.prog_appl_id

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;

Line 533: fnd_global.user_id,

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 */

Line 534: fnd_global.login_id,

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,

Line 536: fnd_global.user_id, --10

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),

Line 544: fnd_global.conc_request_id,

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,

Line 545: fnd_global.prog_appl_id,

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,

Line 546: fnd_global.conc_program_id, --20

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,

Line 1106: fnd_global.user_id,

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,

Line 1108: fnd_global.user_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,

Line 1109: fnd_global.conc_login_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,

Line 1110: fnd_global.conc_request_id,

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),

Line 1111: fnd_global.prog_appl_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),
1115: l_mmta_txnQtyTbl(i),

Line 1112: fnd_global.conc_program_id,

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);