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.

[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_IMP_DOCUMENTS

Line 3463: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;

3459: L_MESG_TEXT VARCHAR2(2000);
3460:
3461:
3462: cursor c_file_type is
3463: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;
3464:
3465: cursor c_imptype is
3466: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;
3467:

Line 3613: select file_size, file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;

3609: L_MESG_TEXT varchar2(2000);
3610: L_LOOKUP_CODE varchar2(30);
3611:
3612: cursor c_prof_file_size is
3613: select file_size, file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
3614:
3615: cursor c_imptype is
3616: select import_type from ams_imp_list_headers_all where import_list_header_id = p_import_list_header_id;
3617:

Line 3766: select file_type from ams_imp_documents

3762: WHERE import_list_header_id = p_import_list_header_id
3763: AND load_status <> 'DUPLICATE';
3764:
3765: cursor c_file_type is
3766: select file_type from ams_imp_documents
3767: where import_list_header_id = p_import_list_header_id;
3768:
3769: cursor c_dup_recs is
3770: select COL68 from ams_imp_source_lines

Line 7740: select file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;

7736: select per_imp_xml_element_id, add_imp_xml_element_id,cp_imp_xml_element_id, em_imp_xml_element_id
7737: from ams_hz_b2c_mapping_v where import_source_line_id = p_import_source_line_id;
7738:
7739: cursor c_file_type is
7740: select file_type from AMS_IMP_DOCUMENTS where import_list_header_id = p_import_list_header_id;
7741:
7742: begin
7743: FND_MESSAGE.set_name('AMS', 'AMS_IMP_FLD_DATE_VAL_ERROR_CHK');
7744: l_invalid_date := FND_MESSAGE.get;

Line 13700: select 'Y' from ams_imp_xml_elements e, ams_imp_documents d

13696: and load_status in ('ACTIVE','RELOAD')
13697: and rownum < 2;
13698:
13699: cursor c_rec_in_xml_stag_tab is
13700: select 'Y' from ams_imp_xml_elements e, ams_imp_documents d
13701: where d.import_list_header_id = p_import_list_header_id
13702: and d.imp_document_id = e.imp_xml_document_id
13703: and e.load_status in ('ACTIVE','RELOAD')
13704: and rownum < 2;

Line 13721: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;

13717: SELECT concurrent_program FROM ams_imp_list_import_types
13718: where import_type = x_imp_type;
13719:
13720: cursor c_file_type is
13721: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;
13722:
13723: cursor c_total_records is
13724: select count(*) from ams_imp_source_lines
13725: where import_list_header_id = p_import_list_header_id

Line 20924: select file_type from ams_imp_documents

20920: where import_list_header_id = p_import_list_header_id
20921: and load_status = G_STATUS_DUPLICATE;
20922:
20923: cursor c_file_type is
20924: select file_type from ams_imp_documents
20925: where import_list_header_id = p_import_list_header_id;
20926:
20927: cursor c_dup_xml_recs is
20928: select COL68 from ams_imp_source_lines