DBA Data[Home] [Help]

APPS.XTR_USER_ACCESS dependencies on XTR_DEALER_CODES

Line 4: FUNCTION dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS

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

Line 5: FUNCTION get_dealer_code RETURN xtr_dealer_codes.dealer_code%TYPE IS

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;

Line 8: FROM xtr_dealer_codes

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: