APPS.JMF_SHIKYU_WIP_PVT dependencies on FND_GLOBAL

Line 459: , FND_GLOBAL.USER_ID

455: )
456: VALUES
457: ( DECODE(p_action,'U',null,'D',null,l_start_date)
458: , sysdate
459: , FND_GLOBAL.USER_ID
460: , sysdate
461: , FND_GLOBAL.USER_ID
462: , FND_GLOBAL.USER_NAME
463: , FND_GLOBAL.USER_NAME

Line 461: , FND_GLOBAL.USER_ID

457: ( DECODE(p_action,'U',null,'D',null,l_start_date)
458: , sysdate
459: , FND_GLOBAL.USER_ID
460: , sysdate
461: , FND_GLOBAL.USER_ID
462: , FND_GLOBAL.USER_NAME
463: , FND_GLOBAL.USER_NAME
464: , FND_GLOBAL.USER_ID
465: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,

Line 462: , FND_GLOBAL.USER_NAME

458: , sysdate
459: , FND_GLOBAL.USER_ID
460: , sysdate
461: , FND_GLOBAL.USER_ID
462: , FND_GLOBAL.USER_NAME
463: , FND_GLOBAL.USER_NAME
464: , FND_GLOBAL.USER_ID
465: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,
466: 'D',l_subcontract_orders_rec.wip_entity_id,null)

Line 463: , FND_GLOBAL.USER_NAME

459: , FND_GLOBAL.USER_ID
460: , sysdate
461: , FND_GLOBAL.USER_ID
462: , FND_GLOBAL.USER_NAME
463: , FND_GLOBAL.USER_NAME
464: , FND_GLOBAL.USER_ID
465: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,
466: 'D',l_subcontract_orders_rec.wip_entity_id,null)
467: , 1

Line 464: , FND_GLOBAL.USER_ID

460: , sysdate
461: , FND_GLOBAL.USER_ID
462: , FND_GLOBAL.USER_NAME
463: , FND_GLOBAL.USER_NAME
464: , FND_GLOBAL.USER_ID
465: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,
466: 'D',l_subcontract_orders_rec.wip_entity_id,null)
467: , 1
468: , DECODE(p_action,'C',l_start_date,l_orig_start_date)

Line 506: , last_updated_by = FND_GLOBAL.user_id

502: -- Update JMF table with the wip job # if successful.
503: UPDATE jmf_subcontract_orders
504: SET wip_entity_id = l_wip_entity_id
505: , last_update_date = sysdate
506: , last_updated_by = FND_GLOBAL.user_id
507: , last_update_login = FND_GLOBAL.login_id
508: WHERE subcontract_po_shipment_id =
509: l_subcontract_orders_rec.subcontract_po_shipment_id;
510: ELSE

Line 507: , last_update_login = FND_GLOBAL.login_id

503: UPDATE jmf_subcontract_orders
504: SET wip_entity_id = l_wip_entity_id
505: , last_update_date = sysdate
506: , last_updated_by = FND_GLOBAL.user_id
507: , last_update_login = FND_GLOBAL.login_id
508: WHERE subcontract_po_shipment_id =
509: l_subcontract_orders_rec.subcontract_po_shipment_id;
510: ELSE
511: FND_MESSAGE.set_name('JMF', 'JMF_SHK_WIP_CREATION_ERR');

Line 567: , FND_GLOBAL.USER_ID

563: )
564: VALUES
565: ( l_start_date
566: , sysdate
567: , FND_GLOBAL.USER_ID
568: , sysdate
569: , FND_GLOBAL.USER_ID
570: , FND_GLOBAL.USER_NAME
571: , FND_GLOBAL.USER_NAME

Line 569: , FND_GLOBAL.USER_ID

565: ( l_start_date
566: , sysdate
567: , FND_GLOBAL.USER_ID
568: , sysdate
569: , FND_GLOBAL.USER_ID
570: , FND_GLOBAL.USER_NAME
571: , FND_GLOBAL.USER_NAME
572: , FND_GLOBAL.USER_ID
573: , l_subcontract_orders_rec.wip_entity_id

Line 570: , FND_GLOBAL.USER_NAME

566: , sysdate
567: , FND_GLOBAL.USER_ID
568: , sysdate
569: , FND_GLOBAL.USER_ID
570: , FND_GLOBAL.USER_NAME
571: , FND_GLOBAL.USER_NAME
572: , FND_GLOBAL.USER_ID
573: , l_subcontract_orders_rec.wip_entity_id
574: , 1

Line 571: , FND_GLOBAL.USER_NAME

567: , FND_GLOBAL.USER_ID
568: , sysdate
569: , FND_GLOBAL.USER_ID
570: , FND_GLOBAL.USER_NAME
571: , FND_GLOBAL.USER_NAME
572: , FND_GLOBAL.USER_ID
573: , l_subcontract_orders_rec.wip_entity_id
574: , 1
575: , l_start_date

Line 572: , FND_GLOBAL.USER_ID

568: , sysdate
569: , FND_GLOBAL.USER_ID
570: , FND_GLOBAL.USER_NAME
571: , FND_GLOBAL.USER_NAME
572: , FND_GLOBAL.USER_ID
573: , l_subcontract_orders_rec.wip_entity_id
574: , 1
575: , l_start_date
576: , l_group_id