APPS.AMS_DM_SCORES_B_PKG dependencies on FND_API

Line 124: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),

120: attribute13,
121: attribute14,
122: attribute15
123: ) VALUES (
124: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

121: attribute14,
122: attribute15
123: ) VALUES (
124: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

122: attribute15
123: ) VALUES (
124: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),

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

123: ) VALUES (
124: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),
131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id

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

124: DECODE( p_score_id, FND_API.g_miss_num, NULL, p_score_id),
125: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),
131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id
132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),

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

125: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),
131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id
132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),
133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),

Line 130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),

126: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
127: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),
131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id
132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),
133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

Line 132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),

128: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),
131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id
132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),
133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),

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

129: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),
131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id
132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),
133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),

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

130: decode( p_OBJECT_VERSION_NUMBER, FND_API.g_miss_num, 1, p_OBJECT_VERSION_NUMBER),
131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id
132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),
133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),

Line 135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),

131: TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10)), -- org_id
132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),
133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),

Line 136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),

132: DECODE( p_model_id, FND_API.g_miss_num, NULL, p_model_id),
133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),

Line 137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),

133: DECODE( p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id),
134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),

Line 138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),

134: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),

Line 139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),

135: DECODE( p_status_date, FND_API.g_miss_date, NULL, p_status_date),
136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),

Line 140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),

136: DECODE( p_owner_user_id, FND_API.g_miss_num, NULL, p_owner_user_id),
137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),

Line 141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),

137: decode( p_RESULTS_FLAG, FND_API.g_miss_char, 'N', p_RESULTS_FLAG),
138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),

Line 142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),

138: DECODE( p_logs_flag, FND_API.g_miss_char, 'N', p_logs_flag),
139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),

Line 143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),

139: DECODE( p_scheduled_date, FND_API.g_miss_date, NULL, p_scheduled_date),
140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),

Line 144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),

140: DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, NULL, p_scheduled_timezone_id),
141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),

Line 145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),

141: DECODE( p_score_date, FND_API.g_miss_date, NULL, p_score_date),
142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),

Line 146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),

142: DECODE( p_expiration_date, FND_API.g_miss_date, NULL, p_expiration_date),
143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),

Line 147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),

143: DECODE( p_total_records, FND_API.g_miss_num, NULL, p_total_records),
144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),

Line 148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),

144: DECODE( p_total_positives, FND_API.g_miss_num, NULL, p_total_positives),
145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),

Line 149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),

145: DECODE( p_min_records, FND_API.g_miss_num, NULL, p_min_records),
146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

Line 150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),

146: DECODE( p_max_records, FND_API.g_miss_num, NULL, p_max_records),
147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

Line 151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),

147: DECODE( p_row_selection_type, FND_API.g_miss_char, 'N', p_row_selection_type),
148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

Line 152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),

148: DECODE( p_every_nth_row, FND_API.g_miss_num, NULL, p_every_nth_row),
149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

Line 153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),

149: DECODE( p_pct_random, FND_API.g_miss_num, NULL, p_pct_random),
150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

Line 154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),

150: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

Line 155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),

151: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

Line 156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),

152: DECODE( p_wf_itemkey, FND_API.g_miss_char, NULL, p_wf_itemkey),
153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

Line 157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),

153: decode( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

Line 158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),

154: decode( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

Line 159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),

155: decode( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

Line 160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),

156: decode( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

Line 161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),

157: decode( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

Line 162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),

158: decode( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

Line 163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),

159: decode( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

Line 164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),

