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

Line 634: select hz_party_number_s.nextval into x_party_number from dual;

630: END IF;*/
631: Write_log(L_API_NAME, 'B2B: Organization is NULL');
632: x_party_number := null;
633: if x_generate_party_number = 'N' then
634: select hz_party_number_s.nextval into x_party_number from dual;
635: end if;
636: select hz_parties_s.nextval into x_org_party_id from dual;
637: org_rec.party_rec.party_number := x_party_number;
638: org_rec.party_rec.party_id := x_org_party_id;

Line 636: select hz_parties_s.nextval into x_org_party_id from dual;

632: x_party_number := null;
633: if x_generate_party_number = 'N' then
634: select hz_party_number_s.nextval into x_party_number from dual;
635: end if;
636: select hz_parties_s.nextval into x_org_party_id from dual;
637: org_rec.party_rec.party_number := x_party_number;
638: org_rec.party_rec.party_id := x_org_party_id;
639: org_rec.ceo_name := p_rec.ceo_name;
640: org_rec.curr_fy_potential_revenue := p_rec.current_fy_potential_rev;

Line 741: select hz_party_number_s.nextval into x_party_number from dual;

737: END IF;*/
738: Write_log(L_API_NAME, 'B2B: Creating Person' || person_rec.person_first_name);
739: if person_rec.person_first_name is not null then
740: if x_generate_party_number = 'N' then
741: select hz_party_number_s.nextval into x_party_number from dual;
742: end if;
743: select hz_parties_s.nextval into x_per_party_id from dual;
744: person_rec.party_rec.party_number := x_party_number;
745: person_rec.party_rec.party_id := x_per_party_id;

Line 743: select hz_parties_s.nextval into x_per_party_id from dual;

739: if person_rec.person_first_name is not null then
740: if x_generate_party_number = 'N' then
741: select hz_party_number_s.nextval into x_party_number from dual;
742: end if;
743: select hz_parties_s.nextval into x_per_party_id from dual;
744: person_rec.party_rec.party_number := x_party_number;
745: person_rec.party_rec.party_id := x_per_party_id;
746: x_return_status := null;
747: x_msg_count := 0;

Line 815: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;

811: AMS_UTILITY_PVT.debug_message('B2B :Creating Org Contact' || p_pr_party_id);
812: END IF;*/
813: Write_log(L_API_NAME, 'B2B :Creating Org Contact' || p_pr_party_id);
814:
815: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;
816: if x_generate_party_number = 'N' then
817: select hz_party_number_s.nextval into x_party_number from dual;
818: end if;
819:

Line 817: select hz_party_number_s.nextval into x_party_number from dual;

813: Write_log(L_API_NAME, 'B2B :Creating Org Contact' || p_pr_party_id);
814:
815: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;
816: if x_generate_party_number = 'N' then
817: select hz_party_number_s.nextval into x_party_number from dual;
818: end if;
819:
820: ocon_rec.party_rel_rec.subject_id := x_per_party_id;
821: ocon_rec.party_rel_rec.object_id := x_org_party_id;

Line 833: select hz_contact_numbers_s.nextval into x_contact_number from dual;

829: IF x_generate_party_number = 'N' THEN
830: ocon_rec.party_rel_rec.party_rec.party_number := x_party_number;
831: END IF;
832: IF x_gen_contact_number = 'N' THEN
833: select hz_contact_numbers_s.nextval into x_contact_number from dual;
834: end if;
835: ocon_rec.contact_number := x_contact_number;
836: -- Obsolete in TCA V2 ocon_rec.status
837: -- ocon_rec.status := 'A';

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

900: Write_log(L_API_NAME, 'B2B:Creating Location' || location_rec.address1);
901: x_return_status := null;
902: x_msg_count := null;
903: x_msg_data := null;
904: select hr_locations_s.nextval into x_location_id from dual;
905: location_rec.location_id := X_location_Id;
906: location_rec.orig_system_reference := x_location_id ;
907: location_rec.created_by_module := 'AMS_EVENT';
908:

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

952: x_return_status := null;
953: x_msg_count := null;
954: x_msg_data := null;
955: x_party_site_number := null;
956: select hz_party_sites_s.nextval into x_party_site_id from dual;
957: if x_gen_party_site_number = 'N' then
958: select hz_party_site_number_s.nextval into x_party_site_number from dual;
959: end if;
960:

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

954: x_msg_data := null;
955: x_party_site_number := null;
956: select hz_party_sites_s.nextval into x_party_site_id from dual;
957: if x_gen_party_site_number = 'N' then
958: select hz_party_site_number_s.nextval into x_party_site_number from dual;
959: end if;
960:
961: psite_rec.party_site_id := x_party_site_id;
962: psite_rec.party_id := x_org_party_id;

Line 1007: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;

1003: end if;
1004:
1005: if (p_rec.site_use_code is not null)
1006: then
1007: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;
1008:
1009: psite_use_rec.site_use_type := p_rec.site_use_code;
1010: psite_use_rec.party_site_id := x_party_site_id;
1011: psite_use_rec.party_site_use_id := x_party_site_use_id;

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

1065: x_return_status := null;
1066: x_msg_count := null;
1067: x_msg_data := null;
1068: x_party_site_number := null;
1069: select hz_party_sites_s.nextval into x_party_site_id from dual;
1070: if x_gen_party_site_number = 'N' then
1071: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1072: end if;
1073:

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

1067: x_msg_data := null;
1068: x_party_site_number := null;
1069: select hz_party_sites_s.nextval into x_party_site_id from dual;
1070: if x_gen_party_site_number = 'N' then
1071: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1072: end if;
1073:
1074: psite_rec.party_site_id := x_party_site_id;
1075: psite_rec.party_id := x_party_rel_party_id;

Line 1118: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;

1114: end if;
1115:
1116: if (p_rec.site_use_code is not null)
1117: then
1118: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;
1119:
1120: psite_use_rec.site_use_type := p_rec.site_use_code;
1121: psite_use_rec.party_site_id := x_party_site_id;
1122: psite_use_rec.party_site_use_id := x_party_site_use_id;

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

1162:
1163: -- Create contact points Phone
1164:
1165: if x_phone_number is not NULL and x_party_rel_party_id is not null then
1166: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1167: x_return_status := null;
1168: x_msg_count := null;
1169: x_msg_data := null;
1170: cpoint_rec.contact_point_id := x_contact_point_id;

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

1229:
1230: -- Create contact points Email
1231:
1232: if x_email_address is not NULL and x_party_rel_party_id is not null then
1233: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1234:
1235: x_return_status := null;
1236: x_msg_count := null;
1237: x_msg_data := null;

Line 1399: select hz_party_number_s.nextval into x_party_number from dual;

1395: Write_log(L_API_NAME, 'B2c:Party_id exists ' || x_per_party_id);
1396:
1397: if x_per_party_id is null then
1398: if x_generate_party_number = 'N' then
1399: select hz_party_number_s.nextval into x_party_number from dual;
1400: end if;
1401: select hz_parties_s.nextval into x_per_party_id from dual;
1402:
1403: person_rec.party_rec.party_number := x_party_number;

Line 1401: select hz_parties_s.nextval into x_per_party_id from dual;

1397: if x_per_party_id is null then
1398: if x_generate_party_number = 'N' then
1399: select hz_party_number_s.nextval into x_party_number from dual;
1400: end if;
1401: select hz_parties_s.nextval into x_per_party_id from dual;
1402:
1403: person_rec.party_rec.party_number := x_party_number;
1404: person_rec.party_rec.party_id := x_per_party_id;
1405: x_return_status := null;

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

1468: -- Create Location
1469: x_return_status := null;
1470: x_msg_count := null;
1471: x_msg_data := null;
1472: select hr_locations_s.nextval into x_location_id from dual;
1473: location_rec.location_id := X_location_Id;
1474: location_rec.orig_system_reference := x_location_id ;
1475: /*IF (AMS_DEBUG_HIGH_ON) THEN
1476:

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

1528: x_return_status := null;
1529: x_msg_count := null;
1530: x_msg_data := null;
1531: x_party_site_number := null;
1532: select hz_party_sites_s.nextval into x_party_site_id from dual;
1533: if x_gen_party_site_number = 'N' then
1534: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1535: end if;
1536:

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

1530: x_msg_data := null;
1531: x_party_site_number := null;
1532: select hz_party_sites_s.nextval into x_party_site_id from dual;
1533: if x_gen_party_site_number = 'N' then
1534: select hz_party_site_number_s.nextval into x_party_site_number from dual;
1535: end if;
1536:
1537: psite_rec.party_site_id := x_party_site_id;
1538: psite_rec.party_id := x_per_party_id;

Line 1618: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;

1614: end if;
1615: end if;
1616: if (p_rec.site_use_code is not null)
1617: then
1618: select hz_party_site_uses_s.nextval into x_party_site_use_id from dual;
1619:
1620: psite_use_rec.site_use_type := p_rec.site_use_code;
1621: psite_use_rec.party_site_id := x_party_site_id;
1622: psite_use_rec.party_site_use_id := x_party_site_use_id;

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

1656: -- ***************************************************8
1657: -- Create contact points Phone
1658:
1659: if x_phone_number is not NULL and x_per_party_id is not null then
1660: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1661:
1662: x_return_status := null;
1663: x_msg_count := null;
1664: x_msg_data := null;

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

1727:
1728: -- Create contact points Email
1729:
1730: if x_email_address is not NULL and x_per_party_id is not null then
1731: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1732:
1733: x_return_status := null;
1734: x_msg_count := null;
1735: x_msg_data := null;