APPS.JAI_PO_OSP_PKG dependencies on FND_GLOBAL

Line 582: fnd_global.user_id ,

578: 'N',
579: 'N',
580: 'N',
581: sysdate,
582: fnd_global.user_id ,
583: sysdate ,
584: fnd_global.user_id ,
585: fnd_global.login_id,
586: p_po_release_id,

Line 584: fnd_global.user_id ,

580: 'N',
581: sysdate,
582: fnd_global.user_id ,
583: sysdate ,
584: fnd_global.user_id ,
585: fnd_global.login_id,
586: p_po_release_id,
587: 'Y',
588: sysdate -- added for bug 8303018

Line 585: fnd_global.login_id,

581: sysdate,
582: fnd_global.user_id ,
583: sysdate ,
584: fnd_global.user_id ,
585: fnd_global.login_id,
586: p_po_release_id,
587: 'Y',
588: sysdate -- added for bug 8303018
589: );

Line 771: fnd_global.user_id ,

767: ln_item_Value ,
768: lv_tariff_code ,
769: nvl(ln_osp_excise_percent,0) ,
770: sysdate ,
771: fnd_global.user_id ,
772: fnd_global.user_id ,
773: sysdate ,
774: fnd_global.login_id ,
775: ln_parent_item_id ,

Line 772: fnd_global.user_id ,

768: lv_tariff_code ,
769: nvl(ln_osp_excise_percent,0) ,
770: sysdate ,
771: fnd_global.user_id ,
772: fnd_global.user_id ,
773: sysdate ,
774: fnd_global.login_id ,
775: ln_parent_item_id ,
776: c_component_rec.quantity_per_assembly,

Line 774: fnd_global.login_id ,

770: sysdate ,
771: fnd_global.user_id ,
772: fnd_global.user_id ,
773: sysdate ,
774: fnd_global.login_id ,
775: ln_parent_item_id ,
776: c_component_rec.quantity_per_assembly,
777: ln_bal_parent_item_qty ,
778: lv_source_code ,

Line 820: ,last_updated_by = fnd_global.user_id

816: /* cancel the OSP Challan */
817: UPDATE JAI_PO_OSP_HDRS
818: SET cancel_flag = 'Y'
819: ,last_update_date = sysdate
820: ,last_updated_by = fnd_global.user_id
821: ,last_update_login= fnd_global.login_id
822: WHERE form_id = p_form_id
823: OR (primary_form_id = p_form_id
824: AND source <> lv_rtv_source

Line 821: ,last_update_login= fnd_global.login_id

817: UPDATE JAI_PO_OSP_HDRS
818: SET cancel_flag = 'Y'
819: ,last_update_date = sysdate
820: ,last_updated_by = fnd_global.user_id
821: ,last_update_login= fnd_global.login_id
822: WHERE form_id = p_form_id
823: OR (primary_form_id = p_form_id
824: AND source <> lv_rtv_source
825: );

Line 1031: v_created_by := fnd_global.user_id;

1027: open c_base_trx(p_transaction_id);
1028: fetch c_base_trx into r_base_trx;
1029: close c_base_trx;
1030:
1031: v_created_by := fnd_global.user_id;
1032: v_creation_dt := sysdate;
1033: v_last_upd_dt := sysdate;
1034: v_last_upd_by := fnd_global.user_id;
1035: v_last_upd_lgin := fnd_global.login_id;

Line 1034: v_last_upd_by := fnd_global.user_id;

1030:
1031: v_created_by := fnd_global.user_id;
1032: v_creation_dt := sysdate;
1033: v_last_upd_dt := sysdate;
1034: v_last_upd_by := fnd_global.user_id;
1035: v_last_upd_lgin := fnd_global.login_id;
1036:
1037: v_organization_id := r_base_trx.organization_id;
1038: v_po_header := r_base_trx.po_header_id;

Line 1035: v_last_upd_lgin := fnd_global.login_id;

1031: v_created_by := fnd_global.user_id;
1032: v_creation_dt := sysdate;
1033: v_last_upd_dt := sysdate;
1034: v_last_upd_by := fnd_global.user_id;
1035: v_last_upd_lgin := fnd_global.login_id;
1036:
1037: v_organization_id := r_base_trx.organization_id;
1038: v_po_header := r_base_trx.po_header_id;
1039: v_po_release_id := r_base_trx.po_release_id;