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_ACT_LIST_GROUPS_PKG dependencies on FND_API

Line 101: DECODE( px_act_list_group_id, FND_API.g_miss_num, NULL, px_act_list_group_id),

97: quantum,
98: quota,
99: quota_reset
100: ) VALUES (
101: DECODE( px_act_list_group_id, FND_API.g_miss_num, NULL, px_act_list_group_id),
102: DECODE( p_act_list_used_by_id, FND_API.g_miss_num, NULL, p_act_list_used_by_id),
103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),
104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),

Line 102: DECODE( p_act_list_used_by_id, FND_API.g_miss_num, NULL, p_act_list_used_by_id),

98: quota,
99: quota_reset
100: ) VALUES (
101: DECODE( px_act_list_group_id, FND_API.g_miss_num, NULL, px_act_list_group_id),
102: DECODE( p_act_list_used_by_id, FND_API.g_miss_num, NULL, p_act_list_used_by_id),
103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),
104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),

99: quota_reset
100: ) VALUES (
101: DECODE( px_act_list_group_id, FND_API.g_miss_num, NULL, px_act_list_group_id),
102: DECODE( p_act_list_used_by_id, FND_API.g_miss_num, NULL, p_act_list_used_by_id),
103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),
104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),

100: ) VALUES (
101: DECODE( px_act_list_group_id, FND_API.g_miss_num, NULL, px_act_list_group_id),
102: DECODE( p_act_list_used_by_id, FND_API.g_miss_num, NULL, p_act_list_used_by_id),
103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),
104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),

101: DECODE( px_act_list_group_id, FND_API.g_miss_num, NULL, px_act_list_group_id),
102: DECODE( p_act_list_used_by_id, FND_API.g_miss_num, NULL, p_act_list_used_by_id),
103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),
104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

102: DECODE( p_act_list_used_by_id, FND_API.g_miss_num, NULL, p_act_list_used_by_id),
103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),
104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

103: DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, NULL, p_arc_act_list_used_by),
104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

104: DECODE( p_group_code, FND_API.g_miss_char, NULL, p_group_code),
105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

Line 109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

105: DECODE( p_group_priority, FND_API.g_miss_num, NULL, p_group_priority),
106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),

Line 110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

106: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),

Line 111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

107: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),

Line 112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

108: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),

Line 113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),

109: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),

Line 114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),

110: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),

Line 115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),

111: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),

Line 116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),

112: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),

Line 117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),

113: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),
121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),

Line 118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),

114: DECODE( p_calling_calendar_id, FND_API.g_miss_num, NULL, p_calling_calendar_id),
115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),
121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),
122: DECODE( p_quota, FND_API.g_miss_num, NULL, p_quota),

Line 119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),

115: DECODE( p_release_control_alg_id, FND_API.g_miss_num, NULL, p_release_control_alg_id),
116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),
121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),
122: DECODE( p_quota, FND_API.g_miss_num, NULL, p_quota),
123: DECODE( p_quota_reset, FND_API.g_miss_num, NULL, p_quota_reset));

Line 120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),

116: DECODE( p_release_strategy, FND_API.g_miss_char, NULL, p_release_strategy),
117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),
121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),
122: DECODE( p_quota, FND_API.g_miss_num, NULL, p_quota),
123: DECODE( p_quota_reset, FND_API.g_miss_num, NULL, p_quota_reset));
124: END Insert_Row;

Line 121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),

117: DECODE( p_recycling_alg_id, FND_API.g_miss_num, NULL, p_recycling_alg_id),
118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),
121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),
122: DECODE( p_quota, FND_API.g_miss_num, NULL, p_quota),
123: DECODE( p_quota_reset, FND_API.g_miss_num, NULL, p_quota_reset));
124: END Insert_Row;
125:

Line 122: DECODE( p_quota, FND_API.g_miss_num, NULL, p_quota),

118: DECODE( p_callback_priority_flag, FND_API.g_miss_char, NULL, p_callback_priority_flag),
119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),
121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),
122: DECODE( p_quota, FND_API.g_miss_num, NULL, p_quota),
123: DECODE( p_quota_reset, FND_API.g_miss_num, NULL, p_quota_reset));
124: END Insert_Row;
125:
126:

Line 123: DECODE( p_quota_reset, FND_API.g_miss_num, NULL, p_quota_reset));

119: DECODE( p_call_center_ready_flag, FND_API.g_miss_char, NULL, p_call_center_ready_flag),
120: DECODE( p_dialing_method, FND_API.g_miss_char, NULL, p_dialing_method),
121: DECODE( p_quantum, FND_API.g_miss_num, NULL, p_quantum),
122: DECODE( p_quota, FND_API.g_miss_num, NULL, p_quota),
123: DECODE( p_quota_reset, FND_API.g_miss_num, NULL, p_quota_reset));
124: END Insert_Row;
125:
126:
127: ----------------------------------------------------------

Line 172: act_list_group_id = DECODE( p_act_list_group_id, FND_API.g_miss_num, act_list_group_id, p_act_list_group_id),

