712: A.parents_email_txt,
713: A.parent_1_birth_date,
714: A.parent_2_birth_date
715: FROM
716: IGF_AP_LI_CSS_INTS A
717: WHERE
718: A.BATCH_NUM = p_batch_id AND
719: A.IMPORT_STATUS_TYPE IN ('U','R') ;
720:
6105: counter := counter+1;
6106: g_message_table(counter).msg_text:=fnd_message.get;
6107: l_debug_str := l_debug_str || lv_person_number || 'person idoes not exist';
6108:
6109: UPDATE igf_ap_li_css_ints
6110: SET IMPORT_STATUS_TYPE='E'
6111: WHERE ROWID = c_int_data_rec.ROW_ID ;
6112: END IF;
6113: END IF;
6147: IF l_valid_for_dml = 'Y' AND l_dup_tran_num_exists <> 'Y' THEN
6148: css_insert_row( c_int_data_rec,lv_fa_base_id,p_cssp_id);
6149: fnar_insert_row(c_int_data_rec ,p_cssp_id);
6150: IF NVL(p_css_import,'N') <> 'Y' THEN
6151: UPDATE igf_ap_li_css_ints
6152: SET import_status_type='I'
6153: WHERE ROWID = c_int_data_rec.row_id ;
6154: ELSE
6155: UPDATE igf_ap_css_interface
6159: l_debug_str := l_debug_str || lv_person_number || ' PROFILE Record updated ';
6160: l_num_recrd_passed := l_num_recrd_passed +1;
6161: END IF;
6162: IF l_valid_for_dml <> 'Y' AND NVL(p_css_import,'N') <> 'Y'THEN
6163: UPDATE igf_ap_li_css_ints
6164: SET import_status_type='E'
6165: WHERE ROWID = c_int_data_rec.row_id ;
6166: END IF;
6167: --Print Error Messages