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_LISTIMPORT_PVT dependencies on DUAL

Line 2348: select as_import_interface_s.nextval into l_batch_id from dual;

2344: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2345: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2346: system_status_code = 'STAGED' and default_flag = 'Y';
2347:
2348: select as_import_interface_s.nextval into l_batch_id from dual;
2349:
2350: UPDATE ams_imp_list_headers_all
2351: set status_code = l_lookup_code,
2352: user_status_id = l_user_status_id,

Line 7826: select to_date(p_column1, x_date_format) into l_date1 from dual;

7822: */
7823: if p_column1 is not null then
7824: begin
7825: -- l_date1 := to_date(p_column1,'MM/DD/YYYY');
7826: select to_date(p_column1, x_date_format) into l_date1 from dual;
7827: AMS_Utility_PVT.Create_Log (
7828: x_return_status => l_return_status,
7829: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7830: p_log_used_by_id => p_import_list_header_id,

Line 7843: select to_date(p_column2, x_date_format) into l_date2 from dual;

7839: end if;
7840: if p_column2 is not null then
7841: begin
7842: -- l_date2 := to_date(p_column2,'MM/DD/YYYY');
7843: select to_date(p_column2, x_date_format) into l_date2 from dual;
7844: AMS_Utility_PVT.Create_Log (
7845: x_return_status => l_return_status,
7846: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7847: p_log_used_by_id => p_import_list_header_id,

Line 7860: select to_date(p_column3, x_date_format) into l_date3 from dual;

7856: end if;
7857: if p_column3 is not null then
7858: begin
7859: -- l_date3 := to_date(p_column3,'MM/DD/YYYY');
7860: select to_date(p_column3, x_date_format) into l_date3 from dual;
7861: AMS_Utility_PVT.Create_Log (
7862: x_return_status => l_return_status,
7863: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7864: p_log_used_by_id => p_import_list_header_id,

Line 7878: select to_date(p_column4, x_date_format) into l_date4 from dual;

7874:
7875: if p_column4 is not null then
7876: begin
7877: -- l_date4 := to_date(p_column4,'MM/DD/YYYY');
7878: select to_date(p_column4, x_date_format) into l_date4 from dual;
7879: AMS_Utility_PVT.Create_Log (
7880: x_return_status => l_return_status,
7881: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7882: p_log_used_by_id => p_import_list_header_id,

Line 7897: select to_date(p_column5, x_date_format) into l_date5 from dual;

7893:
7894: if p_column5 is not null then
7895: begin
7896: -- l_date5 := to_date(p_column5,'MM/DD/YYYY');
7897: select to_date(p_column5, x_date_format) into l_date5 from dual;
7898: AMS_Utility_PVT.Create_Log (
7899: x_return_status => l_return_status,
7900: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7901: p_log_used_by_id => p_import_list_header_id,

Line 7914: select to_date(p_column6, x_date_format) into l_date6 from dual;

7910:
7911: if p_column6 is not null then
7912: begin
7913: -- l_date6 := to_date(p_column6,'MM/DD/YYYY');
7914: select to_date(p_column6, x_date_format) into l_date6 from dual;
7915: AMS_Utility_PVT.Create_Log (
7916: x_return_status => l_return_status,
7917: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
7918: p_log_used_by_id => p_import_list_header_id,

Line 13439: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

13435: telex_rec hz_contact_point_v2pub.telex_rec_type := p_telex_rec;
13436: web_rec hz_contact_point_v2pub.web_rec_type := p_web_rec ;
13437:
13438: begin
13439: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
13440:
13441: cpoint_rec.contact_point_id := x_contact_point_id;
13442: cpoint_rec.orig_system_reference := x_contact_point_id;
13443: cpoint_rec.CREATED_BY_MODULE := 'AMS_LIST_IMPORT';

Line 13541: select hr_locations_s.nextval into x_location_id from dual;

13537: location_rec hz_location_v2pub.location_rec_type := p_location_rec;
13538:
13539: BEGIN
13540:
13541: select hr_locations_s.nextval into x_location_id from dual;
13542: location_rec.location_id := x_location_Id;
13543: location_rec.orig_system_reference := x_location_id ;
13544: location_rec.CREATED_BY_MODULE := 'AMS_LIST_IMPORT';
13545: location_rec.application_id := 530;

Line 13575: select hz_party_sites_s.nextval into x_party_site_id from dual;

13571:
13572: begin
13573: x_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
13574: x_party_site_number := null;
13575: select hz_party_sites_s.nextval into x_party_site_id from dual;
13576: if x_gen_party_site_number = 'N' then
13577: select hz_party_site_number_s.nextval into x_party_site_number from dual;
13578: end if;
13579:

Line 13577: select hz_party_site_number_s.nextval into x_party_site_number from dual;

13573: x_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
13574: x_party_site_number := null;
13575: select hz_party_sites_s.nextval into x_party_site_id from dual;
13576: if x_gen_party_site_number = 'N' then
13577: select hz_party_site_number_s.nextval into x_party_site_number from dual;
13578: end if;
13579:
13580: psite_rec.party_site_id := x_party_site_id;
13581: psite_rec.party_site_number := x_party_site_number;

Line 13806: select as_import_interface_s.nextval into l_batch_id from dual;

13802: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
13803: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
13804: system_status_code = 'STAGED' and default_flag = 'Y';
13805:
13806: select as_import_interface_s.nextval into l_batch_id from dual;
13807:
13808: UPDATE ams_imp_list_headers_all
13809: set status_code = l_lookup_code,
13810: user_status_id = l_user_status_id,