[Home] [Help]
747: p_action_num in number,
748: p_pa_req in out nocopy ghr_pa_requests%rowtype) IS
749:
750: TYPE fields_type is record
751: (form_field_name ghr_pa_data_fields.form_field_name%TYPE,
752: process_method_code ghr_noa_fam_proc_methods.process_method_code%TYPE
753: );
754: CURSOR get_root_pa_hist_id( cp_pa_request_id in number,
755: cp_noa_id in number) IS
794: l_proc varchar2(30):='assign_new_rg';
795:
796: PROCEDURE initialize_fld_names_table ( p_noa_id in number,
797: p_fld_names_tab in out nocopy fld_names_typ) IS
798: -- initializes the local pl/sql table with the field names from ghr_pa_data_fields table.
799: -- this cursor fetches the form_field_names for the noa_id specified.
800: CURSOR cur_flds(p_noa_id number) IS
801: SELECT fld.form_field_name,
802: met.process_method_code
802: met.process_method_code
803: FROM
804: ghr_families ghrf,
805: ghr_noa_fam_proc_methods met,
806: ghr_pa_data_fields fld,
807: ghr_noa_families fam
808: WHERE
809: fam.noa_family_code = met.noa_family_code
810: AND ghrf.noa_family_code = met.noa_family_code
3672: select fpm.process_method_code
3673: from ghr_noa_families nof
3674: ,ghr_families fam
3675: ,ghr_noa_fam_proc_methods fpm
3676: ,ghr_pa_data_fields pdf
3677: where nof.nature_of_action_id = p_noa_id
3678: and nof.noa_family_code = fam.noa_family_code
3679: and nof.enabled_flag = 'Y'
3680: and p_effective_date between nvl(nof.start_date_active,p_effective_date) and nvl(nof.end_date_active,p_effective_date)
3739: select fpm.process_method_code
3740: from ghr_noa_families nof
3741: ,ghr_families fam
3742: ,ghr_noa_fam_proc_methods fpm
3743: ,ghr_pa_data_fields pdf
3744: where nof.nature_of_action_id = p_noa_id
3745: and nof.noa_family_code = fam.noa_family_code
3746: and nof.enabled_flag = 'Y'
3747: and p_effective_date between nvl(nof.start_date_active,p_effective_date) and nvl(nof.end_date_active,p_effective_date)
4753: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
4754: p_pa_req_out out nocopy ghr_pa_requests%rowtype) IS
4755:
4756: TYPE fields_type is record
4757: (form_field_name ghr_pa_data_fields.form_field_name%TYPE );
4758:
4759: TYPE fld_names_typ is TABLE of fields_type
4760: INDEX BY BINARY_INTEGER;
4761: l_fld_names_tab fld_names_typ;
4767: PROCEDURE initialize_fld_names_table (p_1st_noa_id in number,
4768: p_2nd_noa_id in number default null,
4769: p_fld_names_tab in out nocopy fld_names_typ) IS
4770: --
4771: -- initializes the local pl/sql table with the field names from ghr_pa_data_fields table.
4772: --
4773: --
4774: -- this cursor fetches the form_field_names for the 1st_noa_id and 2nd_noa_id specified.
4775: CURSOR cur_flds2( p_1st_noa_id number,
4777: SELECT fld.form_field_name
4778: FROM
4779: ghr_families ghrf,
4780: ghr_noa_fam_proc_methods met,
4781: ghr_pa_data_fields fld,
4782: ghr_noa_families fam
4783: WHERE
4784: fam.noa_family_code = met.noa_family_code
4785: AND ghrf.noa_family_code = met.noa_family_code
4791: SELECT fld2.form_field_name
4792: FROM
4793: ghr_families ghrf2,
4794: ghr_noa_fam_proc_methods met2,
4795: ghr_pa_data_fields fld2,
4796: ghr_noa_families fam2
4797: WHERE
4798: fam2.noa_family_code = met2.noa_family_code
4799: AND ghrf2.noa_family_code = met2.noa_family_code
4806: SELECT fld.form_field_name
4807: FROM
4808: ghr_families ghrf,
4809: ghr_noa_fam_proc_methods met,
4810: ghr_pa_data_fields fld,
4811: ghr_noa_families fam
4812: WHERE
4813: fam.noa_family_code = met.noa_family_code
4814: AND ghrf.noa_family_code = met.noa_family_code
4821: SELECT fld.form_field_name
4822: FROM
4823: ghr_families ghrf,
4824: ghr_noa_fam_proc_methods met,
4825: ghr_pa_data_fields fld,
4826: ghr_noa_families fam
4827: WHERE
4828: fam.noa_family_code = met.noa_family_code
4829: AND ghrf.noa_family_code = met.noa_family_code
4837: SELECT fld.form_field_name
4838: FROM
4839: ghr_families ghrf,
4840: ghr_noa_fam_proc_methods met,
4841: ghr_pa_data_fields fld,
4842: ghr_noa_families fam
4843: WHERE
4844: fam.noa_family_code = met.noa_family_code
4845: AND ghrf.noa_family_code = met.noa_family_code