DBA Data[Home] [Help]

APPS.WIP_CPLPROC_PRIV dependencies on FND_GLOBAL

Line 402: last_updated_by = fnd_global.user_id,

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,

Line 404: request_id = fnd_global.conc_request_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;

Line 405: program_application_id = fnd_global.prog_appl_id,

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:

Line 406: program_id = fnd_global.conc_program_id,

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

Line 428: last_updated_by = fnd_global.user_id,

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,

Line 430: request_id = fnd_global.conc_request_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;

Line 431: program_application_id = fnd_global.prog_appl_id,

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)

Line 432: program_id = fnd_global.conc_program_id,

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

Line 615: last_updated_by = fnd_global.user_id,

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,

Line 617: request_id = fnd_global.conc_request_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))

Line 618: program_application_id = fnd_global.prog_appl_id,

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;

Line 619: program_id = fnd_global.conc_program_id,

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:

Line 650: last_updated_by = fnd_global.user_id,

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,

Line 652: request_id = fnd_global.conc_request_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));

Line 653: program_application_id = fnd_global.prog_appl_id,

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:

Line 654: program_id = fnd_global.conc_program_id,

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

Line 691: fnd_global.user_id,

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,

Line 693: fnd_global.user_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,
696: wmat.transaction_quantity,
697: fnd_global.conc_request_id,

Line 694: fnd_global.login_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,

Line 697: fnd_global.conc_request_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

Line 698: fnd_global.prog_appl_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
702: where wmat.transaction_temp_id = p_txnTmpID;

Line 699: fnd_global.conc_program_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;
703:

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

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,

Line 830: p_login_id => fnd_global.conc_login_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,

Line 831: p_req_id => fnd_global.conc_request_id,

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,

Line 832: p_appl_id => fnd_global.prog_appl_id,

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

Line 833: p_prog_id => fnd_global.conc_program_id,

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:

Line 1209: fnd_global.user_id,

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,

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

Line 1212: fnd_global.login_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,

Line 1213: fnd_global.conc_request_id,

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

Line 1214: fnd_global.prog_appl_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
1218: l_schedQty,

Line 1215: fnd_global.conc_program_id,

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

Line 1299: fnd_global.user_id,

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,

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

Line 1302: fnd_global.login_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,

Line 1303: fnd_global.conc_request_id,

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

Line 1304: fnd_global.prog_appl_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),
1308: l_txnRecTbl.priQty(i),

Line 1305: fnd_global.conc_program_id,

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

Line 1440: fnd_global.user_id,

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,

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

Line 1443: fnd_global.login_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,

Line 1444: fnd_global.conc_request_id,

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,

Line 1445: fnd_global.prog_appl_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,
1449: mmtt.primary_quantity,

Line 1446: fnd_global.conc_program_id,

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

Line 1476: fnd_global.user_id,

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,

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

Line 1479: fnd_global.login_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,

Line 1480: fnd_global.conc_request_id,

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,

Line 1481: fnd_global.prog_appl_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,
1485: mti.primary_quantity,

Line 1482: fnd_global.conc_program_id,

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