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.JMF_SHIKYU_ALLOCATION_PVT dependencies on FND_GLOBAL

Line 490: , FND_GLOBAL.user_id

486: , p_replen_so_line_id
487: , l_qty_to_allocate
488: , l_primary_uom
489: , sysdate
490: , FND_GLOBAL.user_id
491: , sysdate
492: , FND_GLOBAL.user_id
493: , FND_GLOBAL.login_id
494: );

Line 492: , FND_GLOBAL.user_id

488: , l_primary_uom
489: , sysdate
490: , FND_GLOBAL.user_id
491: , sysdate
492: , FND_GLOBAL.user_id
493: , FND_GLOBAL.login_id
494: );
495:
496: -- If previous allocations have been created between the Subcontracting

Line 493: , FND_GLOBAL.login_id

489: , sysdate
490: , FND_GLOBAL.user_id
491: , sysdate
492: , FND_GLOBAL.user_id
493: , FND_GLOBAL.login_id
494: );
495:
496: -- If previous allocations have been created between the Subcontracting
497: -- Order Shipment and the Replenishment Order Line

Line 504: last_updated_by = FND_GLOBAL.user_id,

500:
501: UPDATE jmf_shikyu_allocations
502: SET allocated_quantity = l_allocation_qty,
503: last_update_date = sysdate,
504: last_updated_by = FND_GLOBAL.user_id,
505: last_update_login = FND_GLOBAL.login_id
506: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
507: AND replenishment_so_line_id = p_replen_so_line_id
508: AND shikyu_component_id = p_component_id;

Line 505: last_update_login = FND_GLOBAL.login_id

501: UPDATE jmf_shikyu_allocations
502: SET allocated_quantity = l_allocation_qty,
503: last_update_date = sysdate,
504: last_updated_by = FND_GLOBAL.user_id,
505: last_update_login = FND_GLOBAL.login_id
506: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
507: AND replenishment_so_line_id = p_replen_so_line_id
508: AND shikyu_component_id = p_component_id;
509:

Line 580: last_updated_by = FND_GLOBAL.user_id,

