APPS.JAI_PO_OSP_PKG dependencies on FND_GLOBAL

Line 484: fnd_global.user_id ,

480: 'N',
481: 'N',
482: 'N',
483: sysdate,
484: fnd_global.user_id ,
485: sysdate ,
486: fnd_global.user_id ,
487: fnd_global.login_id,
488: p_po_release_id,

Line 486: fnd_global.user_id ,

482: 'N',
483: sysdate,
484: fnd_global.user_id ,
485: sysdate ,
486: fnd_global.user_id ,
487: fnd_global.login_id,
488: p_po_release_id,
489: 'Y'
490: );

Line 487: fnd_global.login_id,

483: sysdate,
484: fnd_global.user_id ,
485: sysdate ,
486: fnd_global.user_id ,
487: fnd_global.login_id,
488: p_po_release_id,
489: 'Y'
490: );
491:

Line 660: fnd_global.user_id ,

656: ln_item_Value ,
657: lv_tariff_code ,
658: nvl(ln_osp_excise_percent,0) ,
659: sysdate ,
660: fnd_global.user_id ,
661: fnd_global.user_id ,
662: sysdate ,
663: fnd_global.login_id ,
664: ln_parent_item_id ,

Line 661: fnd_global.user_id ,

657: lv_tariff_code ,
658: nvl(ln_osp_excise_percent,0) ,
659: sysdate ,
660: fnd_global.user_id ,
661: fnd_global.user_id ,
662: sysdate ,
663: fnd_global.login_id ,
664: ln_parent_item_id ,
665: c_component_rec.quantity_per_assembly,

Line 663: fnd_global.login_id ,

659: sysdate ,
660: fnd_global.user_id ,
661: fnd_global.user_id ,
662: sysdate ,
663: fnd_global.login_id ,
664: ln_parent_item_id ,
665: c_component_rec.quantity_per_assembly,
666: ln_bal_parent_item_qty ,
667: lv_source_code ,

Line 709: ,last_updated_by = fnd_global.user_id

705: /* cancel the OSP Challan */
706: UPDATE JAI_PO_OSP_HDRS
707: SET cancel_flag = 'Y'
708: ,last_update_date = sysdate
709: ,last_updated_by = fnd_global.user_id
710: ,last_update_login= fnd_global.login_id
711: WHERE form_id = p_form_id
712: OR (primary_form_id = p_form_id
713: AND source <> lv_rtv_source

Line 710: ,last_update_login= fnd_global.login_id

706: UPDATE JAI_PO_OSP_HDRS
707: SET cancel_flag = 'Y'
708: ,last_update_date = sysdate
709: ,last_updated_by = fnd_global.user_id
710: ,last_update_login= fnd_global.login_id
711: WHERE form_id = p_form_id
712: OR (primary_form_id = p_form_id
713: AND source <> lv_rtv_source
714: );

Line 910: v_created_by := fnd_global.user_id;

906: open c_base_trx(p_transaction_id);
907: fetch c_base_trx into r_base_trx;
908: close c_base_trx;
909:
910: v_created_by := fnd_global.user_id;
911: v_creation_dt := sysdate;
912: v_last_upd_dt := sysdate;
913: v_last_upd_by := fnd_global.user_id;
914: v_last_upd_lgin := fnd_global.login_id;

Line 913: v_last_upd_by := fnd_global.user_id;

909:
910: v_created_by := fnd_global.user_id;
911: v_creation_dt := sysdate;
912: v_last_upd_dt := sysdate;
913: v_last_upd_by := fnd_global.user_id;
914: v_last_upd_lgin := fnd_global.login_id;
915:
916: v_organization_id := r_base_trx.organization_id;
917: v_po_header := r_base_trx.po_header_id;

Line 914: v_last_upd_lgin := fnd_global.login_id;

910: v_created_by := fnd_global.user_id;
911: v_creation_dt := sysdate;
912: v_last_upd_dt := sysdate;
913: v_last_upd_by := fnd_global.user_id;
914: v_last_upd_lgin := fnd_global.login_id;
915:
916: v_organization_id := r_base_trx.organization_id;
917: v_po_header := r_base_trx.po_header_id;
918: v_po_release_id := r_base_trx.po_release_id;