[Home] [Help]
108: -- Start of comments
109: -- API Name Mark_Insert_Lead_Errors
110: -- Type Private
111: -- Pre-reqs None.
112: -- Function Mark lead errors to the "ams_imp_source_lines"
113: -- table and insert error records into the
114: -- "ams_list_import_errors" table.
115: -- Parameters
116: -- IN
179: IF c_batch_id%FOUND THEN
180: FOR import_interface_data_rec IN c_import_interface_data (l_batch_id)
181: LOOP
182: BEGIN
183: UPDATE ams_imp_source_lines
184: SET load_status = import_interface_data_rec.load_status
185: WHERE import_source_line_id = import_interface_data_rec.imp_list_header_number;
186:
187: --need to insert one row to the error table
1440: -- NAME
1441: -- Insert_Lead_Data
1442: --
1443: -- PURPOSE
1444: -- The procedure insert a collection of data into the "ams_imp_source_lines"
1445: -- The "p_data" contains all data needed to be inserted, assuming all data
1446: -- types are "VARCHAR2". For example, if the data to be inserted are the
1447: -- followings:
1448: --
1585: Insert_Data (
1586: p_api_version => 1.0,
1587: p_table_name => l_field_table_name,
1588: p_prim_key_name => 'IMPORT_SOURCE_LINE_ID',
1589: p_seq_name => 'AMS_IMP_SOURCE_LINES_S',
1590: p_str_col_names => l_str_col_names,
1591: p_num_col_names => l_num_col_names,
1592: p_str_data => l_str_data,
1593: p_num_data => l_num_data,
1721: -- NAME
1722: -- Insert_List_Data
1723: --
1724: -- PURPOSE
1725: -- The procedure insert a collection of data into the "ams_imp_source_lines"
1726: -- The "p_data" contains all data needed to be inserted, assuming all data
1727: -- types are "VARCHAR2". For example, if the data to be inserted are the
1728: -- followings:
1729: --
1872: Insert_Data (
1873: p_api_version => 1.0,
1874: p_table_name => l_field_table_name,
1875: p_prim_key_name => 'IMPORT_SOURCE_LINE_ID',
1876: p_seq_name => 'AMS_IMP_SOURCE_LINES_S',
1877: p_str_col_names => l_str_col_names,
1878: p_num_col_names => l_num_col_names,
1879: p_str_data => l_str_data,
1880: p_num_data => l_num_data,
2049: -- Both "p_col_names" and "p_data" are consecutive.
2050: -- The data stored in the "p_prim_key_name" field is the column name of the
2051: -- primary key column. The "p_seq_name" is the name of sequence used to
2052: -- generate the primary keys for all the rows. For example, it must be
2053: -- "AMS.AMS_IMP_SOURCE_LINES_S" instead of "AMS_IMP_SOURCE_LINES_S".
2054: -- The "p_str_col_names" and
2055: -- the "p_num_col_names" contain other "VARCHAR2" field and "NUMBER" field
2056: -- names respectively, while the "p_str_data" and "p_num_data" are
2057: -- corresponding data. The other flag fields are used to indicate whether