576: UPDATE JMF_SHIKYU_REPLENISHMENTS
577: SET allocated_primary_uom_quantity = l_replen_allocated_primary_qty,
578: allocated_quantity = l_replen_allocated_qty,
579: last_update_date = sysdate,
580: last_updated_by = FND_GLOBAL.user_id,
581: last_update_login = FND_GLOBAL.login_id
582: WHERE replenishment_so_line_id = p_replen_so_line_id;
583:
584: IF (g_fnd_debug = 'Y' AND

Line 581: last_update_login = FND_GLOBAL.login_id

577: SET allocated_primary_uom_quantity = l_replen_allocated_primary_qty,
578: allocated_quantity = l_replen_allocated_qty,
579: last_update_date = sysdate,
580: last_updated_by = FND_GLOBAL.user_id,
581: last_update_login = FND_GLOBAL.login_id
582: WHERE replenishment_so_line_id = p_replen_so_line_id;
583:
584: IF (g_fnd_debug = 'Y' AND
585: FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE)

Line 3119: last_updated_by = FND_GLOBAL.user_id,

3115: SET allocated_quantity = allocated_quantity - l_deleted_primary_uom_qty,
3116: allocated_primary_uom_quantity
3117: = allocated_primary_uom_quantity - x_deleted_allocations_tbl(l_tbl_index).qty,
3118: last_update_date = sysdate,
3119: last_updated_by = FND_GLOBAL.user_id,
3120: last_update_login = FND_GLOBAL.login_id
3121: WHERE replenishment_so_line_id = x_deleted_allocations_tbl(l_tbl_index).replenishment_so_line_id;
3122:
3123: l_tbl_index := x_deleted_allocations_tbl.next(l_tbl_index);

Line 3120: last_update_login = FND_GLOBAL.login_id

3116: allocated_primary_uom_quantity
3117: = allocated_primary_uom_quantity - x_deleted_allocations_tbl(l_tbl_index).qty,
3118: last_update_date = sysdate,
3119: last_updated_by = FND_GLOBAL.user_id,
3120: last_update_login = FND_GLOBAL.login_id
3121: WHERE replenishment_so_line_id = x_deleted_allocations_tbl(l_tbl_index).replenishment_so_line_id;
3122:
3123: l_tbl_index := x_deleted_allocations_tbl.next(l_tbl_index);
3124: EXIT WHEN l_tbl_index IS NULL;

Line 3416: last_updated_by = FND_GLOBAL.user_id,

3412: SET allocable_quantity = l_closed_so_line_rec.qty,
3413: allocable_primary_uom_quantity = l_closed_so_line_rec.primary_uom_qty,
3414: status = 'CLOSED',
3415: last_update_date = sysdate,
3416: last_updated_by = FND_GLOBAL.user_id,
3417: last_update_login = FND_GLOBAL.login_id
3418: WHERE replenishment_so_line_id = l_closed_so_line_rec.replenishment_so_line_id;
3419:
3420: --Bugfix 14078692: Committing the successful transaction.

Line 3417: last_update_login = FND_GLOBAL.login_id

3413: allocable_primary_uom_quantity = l_closed_so_line_rec.primary_uom_qty,
3414: status = 'CLOSED',
3415: last_update_date = sysdate,
3416: last_updated_by = FND_GLOBAL.user_id,
3417: last_update_login = FND_GLOBAL.login_id
3418: WHERE replenishment_so_line_id = l_closed_so_line_rec.replenishment_so_line_id;
3419:
3420: --Bugfix 14078692: Committing the successful transaction.
3421: commit;

Line 3655: last_updated_by = FND_GLOBAL.user_id,

3651: UPDATE JMF_SHIKYU_REPLENISHMENTS
3652: SET allocable_quantity = l_allocable_qty,
3653: allocable_primary_uom_quantity = l_allocable_primary_qty,
3654: last_update_date = sysdate,
3655: last_updated_by = FND_GLOBAL.user_id,
3656: last_update_login = FND_GLOBAL.login_id
3657: WHERE replenishment_so_line_id = p_replen_order_line_id;
3658: RETURN;
3659: END IF;

Line 3656: last_update_login = FND_GLOBAL.login_id

3652: SET allocable_quantity = l_allocable_qty,
3653: allocable_primary_uom_quantity = l_allocable_primary_qty,
3654: last_update_date = sysdate,
3655: last_updated_by = FND_GLOBAL.user_id,
3656: last_update_login = FND_GLOBAL.login_id
3657: WHERE replenishment_so_line_id = p_replen_order_line_id;
3658: RETURN;
3659: END IF;
3660: /*

Line 3712: last_updated_by = FND_GLOBAL.user_id,

3708: allocable_primary_uom_quantity = 0,
3709: allocated_quantity = 0,
3710: allocated_primary_uom_quantity = 0,
3711: last_update_date = sysdate,
3712: last_updated_by = FND_GLOBAL.user_id,
3713: last_update_login = FND_GLOBAL.login_id
3714: WHERE replenishment_so_line_id = p_replen_order_line_id;
3715:
3716: -- Loop through the table containing the subcontracting orders

Line 3713: last_update_login = FND_GLOBAL.login_id

3709: allocated_quantity = 0,
3710: allocated_primary_uom_quantity = 0,
3711: last_update_date = sysdate,
3712: last_updated_by = FND_GLOBAL.user_id,
3713: last_update_login = FND_GLOBAL.login_id
3714: WHERE replenishment_so_line_id = p_replen_order_line_id;
3715:
3716: -- Loop through the table containing the subcontracting orders
3717: -- being deallocated by the Delete_Allocations procedure,

Line 3813: last_updated_by = FND_GLOBAL.user_id,

3809: UPDATE JMF_SHIKYU_REPLENISHMENTS
3810: SET allocable_quantity = l_allocable_qty,
3811: allocable_primary_uom_quantity = l_allocable_primary_qty,
3812: last_update_date = sysdate,
3813: last_updated_by = FND_GLOBAL.user_id,
3814: last_update_login = FND_GLOBAL.login_id
3815: WHERE replenishment_so_line_id = p_replen_order_line_id;
3816:
3817: OPEN c_subcontract_po_allocations;

Line 3814: last_update_login = FND_GLOBAL.login_id

3810: SET allocable_quantity = l_allocable_qty,
3811: allocable_primary_uom_quantity = l_allocable_primary_qty,
3812: last_update_date = sysdate,
3813: last_updated_by = FND_GLOBAL.user_id,
3814: last_update_login = FND_GLOBAL.login_id
3815: WHERE replenishment_so_line_id = p_replen_order_line_id;
3816:
3817: OPEN c_subcontract_po_allocations;
3818:

Line 4322: last_updated_by = FND_GLOBAL.user_id,

4318: allocable_primary_uom_quantity = l_primary_uom_qty,
4319: ordered_quantity = C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity,
4320: ordered_primary_uom_quantity = l_primary_uom_qty,
4321: last_update_date = sysdate,
4322: last_updated_by = FND_GLOBAL.user_id,
4323: last_update_login = FND_GLOBAL.login_id
4324: WHERE REPLENISHMENT_SO_LINE_ID = C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID;
4325:
4326: IF g_fnd_debug = 'Y' AND

Line 4323: last_update_login = FND_GLOBAL.login_id

4319: ordered_quantity = C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity,
4320: ordered_primary_uom_quantity = l_primary_uom_qty,
4321: last_update_date = sysdate,
4322: last_updated_by = FND_GLOBAL.user_id,
4323: last_update_login = FND_GLOBAL.login_id
4324: WHERE REPLENISHMENT_SO_LINE_ID = C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID;
4325:
4326: IF g_fnd_debug = 'Y' AND
4327: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 4433: last_updated_by = FND_GLOBAL.user_id,

4429: allocated_primary_uom_quantity = 0,
4430: ordered_quantity = 0,
4431: ordered_primary_uom_quantity = 0,
4432: last_update_date = sysdate,
4433: last_updated_by = FND_GLOBAL.user_id,
4434: last_update_login = FND_GLOBAL.login_id
4435: WHERE replenishment_so_line_id = C_SHIKYU_REPLENISHMENT_REC.replenishment_so_line_id
4436: AND replenishment_so_header_id = C_SHIKYU_REPLENISHMENT_REC.replenishment_so_header_id ;
4437:

Line 4434: last_update_login = FND_GLOBAL.login_id

4430: ordered_quantity = 0,
4431: ordered_primary_uom_quantity = 0,
4432: last_update_date = sysdate,
4433: last_updated_by = FND_GLOBAL.user_id,
4434: last_update_login = FND_GLOBAL.login_id
4435: WHERE replenishment_so_line_id = C_SHIKYU_REPLENISHMENT_REC.replenishment_so_line_id
4436: AND replenishment_so_header_id = C_SHIKYU_REPLENISHMENT_REC.replenishment_so_header_id ;
4437:
4438: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 4597: last_updated_by = FND_GLOBAL.user_id,

4593: allocable_primary_uom_quantity = l_primary_uom_qty,
4594: ordered_quantity = C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity,
4595: ordered_primary_uom_quantity = l_primary_uom_qty,
4596: last_update_date = sysdate,
4597: last_updated_by = FND_GLOBAL.user_id,
4598: last_update_login = FND_GLOBAL.login_id
4599: WHERE REPLENISHMENT_SO_LINE_ID = C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID;
4600:
4601: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 4598: last_update_login = FND_GLOBAL.login_id

4594: ordered_quantity = C_SHIKYU_REPLENISHMENT_rec.oel_ordered_quantity,
4595: ordered_primary_uom_quantity = l_primary_uom_qty,
4596: last_update_date = sysdate,
4597: last_updated_by = FND_GLOBAL.user_id,
4598: last_update_login = FND_GLOBAL.login_id
4599: WHERE REPLENISHMENT_SO_LINE_ID = C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID;
4600:
4601: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4602: THEN

Line 5196: , FND_GLOBAL.user_id

5192: , l_org_id
5193: , p_additional_supply
5194: , NULL
5195: , SYSDATE
5196: , FND_GLOBAL.user_id
5197: , SYSDATE
5198: , FND_GLOBAL.user_id
5199: , FND_GLOBAL.login_id
5200: );

Line 5198: , FND_GLOBAL.user_id

5194: , NULL
5195: , SYSDATE
5196: , FND_GLOBAL.user_id
5197: , SYSDATE
5198: , FND_GLOBAL.user_id
5199: , FND_GLOBAL.login_id
5200: );
5201:
5202: IF (g_fnd_debug = 'Y' AND

Line 5199: , FND_GLOBAL.login_id

5195: , SYSDATE
5196: , FND_GLOBAL.user_id
5197: , SYSDATE
5198: , FND_GLOBAL.user_id
5199: , FND_GLOBAL.login_id
5200: );
5201:
5202: IF (g_fnd_debug = 'Y' AND
5203: FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE)

Line 5756: last_updated_by = FND_GLOBAL.user_id,

5752: then
5753: update jmf_shikyu_replenishments
5754: set schedule_ship_date = so_date_change_rec.om_schedule_ship_date,
5755: last_update_date = sysdate,
5756: last_updated_by = FND_GLOBAL.user_id,
5757: last_update_login = FND_GLOBAL.login_id
5758: where replenishment_so_line_id = l_line_id;
5759:
5760: l_cnt := sql%rowcount;

Line 5757: last_update_login = FND_GLOBAL.login_id

5753: update jmf_shikyu_replenishments
5754: set schedule_ship_date = so_date_change_rec.om_schedule_ship_date,
5755: last_update_date = sysdate,
5756: last_updated_by = FND_GLOBAL.user_id,
5757: last_update_login = FND_GLOBAL.login_id
5758: where replenishment_so_line_id = l_line_id;
5759:
5760: l_cnt := sql%rowcount;
5761:

Line 5924: last_updated_by = FND_GLOBAL.user_id,

5920: if l_deletion_failed = 0 then
5921: update jmf_shikyu_replenishments
5922: set schedule_ship_date = so_date_change_rec.om_schedule_ship_date,
5923: last_update_date = sysdate,
5924: last_updated_by = FND_GLOBAL.user_id,
5925: last_update_login = FND_GLOBAL.login_id
5926: where replenishment_so_line_id = l_line_id;
5927:
5928: l_cnt := sql%rowcount;

Line 5925: last_update_login = FND_GLOBAL.login_id

5921: update jmf_shikyu_replenishments
5922: set schedule_ship_date = so_date_change_rec.om_schedule_ship_date,
5923: last_update_date = sysdate,
5924: last_updated_by = FND_GLOBAL.user_id,
5925: last_update_login = FND_GLOBAL.login_id
5926: where replenishment_so_line_id = l_line_id;
5927:
5928: l_cnt := sql%rowcount;
5929: if FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL