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

Line 92: DECODE( px_criteria_id, FND_API.G_MISS_NUM, NULL, px_criteria_id),

88: created_by,
89: last_update_login,
90: object_version_number
91: ) VALUES (
92: DECODE( px_criteria_id, FND_API.G_MISS_NUM, NULL, px_criteria_id),
93: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),

Line 93: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),

89: last_update_login,
90: object_version_number
91: ) VALUES (
92: DECODE( px_criteria_id, FND_API.G_MISS_NUM, NULL, px_criteria_id),
93: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),

Line 94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),

90: object_version_number
91: ) VALUES (
92: DECODE( px_criteria_id, FND_API.G_MISS_NUM, NULL, px_criteria_id),
93: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),

Line 95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),

91: ) VALUES (
92: DECODE( px_criteria_id, FND_API.G_MISS_NUM, NULL, px_criteria_id),
93: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),
99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),

Line 96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),

92: DECODE( px_criteria_id, FND_API.G_MISS_NUM, NULL, px_criteria_id),
93: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),
99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),

Line 97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),

93: DECODE( p_object_type_code, FND_API.g_miss_char, NULL, p_object_type_code),
94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),
99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),
101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),

Line 98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),

94: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),
99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),
101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),
102: 'N',

Line 99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),

95: DECODE( p_activity_type_code, FND_API.g_miss_char, NULL, p_activity_type_code),
96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),
99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),
101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),
102: 'N',
103: 'Y',

Line 100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),

96: DECODE( p_activity_id, FND_API.G_MISS_NUM, NULL, p_activity_id),
97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),
99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),
101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),
102: 'N',
103: 'Y',
104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),

97: DECODE( p_status_id, FND_API.G_MISS_NUM, NULL, p_status_id),
98: DECODE( p_priority_id, FND_API.g_miss_char, NULL, p_priority_id),
99: DECODE( p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),
101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),
102: 'N',
103: 'Y',
104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

100: DECODE( p_criteria_start_date, FND_API.G_MISS_DATE, NULL, p_criteria_start_date),
101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),
102: 'N',
103: 'Y',
104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
107: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

101: DECODE( p_criteria_end_date, FND_API.G_MISS_DATE, NULL, p_criteria_end_date),
102: 'N',
103: 'Y',
104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
107: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

Line 106: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

102: 'N',
103: 'Y',
104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
107: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
110:

Line 107: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

103: 'Y',
104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
107: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
110:
111: END Insert_Row;

Line 108: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

104: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
107: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
110:
111: END Insert_Row;
112:

Line 109: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

105: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
107: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
110:
111: END Insert_Row;
112:
113:

Line 150: criteria_id = DECODE( p_criteria_id, null, criteria_id, FND_API.G_MISS_NUM, null, p_criteria_id),

146: IS
147: BEGIN
148: Update ams_calendar_criteria
149: SET
150: criteria_id = DECODE( p_criteria_id, null, criteria_id, FND_API.G_MISS_NUM, null, p_criteria_id),
151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),

Line 151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),

147: BEGIN
148: Update ams_calendar_criteria
149: SET
150: criteria_id = DECODE( p_criteria_id, null, criteria_id, FND_API.G_MISS_NUM, null, p_criteria_id),
151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),

Line 152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),

148: Update ams_calendar_criteria
149: SET
150: criteria_id = DECODE( p_criteria_id, null, criteria_id, FND_API.G_MISS_NUM, null, p_criteria_id),
151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),

Line 153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),

149: SET
150: criteria_id = DECODE( p_criteria_id, null, criteria_id, FND_API.G_MISS_NUM, null, p_criteria_id),
151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),

Line 154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),

150: criteria_id = DECODE( p_criteria_id, null, criteria_id, FND_API.G_MISS_NUM, null, p_criteria_id),
151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),

Line 155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),

151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),

Line 156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),

152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),

Line 157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),

153: activity_type_code = DECODE( p_activity_type_code, null, activity_type_code, FND_API.g_miss_char, null, p_activity_type_code),
154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),

Line 158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),

154: activity_id = DECODE( p_activity_id, null, activity_id, FND_API.G_MISS_NUM, null, p_activity_id),
155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),
162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),

155: status_id = DECODE( p_status_id, null, status_id, FND_API.G_MISS_NUM, null, p_status_id),
156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),
162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
163: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),

156: priority_id = DECODE( p_priority_id, null, priority_id, FND_API.g_miss_char, null, p_priority_id),
157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),
162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
163: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),

157: object_id = DECODE( p_object_id, null, object_id, FND_API.G_MISS_NUM, null, p_object_id),
158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),
162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
163: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: object_version_number = nvl(p_object_version_number,0) + 1

Line 162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

158: criteria_start_date = DECODE( p_criteria_start_date, null, criteria_start_date, FND_API.G_MISS_DATE, null, p_criteria_start_date),
159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),
162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
163: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: object_version_number = nvl(p_object_version_number,0) + 1
166: WHERE criteria_id = p_criteria_id

Line 163: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

159: criteria_end_date = DECODE( p_criteria_end_date, null, criteria_end_date, FND_API.G_MISS_DATE, null, p_criteria_end_date),
160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),
162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
163: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: object_version_number = nvl(p_object_version_number,0) + 1
166: WHERE criteria_id = p_criteria_id
167: AND object_version_number = p_object_version_number;

Line 164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

160: criteria_deleted = DECODE( p_criteria_deleted, null, criteria_deleted, FND_API.g_miss_char, null, p_criteria_deleted),
161: criteria_enabled = DECODE( p_criteria_enabled, null, criteria_enabled, FND_API.g_miss_char, null, p_criteria_enabled),
162: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
163: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
164: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
165: object_version_number = nvl(p_object_version_number,0) + 1
166: WHERE criteria_id = p_criteria_id
167: AND object_version_number = p_object_version_number;
168:

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: AND object_version_number = p_object_version_number;
168:
169:
170: IF (SQL%NOTFOUND) THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174:
175: END Update_Row;

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: DELETE FROM ams_calendar_criteria
198: WHERE criteria_id = p_criteria_id
199: AND object_version_number = p_object_version_number;
200: If (SQL%NOTFOUND) then
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: End If;
203: END Delete_Row ;
204:
205:

Line 239: RAISE FND_API.g_exc_error;

235: FETCH c INTO Recinfo;
236: IF (c%NOTFOUND) THEN
237: CLOSE c;
238: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
239: RAISE FND_API.g_exc_error;
240: END IF;
241: CLOSE c;
242: END Lock_Row;
243: