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.UMX_REG_REQUESTS_PKG dependencies on FND_API

Line 98: STATUS_CODE = decode (X_STATUS_CODE, NULL, STATUS_CODE, fnd_api.g_miss_char, NULL, X_STATUS_CODE),

94: X_JUSTIFICATION in VARCHAR2 DEFAULT NULL) IS
95: BEGIN
96:
97: UPDATE UMX_REG_REQUESTS SET
98: STATUS_CODE = decode (X_STATUS_CODE, NULL, STATUS_CODE, fnd_api.g_miss_char, NULL, X_STATUS_CODE),
99: LAST_UPDATED_BY = fnd_global.user_id,
100: LAST_UPDATE_DATE = sysdate,
101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),
102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),

Line 101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),

97: UPDATE UMX_REG_REQUESTS SET
98: STATUS_CODE = decode (X_STATUS_CODE, NULL, STATUS_CODE, fnd_api.g_miss_char, NULL, X_STATUS_CODE),
99: LAST_UPDATED_BY = fnd_global.user_id,
100: LAST_UPDATE_DATE = sysdate,
101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),
102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),
103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),
104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),

Line 102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),

98: STATUS_CODE = decode (X_STATUS_CODE, NULL, STATUS_CODE, fnd_api.g_miss_char, NULL, X_STATUS_CODE),
99: LAST_UPDATED_BY = fnd_global.user_id,
100: LAST_UPDATE_DATE = sysdate,
101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),
102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),
103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),
104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),

Line 103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),

99: LAST_UPDATED_BY = fnd_global.user_id,
100: LAST_UPDATE_DATE = sysdate,
101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),
102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),
103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),
104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),

Line 104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),

100: LAST_UPDATE_DATE = sysdate,
101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),
102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),
103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),
104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),

Line 105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),

101: REQUESTED_BY_USER_ID = decode (X_REQUESTED_BY_USER_ID, NULL, REQUESTED_BY_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_BY_USER_ID),
102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),
103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),
104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),
109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),

Line 106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),

102: REQUESTED_FOR_USER_ID = decode (X_REQUESTED_FOR_USER_ID, NULL, REQUESTED_FOR_USER_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_USER_ID),
103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),
104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),
109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),
110: AME_TRANSACTION_TYPE_ID = decode (X_AME_TRANSACTION_TYPE_ID, NULL, AME_TRANSACTION_TYPE_ID, fnd_api.g_miss_char, NULL, X_AME_TRANSACTION_TYPE_ID),

Line 107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),

103: REQUESTED_FOR_PARTY_ID = decode (X_REQUESTED_FOR_PARTY_ID, NULL, REQUESTED_FOR_PARTY_ID, fnd_api.g_miss_num, NULL, X_REQUESTED_FOR_PARTY_ID),
104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),
109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),
110: AME_TRANSACTION_TYPE_ID = decode (X_AME_TRANSACTION_TYPE_ID, NULL, AME_TRANSACTION_TYPE_ID, fnd_api.g_miss_char, NULL, X_AME_TRANSACTION_TYPE_ID),
111: JUSTIFICATION = decode (X_JUSTIFICATION, NULL, JUSTIFICATION, fnd_api.g_miss_char, NULL, X_JUSTIFICATION)

Line 108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),

104: REQUESTED_USERNAME = decode (X_REQUESTED_USERNAME, NULL, REQUESTED_USERNAME, fnd_api.g_miss_char, NULL, X_REQUESTED_USERNAME),
105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),
109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),
110: AME_TRANSACTION_TYPE_ID = decode (X_AME_TRANSACTION_TYPE_ID, NULL, AME_TRANSACTION_TYPE_ID, fnd_api.g_miss_char, NULL, X_AME_TRANSACTION_TYPE_ID),
111: JUSTIFICATION = decode (X_JUSTIFICATION, NULL, JUSTIFICATION, fnd_api.g_miss_char, NULL, X_JUSTIFICATION)
112: WHERE REG_REQUEST_ID = X_REG_REQUEST_ID;

Line 109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),

105: REQUESTED_START_DATE = decode (X_REQUESTED_START_DATE, NULL, REQUESTED_START_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_START_DATE),
106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),
109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),
110: AME_TRANSACTION_TYPE_ID = decode (X_AME_TRANSACTION_TYPE_ID, NULL, AME_TRANSACTION_TYPE_ID, fnd_api.g_miss_char, NULL, X_AME_TRANSACTION_TYPE_ID),
111: JUSTIFICATION = decode (X_JUSTIFICATION, NULL, JUSTIFICATION, fnd_api.g_miss_char, NULL, X_JUSTIFICATION)
112: WHERE REG_REQUEST_ID = X_REG_REQUEST_ID;
113: if (sql%notfound) then

Line 110: AME_TRANSACTION_TYPE_ID = decode (X_AME_TRANSACTION_TYPE_ID, NULL, AME_TRANSACTION_TYPE_ID, fnd_api.g_miss_char, NULL, X_AME_TRANSACTION_TYPE_ID),

106: REQUESTED_END_DATE = decode (X_REQUESTED_END_DATE, NULL, REQUESTED_END_DATE, fnd_api.g_miss_date, NULL, X_REQUESTED_END_DATE),
107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),
109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),
110: AME_TRANSACTION_TYPE_ID = decode (X_AME_TRANSACTION_TYPE_ID, NULL, AME_TRANSACTION_TYPE_ID, fnd_api.g_miss_char, NULL, X_AME_TRANSACTION_TYPE_ID),
111: JUSTIFICATION = decode (X_JUSTIFICATION, NULL, JUSTIFICATION, fnd_api.g_miss_char, NULL, X_JUSTIFICATION)
112: WHERE REG_REQUEST_ID = X_REG_REQUEST_ID;
113: if (sql%notfound) then
114: raise no_data_found;

Line 111: JUSTIFICATION = decode (X_JUSTIFICATION, NULL, JUSTIFICATION, fnd_api.g_miss_char, NULL, X_JUSTIFICATION)

107: WF_ROLE_NAME = decode (X_WF_ROLE_NAME, NULL, WF_ROLE_NAME, fnd_api.g_miss_char, NULL, X_WF_ROLE_NAME),
108: REG_SERVICE_CODE = decode (X_REG_SERVICE_CODE, NULL, REG_SERVICE_CODE, fnd_api.g_miss_char, NULL, X_REG_SERVICE_CODE),
109: AME_APPLICATION_ID = decode (X_AME_APPLICATION_ID, NULL, AME_APPLICATION_ID, fnd_api.g_miss_num, NULL, X_AME_APPLICATION_ID),
110: AME_TRANSACTION_TYPE_ID = decode (X_AME_TRANSACTION_TYPE_ID, NULL, AME_TRANSACTION_TYPE_ID, fnd_api.g_miss_char, NULL, X_AME_TRANSACTION_TYPE_ID),
111: JUSTIFICATION = decode (X_JUSTIFICATION, NULL, JUSTIFICATION, fnd_api.g_miss_char, NULL, X_JUSTIFICATION)
112: WHERE REG_REQUEST_ID = X_REG_REQUEST_ID;
113: if (sql%notfound) then
114: raise no_data_found;
115: end if;