79: -- are needed when calling the derive person names function
80: --
81: cursor csr_get_person_details is
82: select *
83: from per_all_people_f
84: where rowid = X_rowid;
85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
83: from per_all_people_f
84: where rowid = X_rowid;
85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);
84: where rowid = X_rowid;
85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);
92: --
85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);
92: --
93: BEGIN
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);
92: --
93: BEGIN
94: l_dup_name := 'N';