1: PACKAGE BODY XTR_USER_ACCESS AS
2: /* $Header: xtruaccb.pls 120.1 2005/09/28 11:52:25 eaggarwa noship $ */
3:
4: FUNCTION dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS
5: FUNCTION get_dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS
6: CURSOR c_get_dealer_code IS
7: SELECT dealer_code
8: FROM xtr_dealer_codes
1: PACKAGE BODY XTR_USER_ACCESS AS
2: /* $Header: xtruaccb.pls 120.1 2005/09/28 11:52:25 eaggarwa noship $ */
3:
4: FUNCTION dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS
5: FUNCTION get_dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS
6: CURSOR c_get_dealer_code IS
7: SELECT dealer_code
8: FROM xtr_dealer_codes
9: WHERE user_id = fnd_global.user_id;
4: FUNCTION dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS
5: FUNCTION get_dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS
6: CURSOR c_get_dealer_code IS
7: SELECT dealer_code
8: FROM xtr_dealer_codes
9: WHERE user_id = fnd_global.user_id;
10: BEGIN
11: if g_dealer_code is null then --4491268
12: