eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_SCH_INT_PVT dependencies on FND_PROFILE

Line 263: (fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or

259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
260: RETURN;
261: END IF ;
262: IF l_unavailable_list.count > 0 AND (NOT p_subinv_only) AND
263: (fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or
264: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'SCHONLY' ) THEN
265: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,p_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
266: ELSE
267: l_final_unavailable_list := l_unavailable_list;

Line 264: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'SCHONLY' ) THEN

260: RETURN;
261: END IF ;
262: IF l_unavailable_list.count > 0 AND (NOT p_subinv_only) AND
263: (fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or
264: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'SCHONLY' ) THEN
265: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,p_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
266: ELSE
267: l_final_unavailable_list := l_unavailable_list;
268: END IF;

Line 653: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');

649: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'IO' ;
650: END IF;
651: END LOOP;
652: IF l_parts_lines.count > 0 THEN
653: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
654: l_parts_header.SHIP_TO_LOCATION_ID := l_ship_to_location_id;
655: l_parts_header.DEST_ORGANIZATION_ID := l_destination_org_id;
656: l_parts_header.OPERATION := 'CREATE';
657: l_parts_header.need_by_date :=g_arrival_date;

Line 723: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');

719: IF l_address_type IS NULL or l_address_type = 'R' OR l_address_type = 'S' THEN
720: l_requirement_header.address_type := 'R';
721: l_requirement_header.ship_to_location_id := l_ship_to_location_id;
722: END IF;
723: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
724: CSP_Requirement_Headers_PVT.Update_requirement_headers(
725: P_Api_Version_Number => 1.0,
726: P_Init_Msg_List => FND_API.G_FALSE,
727: P_Commit => FND_API.G_FALSE,

Line 1352: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');

1348: FETCH csp_ship_to_location INTO l_ship_to_location_id;
1349: EXIT WHEN csp_ship_to_location% NOTFOUND;
1350: END LOOP;
1351: CLOSE csp_ship_to_location;
1352: l_parts_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
1353: l_parts_header.SHIP_TO_LOCATION_ID := l_ship_to_location_id;
1354: l_parts_header.DEST_ORGANIZATION_ID := l_destination_org_id;
1355: l_parts_header.OPERATION := 'CREATE';
1356: CSP_PARTS_ORDER.process_order(

Line 1611: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or

1607: END IF;
1608: FOR I IN 1..p_resource_org_subinv.count LOOP
1609: FOR J IN 1..p_parts_list.count LOOP
1610: l_required_quantity := 0;
1611: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or
1612: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'SCHONLY' THEN
1613: if l_alternate_parts.count >0 THEN
1614: l_alternate_parts.delete;
1615: END IF;

Line 1612: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'SCHONLY' THEN

1608: FOR I IN 1..p_resource_org_subinv.count LOOP
1609: FOR J IN 1..p_parts_list.count LOOP
1610: l_required_quantity := 0;
1611: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or
1612: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'SCHONLY' THEN
1613: if l_alternate_parts.count >0 THEN
1614: l_alternate_parts.delete;
1615: END IF;
1616: if l_supersede_items.count > 0 THEN

Line 1643: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or

1639: END LOOP;
1640: CLOSE substitutes;
1641: END IF;
1642:
1643: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or
1644: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'SCHONLY' THEN
1645: l_att := 0;
1646: IF p_parts_list(J).revision IS NOT NULL THEN
1647: l_revision_controlled := TRUE;

Line 1644: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'SCHONLY' THEN

1640: CLOSE substitutes;
1641: END IF;
1642:
1643: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or
1644: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'SCHONLY' THEN
1645: l_att := 0;
1646: IF p_parts_list(J).revision IS NOT NULL THEN
1647: l_revision_controlled := TRUE;
1648: END IF;

Line 1988: l_mrp_database_link := fnd_profile.value(name => 'MRP_ATP_DATABASE_LINK');

1984: x_final_unavailable_list := CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE();
1985: OPEN instance;
1986: FETCH instance INTO l_instance_id;
1987: CLOSE instance;
1988: l_mrp_database_link := fnd_profile.value(name => 'MRP_ATP_DATABASE_LINK');
1989: If l_mrp_database_link IS NULL Then
1990: Select MRP_ATP_SCHEDULE_TEMP_S.NextVal
1991: Into l_session_id
1992: From Dual;

Line 2017: l_ship_complete_profile := fnd_profile.value(name => 'CSP_SHIP_COMPLETE');

2013: l_atp_rec.Requested_Ship_Date(I) := sysdate ; --'03-MAY-2002' ;
2014: l_atp_rec.Organization_id(I) := p_unavailable_list(I).organization_id;
2015: l_atp_rec.Identifier(I):= p_unavailable_list(I).resource_id + I ;
2016: l_atp_rec.Scenario_Id(I) := 1;
2017: l_ship_complete_profile := fnd_profile.value(name => 'CSP_SHIP_COMPLETE');
2018: IF l_ship_complete_profile ='Y' THEN
2019: IF g_schedular_call = 'Y' THEN
2020: l_atp_rec.ship_set_name(I) := to_char(p_unavailable_list(I).resource_id);
2021: ELSE

Line 2045: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');

2041: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2042: l_unavailable := 'Y';
2043: FOR I IN 1..l_atp_rec_out.Inventory_Item_Id.count LOOP
2044: IF (l_atp_rec_out.Error_Code(I) <> 0 and l_atp_rec_out.Error_Code(I) <> 150 ) THEN
2045: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');
2046: OPEN check_buy_from(l_atp_rec.Inventory_Item_Id(I),l_assignment_set_id, l_atp_rec.Organization_id(I));
2047: FETCH check_buy_from INTO l_buy_from;
2048: CLOSE check_buy_from;
2049: IF g_schedular_call = 'N' AND l_buy_from = 'Y' THEN

Line 2989: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');

2985: l_ship_method_present_for_reg boolean :=false;
2986: BEGIN
2987: l_server_sys_date := sysdate;
2988: x_return_status := FND_API.G_RET_STS_SUCCESS;
2989: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
2990: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
2991:
2992: IF g_interval.latest_time IS NOT NULL
2993: THEN

Line 2990: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');

2986: BEGIN
2987: l_server_sys_date := sysdate;
2988: x_return_status := FND_API.G_RET_STS_SUCCESS;
2989: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
2990: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
2991:
2992: IF g_interval.latest_time IS NOT NULL
2993: THEN
2994: l_need_by_date := g_interval.latest_time;

Line 3281: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');

3277: l_default_unit_for_hour varchar2(3);
3278: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.GET_DELIVERY_DATE' ;
3279: BEGIN
3280: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3281: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
3282: OPEN C1(p_relation_ship_id);
3283: LOOP
3284: FETCH C1 INTO l_lead_time,l_lead_time_uom,l_delivery_time,l_cutoff_time, l_timezone_id, l_saftey_zone;
3285: EXIT WHEN C1%NOTFOUND;

Line 3632: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');

3628: l_shipping_methode varchar2(30);
3629: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.GET_SHIPPING_METHODE' ;
3630: BEGIN
3631: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3632: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
3633: OPEN C3(p_from_org_id,p_to_org_id);
3634: LOOP
3635: FETCH C3 INTO l_cost,l_relation_ship_id ,l_cutoff_time,l_timezone_id,l_shipping_methode ;
3636: EXIT WHEN C3%NOTFOUND;

Line 3999: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or

3995: END IF;
3996: END IF;
3997: END LOOP;
3998: FOR I IN 1..p_parts_list.count LOOP
3999: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or
4000: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY' THEN
4001: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(I).item_id
4002: ,p_organization_id => l_temp_org_id
4003: ,x_supersede_items => l_supersede_items);

Line 4000: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY' THEN

3996: END IF;
3997: END LOOP;
3998: FOR I IN 1..p_parts_list.count LOOP
3999: IF fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'ALWAYS' or
4000: fnd_profile.value(name => 'CSP_INCL_ALTERNATES')= 'PRONLY' THEN
4001: CSP_SUPERSESSIONS_PVT.get_supersede_bilateral_items(p_inventory_item_id => p_parts_list(I).item_id
4002: ,p_organization_id => l_temp_org_id
4003: ,x_supersede_items => l_supersede_items);
4004: FOR J IN 1..l_supersede_items.count LOOP

Line 4139: IF fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or

4135: END LOOP;
4136: for i in 1..l_res_ids.count loop
4137: CSP_SCH_INT_PVT.DELETE_RESERVATION(l_res_ids(i),x_return_status,x_msg_data);
4138: end loop;
4139: IF fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or
4140: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'PRONLY' THEN
4141: IF l_unavailable_list.count >=1 THEN
4142: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,l_interval,l_available_list,l_final_unavailable_list,l_return_status,x_msg_data,x_msg_count);
4143: END IF;

