eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_IMPORTCLIENT_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 13: -- "ams_imp_list_headers_all" table in the

9: -- 12-Apr-2001 huili Created
10: -- 13-May-2001 huili Added the "Insert_Lead_Data" module
11: -- 04-June-2001 huili Added writing to log file
12: -- 16-June-2001 huili Added checking the "DEDUPE_FLAG" of the
13: -- "ams_imp_list_headers_all" table in the
14: -- "Insert_List_Data" procedure
15: -- 18-June-2001 huili Added Updating status_id in the
16: -- "ams_imp_list_headers_all" table
17: -- 18-June-2001 huili Took out the checking for "p_row_count"

Line 16: -- "ams_imp_list_headers_all" table

12: -- 16-June-2001 huili Added checking the "DEDUPE_FLAG" of the
13: -- "ams_imp_list_headers_all" table in the
14: -- "Insert_List_Data" procedure
15: -- 18-June-2001 huili Added Updating status_id in the
16: -- "ams_imp_list_headers_all" table
17: -- 18-June-2001 huili Took out the checking for "p_row_count"
18: -- in both lead import and list import
19: -- stored procedure.
20: -- 23-July-2001 huili Changed the "SOURCE_SYSTEM" to "NEW".

Line 138: FROM ams_imp_list_headers_all

134: L_MAX_ERROR_TXT_LENGTH CONSTANT NUMBER := 250;
135:
136: CURSOR c_batch_id (p_import_list_header_id NUMBER) IS
137: SELECT batch_id
138: FROM ams_imp_list_headers_all
139: WHERE import_list_header_id = p_import_list_header_id;
140:
141: CURSOR c_import_interface_data (p_batch_id NUMBER) IS
142: SELECT imp_list_header_number, import_interface_id,

Line 563: FROM ams_imp_list_headers_all

559: l_batch_id NUMBER;
560:
561: CURSOR c_get_batch_id (p_list_header_id NUMBER)
562: IS SELECT batch_id
563: FROM ams_imp_list_headers_all
564: WHERE import_list_header_id = p_list_header_id;
565:
566: CURSOR c_lead_recs (p_list_header_id NUMBER)
567: IS SELECT import_source_line_id, import_list_header_id,source_system,

Line 1462: -- columns in the "ams_imp_list_headers_all" table.

