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_CPLPROC_PRIV dependencies on FND_GLOBAL

Line 425: last_updated_by = fnd_global.user_id,

421: update wip_discrete_jobs --increase the qty completed
422: set quantity_completed = l_qtyCompleted + p_cplRec.priQty, --remember txn qty is negative for returns
423: date_completed = l_cplDate,
424: status_type = nvl(l_jobStatus, status_type),
425: last_updated_by = fnd_global.user_id,
426: last_update_date = sysdate,
427: request_id = fnd_global.conc_request_id,
428: program_application_id = fnd_global.prog_appl_id,
429: program_id = fnd_global.conc_program_id,

Line 427: request_id = fnd_global.conc_request_id,

423: date_completed = l_cplDate,
424: status_type = nvl(l_jobStatus, status_type),
425: last_updated_by = fnd_global.user_id,
426: last_update_date = sysdate,
427: request_id = fnd_global.conc_request_id,
428: program_application_id = fnd_global.prog_appl_id,
429: program_id = fnd_global.conc_program_id,
430: program_update_date = sysdate
431: where rowid = l_rowid;

Line 428: program_application_id = fnd_global.prog_appl_id,

424: status_type = nvl(l_jobStatus, status_type),
425: last_updated_by = fnd_global.user_id,
426: last_update_date = sysdate,
427: request_id = fnd_global.conc_request_id,
428: program_application_id = fnd_global.prog_appl_id,
429: program_id = fnd_global.conc_program_id,
430: program_update_date = sysdate
431: where rowid = l_rowid;
432:

Line 429: program_id = fnd_global.conc_program_id,

425: last_updated_by = fnd_global.user_id,
426: last_update_date = sysdate,
427: request_id = fnd_global.conc_request_id,
428: program_application_id = fnd_global.prog_appl_id,
429: program_id = fnd_global.conc_program_id,
430: program_update_date = sysdate
431: where rowid = l_rowid;
432:
433: --if there exists a routing, lock the last operation

Line 451: last_updated_by = fnd_global.user_id,

447: end if;
448: update wip_operations --lower the quantity available to complete
449: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
450: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
451: last_updated_by = fnd_global.user_id,
452: last_update_date = sysdate,
453: request_id = fnd_global.conc_request_id,
454: program_application_id = fnd_global.prog_appl_id,
455: program_id = fnd_global.conc_program_id,

Line 453: request_id = fnd_global.conc_request_id,

449: set quantity_waiting_to_move = quantity_waiting_to_move - p_cplRec.priQty,
450: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
451: last_updated_by = fnd_global.user_id,
452: last_update_date = sysdate,
453: request_id = fnd_global.conc_request_id,
454: program_application_id = fnd_global.prog_appl_id,
455: program_id = fnd_global.conc_program_id,
456: program_update_date = sysdate
457: where rowid = l_rowid;

Line 454: program_application_id = fnd_global.prog_appl_id,

450: date_last_moved = decode(p_cplRec.txnActionID, wip_constants.cplassy_action, p_cplRec.txnDate, date_last_moved),
451: last_updated_by = fnd_global.user_id,
452: last_update_date = sysdate,
453: request_id = fnd_global.conc_request_id,
454: program_application_id = fnd_global.prog_appl_id,
455: program_id = fnd_global.conc_program_id,
456: program_update_date = sysdate
457: where rowid = l_rowid;
458: else -- Fix BUG 4869979 (FP 5107900)

Line 455: program_id = fnd_global.conc_program_id,

451: last_updated_by = fnd_global.user_id,
452: last_update_date = sysdate,
453: request_id = fnd_global.conc_request_id,
454: program_application_id = fnd_global.prog_appl_id,
455: program_id = fnd_global.conc_program_id,
456: program_update_date = sysdate
457: where rowid = l_rowid;
458: else -- Fix BUG 4869979 (FP 5107900)
459: -- If routing does not exist, validate if quantity is available on the job for completion

Line 640: last_updated_by = fnd_global.user_id,

636: if(l_schedRecTbl.woRowID(i) is not null) then
637: update wip_operations
638: set quantity_waiting_to_move = quantity_waiting_to_move - l_schedRecTbl.preAlcQty(i),
639: date_last_moved = sysdate,
640: last_updated_by = fnd_global.user_id,
641: last_update_date = sysdate,
642: request_id = fnd_global.conc_request_id,
643: program_application_id = fnd_global.prog_appl_id,
644: program_id = fnd_global.conc_program_id,

