DBA Data[Home] [Help]

APPS.POS_PRODUCT_SERVICE_BO_PKG dependencies on FND_GLOBAL

Line 24: l_request_id NUMBER := fnd_global.conc_request_id;

20:
21: l_msg_count NUMBER;
22: l_msg_data VARCHAR2(2000);
23: l_api_name CONSTANT VARCHAR2(50) := 'VALIDATE_VENDOR_PRODS_SERVICES';
24: l_request_id NUMBER := fnd_global.conc_request_id;
25:
26: l_pscur cursor_ref_type;
27: l_sql VARCHAR2(4000) := NULL;
28: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;

Line 452: last_updated_by = fnd_global.user_id,

448: BEGIN
449:
450: UPDATE pos_sup_products_services
451: SET status = p_status,
452: last_updated_by = fnd_global.user_id,
453: last_update_date = SYSDATE,
454: last_update_login = fnd_global.login_id
455: WHERE classification_id = p_req_id;
456:

Line 454: last_update_login = fnd_global.login_id

450: UPDATE pos_sup_products_services
451: SET status = p_status,
452: last_updated_by = fnd_global.user_id,
453: last_update_date = SYSDATE,
454: last_update_login = fnd_global.login_id
455: WHERE classification_id = p_req_id;
456:
457: x_return_status := fnd_api.g_ret_sts_success;
458: EXCEPTION