APPS.CSP_SCH_INT_PVT dependencies on CSP_PART_SEARCH_PVT

Line 3641: p_required_parts csp_part_search_pvt.required_parts_tbl;

3637: l_old_item number;
3638: l_hz_location_id number;
3639: l_hr_location_id number;
3640:
3641: p_required_parts csp_part_search_pvt.required_parts_tbl;
3642: p_search_params apps.csp_part_search_pvt.search_params_rec;
3643: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3644: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3645: l_alternates boolean := FALSE;

Line 3642: p_search_params apps.csp_part_search_pvt.search_params_rec;

3638: l_hz_location_id number;
3639: l_hr_location_id number;
3640:
3641: p_required_parts csp_part_search_pvt.required_parts_tbl;
3642: p_search_params apps.csp_part_search_pvt.search_params_rec;
3643: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3644: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3645: l_alternates boolean := FALSE;
3646:

Line 3684: 'Before calling csp_part_search_pvt.search...');

3680:
3681: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3683: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3684: 'Before calling csp_part_search_pvt.search...');
3685: end if;
3686:
3687: csp_part_search_pvt.search(
3688: p_required_parts => p_required_parts,

Line 3687: csp_part_search_pvt.search(

3683: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3684: 'Before calling csp_part_search_pvt.search...');
3685: end if;
3686:
3687: csp_part_search_pvt.search(
3688: p_required_parts => p_required_parts,
3689: p_search_params => p_search_params,
3690: x_return_status => x_return_status,
3691: x_msg_data => x_msg_data,

Line 3706: 'After calling csp_part_search_pvt.search...');

3702:
3703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3705: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3706: 'After calling csp_part_search_pvt.search...');
3707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3708: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3709: 'l_organization_id=' || l_organization_id);
3710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3834: p_required_parts csp_part_search_pvt.required_parts_tbl;

3830: l_hz_to_location_id number := null;
3831: l_primary_ship_to number := null;
3832: l_org_id number := null;
3833: l_sr_org_id number := null;
3834: p_required_parts csp_part_search_pvt.required_parts_tbl;
3835: p_search_params apps.csp_part_search_pvt.search_params_rec;
3836: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3837: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3838: l_alternates boolean := FALSE;

Line 3835: p_search_params apps.csp_part_search_pvt.search_params_rec;

3831: l_primary_ship_to number := null;
3832: l_org_id number := null;
3833: l_sr_org_id number := null;
3834: p_required_parts csp_part_search_pvt.required_parts_tbl;
3835: p_search_params apps.csp_part_search_pvt.search_params_rec;
3836: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
3837: l_incl_alternates varchar2(30) := fnd_profile.value('CSP_INCL_ALTERNATES');
3838: l_alternates boolean := FALSE;
3839: l_choose_option boolean := FALSE;

Line 3901: csp_part_search_pvt.search(

3897: p_search_params.include_alternates := l_alternates;
3898: p_search_params.requirement_header_id := l_requirement_header_id;
3899: p_search_params.called_from := 'SCHEDULER';
3900:
3901: csp_part_search_pvt.search(
3902: p_required_parts => p_required_parts,
3903: p_search_params => p_search_params,
3904: x_return_status => x_return_status,
3905: x_msg_data => x_msg_data,

Line 3963: csp_part_search_pvt.search(

3959: p_search_params.include_alternates := l_alternates;
3960: p_search_params.requirement_header_id := l_requirement_header_id;
3961: p_search_params.called_from := 'SCHEDULER';
3962:
3963: csp_part_search_pvt.search(
3964: p_required_parts => p_required_parts,
3965: p_search_params => p_search_params,
3966: x_return_status => x_return_status,
3967: x_msg_data => x_msg_data,

Line 3998: csp_part_search_pvt.search(

3994: if not p_warehouse then
3995: delete from csp_required_parts_temp;
3996: p_search_params.requirement_header_id := l_requirement_header_id;
3997: end if;
3998: csp_part_search_pvt.search(
3999: p_required_parts => p_required_parts,
4000: p_search_params => p_search_params,
4001: x_return_status => x_return_status,
4002: x_msg_data => x_msg_data,