Line 642: request_id = fnd_global.conc_request_id,

638: set quantity_waiting_to_move = quantity_waiting_to_move - l_schedRecTbl.preAlcQty(i),
639: date_last_moved = sysdate,
640: last_updated_by = fnd_global.user_id,
641: last_update_date = sysdate,
642: request_id = fnd_global.conc_request_id,
643: program_application_id = fnd_global.prog_appl_id,
644: program_id = fnd_global.conc_program_id,
645: program_update_date = sysdate
646: where rowid = chartorowid(l_schedRecTbl.woRowID(i))

Line 643: program_application_id = fnd_global.prog_appl_id,

639: date_last_moved = sysdate,
640: last_updated_by = fnd_global.user_id,
641: last_update_date = sysdate,
642: request_id = fnd_global.conc_request_id,
643: program_application_id = fnd_global.prog_appl_id,
644: program_id = fnd_global.conc_program_id,
645: program_update_date = sysdate
646: where rowid = chartorowid(l_schedRecTbl.woRowID(i))
647: returning quantity_waiting_to_move into l_newSchedQty;

Line 644: program_id = fnd_global.conc_program_id,

640: last_updated_by = fnd_global.user_id,
641: last_update_date = sysdate,
642: request_id = fnd_global.conc_request_id,
643: program_application_id = fnd_global.prog_appl_id,
644: program_id = fnd_global.conc_program_id,
645: program_update_date = sysdate
646: where rowid = chartorowid(l_schedRecTbl.woRowID(i))
647: returning quantity_waiting_to_move into l_newSchedQty;
648:

Line 675: last_updated_by = fnd_global.user_id,

671:
672: update wip_repetitive_schedules
673: set quantity_completed = quantity_completed + l_schedRecTbl.preAlcQty(i),
674: status_type = l_status,
675: last_updated_by = fnd_global.user_id,
676: last_update_date = sysdate,
677: request_id = fnd_global.conc_request_id,
678: program_application_id = fnd_global.prog_appl_id,
679: program_id = fnd_global.conc_program_id,

Line 677: request_id = fnd_global.conc_request_id,

673: set quantity_completed = quantity_completed + l_schedRecTbl.preAlcQty(i),
674: status_type = l_status,
675: last_updated_by = fnd_global.user_id,
676: last_update_date = sysdate,
677: request_id = fnd_global.conc_request_id,
678: program_application_id = fnd_global.prog_appl_id,
679: program_id = fnd_global.conc_program_id,
680: program_update_date = sysdate
681: where rowid = chartorowid(l_schedRecTbl.wrsRowID(i));

Line 678: program_application_id = fnd_global.prog_appl_id,

674: status_type = l_status,
675: last_updated_by = fnd_global.user_id,
676: last_update_date = sysdate,
677: request_id = fnd_global.conc_request_id,
678: program_application_id = fnd_global.prog_appl_id,
679: program_id = fnd_global.conc_program_id,
680: program_update_date = sysdate
681: where rowid = chartorowid(l_schedRecTbl.wrsRowID(i));
682:

Line 679: program_id = fnd_global.conc_program_id,

675: last_updated_by = fnd_global.user_id,
676: last_update_date = sysdate,
677: request_id = fnd_global.conc_request_id,
678: program_application_id = fnd_global.prog_appl_id,
679: program_id = fnd_global.conc_program_id,
680: program_update_date = sysdate
681: where rowid = chartorowid(l_schedRecTbl.wrsRowID(i));
682:
683: if(l_status = wip_constants.comp_chrg) then

Line 716: fnd_global.user_id,

712: select p_cplRec.mtlAlcTmpID,
713: wmat.repetitive_schedule_id,
714: wmat.organization_id,
715: sysdate,
716: fnd_global.user_id,
717: sysdate,
718: fnd_global.user_id,
719: fnd_global.login_id,
720: wmat.primary_quantity,

Line 718: fnd_global.user_id,

714: wmat.organization_id,
715: sysdate,
716: fnd_global.user_id,
717: sysdate,
718: fnd_global.user_id,
719: fnd_global.login_id,
720: wmat.primary_quantity,
721: wmat.transaction_quantity,
722: fnd_global.conc_request_id,

Line 719: fnd_global.login_id,