160: decode( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
168: decode( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

Line 165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),

161: decode( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
168: decode( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
169:

Line 166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),

162: decode( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
168: decode( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
169:
170: INSERT INTO ams_dm_scores_all_tl(

Line 167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),

163: decode( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
168: decode( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
169:
170: INSERT INTO ams_dm_scores_all_tl(
171: score_id,

Line 168: decode( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));

164: decode( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
165: decode( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
168: decode( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
169:
170: INSERT INTO ams_dm_scores_all_tl(
171: score_id,
172: language,

Line 183: decode( p_score_ID, FND_API.G_MISS_NUM, NULL, p_score_ID),

179: score_name,
180: description
181: )
182: SELECT
183: decode( p_score_ID, FND_API.G_MISS_NUM, NULL, p_score_ID),
184: l.language_code,
185: SYSDATE,
186: FND_GLOBAL.user_id,
187: SYSDATE,

Line 191: decode( p_score_name, FND_API.G_MISS_CHAR, NULL, p_score_name),

187: SYSDATE,
188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: USERENV('LANG'),
191: decode( p_score_name, FND_API.G_MISS_CHAR, NULL, p_score_name),
192: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
193: FROM fnd_languages l
194: WHERE l.installed_flag in ('I', 'B')
195: AND NOT EXISTS(

Line 192: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)

188: FND_GLOBAL.user_id,
189: FND_GLOBAL.conc_login_id,
190: USERENV('LANG'),
191: decode( p_score_name, FND_API.G_MISS_CHAR, NULL, p_score_name),
192: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
193: FROM fnd_languages l
194: WHERE l.installed_flag in ('I', 'B')
195: AND NOT EXISTS(
196: SELECT NULL

Line 198: WHERE t.score_id = decode( p_score_ID, FND_API.G_MISS_NUM, NULL, p_score_ID)

194: WHERE l.installed_flag in ('I', 'B')
195: AND NOT EXISTS(
196: SELECT NULL
197: FROM ams_dm_scores_all_tl t
198: WHERE t.score_id = decode( p_score_ID, FND_API.G_MISS_NUM, NULL, p_score_ID)
199: AND t.language = l.language_code );
200:
201: End Insert_Row;
202:

Line 253: score_ID = decode( p_score_ID, FND_API.g_miss_num, score_ID, p_score_ID),

249: IS
250: BEGIN
251: Update AMS_DM_scoreS_ALL_B
252: SET
253: score_ID = decode( p_score_ID, FND_API.g_miss_num, score_ID, p_score_ID),
254: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
257: OBJECT_VERSION_NUMBER = object_version_number + 1,

Line 254: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

250: BEGIN
251: Update AMS_DM_scoreS_ALL_B
252: SET
253: score_ID = decode( p_score_ID, FND_API.g_miss_num, score_ID, p_score_ID),
254: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
257: OBJECT_VERSION_NUMBER = object_version_number + 1,
258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),

Line 255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

251: Update AMS_DM_scoreS_ALL_B
252: SET
253: score_ID = decode( p_score_ID, FND_API.g_miss_num, score_ID, p_score_ID),
254: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
257: OBJECT_VERSION_NUMBER = object_version_number + 1,
258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),

Line 256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

252: SET
253: score_ID = decode( p_score_ID, FND_API.g_miss_num, score_ID, p_score_ID),
254: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
257: OBJECT_VERSION_NUMBER = object_version_number + 1,
258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),
260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),

Line 258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),

254: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
257: OBJECT_VERSION_NUMBER = object_version_number + 1,
258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),
260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),
261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),

Line 259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),

255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
257: OBJECT_VERSION_NUMBER = object_version_number + 1,
258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),
260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),
261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),

Line 260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),

256: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.g_miss_num, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
257: OBJECT_VERSION_NUMBER = object_version_number + 1,
258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),
260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),
261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),

Line 261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),

257: OBJECT_VERSION_NUMBER = object_version_number + 1,
258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),
260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),
261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),

Line 262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),

258: MODEL_ID = decode( p_MODEL_ID, FND_API.g_miss_num, MODEL_ID, p_MODEL_ID),
259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),
260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),
261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),

Line 263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),

259: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.g_miss_num, USER_STATUS_ID, p_USER_STATUS_ID),
260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),
261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),

Line 264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),

260: STATUS_CODE = decode( p_STATUS_CODE, FND_API.g_miss_char, STATUS_CODE, p_STATUS_CODE),
261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),

Line 265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),

261: STATUS_DATE = decode( p_STATUS_DATE, FND_API.g_miss_date, STATUS_DATE, p_STATUS_DATE),
262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),

Line 266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),

262: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.g_miss_num, OWNER_USER_ID, p_OWNER_USER_ID),
263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),

Line 267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),

263: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.g_miss_char, RESULTS_FLAG, p_RESULTS_FLAG),
264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),

Line 268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),

