APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_CF_DNB_DTLS

Line 389: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;

385: p_data_point_value OUT NOCOPY VARCHAR2) IS
386:
387: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;
388: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
389: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
390: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
391: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;
392: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_name%type;
393:

Line 390: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;

386:
387: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;
388: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
389: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
390: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
391: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;
392: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_name%type;
393:
394: TYPE cur_type IS REF CURSOR;

Line 391: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;

387: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;
388: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
389: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
390: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
391: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;
392: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_name%type;
393:
394: TYPE cur_type IS REF CURSOR;
395: c cur_type;

Line 392: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_name%type;

388: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
389: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
390: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
391: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;
392: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_name%type;
393:
394: TYPE cur_type IS REF CURSOR;
395: c cur_type;
396:

Line 408: FROM ar_cmgt_cf_dnb_dtls cfd

404: SELECT cfd.source_key, cfd.source_key_type, cfd.source_key_column_name,
405: cfd.source_key_column_type_name
406: INTO l_source_key, l_source_key_type, l_source_key_column_name,
407: l_source_key_column_type
408: FROM ar_cmgt_cf_dnb_dtls cfd
409: WHERE cfd.case_folder_id = p_case_folder_id
410: AND cfd.source_table_name = l_source_table_name;
411:
412: IF l_source_key_type IS NULL