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_IMPORT_LIST_PVT dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 214: UPDATE AMS_IMP_LIST_HEADERS_ALL

210: -- || ' l_repeat_interval::' || l_repeat_interval || ' l_repeat_unit::' || l_repeat_unit
211: -- || ' l_repeate_end_time::' || l_repeate_end_time || ' l_repeate_start_time::' || l_repeate_start_time);
212: NULL;
213: END IF;
214: UPDATE AMS_IMP_LIST_HEADERS_ALL
215: SET REPEAT_MODE = l_repeat_mode, CANCEL_DATE = l_cancel_date,
216: CANCEL_FLAG = l_cancel_flag, REPEAT_TIME = l_repeat_time,
217: REPEAT_INTERVAL = l_repeat_interval, REPEAT_UNIT = l_repeat_unit,
218: REPEAT_END_TIME = l_repeate_end_time, REPEAT_START_TIME = l_repeate_start_time

Line 587: FROM AMS_IMP_LIST_HEADERS_ALL

583: parent_imp_header_id,
584: record_update_flag,
585: error_threshold,
586: charset
587: FROM AMS_IMP_LIST_HEADERS_ALL
588: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
589:
590: l_current_date DATE := SYSDATE;
591:

Line 632: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id

628: OPEN c_get_status_id('AMS_IMPORT_STATUS', 'NEW', 'Y');
629: FETCH c_get_status_id INTO l_status_id;
630: CLOSE c_get_status_id;
631:
632: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id
633: FROM DUAL;
634:
635: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List');
636:

Line 672: update AMS_IMP_LIST_HEADERS_ALL

668: || ' the p_import_list_header_id::' || p_import_list_header_id
669: || ' and the x_ams_import_rec.import_list_header_id::'
670: || x_ams_import_rec.import_list_header_id);
671:
672: update AMS_IMP_LIST_HEADERS_ALL
673: set ( generate_list, number_of_instances)=
674: (select generate_list, number_of_instances
675: from AMS_IMP_LIST_HEADERS_ALL
676: where import_list_header_id = p_import_list_header_id),

Line 675: from AMS_IMP_LIST_HEADERS_ALL

671:
672: update AMS_IMP_LIST_HEADERS_ALL
673: set ( generate_list, number_of_instances)=
674: (select generate_list, number_of_instances
675: from AMS_IMP_LIST_HEADERS_ALL
676: where import_list_header_id = p_import_list_header_id),
677: generated_list_name = name
678: where import_list_header_id = x_ams_import_rec.import_list_header_id;
679:

Line 680: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List after update AMS_IMP_LIST_HEADERS_ALL ');

676: where import_list_header_id = p_import_list_header_id),
677: generated_list_name = name
678: where import_list_header_id = x_ams_import_rec.import_list_header_id;
679:
680: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List after update AMS_IMP_LIST_HEADERS_ALL ');
681:
682: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;

Line 774: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL

770:
771: l_encrpted_password VARCHAR2 (2000);
772:
773: CURSOR c_id IS
774: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL
775: FROM dual;
776:
777: CURSOR c_id_exists (l_id IN NUMBER) IS
778: SELECT 1

Line 779: FROM AMS_IMP_LIST_HEADERS_ALL

775: FROM dual;
776:
777: CURSOR c_id_exists (l_id IN NUMBER) IS
778: SELECT 1
779: FROM AMS_IMP_LIST_HEADERS_ALL
780: WHERE IMPORT_LIST_HEADER_ID = l_id;
781:
782: CURSOR c_get_record (l_id IN NUMBER) IS
783: SELECT version, object_version_number, status_code, status_date,

Line 785: FROM AMS_IMP_LIST_HEADERS_ALL

781:
782: CURSOR c_get_record (l_id IN NUMBER) IS
783: SELECT version, object_version_number, status_code, status_date,
784: user_status_id, country, validate_file
785: FROM AMS_IMP_LIST_HEADERS_ALL
786: WHERE IMPORT_LIST_HEADER_ID = l_id;
787:
788: -- SOLIN, SQL repository
789: CURSOR c_get_status_id(c_status_type VARCHAR2, c_status_code VARCHAR2,

Line 1116: UPDATE AMS_IMP_LIST_HEADERS_ALL

1112: l_encrpted_password := AMS_Import_Security_PVT.Get_DeEncrypt_String (
1113: p_input_string => l_encrpted_password,
1114: p_header_id => l_import_list_header_id,
1115: p_encrypt_flag => TRUE);
1116: UPDATE AMS_IMP_LIST_HEADERS_ALL
1117: SET PASSWORD = l_encrpted_password
1118: WHERE IMPORT_LIST_HEADER_ID = l_import_list_header_id;
1119: END IF;
1120:

Line 1202: FROM AMS_IMP_LIST_HEADERS_ALL

1198: IS
1199:
1200: CURSOR c_get_import_list(import_list_header_id NUMBER) IS
1201: SELECT *
1202: FROM AMS_IMP_LIST_HEADERS_ALL
1203: WHERE import_list_header_id=p_ams_import_rec.import_list_header_id;
1204:
1205: -- Hint: Developer need to provide Where clause
1206: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Import_List';

Line 1591: FROM AMS_IMP_LIST_HEADERS_ALL

1587: l_IMPORT_LIST_HEADER_ID NUMBER;
1588:
1589: CURSOR c_Import_List IS
1590: SELECT IMPORT_LIST_HEADER_ID
1591: FROM AMS_IMP_LIST_HEADERS_ALL
1592: WHERE IMPORT_LIST_HEADER_ID = p_IMPORT_LIST_HEADER_ID
1593: AND object_version_number = p_object_version
1594: FOR UPDATE NOWAIT;
1595:

Line 1711: 'AMS_IMP_LIST_HEADERS_ALL',

1707: BEGIN
1708: x_return_status := FND_API.g_ret_sts_success;
1709: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1710: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1711: 'AMS_IMP_LIST_HEADERS_ALL',
1712: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||''''
1713: );
1714: ELSE
1715: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1716: 'AMS_IMP_LIST_HEADERS_ALL',

1712: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||''''
1713: );
1714: ELSE
1715: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1716: 'AMS_IMP_LIST_HEADERS_ALL',
1717: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||
1718: ''' AND IMPORT_LIST_HEADER_ID <> ' || p_ams_import_rec.IMPORT_LIST_HEADER_ID
1719: );
1720: END IF;

Line 1961: FROM AMS_IMP_LIST_HEADERS_ALL

1957: )
1958: IS
1959: CURSOR c_get_import_list(import_list_header_id NUMBER) IS
1960: SELECT *
1961: FROM AMS_IMP_LIST_HEADERS_ALL
1962: WHERE import_list_header_id=p_ams_import_rec.import_list_header_id;
1963: l_import_rec c_get_import_list%ROWTYPE;
1964:
1965: CURSOR c_get_import_list_name(name VARCHAR2) IS

Line 2152: FROM ams_imp_list_headers_all

2148: l_return_status VARCHAR2(1);
2149:
2150: CURSOR c_complete IS
2151: SELECT *
2152: FROM ams_imp_list_headers_all
2153: WHERE import_list_header_id = p_ams_import_rec.import_list_header_id;
2154: l_ams_import_rec c_complete%ROWTYPE;
2155:
2156: CURSOR c_status_id IS