APPS.AMS_IMPORTCLIENT_PVT dependencies on AMS_LIST_IMPORT_ERRORS

Line 30: -- 07-MAR-2002 huili Always insert one row into the "AMS_LIST_IMPORT_ERRORS" table

26: -- 24-JAN-2002 huili Comment out the "SOURCE_SYSTEM" default data for lead import.
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.

Line 101: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,

97: PROCEDURE Create_List_import_Error (
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
100: p_commit IN VARCHAR2 := FND_API.G_TRUE,
101: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,
102:
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_imp_err_id OUT NOCOPY NUMBER
105: );

Line 114: -- "ams_list_import_errors" table.

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
117: -- p_import_list_header_id NUMBER Required
118: -- OUT x_return_status VARCHAR2

Line 160: l_list_imp_error_rec ams_list_import_errors%ROWTYPE;

156: ORDER BY LEAD_IMPORT_ERROR_ID DESC;
157:
158: l_lead_error_rec c_lead_error_txt%ROWTYPE;
159: l_batch_id NUMBER;
160: l_list_imp_error_rec ams_list_import_errors%ROWTYPE;
161: l_imp_err_id NUMBER;
162: l_error_msg VARCHAR2(2000);
163:
164: BEGIN

Line 2151: l_list_imp_error_rec AMS_LIST_IMPORT_ERRORS%ROWTYPE;

2147: l_source_line_keys num_data_set_type_w;
2148:
2149: l_load_status VARCHAR2(30) := L_ACTIVE;
2150:
2151: l_list_imp_error_rec AMS_LIST_IMPORT_ERRORS%ROWTYPE;
2152: l_imp_err_id NUMBER;
2153:
2154: l_varchar_col_num NUMBER := 0;
2155: l_num_col_num NUMBER := 0;

Line 2446: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,

2442: PROCEDURE Create_List_import_Error (
2443: p_api_version IN NUMBER,
2444: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2445: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2446: p_list_imp_error_rec IN AMS_LIST_IMPORT_ERRORS%ROWTYPE,
2447:
2448: x_return_status OUT NOCOPY VARCHAR2,
2449: x_imp_err_id OUT NOCOPY NUMBER
2450: )

Line 2466: FROM AMS_LIST_IMPORT_ERRORS

2462: l_date DATE := SYSDATE;
2463:
2464: CURSOR c_list_imp_error (l_list_imp_id IN NUMBER) IS
2465: SELECT 1
2466: FROM AMS_LIST_IMPORT_ERRORS
2467: WHERE LIST_IMPORT_ERROR_ID = l_list_imp_id;
2468:
2469: BEGIN
2470: --

Line 2512: SELECT AMS_LIST_IMPORT_ERRORS_S.NEXTVAL INTO l_list_imp_id

2508: --
2509: x_return_status := FND_API.G_RET_STS_SUCCESS;
2510:
2511: LOOP
2512: SELECT AMS_LIST_IMPORT_ERRORS_S.NEXTVAL INTO l_list_imp_id
2513: FROM DUAL;
2514:
2515: l_flag := NULL;
2516:

Line 2524: INSERT INTO AMS_LIST_IMPORT_ERRORS (

2520:
2521: EXIT WHEN l_flag IS NULL;
2522: END LOOP;
2523:
2524: INSERT INTO AMS_LIST_IMPORT_ERRORS (
2525: LIST_IMPORT_ERROR_ID,
2526: LAST_UPDATED_BY,
2527: LAST_UPDATE_DATE,
2528: CREATION_DATE,