1458: --
1459: -- HISTORY
1460: -- 05/13/2001 huili Created.
1461: -- 06/04/2001 huili Populated the "loaded_no_of_rows" and "loaded_date"
1462: -- columns in the "ams_imp_list_headers_all" table.
1463: --
1464: --06/08/2001 huili Changed logic for setting up the "status_code" of
1465: -- the "ams_imp_list_headers_all" table.
1466: PROCEDURE Insert_Lead_Data (

Line 1465: -- the "ams_imp_list_headers_all" table.

1461: -- 06/04/2001 huili Populated the "loaded_no_of_rows" and "loaded_date"
1462: -- columns in the "ams_imp_list_headers_all" table.
1463: --
1464: --06/08/2001 huili Changed logic for setting up the "status_code" of
1465: -- the "ams_imp_list_headers_all" table.
1466: PROCEDURE Insert_Lead_Data (
1467: p_api_version IN NUMBER,
1468: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1469: p_commit IN VARCHAR2 := FND_API.G_TRUE,

Line 1517: FROM ams_list_src_fields A, ams_imp_list_headers_all b

1513: AND default_flag = 'Y';
1514:
1515: CURSOR c_list_fields (l_import_list_header_id NUMBER) IS
1516: SELECT A.field_column_name, B.batch_id
1517: FROM ams_list_src_fields A, ams_imp_list_headers_all b
1518: WHERE b.IMPORT_LIST_HEADER_ID = l_import_list_header_id
1519: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
1520: ORDER BY LIST_SOURCE_FIELD_ID;
1521:

Line 1525: FROM ams_imp_list_headers_all

1521:
1522: --06/16/2001 huili added
1523: CURSOR c_dup_checking (l_import_list_header_id NUMBER) IS
1524: SELECT dedupe_flag
1525: FROM ams_imp_list_headers_all
1526: WHERE import_list_header_id = l_import_list_header_id;
1527:
1528: BEGIN
1529:

Line 1629: UPDATE ams_imp_list_headers_all

1625: CLOSE c_get_status_id;
1626:
1627: --huili 06/19/2001 added NULL checking for l_status_id
1628: IF l_status_id IS NOT NULL THEN
1629: UPDATE ams_imp_list_headers_all
1630: SET status_code = 'STAGED',
1631: --loaded_no_of_rows = p_row_count,
1632: loaded_date = SYSDATE, user_status_id = l_status_id
1633: WHERE import_list_header_id = p_import_list_header_id;

Line 1635: UPDATE ams_imp_list_headers_all

1631: --loaded_no_of_rows = p_row_count,
1632: loaded_date = SYSDATE, user_status_id = l_status_id
1633: WHERE import_list_header_id = p_import_list_header_id;
1634: ELSE
1635: UPDATE ams_imp_list_headers_all
1636: SET status_code = 'STAGED',
1637: --loaded_no_of_rows = p_row_count,
1638: loaded_date = SYSDATE
1639: WHERE import_list_header_id = p_import_list_header_id;

Line 1743: -- 05/10/2001 huili Update "ams_imp_list_headers_all" table.

1739: --
1740: -- HISTORY
1741: -- 04/16/2001 huili Created.
1742: -- 04/26/2001 huili Added table name to the cursor.
1743: -- 05/10/2001 huili Update "ams_imp_list_headers_all" table.
1744: -- 06/18/2001 huili Also update status_code for the
1745: -- "ams_imp_list_headers_all" table
1746: --
1747: PROCEDURE Insert_List_Data (

Line 1745: -- "ams_imp_list_headers_all" table

1741: -- 04/16/2001 huili Created.
1742: -- 04/26/2001 huili Added table name to the cursor.
1743: -- 05/10/2001 huili Update "ams_imp_list_headers_all" table.
1744: -- 06/18/2001 huili Also update status_code for the
1745: -- "ams_imp_list_headers_all" table
1746: --
1747: PROCEDURE Insert_List_Data (
1748: p_api_version IN NUMBER,
1749: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

Line 1796: FROM ams_list_src_fields A, ams_imp_list_headers_all b

1792: AND default_flag = 'Y';
1793:
1794: CURSOR c_list_fields (l_import_list_header_id NUMBER) IS
1795: SELECT A.field_column_name, A.FIELD_TABLE_NAME, B.BATCH_ID
1796: FROM ams_list_src_fields A, ams_imp_list_headers_all b
1797: WHERE b.IMPORT_LIST_HEADER_ID = l_import_list_header_id
1798: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
1799: ORDER BY LIST_SOURCE_FIELD_ID;
1800:

Line 1804: FROM ams_imp_list_headers_all

1800:
1801: --06/16/2001 huili added
1802: CURSOR c_dup_checking (l_import_list_header_id NUMBER) IS
1803: SELECT dedupe_flag
1804: FROM ams_imp_list_headers_all
1805: WHERE import_list_header_id = l_import_list_header_id;
1806:
1807: l_data_count NUMBER := p_data.COUNT;
1808: BEGIN

Line 1916: UPDATE ams_imp_list_headers_all

1912: CLOSE c_get_status_id;
1913:
1914: --huili added NULL checking for l_status_id
1915: IF l_status_id IS NOT NULL THEN
1916: UPDATE ams_imp_list_headers_all
1917: SET status_code = 'STAGED',
1918: --loaded_no_of_rows = p_row_count,
1919: loaded_date = SYSDATE, user_status_id = l_status_id
1920: WHERE import_list_header_id = p_import_list_header_id;

Line 1922: UPDATE ams_imp_list_headers_all

1918: --loaded_no_of_rows = p_row_count,
1919: loaded_date = SYSDATE, user_status_id = l_status_id
1920: WHERE import_list_header_id = p_import_list_header_id;
1921: ELSE
1922: UPDATE ams_imp_list_headers_all
1923: SET status_code = 'STAGED',
1924: --loaded_no_of_rows = p_row_count,
1925: loaded_date = SYSDATE
1926: WHERE import_list_header_id = p_import_list_header_id;