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 1110: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;

1106: if p_pr_party_id is not null then
1107: x_party_rel_party_id := p_pr_party_id;
1108: end if;
1109: if p_pr_party_id is null then
1110: Select hz_org_contacts_s.nextval into x_org_contact_id from dual;
1111: if x_generate_party_number = 'N' then
1112: select hz_party_number_s.nextval into x_party_number from dual;
1113: end if;
1114:

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

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

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

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

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

2326:
2327: if x_per_party_id is null then
2328: /*
2329: if x_generate_party_number = 'N' then
2330: select hz_party_number_s.nextval into x_party_number from dual;
2331: end if;
2332: select hz_parties_s.nextval into x_per_party_id from dual;
2333:
2334: person_rec.party_rec.party_number := x_party_number;

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

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

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

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

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

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

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

2794:
2795: -- Create contact points Email
2796:
2797: if x_email_address is not NULL and x_per_party_id is not null then
2798: -- SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
2799:
2800: x_return_status := null;
2801: x_msg_count := null;
2802: x_msg_data := null;