APPS.HZ_PHONE_COUNTRY_CODES_PKG dependencies on FND_API

Line 27: phone_country_code = decode(p_phone_country_code,FND_API.G_MISS_CHAR,

23: l_object_version_number := NVL(p_object_version_number, 1) + 1;
24:
25: UPDATE HZ_PHONE_COUNTRY_CODES
26: SET
27: phone_country_code = decode(p_phone_country_code,FND_API.G_MISS_CHAR,
28: phone_country_code, p_phone_country_code),
29: PHONE_LENGTH =decode(p_PHONE_LENGTH,FND_API.G_MISS_NUM,
30: PHONE_LENGTH, p_PHONE_LENGTH),
31: AREA_CODE_LENGTH =decode(p_AREA_CODE_LENGTH,FND_API.G_MISS_NUM,

Line 29: PHONE_LENGTH =decode(p_PHONE_LENGTH,FND_API.G_MISS_NUM,

25: UPDATE HZ_PHONE_COUNTRY_CODES
26: SET
27: phone_country_code = decode(p_phone_country_code,FND_API.G_MISS_CHAR,
28: phone_country_code, p_phone_country_code),
29: PHONE_LENGTH =decode(p_PHONE_LENGTH,FND_API.G_MISS_NUM,
30: PHONE_LENGTH, p_PHONE_LENGTH),
31: AREA_CODE_LENGTH =decode(p_AREA_CODE_LENGTH,FND_API.G_MISS_NUM,
32: AREA_CODE_LENGTH, p_AREA_CODE_LENGTH),
33: TRUNK_PREFIX =decode(p_TRUNK_PREFIX,FND_API.G_MISS_CHAR,

Line 31: AREA_CODE_LENGTH =decode(p_AREA_CODE_LENGTH,FND_API.G_MISS_NUM,

27: phone_country_code = decode(p_phone_country_code,FND_API.G_MISS_CHAR,
28: phone_country_code, p_phone_country_code),
29: PHONE_LENGTH =decode(p_PHONE_LENGTH,FND_API.G_MISS_NUM,
30: PHONE_LENGTH, p_PHONE_LENGTH),
31: AREA_CODE_LENGTH =decode(p_AREA_CODE_LENGTH,FND_API.G_MISS_NUM,
32: AREA_CODE_LENGTH, p_AREA_CODE_LENGTH),
33: TRUNK_PREFIX =decode(p_TRUNK_PREFIX,FND_API.G_MISS_CHAR,
34: TRUNK_PREFIX, p_TRUNK_PREFIX),
35: INTL_PREFIX =decode(p_INTL_PREFIX,FND_API.G_MISS_CHAR,

Line 33: TRUNK_PREFIX =decode(p_TRUNK_PREFIX,FND_API.G_MISS_CHAR,

29: PHONE_LENGTH =decode(p_PHONE_LENGTH,FND_API.G_MISS_NUM,
30: PHONE_LENGTH, p_PHONE_LENGTH),
31: AREA_CODE_LENGTH =decode(p_AREA_CODE_LENGTH,FND_API.G_MISS_NUM,
32: AREA_CODE_LENGTH, p_AREA_CODE_LENGTH),
33: TRUNK_PREFIX =decode(p_TRUNK_PREFIX,FND_API.G_MISS_CHAR,
34: TRUNK_PREFIX, p_TRUNK_PREFIX),
35: INTL_PREFIX =decode(p_INTL_PREFIX,FND_API.G_MISS_CHAR,
36: INTL_PREFIX, p_INTL_PREFIX),
37: VALIDATION_PROC =decode(p_VALIDATION_PROC,FND_API.G_MISS_CHAR,

Line 35: INTL_PREFIX =decode(p_INTL_PREFIX,FND_API.G_MISS_CHAR,

31: AREA_CODE_LENGTH =decode(p_AREA_CODE_LENGTH,FND_API.G_MISS_NUM,
32: AREA_CODE_LENGTH, p_AREA_CODE_LENGTH),
33: TRUNK_PREFIX =decode(p_TRUNK_PREFIX,FND_API.G_MISS_CHAR,
34: TRUNK_PREFIX, p_TRUNK_PREFIX),
35: INTL_PREFIX =decode(p_INTL_PREFIX,FND_API.G_MISS_CHAR,
36: INTL_PREFIX, p_INTL_PREFIX),
37: VALIDATION_PROC =decode(p_VALIDATION_PROC,FND_API.G_MISS_CHAR,
38: VALIDATION_PROC, p_VALIDATION_PROC),
39: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,

Line 37: VALIDATION_PROC =decode(p_VALIDATION_PROC,FND_API.G_MISS_CHAR,

33: TRUNK_PREFIX =decode(p_TRUNK_PREFIX,FND_API.G_MISS_CHAR,
34: TRUNK_PREFIX, p_TRUNK_PREFIX),
35: INTL_PREFIX =decode(p_INTL_PREFIX,FND_API.G_MISS_CHAR,
36: INTL_PREFIX, p_INTL_PREFIX),
37: VALIDATION_PROC =decode(p_VALIDATION_PROC,FND_API.G_MISS_CHAR,
38: VALIDATION_PROC, p_VALIDATION_PROC),
39: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,
40: TIMEZONE_ID, p_TIMEZONE_ID),
41: -- Bug 3032780

Line 39: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,

35: INTL_PREFIX =decode(p_INTL_PREFIX,FND_API.G_MISS_CHAR,
36: INTL_PREFIX, p_INTL_PREFIX),
37: VALIDATION_PROC =decode(p_VALIDATION_PROC,FND_API.G_MISS_CHAR,
38: VALIDATION_PROC, p_VALIDATION_PROC),
39: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,
40: TIMEZONE_ID, p_TIMEZONE_ID),
41: -- Bug 3032780
42: /*
43: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,

Line 43: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,

39: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,
40: TIMEZONE_ID, p_TIMEZONE_ID),
41: -- Bug 3032780
42: /*
43: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
44: CREATED_BY, p_created_by),
45: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
46: CREATION_DATE,p_CREATION_DATE),
47: */

Line 45: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,

41: -- Bug 3032780
42: /*
43: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
44: CREATED_BY, p_created_by),
45: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
46: CREATION_DATE,p_CREATION_DATE),
47: */
48: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
49: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),

Line 48: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,

44: CREATED_BY, p_created_by),
45: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
46: CREATION_DATE,p_CREATION_DATE),
47: */
48: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
49: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
50: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
51: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
52: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

Line 50: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,

46: CREATION_DATE,p_CREATION_DATE),
47: */
48: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
49: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
50: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
51: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
52: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
53: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
54: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

Line 52: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

48: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
49: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
50: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
51: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
52: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
53: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
54: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
55: OBJECT_VERSION_NUMBER,l_object_version_number)
56: WHERE TERRITORY_CODE = P_TERRITORY_CODE;

Line 54: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

50: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
51: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
52: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
53: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
54: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
55: OBJECT_VERSION_NUMBER,l_object_version_number)
56: WHERE TERRITORY_CODE = P_TERRITORY_CODE;
57:
58: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;