APPS.JMF_SHIKYU_WIP_PVT dependencies on FND_GLOBAL

Line 509: , FND_GLOBAL.USER_ID

505: )
506: VALUES
507: ( DECODE(p_action,'U',to_date(null),'D',to_date(null),l_start_date) -- Bug 9244436. Used to_date for proper conversion
508: , sysdate
509: , FND_GLOBAL.USER_ID
510: , sysdate
511: , FND_GLOBAL.USER_ID
512: , FND_GLOBAL.USER_NAME
513: , FND_GLOBAL.USER_NAME

Line 511: , FND_GLOBAL.USER_ID

507: ( DECODE(p_action,'U',to_date(null),'D',to_date(null),l_start_date) -- Bug 9244436. Used to_date for proper conversion
508: , sysdate
509: , FND_GLOBAL.USER_ID
510: , sysdate
511: , FND_GLOBAL.USER_ID
512: , FND_GLOBAL.USER_NAME
513: , FND_GLOBAL.USER_NAME
514: , FND_GLOBAL.USER_ID
515: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,

Line 512: , FND_GLOBAL.USER_NAME

508: , sysdate
509: , FND_GLOBAL.USER_ID
510: , sysdate
511: , FND_GLOBAL.USER_ID
512: , FND_GLOBAL.USER_NAME
513: , FND_GLOBAL.USER_NAME
514: , FND_GLOBAL.USER_ID
515: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,
516: 'D',l_subcontract_orders_rec.wip_entity_id,null)

Line 513: , FND_GLOBAL.USER_NAME

509: , FND_GLOBAL.USER_ID
510: , sysdate
511: , FND_GLOBAL.USER_ID
512: , FND_GLOBAL.USER_NAME
513: , FND_GLOBAL.USER_NAME
514: , FND_GLOBAL.USER_ID
515: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,
516: 'D',l_subcontract_orders_rec.wip_entity_id,null)
517: , 1

Line 514: , FND_GLOBAL.USER_ID

510: , sysdate
511: , FND_GLOBAL.USER_ID
512: , FND_GLOBAL.USER_NAME
513: , FND_GLOBAL.USER_NAME
514: , FND_GLOBAL.USER_ID
515: , DECODE(p_action,'U',l_subcontract_orders_rec.wip_entity_id,
516: 'D',l_subcontract_orders_rec.wip_entity_id,null)
517: , 1
518: , DECODE(p_action,'C',l_start_date,l_orig_start_date)

Line 556: , last_updated_by = FND_GLOBAL.user_id

552: -- Update JMF table with the wip job # if successful.
553: UPDATE jmf_subcontract_orders
554: SET wip_entity_id = l_wip_entity_id
555: , last_update_date = sysdate
556: , last_updated_by = FND_GLOBAL.user_id
557: , last_update_login = FND_GLOBAL.login_id
558: WHERE subcontract_po_shipment_id =
559: l_subcontract_orders_rec.subcontract_po_shipment_id;
560:

Line 557: , last_update_login = FND_GLOBAL.login_id

553: UPDATE jmf_subcontract_orders
554: SET wip_entity_id = l_wip_entity_id
555: , last_update_date = sysdate
556: , last_updated_by = FND_GLOBAL.user_id
557: , last_update_login = FND_GLOBAL.login_id
558: WHERE subcontract_po_shipment_id =
559: l_subcontract_orders_rec.subcontract_po_shipment_id;
560:
561: --Debugging for bug 9315131

Line 652: , FND_GLOBAL.USER_ID

648: )
649: VALUES
650: ( l_start_date
651: , sysdate
652: , FND_GLOBAL.USER_ID
653: , sysdate
654: , FND_GLOBAL.USER_ID
655: , FND_GLOBAL.USER_NAME
656: , FND_GLOBAL.USER_NAME

Line 654: , FND_GLOBAL.USER_ID

650: ( l_start_date
651: , sysdate
652: , FND_GLOBAL.USER_ID
653: , sysdate
654: , FND_GLOBAL.USER_ID
655: , FND_GLOBAL.USER_NAME
656: , FND_GLOBAL.USER_NAME
657: , FND_GLOBAL.USER_ID
658: , l_subcontract_orders_rec.wip_entity_id

Line 655: , FND_GLOBAL.USER_NAME

651: , sysdate
652: , FND_GLOBAL.USER_ID
653: , sysdate
654: , FND_GLOBAL.USER_ID
655: , FND_GLOBAL.USER_NAME
656: , FND_GLOBAL.USER_NAME
657: , FND_GLOBAL.USER_ID
658: , l_subcontract_orders_rec.wip_entity_id
659: , 1

Line 656: , FND_GLOBAL.USER_NAME

652: , FND_GLOBAL.USER_ID
653: , sysdate
654: , FND_GLOBAL.USER_ID
655: , FND_GLOBAL.USER_NAME
656: , FND_GLOBAL.USER_NAME
657: , FND_GLOBAL.USER_ID
658: , l_subcontract_orders_rec.wip_entity_id
659: , 1
660: , l_start_date

Line 657: , FND_GLOBAL.USER_ID

653: , sysdate
654: , FND_GLOBAL.USER_ID
655: , FND_GLOBAL.USER_NAME
656: , FND_GLOBAL.USER_NAME
657: , FND_GLOBAL.USER_ID
658: , l_subcontract_orders_rec.wip_entity_id
659: , 1
660: , l_start_date
661: , l_group_id