715: sysdate,
716: fnd_global.user_id,
717: sysdate,
718: fnd_global.user_id,
719: fnd_global.login_id,
720: wmat.primary_quantity,
721: wmat.transaction_quantity,
722: fnd_global.conc_request_id,
723: fnd_global.prog_appl_id,

Line 722: fnd_global.conc_request_id,

718: fnd_global.user_id,
719: fnd_global.login_id,
720: wmat.primary_quantity,
721: wmat.transaction_quantity,
722: fnd_global.conc_request_id,
723: fnd_global.prog_appl_id,
724: fnd_global.conc_program_id,
725: wmat.transaction_date
726: from wip_mtl_allocations_temp wmat

Line 723: fnd_global.prog_appl_id,

719: fnd_global.login_id,
720: wmat.primary_quantity,
721: wmat.transaction_quantity,
722: fnd_global.conc_request_id,
723: fnd_global.prog_appl_id,
724: fnd_global.conc_program_id,
725: wmat.transaction_date
726: from wip_mtl_allocations_temp wmat
727: where wmat.transaction_temp_id = p_txnTmpID;

Line 724: fnd_global.conc_program_id,

720: wmat.primary_quantity,
721: wmat.transaction_quantity,
722: fnd_global.conc_request_id,
723: fnd_global.prog_appl_id,
724: fnd_global.conc_program_id,
725: wmat.transaction_date
726: from wip_mtl_allocations_temp wmat
727: where wmat.transaction_temp_id = p_txnTmpID;
728:

Line 855: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,

851: p_cpl_profile => wip_constants.online,
852: p_oc_txn_id => p_cplRec.overCplTxnID,
853: p_parent_cpl_txn_id => p_cplRec.cplTxnID,
854: p_first_schedule_id => l_firstSchedID,
855: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
856: p_login_id => fnd_global.conc_login_id,
857: p_req_id => fnd_global.conc_request_id,
858: p_appl_id => fnd_global.prog_appl_id,
859: p_prog_id => fnd_global.conc_program_id,

Line 856: p_login_id => fnd_global.conc_login_id,

852: p_oc_txn_id => p_cplRec.overCplTxnID,
853: p_parent_cpl_txn_id => p_cplRec.cplTxnID,
854: p_first_schedule_id => l_firstSchedID,
855: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
856: p_login_id => fnd_global.conc_login_id,
857: p_req_id => fnd_global.conc_request_id,
858: p_appl_id => fnd_global.prog_appl_id,
859: p_prog_id => fnd_global.conc_program_id,
860: p_child_txn_id => p_cplrec.movTxnID,

Line 857: p_req_id => fnd_global.conc_request_id,

853: p_parent_cpl_txn_id => p_cplRec.cplTxnID,
854: p_first_schedule_id => l_firstSchedID,
855: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
856: p_login_id => fnd_global.conc_login_id,
857: p_req_id => fnd_global.conc_request_id,
858: p_appl_id => fnd_global.prog_appl_id,
859: p_prog_id => fnd_global.conc_program_id,
860: p_child_txn_id => p_cplrec.movTxnID,
861: p_first_operation_seq_num => l_firstOpSeq,

Line 858: p_appl_id => fnd_global.prog_appl_id,

854: p_first_schedule_id => l_firstSchedID,
855: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
856: p_login_id => fnd_global.conc_login_id,
857: p_req_id => fnd_global.conc_request_id,
858: p_appl_id => fnd_global.prog_appl_id,
859: p_prog_id => fnd_global.conc_program_id,
860: p_child_txn_id => p_cplrec.movTxnID,
861: p_first_operation_seq_num => l_firstOpSeq,
862: p_err_mesg => l_errMsg);

Line 859: p_prog_id => fnd_global.conc_program_id,

855: p_user_id => p_cplRec.lastUpdBy, --fnd_global.user_id,
856: p_login_id => fnd_global.conc_login_id,
857: p_req_id => fnd_global.conc_request_id,
858: p_appl_id => fnd_global.prog_appl_id,
859: p_prog_id => fnd_global.conc_program_id,
860: p_child_txn_id => p_cplrec.movTxnID,
861: p_first_operation_seq_num => l_firstOpSeq,
862: p_err_mesg => l_errMsg);
863:

Line 1235: fnd_global.user_id,

