APPS.AMS_IMPORTCLIENT_PVT dependencies on AS_IMPORT_INTERFACE

Line 31: -- for all kinds of errors in the "as_import_interface".

27: -- 01-MAR-2002 huili Remove populating error for trancated columns.
28: -- 07-MAR-2002 huili Remove the update for number of rows for both list
29: -- and lead import.
30: -- 07-MAR-2002 huili Always insert one row into the "AMS_LIST_IMPORT_ERRORS" table
31: -- for all kinds of errors in the "as_import_interface".
32: -- 10-April-2002 huili Added one more column "marketing_score" to the "c_lead_recs"
33: -- cursor.
34: -- 26-April-2002 huili Change all tables to varchar2(2000) table for bug #2345334.
35: -- 26-April-2002 huili Remove the "batch_id" checking for the cursor c_lead_error_txt.

Line 147: FROM as_import_interface

143: DECODE (load_status,
144: 'SUCCESS', 'SUCCESS',
145: 'DUPLICATE', 'DUPLICATE',
146: 'ERROR') load_status
147: FROM as_import_interface
148: WHERE batch_id = p_batch_id
149: AND load_status IN ('ERROR', 'SUCCESS', 'T-ERROR', 'UNEXP_ERROR', 'DUPLICATE');
150:
151: CURSOR c_lead_error_txt (p_batch_id NUMBER, p_imp_interface_id NUMBER) IS

Line 283: -- the "as_import_interface" table.

279: -- API Name Load_Lead_Data_To_Interface
280: -- Type Private
281: -- Pre-reqs None.
282: -- Function Transfer data from the "ams_lead_mapping_v" to
283: -- the "as_import_interface" table.
284: -- Parameters
285: -- IN
286: -- p_import_list_header_id NUMBER Required
287: -- OUT x_return_status VARCHAR2

Line 891: SELECT as_import_interface_s.NEXTVAL INTO l_interface_id(i)

887: LIMIT L_MAX_ROW_COUNT;
888:
889: FOR i IN 1 .. l_import_source_line_id.COUNT
890: LOOP
891: SELECT as_import_interface_s.NEXTVAL INTO l_interface_id(i)
892: FROM dual;
893: END LOOP;
894:
895: FORALL i IN 1 .. l_import_source_line_id.COUNT

Line 896: INSERT INTO as_import_interface

892: FROM dual;
893: END LOOP;
894:
895: FORALL i IN 1 .. l_import_source_line_id.COUNT
896: INSERT INTO as_import_interface
897: (import_interface_id,
898: last_update_date,
899: last_updated_by,
900: creation_date,