[Home] [Help]
655: p_action_num in number,
656: p_pa_req in out nocopy ghr_pa_requests%rowtype) IS
657:
658: TYPE fields_type is record
659: (form_field_name ghr_pa_data_fields.form_field_name%TYPE,
660: process_method_code ghr_noa_fam_proc_methods.process_method_code%TYPE
661: );
662: CURSOR get_root_pa_hist_id( cp_pa_request_id in number,
663: cp_noa_id in number) IS
702: l_proc varchar2(30):='assign_new_rg';
703:
704: PROCEDURE initialize_fld_names_table ( p_noa_id in number,
705: p_fld_names_tab in out nocopy fld_names_typ) IS
706: -- initializes the local pl/sql table with the field names from ghr_pa_data_fields table.
707: -- this cursor fetches the form_field_names for the noa_id specified.
708: CURSOR cur_flds(p_noa_id number) IS
709: SELECT fld.form_field_name,
710: met.process_method_code
710: met.process_method_code
711: FROM
712: ghr_families ghrf,
713: ghr_noa_fam_proc_methods met,
714: ghr_pa_data_fields fld,
715: ghr_noa_families fam
716: WHERE
717: fam.noa_family_code = met.noa_family_code
718: AND ghrf.noa_family_code = met.noa_family_code
3542: select fpm.process_method_code
3543: from ghr_noa_families nof
3544: ,ghr_families fam
3545: ,ghr_noa_fam_proc_methods fpm
3546: ,ghr_pa_data_fields pdf
3547: where nof.nature_of_action_id = p_noa_id
3548: and nof.noa_family_code = fam.noa_family_code
3549: and nof.enabled_flag = 'Y'
3550: and p_effective_date between nvl(nof.start_date_active,p_effective_date) and nvl(nof.end_date_active,p_effective_date)
4505: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
4506: p_pa_req_out out nocopy ghr_pa_requests%rowtype) IS
4507:
4508: TYPE fields_type is record
4509: (form_field_name ghr_pa_data_fields.form_field_name%TYPE );
4510:
4511: TYPE fld_names_typ is TABLE of fields_type
4512: INDEX BY BINARY_INTEGER;
4513: l_fld_names_tab fld_names_typ;
4519: PROCEDURE initialize_fld_names_table (p_1st_noa_id in number,
4520: p_2nd_noa_id in number default null,
4521: p_fld_names_tab in out nocopy fld_names_typ) IS
4522: --
4523: -- initializes the local pl/sql table with the field names from ghr_pa_data_fields table.
4524: --
4525: --
4526: -- this cursor fetches the form_field_names for the 1st_noa_id and 2nd_noa_id specified.
4527: CURSOR cur_flds2( p_1st_noa_id number,
4529: SELECT fld.form_field_name
4530: FROM
4531: ghr_families ghrf,
4532: ghr_noa_fam_proc_methods met,
4533: ghr_pa_data_fields fld,
4534: ghr_noa_families fam
4535: WHERE
4536: fam.noa_family_code = met.noa_family_code
4537: AND ghrf.noa_family_code = met.noa_family_code
4543: SELECT fld2.form_field_name
4544: FROM
4545: ghr_families ghrf2,
4546: ghr_noa_fam_proc_methods met2,
4547: ghr_pa_data_fields fld2,
4548: ghr_noa_families fam2
4549: WHERE
4550: fam2.noa_family_code = met2.noa_family_code
4551: AND ghrf2.noa_family_code = met2.noa_family_code
4558: SELECT fld.form_field_name
4559: FROM
4560: ghr_families ghrf,
4561: ghr_noa_fam_proc_methods met,
4562: ghr_pa_data_fields fld,
4563: ghr_noa_families fam
4564: WHERE
4565: fam.noa_family_code = met.noa_family_code
4566: AND ghrf.noa_family_code = met.noa_family_code
4573: SELECT fld.form_field_name
4574: FROM
4575: ghr_families ghrf,
4576: ghr_noa_fam_proc_methods met,
4577: ghr_pa_data_fields fld,
4578: ghr_noa_families fam
4579: WHERE
4580: fam.noa_family_code = met.noa_family_code
4581: AND ghrf.noa_family_code = met.noa_family_code
4589: SELECT fld.form_field_name
4590: FROM
4591: ghr_families ghrf,
4592: ghr_noa_fam_proc_methods met,
4593: ghr_pa_data_fields fld,
4594: ghr_noa_families fam
4595: WHERE
4596: fam.noa_family_code = met.noa_family_code
4597: AND ghrf.noa_family_code = met.noa_family_code