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 2349: select as_import_interface_s.nextval into l_batch_id from dual;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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