1231: p_cplTxnID,
1232: l_schedRecTbl.repSchedID(j),
1233: l_txnRecTbl.orgID(i),
1234: sysdate,
1235: fnd_global.user_id,
1236: sysdate,
1237: fnd_global.user_id,
1238: fnd_global.login_id,
1239: fnd_global.conc_request_id,

Line 1237: fnd_global.user_id,

1233: l_txnRecTbl.orgID(i),
1234: sysdate,
1235: fnd_global.user_id,
1236: sysdate,
1237: fnd_global.user_id,
1238: fnd_global.login_id,
1239: fnd_global.conc_request_id,
1240: fnd_global.prog_appl_id,
1241: fnd_global.conc_program_id,

Line 1238: fnd_global.login_id,

1234: sysdate,
1235: fnd_global.user_id,
1236: sysdate,
1237: fnd_global.user_id,
1238: fnd_global.login_id,
1239: fnd_global.conc_request_id,
1240: fnd_global.prog_appl_id,
1241: fnd_global.conc_program_id,
1242: sysdate,

Line 1239: fnd_global.conc_request_id,

1235: fnd_global.user_id,
1236: sysdate,
1237: fnd_global.user_id,
1238: fnd_global.login_id,
1239: fnd_global.conc_request_id,
1240: fnd_global.prog_appl_id,
1241: fnd_global.conc_program_id,
1242: sysdate,
1243: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty

Line 1240: fnd_global.prog_appl_id,

1236: sysdate,
1237: fnd_global.user_id,
1238: fnd_global.login_id,
1239: fnd_global.conc_request_id,
1240: fnd_global.prog_appl_id,
1241: fnd_global.conc_program_id,
1242: sysdate,
1243: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty
1244: l_schedQty,

Line 1241: fnd_global.conc_program_id,

1237: fnd_global.user_id,
1238: fnd_global.login_id,
1239: fnd_global.conc_request_id,
1240: fnd_global.prog_appl_id,
1241: fnd_global.conc_program_id,
1242: sysdate,
1243: round(l_txnRecTbl.txnQty(i) * l_schedQty/l_txnRecTbl.priQty(i), wip_constants.inv_max_precision), --% of qty completed * txn Qty
1244: l_schedQty,
1245: l_txnRecTbl.txnDate(i));

Line 1325: fnd_global.user_id,

1321: p_cplTxnID,
1322: l_lastSchedID,
1323: l_txnRecTbl.orgID(i),
1324: sysdate,
1325: fnd_global.user_id,
1326: sysdate,
1327: fnd_global.user_id,
1328: fnd_global.login_id,
1329: fnd_global.conc_request_id,

Line 1327: fnd_global.user_id,

1323: l_txnRecTbl.orgID(i),
1324: sysdate,
1325: fnd_global.user_id,
1326: sysdate,
1327: fnd_global.user_id,
1328: fnd_global.login_id,
1329: fnd_global.conc_request_id,
1330: fnd_global.prog_appl_id,
1331: fnd_global.conc_program_id,

Line 1328: fnd_global.login_id,

1324: sysdate,
1325: fnd_global.user_id,
1326: sysdate,
1327: fnd_global.user_id,
1328: fnd_global.login_id,
1329: fnd_global.conc_request_id,
1330: fnd_global.prog_appl_id,
1331: fnd_global.conc_program_id,
1332: sysdate,

Line 1329: fnd_global.conc_request_id,

1325: fnd_global.user_id,
1326: sysdate,
1327: fnd_global.user_id,
1328: fnd_global.login_id,
1329: fnd_global.conc_request_id,
1330: fnd_global.prog_appl_id,
1331: fnd_global.conc_program_id,
1332: sysdate,
1333: l_txnRecTbl.txnQty(i),

Line 1330: fnd_global.prog_appl_id,

1326: sysdate,
1327: fnd_global.user_id,
1328: fnd_global.login_id,
1329: fnd_global.conc_request_id,
1330: fnd_global.prog_appl_id,
1331: fnd_global.conc_program_id,
1332: sysdate,
1333: l_txnRecTbl.txnQty(i),
1334: l_txnRecTbl.priQty(i),

Line 1331: fnd_global.conc_program_id,

1327: fnd_global.user_id,
1328: fnd_global.login_id,
1329: fnd_global.conc_request_id,
1330: fnd_global.prog_appl_id,
1331: fnd_global.conc_program_id,
1332: sysdate,
1333: l_txnRecTbl.txnQty(i),
1334: l_txnRecTbl.priQty(i),
1335: l_txnRecTbl.txnDate(i));