Line 4140: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'PRONLY' THEN

4136: for i in 1..l_res_ids.count loop
4137: CSP_SCH_INT_PVT.DELETE_RESERVATION(l_res_ids(i),x_return_status,x_msg_data);
4138: end loop;
4139: IF fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or
4140: fnd_profile.value(name => 'CSP_CHECK_ATP')= 'PRONLY' THEN
4141: IF l_unavailable_list.count >=1 THEN
4142: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,l_interval,l_available_list,l_final_unavailable_list,l_return_status,x_msg_data,x_msg_count);
4143: END IF;
4144:

Line 4303: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or

4299: ELSE
4300: x_availability(loop_count).source_type := 'RES' ;
4301: END IF;
4302:
4303: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or
4304: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'PRONLY' THEN
4305: IF NOT quantity_fullfilled THEN
4306: IF l_required_quantity > l_final_available_list(k).available_quantity THEN
4307: x_availability(loop_count).recommended_option := 'Y';

Line 4304: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'PRONLY' THEN

4300: x_availability(loop_count).source_type := 'RES' ;
4301: END IF;
4302:
4303: IF fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'ALWAYS' or
4304: fnd_profile.value(name => 'CSP_INCL_CAR_STOCK')= 'PRONLY' THEN
4305: IF NOT quantity_fullfilled THEN
4306: IF l_required_quantity > l_final_available_list(k).available_quantity THEN
4307: x_availability(loop_count).recommended_option := 'Y';
4308: quantity_fullfilled := FALSE;

Line 4401: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');

4397: loop_count := loop_count + 1;
4398: END IF;
4399: END LOOP;
4400: IF NOT quantity_fullfilled THEN
4401: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');
4402: open check_buy_from(p_parts_list(I).item_id, l_assignment_set_id,l_temp_org_id);
4403: LOOP
4404: fetch check_buy_from INTO l_vendor_id, l_vendor_site_id;
4405: exit when check_buy_from%notfound;

Line 5430: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');

5426: where ORGANIZATION_ID = c_org_id
5427: and SHIPPING_METHOD = c_ship_method_code;
5428:
5429: BEGIN
5430: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
5431: OPEN csp_resource_calendar;
5432: FETCH csp_resource_calendar INTO l_calendar_code,l_exception_set_id ;
5433: CLOSE csp_resource_calendar;
5434: IF l_calendar_code is null then