93: l_source_code,
94: l_source_code_id;
95:
96: EXIT WHEN v_RetCursor%NOTFOUND;
97: IF l_outcome_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
98: IF l_result_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
99: IF l_reason_id = fnd_api.g_miss_num THEN l_reason_id := NULL; END IF;
100: IF l_source_code = fnd_api.g_miss_char THEN l_source_code := NULL; END IF;
101: IF l_source_code_id = fnd_api.g_miss_num THEN l_source_code_id := NULL; END IF;
94: l_source_code_id;
95:
96: EXIT WHEN v_RetCursor%NOTFOUND;
97: IF l_outcome_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
98: IF l_result_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
99: IF l_reason_id = fnd_api.g_miss_num THEN l_reason_id := NULL; END IF;
100: IF l_source_code = fnd_api.g_miss_char THEN l_source_code := NULL; END IF;
101: IF l_source_code_id = fnd_api.g_miss_num THEN l_source_code_id := NULL; END IF;
102: BEGIN
95:
96: EXIT WHEN v_RetCursor%NOTFOUND;
97: IF l_outcome_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
98: IF l_result_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
99: IF l_reason_id = fnd_api.g_miss_num THEN l_reason_id := NULL; END IF;
100: IF l_source_code = fnd_api.g_miss_char THEN l_source_code := NULL; END IF;
101: IF l_source_code_id = fnd_api.g_miss_num THEN l_source_code_id := NULL; END IF;
102: BEGIN
103: BEGIN
96: EXIT WHEN v_RetCursor%NOTFOUND;
97: IF l_outcome_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
98: IF l_result_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
99: IF l_reason_id = fnd_api.g_miss_num THEN l_reason_id := NULL; END IF;
100: IF l_source_code = fnd_api.g_miss_char THEN l_source_code := NULL; END IF;
101: IF l_source_code_id = fnd_api.g_miss_num THEN l_source_code_id := NULL; END IF;
102: BEGIN
103: BEGIN
104: -- IF l_active_outcome IS NULL OR l_active_result IS NULL OR l_active_reason IS NULL THEN
97: IF l_outcome_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
98: IF l_result_id = fnd_api.g_miss_num THEN l_result_id := NULL; END IF;
99: IF l_reason_id = fnd_api.g_miss_num THEN l_reason_id := NULL; END IF;
100: IF l_source_code = fnd_api.g_miss_char THEN l_source_code := NULL; END IF;
101: IF l_source_code_id = fnd_api.g_miss_num THEN l_source_code_id := NULL; END IF;
102: BEGIN
103: BEGIN
104: -- IF l_active_outcome IS NULL OR l_active_result IS NULL OR l_active_reason IS NULL THEN
105: --