264: logs_flag = DECODE( p_logs_flag, FND_API.g_miss_char, logs_flag, p_logs_flag),
265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),

Line 269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),

265: scheduled_date = DECODE( p_scheduled_date, FND_API.g_miss_date, scheduled_date, p_scheduled_date),
266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),

Line 270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),

266: scheduled_timezone_id = DECODE( p_scheduled_timezone_id, FND_API.g_miss_num, scheduled_timezone_id, p_scheduled_timezone_id),
267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),

Line 271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),

267: score_date = DECODE( p_score_date, FND_API.g_miss_date, score_date, p_score_date),
268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),

Line 272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),

268: expiration_date = DECODE( p_expiration_date, FND_API.g_miss_date, expiration_date, p_expiration_date),
269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),

Line 273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),

269: total_records = DECODE( p_total_records, FND_API.g_miss_num, total_records, p_total_records),
270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),

Line 274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),

270: total_positives = DECODE( p_total_positives, FND_API.g_miss_num, total_positives, p_total_positives),
271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),

Line 275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),

271: min_records = DECODE( p_min_records, FND_API.g_miss_num, min_records, p_min_records),
272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

Line 276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),

272: max_records = DECODE( p_max_records, FND_API.g_miss_num, max_records, p_max_records),
273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

Line 277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),

273: row_selection_type = DECODE( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

Line 278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),

274: every_nth_row = DECODE( p_every_nth_row, FND_API.g_miss_num, every_nth_row, p_every_nth_row),
275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

Line 279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),

275: pct_random = DECODE( p_pct_random, FND_API.g_miss_num, pct_random, p_pct_random),
276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

Line 280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),

276: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

Line 281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),

277: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

Line 282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),

278: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

Line 283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),

279: attribute_category = decode( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

Line 284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),

280: attribute1 = decode( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

Line 285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),

281: attribute2 = decode( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

Line 286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),

282: attribute3 = decode( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

Line 287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),

283: attribute4 = decode( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

Line 288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),

284: attribute5 = decode( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

Line 289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),

285: attribute6 = decode( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
293: attribute14 = decode( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

Line 290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),

286: attribute7 = decode( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
293: attribute14 = decode( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
294: attribute15 = decode( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)

Line 291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),

287: attribute8 = decode( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
293: attribute14 = decode( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
294: attribute15 = decode( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
295: WHERE score_id = p_score_id

Line 292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),

288: attribute9 = decode( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
293: attribute14 = decode( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
294: attribute15 = decode( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
295: WHERE score_id = p_score_id
296: AND object_version_number = p_object_version_number;

Line 293: attribute14 = decode( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),

289: attribute10 = decode( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
293: attribute14 = decode( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
294: attribute15 = decode( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
295: WHERE score_id = p_score_id
296: AND object_version_number = p_object_version_number;
297: IF SQL%NOTFOUND THEN

Line 294: attribute15 = decode( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)

290: attribute11 = decode( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
291: attribute12 = decode( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
292: attribute13 = decode( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
293: attribute14 = decode( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
294: attribute15 = decode( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
295: WHERE score_id = p_score_id
296: AND object_version_number = p_object_version_number;
297: IF SQL%NOTFOUND THEN
298: -- the calling program should catch no_data_found

Line 305: score_name = decode( p_score_NAME, FND_API.G_MISS_CHAR, score_NAME, p_score_NAME),

301: RAISE NO_DATA_FOUND;
302: END IF;
303:
304: update ams_dm_scores_all_tl set
305: score_name = decode( p_score_NAME, FND_API.G_MISS_CHAR, score_NAME, p_score_NAME),
306: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
307: last_update_date = SYSDATE,
308: last_updated_by = FND_GLOBAL.user_id,
309: last_update_login = FND_GLOBAL.conc_login_id,

Line 306: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),

302: END IF;
303:
304: update ams_dm_scores_all_tl set
305: score_name = decode( p_score_NAME, FND_API.G_MISS_CHAR, score_NAME, p_score_NAME),
306: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
307: last_update_date = SYSDATE,
308: last_updated_by = FND_GLOBAL.user_id,
309: last_update_login = FND_GLOBAL.conc_login_id,
310: source_lang = USERENV('LANG')