eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MOBILE_PREFIXES_PKG dependencies on FND_API

Line 35: decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR, NULL, p_MOBILE_PREFIX),

31: LAST_UPDATE_DATE,
32: LAST_UPDATED_BY,
33: OBJECT_VERSION_NUMBER ) VALUES(
34: p_TERRITORY_CODE,
35: decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR, NULL, p_MOBILE_PREFIX),
36: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
37: p_PHONE_COUNTRY_CODE),
38: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

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

32: LAST_UPDATED_BY,
33: OBJECT_VERSION_NUMBER ) VALUES(
34: p_TERRITORY_CODE,
35: decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR, NULL, p_MOBILE_PREFIX),
36: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
37: p_PHONE_COUNTRY_CODE),
38: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
40: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),

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

34: p_TERRITORY_CODE,
35: decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR, NULL, p_MOBILE_PREFIX),
36: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
37: p_PHONE_COUNTRY_CODE),
38: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
40: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
41: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
42: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

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

35: decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR, NULL, p_MOBILE_PREFIX),
36: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
37: p_PHONE_COUNTRY_CODE),
38: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
40: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
41: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
42: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
43: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

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

36: decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR, NULL,
37: p_PHONE_COUNTRY_CODE),
38: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
40: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
41: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
42: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
43: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
44: 1

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

37: p_PHONE_COUNTRY_CODE),
38: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
40: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
41: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
42: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
43: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
44: 1
45: );

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

38: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
40: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
41: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
42: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
43: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
44: 1
45: );
46: OPEN C;

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

39: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
40: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
41: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
42: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
43: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
44: 1
45: );
46: OPEN C;
47: FETCH C INTO p_Rowid;

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

70:
71: l_object_version_number := NVL(p_object_version_number, 1) + 1;
72: UPDATE HZ_MOBILE_PREFIXES
73: SET
74: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
75: TERRITORY_CODE, p_TERRITORY_CODE),
76: MOBILE_PREFIX = decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR,
77: MOBILE_PREFIX, p_MOBILE_PREFIX),
78: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,

Line 76: MOBILE_PREFIX = decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR,

72: UPDATE HZ_MOBILE_PREFIXES
73: SET
74: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
75: TERRITORY_CODE, p_TERRITORY_CODE),
76: MOBILE_PREFIX = decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR,
77: MOBILE_PREFIX, p_MOBILE_PREFIX),
78: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,
79: PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
80: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,

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

74: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
75: TERRITORY_CODE, p_TERRITORY_CODE),
76: MOBILE_PREFIX = decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR,
77: MOBILE_PREFIX, p_MOBILE_PREFIX),
78: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,
79: PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
80: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
81: DESCRIPTION, p_DESCRIPTION),
82: -- Bug 3032780

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

76: MOBILE_PREFIX = decode(p_MOBILE_PREFIX, FND_API.G_MISS_CHAR,
77: MOBILE_PREFIX, p_MOBILE_PREFIX),
78: PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE, FND_API.G_MISS_CHAR,
79: PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
80: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
81: DESCRIPTION, p_DESCRIPTION),
82: -- Bug 3032780
83: /*
84: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,

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

80: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
81: DESCRIPTION, p_DESCRIPTION),
82: -- Bug 3032780
83: /*
84: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
85: CREATED_BY, p_created_by),
86: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
87: CREATION_DATE,p_CREATION_DATE),
88: */

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

82: -- Bug 3032780
83: /*
84: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
85: CREATED_BY, p_created_by),
86: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
87: CREATION_DATE,p_CREATION_DATE),
88: */
89: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
90: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),

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

85: CREATED_BY, p_created_by),
86: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
87: CREATION_DATE,p_CREATION_DATE),
88: */
89: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
90: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
91: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
92: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
93: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

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

87: CREATION_DATE,p_CREATION_DATE),
88: */
89: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
90: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
91: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
92: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
93: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
94: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
95: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

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

89: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
90: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
91: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
92: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
93: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
94: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
95: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
96: OBJECT_VERSION_NUMBER,l_object_version_number)
97: WHERE ROWID = P_ROWID;

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

91: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
92: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
93: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
94: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
95: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
96: OBJECT_VERSION_NUMBER,l_object_version_number)
97: WHERE ROWID = P_ROWID;
98:
99: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;