DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSR_SCHEDULER_PUB

Line 1039: l_max_resources := csr_scheduler_pub.get_sch_parameter_value('spMaxResources');

1035: cnt PLS_INTEGER;
1036: BEGIN
1037: -- Get the maximum number of allowed Resources
1038: -- Modified to get the profile value from Scheduler API
1039: l_max_resources := csr_scheduler_pub.get_sch_parameter_value('spMaxResources');
1040:
1041: -- Validate retrieved maximum value
1042: IF NVL(l_max_resources, 0) <= 0 THEN
1043: l_max_resources := p_res_tbl.COUNT;

Line 1449: IF csr_scheduler_pub.get_sch_parameter_value('spEnforcePlanWindow') = 'NONE' THEN

1445:
1446: l_continue_search := TRUE;
1447:
1448:
1449: IF csr_scheduler_pub.get_sch_parameter_value('spEnforcePlanWindow') = 'NONE' THEN
1450: l_end_date := p_end + NVL(csr_scheduler_pub.get_sch_parameter_value('spPlanScope'), 5)/5;
1451: debug( fnd_log.level_statement, l_api_name, ' Enforce None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
1452: ELSE
1453: l_end_date := p_end;

Line 1450: l_end_date := p_end + NVL(csr_scheduler_pub.get_sch_parameter_value('spPlanScope'), 5)/5;

1446: l_continue_search := TRUE;
1447:
1448:
1449: IF csr_scheduler_pub.get_sch_parameter_value('spEnforcePlanWindow') = 'NONE' THEN
1450: l_end_date := p_end + NVL(csr_scheduler_pub.get_sch_parameter_value('spPlanScope'), 5)/5;
1451: debug( fnd_log.level_statement, l_api_name, ' Enforce None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
1452: ELSE
1453: l_end_date := p_end;
1454: debug( fnd_log.level_statement, l_api_name, ' Enforce is Not None; End Date:'|| to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 2074: , p_contracts_flag => csr_scheduler_pub.get_sch_parameter_value('spPickContractResources')

2070: BEGIN
2071: l_res_tbl :=
2072: get_resources_to_schedule_pvt(
2073: p_task_id => p_task_id
2074: , p_contracts_flag => csr_scheduler_pub.get_sch_parameter_value('spPickContractResources')
2075: , p_ib_flag => csr_scheduler_pub.get_sch_parameter_value('spPickIbResources')
2076: , p_territory_flag => csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources')
2077: , p_skill_flag => csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources')
2078: );

Line 2075: , p_ib_flag => csr_scheduler_pub.get_sch_parameter_value('spPickIbResources')

2071: l_res_tbl :=
2072: get_resources_to_schedule_pvt(
2073: p_task_id => p_task_id
2074: , p_contracts_flag => csr_scheduler_pub.get_sch_parameter_value('spPickContractResources')
2075: , p_ib_flag => csr_scheduler_pub.get_sch_parameter_value('spPickIbResources')
2076: , p_territory_flag => csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources')
2077: , p_skill_flag => csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources')
2078: );
2079:

Line 2076: , p_territory_flag => csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources')

2072: get_resources_to_schedule_pvt(
2073: p_task_id => p_task_id
2074: , p_contracts_flag => csr_scheduler_pub.get_sch_parameter_value('spPickContractResources')
2075: , p_ib_flag => csr_scheduler_pub.get_sch_parameter_value('spPickIbResources')
2076: , p_territory_flag => csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources')
2077: , p_skill_flag => csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources')
2078: );
2079:
2080: RETURN l_res_tbl;

Line 2077: , p_skill_flag => csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources')

2073: p_task_id => p_task_id
2074: , p_contracts_flag => csr_scheduler_pub.get_sch_parameter_value('spPickContractResources')
2075: , p_ib_flag => csr_scheduler_pub.get_sch_parameter_value('spPickIbResources')
2076: , p_territory_flag => csr_scheduler_pub.get_sch_parameter_value('spPickTerritoryResources')
2077: , p_skill_flag => csr_scheduler_pub.get_sch_parameter_value('spPickSkilledResources')
2078: );
2079:
2080: RETURN l_res_tbl;
2081: END get_resources_to_schedule;