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

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

803: if x_org_party_id is NULL then
804: /*
805: x_party_number := null;
806: if x_generate_party_number = 'N' then
807: select hz_party_number_s.nextval into x_party_number from dual;
808: end if;
809: select hz_parties_s.nextval into x_org_party_id from dual;
810:
811: org_rec.party_rec.party_number := x_party_number;

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

805: x_party_number := null;
806: if x_generate_party_number = 'N' then
807: select hz_party_number_s.nextval into x_party_number from dual;
808: end if;
809: select hz_parties_s.nextval into x_org_party_id from dual;
810:
811: org_rec.party_rec.party_number := x_party_number;
812: org_rec.party_rec.party_id := x_org_party_id;
813: */

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

830: org_rec.application_id := 530;
831: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_org_party_id is NULL)) then
832: x_party_number := null;
833: if x_generate_party_number = 'N' then
834: select hz_party_number_s.nextval into x_party_number from dual;
835: end if;
836: select hz_parties_s.nextval into x_org_party_id from dual;
837: org_rec.party_rec.party_number := x_party_number;
838: org_rec.party_rec.party_id := x_org_party_id;

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

832: x_party_number := null;
833: if x_generate_party_number = 'N' then
834: select hz_party_number_s.nextval into x_party_number from dual;
835: end if;
836: select hz_parties_s.nextval into x_org_party_id from dual;
837: org_rec.party_rec.party_number := x_party_number;
838: org_rec.party_rec.party_id := x_org_party_id;
839: hz_party_v2pub.create_organization(
840: 'F',

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

1012: if x_per_party_id is null then
1013: if person_rec.person_first_name is not null then
1014: /*
1015: if x_generate_party_number = 'N' then
1016: select hz_party_number_s.nextval into x_party_number from dual;
1017: end if;
1018: select hz_parties_s.nextval into x_per_party_id from dual;
1019:
1020: person_rec.party_rec.party_number := x_party_number;

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

1014: /*
1015: if x_generate_party_number = 'N' then
1016: select hz_party_number_s.nextval into x_party_number from dual;
1017: end if;
1018: select hz_parties_s.nextval into x_per_party_id from dual;
1019:
1020: person_rec.party_rec.party_number := x_party_number;
1021: person_rec.party_rec.party_id := x_per_party_id;
1022:

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

1035: person_rec.party_rec.status := 'I';
1036: end if;
1037: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_per_party_id is NULL)) then
1038: if x_generate_party_number = 'N' then
1039: select hz_party_number_s.nextval into x_party_number from dual;
1040: end if;
1041: select hz_parties_s.nextval into x_per_party_id from dual;
1042:
1043: person_rec.party_rec.party_number := x_party_number;

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

1037: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_per_party_id is NULL)) then
1038: if x_generate_party_number = 'N' then
1039: select hz_party_number_s.nextval into x_party_number from dual;
1040: end if;
1041: select hz_parties_s.nextval into x_per_party_id from dual;
1042:
1043: person_rec.party_rec.party_number := x_party_number;
1044: person_rec.party_rec.party_id := x_per_party_id;
1045:

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

1110: if p_pr_party_id is not null then
1111: x_party_rel_party_id := p_pr_party_id;
1112: end if;
1113: if p_pr_party_id is null then
1114: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;
1115: if x_generate_party_number = 'N' then
1116: select hz_party_number_s.nextval into x_party_number from dual;
1117: end if;
1118:

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

1112: end if;
1113: if p_pr_party_id is null then
1114: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;
1115: if x_generate_party_number = 'N' then
1116: select hz_party_number_s.nextval into x_party_number from dual;
1117: end if;
1118:
1119: ocon_rec.party_rel_rec.subject_id := x_per_party_id;
1120: ocon_rec.party_rel_rec.object_id := x_org_party_id;

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

1162: IF x_generate_party_number = 'N' THEN
1163: ocon_rec.party_rel_rec.party_rec.party_number := x_party_number;
1164: END IF;
1165: IF x_gen_contact_number = 'N' THEN
1166: select hz_contact_numbers_s.nextval into x_contact_number from dual;
1167: end if;
1168: ocon_rec.contact_number := x_contact_number;
1169: -- ocon_rec.status := 'A';
1170: if x_rented_list_flag = 'R' then

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

2330:
2331: if x_per_party_id is null then
2332: /*
2333: if x_generate_party_number = 'N' then
2334: select hz_party_number_s.nextval into x_party_number from dual;
2335: end if;
2336: select hz_parties_s.nextval into x_per_party_id from dual;
2337:
2338: person_rec.party_rec.party_number := x_party_number;

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

2332: /*
2333: if x_generate_party_number = 'N' then
2334: select hz_party_number_s.nextval into x_party_number from dual;
2335: end if;
2336: select hz_parties_s.nextval into x_per_party_id from dual;
2337:
2338: person_rec.party_rec.party_number := x_party_number;
2339: person_rec.party_rec.party_id := x_per_party_id;
2340: */

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

2358: */
2359: person_rec.application_id := 530;
2360: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_per_party_id is NULL)) then
2361: if x_generate_party_number = 'N' then
2362: select hz_party_number_s.nextval into x_party_number from dual;
2363: end if;
2364: select hz_parties_s.nextval into x_per_party_id from dual;
2365: person_rec.party_rec.party_number := x_party_number;
2366: person_rec.party_rec.party_id := x_per_party_id;

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

2360: if (l_rec_update_flag = 'N' or (l_rec_update_flag = 'Y' and x_per_party_id is NULL)) then
2361: if x_generate_party_number = 'N' then
2362: select hz_party_number_s.nextval into x_party_number from dual;
2363: end if;
2364: select hz_parties_s.nextval into x_per_party_id from dual;
2365: person_rec.party_rec.party_number := x_party_number;
2366: person_rec.party_rec.party_id := x_per_party_id;
2367:
2368:

Line 2805: -- SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

2801:
2802: -- Create contact points Email
2803:
2804: if x_email_address is not NULL and x_per_party_id is not null then
2805: -- SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
2806:
2807: x_return_status := null;
2808: x_msg_count := null;
2809: x_msg_data := null;