168: IS
169: BEGIN
170: Update AMS_ACT_LIST_GROUPS
171: SET
172: act_list_group_id = DECODE( p_act_list_group_id, FND_API.g_miss_num, act_list_group_id, p_act_list_group_id),
173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),
174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),
175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),

Line 173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),

169: BEGIN
170: Update AMS_ACT_LIST_GROUPS
171: SET
172: act_list_group_id = DECODE( p_act_list_group_id, FND_API.g_miss_num, act_list_group_id, p_act_list_group_id),
173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),
174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),
175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),

170: Update AMS_ACT_LIST_GROUPS
171: SET
172: act_list_group_id = DECODE( p_act_list_group_id, FND_API.g_miss_num, act_list_group_id, p_act_list_group_id),
173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),
174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),
175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),

171: SET
172: act_list_group_id = DECODE( p_act_list_group_id, FND_API.g_miss_num, act_list_group_id, p_act_list_group_id),
173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),
174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),
175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),

172: act_list_group_id = DECODE( p_act_list_group_id, FND_API.g_miss_num, act_list_group_id, p_act_list_group_id),
173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),
174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),
175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),
174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),
175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),
175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

175: group_code = DECODE( p_group_code, FND_API.g_miss_char, group_code, p_group_code),
176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

Line 180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

176: group_priority = DECODE( p_group_priority, FND_API.g_miss_num, group_priority, p_group_priority),
177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),

Line 181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

177: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),

Line 182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),

Line 183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

179: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),

Line 184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),

180: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),

Line 185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),

181: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),

Line 186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),

182: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),

Line 187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),

183: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),

Line 188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),

184: user_status_id = DECODE( p_user_status_id, FND_API.g_miss_num, user_status_id, p_user_status_id),
185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),
192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),

Line 189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),

185: calling_calendar_id = DECODE( p_calling_calendar_id, FND_API.g_miss_num, calling_calendar_id, p_calling_calendar_id),
186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),
192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),
193: quota = DECODE( p_quota, FND_API.g_miss_num, quota, p_quota),

Line 190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),

186: release_control_alg_id = DECODE( p_release_control_alg_id, FND_API.g_miss_num, release_control_alg_id, p_release_control_alg_id),
187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),
192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),
193: quota = DECODE( p_quota, FND_API.g_miss_num, quota, p_quota),
194: quota_reset = DECODE( p_quota_reset, FND_API.g_miss_num, quota_reset, p_quota_reset)

Line 191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),

187: release_strategy = DECODE( p_release_strategy, FND_API.g_miss_char, release_strategy, p_release_strategy),
188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),
192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),
193: quota = DECODE( p_quota, FND_API.g_miss_num, quota, p_quota),
194: quota_reset = DECODE( p_quota_reset, FND_API.g_miss_num, quota_reset, p_quota_reset)
195: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID

Line 192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),

188: recycling_alg_id = DECODE( p_recycling_alg_id, FND_API.g_miss_num, recycling_alg_id, p_recycling_alg_id),
189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),
192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),
193: quota = DECODE( p_quota, FND_API.g_miss_num, quota, p_quota),
194: quota_reset = DECODE( p_quota_reset, FND_API.g_miss_num, quota_reset, p_quota_reset)
195: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID
196: AND object_version_number = p_object_version_number;

Line 193: quota = DECODE( p_quota, FND_API.g_miss_num, quota, p_quota),

189: callback_priority_flag = DECODE( p_callback_priority_flag, FND_API.g_miss_char, callback_priority_flag, p_callback_priority_flag),
190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),
192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),
193: quota = DECODE( p_quota, FND_API.g_miss_num, quota, p_quota),
194: quota_reset = DECODE( p_quota_reset, FND_API.g_miss_num, quota_reset, p_quota_reset)
195: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID
196: AND object_version_number = p_object_version_number;
197:

Line 194: quota_reset = DECODE( p_quota_reset, FND_API.g_miss_num, quota_reset, p_quota_reset)

190: call_center_ready_flag = DECODE( p_call_center_ready_flag, FND_API.g_miss_char, call_center_ready_flag, p_call_center_ready_flag),
191: dialing_method = DECODE( p_dialing_method, FND_API.g_miss_char, dialing_method, p_dialing_method),
192: quantum = DECODE( p_quantum, FND_API.g_miss_num, quantum, p_quantum),
193: quota = DECODE( p_quota, FND_API.g_miss_num, quota, p_quota),
194: quota_reset = DECODE( p_quota_reset, FND_API.g_miss_num, quota_reset, p_quota_reset)
195: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID
196: AND object_version_number = p_object_version_number;
197:
198: IF (SQL%NOTFOUND) THEN

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID
196: AND object_version_number = p_object_version_number;
197:
198: IF (SQL%NOTFOUND) THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201: END Update_Row;
202:
203:

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223: BEGIN
224: DELETE FROM AMS_ACT_LIST_GROUPS
225: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID;
226: If (SQL%NOTFOUND) then
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: End If;
229: END Delete_Row ;
230:
231: