DBA Data[Home] [Help]

APPS.ARH_CONT_PKG dependencies on HZ_PARTY_NUMBER_S

Line 625: select hz_party_number_s.nextval into i_subject_party_number from dual;

621: -- BugFix:2225260
622: --- If Subject Party does not exist,added this following if clause.
623: --
624: IF X_Sub_Party_Id IS NULL THEN
625: select hz_party_number_s.nextval into i_subject_party_number from dual;
626: select hz_parties_s.nextval into i_subject_party_id from dual;
627: ELSE
628: i_subject_party_id := X_Sub_Party_Id;
629: END IF;

Line 702: SELECT hz_party_number_s.nextval INTO ii_party_number FROM DUAL;

698: OPEN cu_party_type(i_subject_party_id);
699: FETCH cu_party_type INTO l_subject_type;
700: CLOSE cu_party_type;
701:
702: SELECT hz_party_number_s.nextval INTO ii_party_number FROM DUAL;
703:
704: ocon_rec.party_rel_rec.subject_id := i_subject_party_id;
705: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
706: -- ocon_rec.party_rel_rec.subject_type := 'PERSON';