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 594: FROM AMS_IMP_LIST_HEADERS_ALL

590: parent_imp_header_id,
591: record_update_flag,
592: error_threshold,
593: charset
594: FROM AMS_IMP_LIST_HEADERS_ALL
595: WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;
596:
597: l_current_date DATE := SYSDATE;
598:

Line 639: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id

635: OPEN c_get_status_id('AMS_IMPORT_STATUS', 'NEW', 'Y');
636: FETCH c_get_status_id INTO l_status_id;
637: CLOSE c_get_status_id;
638:
639: SELECT AMS_IMP_LIST_HEADERS_ALL_S.NEXTVAL INTO x_ams_import_rec.import_list_header_id
640: FROM DUAL;
641:
642: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List');
643:

Line 679: update AMS_IMP_LIST_HEADERS_ALL

675: || ' the p_import_list_header_id::' || p_import_list_header_id
676: || ' and the x_ams_import_rec.import_list_header_id::'
677: || x_ams_import_rec.import_list_header_id);
678:
679: update AMS_IMP_LIST_HEADERS_ALL
680: set ( generate_list, number_of_instances)=
681: (select generate_list, number_of_instances
682: from AMS_IMP_LIST_HEADERS_ALL
683: where import_list_header_id = p_import_list_header_id),

Line 682: from AMS_IMP_LIST_HEADERS_ALL

678:
679: update AMS_IMP_LIST_HEADERS_ALL
680: set ( generate_list, number_of_instances)=
681: (select generate_list, number_of_instances
682: from AMS_IMP_LIST_HEADERS_ALL
683: where import_list_header_id = p_import_list_header_id),
684: generated_list_name = name
685: where import_list_header_id = x_ams_import_rec.import_list_header_id;
686:

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

683: where import_list_header_id = p_import_list_header_id),
684: generated_list_name = name
685: where import_list_header_id = x_ams_import_rec.import_list_header_id;
686:
687: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List after update AMS_IMP_LIST_HEADERS_ALL ');
688:
689: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
690: RAISE FND_API.G_EXC_ERROR;
691: END IF;

Line 781: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL

777:
778: l_encrpted_password VARCHAR2 (2000);
779:
780: CURSOR c_id IS
781: SELECT AMS_IMP_LIST_HEADERS_ALL_s.NEXTVAL
782: FROM dual;
783:
784: CURSOR c_id_exists (l_id IN NUMBER) IS
785: SELECT 1

Line 786: FROM AMS_IMP_LIST_HEADERS_ALL

782: FROM dual;
783:
784: CURSOR c_id_exists (l_id IN NUMBER) IS
785: SELECT 1
786: FROM AMS_IMP_LIST_HEADERS_ALL
787: WHERE IMPORT_LIST_HEADER_ID = l_id;
788:
789: CURSOR c_get_record (l_id IN NUMBER) IS
790: SELECT version, object_version_number, status_code, status_date,

Line 792: FROM AMS_IMP_LIST_HEADERS_ALL

788:
789: CURSOR c_get_record (l_id IN NUMBER) IS
790: SELECT version, object_version_number, status_code, status_date,
791: user_status_id, country, validate_file
792: FROM AMS_IMP_LIST_HEADERS_ALL
793: WHERE IMPORT_LIST_HEADER_ID = l_id;
794:
795: -- SOLIN, SQL repository
796: CURSOR c_get_status_id(c_status_type VARCHAR2, c_status_code VARCHAR2,

Line 1123: UPDATE AMS_IMP_LIST_HEADERS_ALL

1119: l_encrpted_password := AMS_Import_Security_PVT.Get_DeEncrypt_String (
1120: p_input_string => l_encrpted_password,
1121: p_header_id => l_import_list_header_id,
1122: p_encrypt_flag => TRUE);
1123: UPDATE AMS_IMP_LIST_HEADERS_ALL
1124: SET PASSWORD = l_encrpted_password
1125: WHERE IMPORT_LIST_HEADER_ID = l_import_list_header_id;
1126: END IF;
1127:

Line 1209: FROM AMS_IMP_LIST_HEADERS_ALL

1205: IS
1206:
1207: CURSOR c_get_import_list(import_list_header_id NUMBER) IS
1208: SELECT *
1209: FROM AMS_IMP_LIST_HEADERS_ALL
1210: WHERE import_list_header_id=p_ams_import_rec.import_list_header_id;
1211:
1212: -- Hint: Developer need to provide Where clause
1213: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Import_List';

Line 1598: FROM AMS_IMP_LIST_HEADERS_ALL

1594: l_IMPORT_LIST_HEADER_ID NUMBER;
1595:
1596: CURSOR c_Import_List IS
1597: SELECT IMPORT_LIST_HEADER_ID
1598: FROM AMS_IMP_LIST_HEADERS_ALL
1599: WHERE IMPORT_LIST_HEADER_ID = p_IMPORT_LIST_HEADER_ID
1600: AND object_version_number = p_object_version
1601: FOR UPDATE NOWAIT;
1602:

Line 1718: 'AMS_IMP_LIST_HEADERS_ALL',

1714: BEGIN
1715: x_return_status := FND_API.g_ret_sts_success;
1716: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1717: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1718: 'AMS_IMP_LIST_HEADERS_ALL',
1719: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||''''
1720: );
1721: ELSE
1722: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1723: 'AMS_IMP_LIST_HEADERS_ALL',

1719: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||''''
1720: );
1721: ELSE
1722: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1723: 'AMS_IMP_LIST_HEADERS_ALL',
1724: 'IMPORT_LIST_HEADER_ID = ''' || p_ams_import_rec.IMPORT_LIST_HEADER_ID ||
1725: ''' AND IMPORT_LIST_HEADER_ID <> ' || p_ams_import_rec.IMPORT_LIST_HEADER_ID
1726: );
1727: END IF;

Line 1968: FROM AMS_IMP_LIST_HEADERS_ALL

1964: )
1965: IS
1966: CURSOR c_get_import_list(import_list_header_id NUMBER) IS
1967: SELECT *
1968: FROM AMS_IMP_LIST_HEADERS_ALL
1969: WHERE import_list_header_id=p_ams_import_rec.import_list_header_id;
1970: l_import_rec c_get_import_list%ROWTYPE;
1971:
1972: CURSOR c_get_import_list_name(name VARCHAR2) IS

Line 2159: FROM ams_imp_list_headers_all

2155: l_return_status VARCHAR2(1);
2156:
2157: CURSOR c_complete IS
2158: SELECT *
2159: FROM ams_imp_list_headers_all
2160: WHERE import_list_header_id = p_ams_import_rec.import_list_header_id;
2161: l_ams_import_rec c_complete%ROWTYPE;
2162:
2163: CURSOR c_status_id IS