DBA Data[Home] [Help]

APPS.AMS_REGISTRANTS_PVT dependencies on HZ_PARTIES_S

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 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 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;