4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSR_SCHEDULER_PVT';
5: g_csr_appl_id CONSTANT NUMBER := 698;
6: g_conc_program_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
7:
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickContractResources');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickIbResources');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources');
12: g_spares_source CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spSparesSource');
5: g_csr_appl_id CONSTANT NUMBER := 698;
6: g_conc_program_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
7:
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickContractResources');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickIbResources');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources');
12: g_spares_source CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spSparesSource');
13: g_spares_mandatory CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spSparesMandatory');
6: g_conc_program_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
7:
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickContractResources');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickIbResources');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources');
12: g_spares_source CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spSparesSource');
13: g_spares_mandatory CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spSparesMandatory');
14: g_standby_shifts CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spConsiderStandbyShifts');
7:
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickContractResources');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickIbResources');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources');
12: g_spares_source CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spSparesSource');
13: g_spares_mandatory CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spSparesMandatory');
14: g_standby_shifts CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spConsiderStandbyShifts');
15:
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickContractResources');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickIbResources');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources');
12: g_spares_source CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spSparesSource');
13: g_spares_mandatory CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spSparesMandatory');
14: g_standby_shifts CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spConsiderStandbyShifts');
15:
16: TYPE ref_cursor_type IS REF CURSOR;
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickIbResources');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources');
12: g_spares_source CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spSparesSource');
13: g_spares_mandatory CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spSparesMandatory');
14: g_standby_shifts CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spConsiderStandbyShifts');
15:
16: TYPE ref_cursor_type IS REF CURSOR;
17:
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources');
12: g_spares_source CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spSparesSource');
13: g_spares_mandatory CONSTANT VARCHAR2(1) := csr_scheduler_pub.get_sch_parameter_value('spSparesMandatory');
14: g_standby_shifts CONSTANT VARCHAR2(30) := csr_scheduler_pub.get_sch_parameter_value('spConsiderStandbyShifts');
15:
16: TYPE ref_cursor_type IS REF CURSOR;
17:
18: