DBA Data[Home] [Help]

APPS.AMS_LIST_IMPORT_PUB dependencies on HZ_PARTIES_S

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