APPS.HZ_PHONE_AREA_CODES_PKG dependencies on FND_API

Line 38: decode(p_AREA_CODE, FND_API.G_MISS_CHAR, NULL, p_AREA_CODE),

34: LAST_UPDATE_DATE,
35: LAST_UPDATED_BY,
36: OBJECT_VERSION_NUMBER ) VALUES(
37: p_TERRITORY_CODE,
38: decode(p_AREA_CODE, FND_API.G_MISS_CHAR, NULL, p_AREA_CODE),
39: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
40: p_PHONE_COUNTRY_CODE),
41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),

Line 39: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,

35: LAST_UPDATED_BY,
36: OBJECT_VERSION_NUMBER ) VALUES(
37: p_TERRITORY_CODE,
38: decode(p_AREA_CODE, FND_API.G_MISS_CHAR, NULL, p_AREA_CODE),
39: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
40: p_PHONE_COUNTRY_CODE),
41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

Line 41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),

37: p_TERRITORY_CODE,
38: decode(p_AREA_CODE, FND_API.G_MISS_CHAR, NULL, p_AREA_CODE),
39: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
40: p_PHONE_COUNTRY_CODE),
41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

Line 42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),

38: decode(p_AREA_CODE, FND_API.G_MISS_CHAR, NULL, p_AREA_CODE),
39: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
40: p_PHONE_COUNTRY_CODE),
41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
46: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

Line 43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

39: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
40: p_PHONE_COUNTRY_CODE),
41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
46: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
47: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

Line 44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),

40: p_PHONE_COUNTRY_CODE),
41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
46: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
47: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
48: 1

Line 45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

41: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
46: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
47: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
48: 1
49: );

Line 46: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

42: decode(p_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_TIMEZONE_ID),
43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
46: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
47: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
48: 1
49: );
50:

Line 47: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

43: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
44: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
45: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
46: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
47: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
48: 1
49: );
50:
51: OPEN C;

Line 81: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,

77: l_object_version_number := NVL(p_object_version_number, 1) + 1;
78:
79: UPDATE HZ_PHONE_AREA_CODES
80: SET
81: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
82: TERRITORY_CODE, p_TERRITORY_CODE),
83: AREA_CODE = decode(p_AREA_CODE, FND_API.G_MISS_CHAR,
84: AREA_CODE, p_AREA_CODE),
85: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,

Line 83: AREA_CODE = decode(p_AREA_CODE, FND_API.G_MISS_CHAR,

79: UPDATE HZ_PHONE_AREA_CODES
80: SET
81: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
82: TERRITORY_CODE, p_TERRITORY_CODE),
83: AREA_CODE = decode(p_AREA_CODE, FND_API.G_MISS_CHAR,
84: AREA_CODE, p_AREA_CODE),
85: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,
86: PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
87: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,

Line 85: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,

81: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
82: TERRITORY_CODE, p_TERRITORY_CODE),
83: AREA_CODE = decode(p_AREA_CODE, FND_API.G_MISS_CHAR,
84: AREA_CODE, p_AREA_CODE),
85: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,
86: PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
87: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
88: DESCRIPTION, p_DESCRIPTION),
89: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,

Line 87: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,

83: AREA_CODE = decode(p_AREA_CODE, FND_API.G_MISS_CHAR,
84: AREA_CODE, p_AREA_CODE),
85: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,
86: PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
87: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
88: DESCRIPTION, p_DESCRIPTION),
89: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,
90: TIMEZONE_ID, p_TIMEZONE_ID),
91: -- Bug 3032780

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

85: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,
86: PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
87: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
88: DESCRIPTION, p_DESCRIPTION),
89: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,
90: TIMEZONE_ID, p_TIMEZONE_ID),
91: -- Bug 3032780
92: /*
93: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,

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

89: TIMEZONE_ID = decode(p_TIMEZONE_ID,FND_API.G_MISS_NUM,
90: TIMEZONE_ID, p_TIMEZONE_ID),
91: -- Bug 3032780
92: /*
93: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
94: CREATED_BY, p_created_by),
95: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
96: CREATION_DATE,p_CREATION_DATE),
97: */

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

91: -- Bug 3032780
92: /*
93: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
94: CREATED_BY, p_created_by),
95: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
96: CREATION_DATE,p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),

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

94: CREATED_BY, p_created_by),
95: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
96: CREATION_DATE,p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
100: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
101: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
102: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

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

96: CREATION_DATE,p_CREATION_DATE),
97: */
98: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
100: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
101: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
102: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
103: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
104: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

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

98: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
100: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
101: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
102: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
103: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
104: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
105: OBJECT_VERSION_NUMBER,l_object_version_number)
106: WHERE ROWID = P_ROWID;

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

100: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
101: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
102: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
103: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
104: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
105: OBJECT_VERSION_NUMBER,l_object_version_number)
106: WHERE ROWID = P_ROWID;
107:
108: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;