Line 1466: fnd_global.user_id,

1462: select mmtt.transaction_temp_id,
1463: l_schedID,
1464: mmtt.organization_id,
1465: sysdate,
1466: fnd_global.user_id,
1467: sysdate,
1468: fnd_global.user_id,
1469: fnd_global.login_id,
1470: fnd_global.conc_request_id,

Line 1468: fnd_global.user_id,

1464: mmtt.organization_id,
1465: sysdate,
1466: fnd_global.user_id,
1467: sysdate,
1468: fnd_global.user_id,
1469: fnd_global.login_id,
1470: fnd_global.conc_request_id,
1471: fnd_global.prog_appl_id,
1472: fnd_global.conc_program_id,

Line 1469: fnd_global.login_id,

1465: sysdate,
1466: fnd_global.user_id,
1467: sysdate,
1468: fnd_global.user_id,
1469: fnd_global.login_id,
1470: fnd_global.conc_request_id,
1471: fnd_global.prog_appl_id,
1472: fnd_global.conc_program_id,
1473: sysdate,

Line 1470: fnd_global.conc_request_id,

1466: fnd_global.user_id,
1467: sysdate,
1468: fnd_global.user_id,
1469: fnd_global.login_id,
1470: fnd_global.conc_request_id,
1471: fnd_global.prog_appl_id,
1472: fnd_global.conc_program_id,
1473: sysdate,
1474: mmtt.transaction_quantity,

Line 1471: fnd_global.prog_appl_id,

1467: sysdate,
1468: fnd_global.user_id,
1469: fnd_global.login_id,
1470: fnd_global.conc_request_id,
1471: fnd_global.prog_appl_id,
1472: fnd_global.conc_program_id,
1473: sysdate,
1474: mmtt.transaction_quantity,
1475: mmtt.primary_quantity,

Line 1472: fnd_global.conc_program_id,

1468: fnd_global.user_id,
1469: fnd_global.login_id,
1470: fnd_global.conc_request_id,
1471: fnd_global.prog_appl_id,
1472: fnd_global.conc_program_id,
1473: sysdate,
1474: mmtt.transaction_quantity,
1475: mmtt.primary_quantity,
1476: mmtt.transaction_date

Line 1502: fnd_global.user_id,

1498: select mti.transaction_interface_id,
1499: l_schedID,
1500: mti.organization_id,
1501: sysdate,
1502: fnd_global.user_id,
1503: sysdate,
1504: fnd_global.user_id,
1505: fnd_global.login_id,
1506: fnd_global.conc_request_id,

Line 1504: fnd_global.user_id,

1500: mti.organization_id,
1501: sysdate,
1502: fnd_global.user_id,
1503: sysdate,
1504: fnd_global.user_id,
1505: fnd_global.login_id,
1506: fnd_global.conc_request_id,
1507: fnd_global.prog_appl_id,
1508: fnd_global.conc_program_id,

Line 1505: fnd_global.login_id,

1501: sysdate,
1502: fnd_global.user_id,
1503: sysdate,
1504: fnd_global.user_id,
1505: fnd_global.login_id,
1506: fnd_global.conc_request_id,
1507: fnd_global.prog_appl_id,
1508: fnd_global.conc_program_id,
1509: sysdate,

Line 1506: fnd_global.conc_request_id,

1502: fnd_global.user_id,
1503: sysdate,
1504: fnd_global.user_id,
1505: fnd_global.login_id,
1506: fnd_global.conc_request_id,
1507: fnd_global.prog_appl_id,
1508: fnd_global.conc_program_id,
1509: sysdate,
1510: mti.transaction_quantity,

Line 1507: fnd_global.prog_appl_id,

1503: sysdate,
1504: fnd_global.user_id,
1505: fnd_global.login_id,
1506: fnd_global.conc_request_id,
1507: fnd_global.prog_appl_id,
1508: fnd_global.conc_program_id,
1509: sysdate,
1510: mti.transaction_quantity,
1511: mti.primary_quantity,

Line 1508: fnd_global.conc_program_id,

1504: fnd_global.user_id,
1505: fnd_global.login_id,
1506: fnd_global.conc_request_id,
1507: fnd_global.prog_appl_id,
1508: fnd_global.conc_program_id,
1509: sysdate,
1510: mti.transaction_quantity,
1511: mti.primary_quantity,
1512: mti.transaction_date