APPS.CSP_PARTS_REQUIREMENT dependencies on FND_PROFILE

Line 1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));

1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1766: l_rqmt_header_Rec.open_requirement := 'W';
1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);

Line 2472: nvl(order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE')),

2468: IF (l_count > 0) THEN
2469: BEGIN
2470: SELECT
2471: requirement_header_id,
2472: nvl(order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE')),
2473: ship_to_location_id,
2474: need_by_date,
2475: destination_organization_id,
2476: destination_subinventory

Line 4342: --l_dflt_ship_add_prf := FND_PROFILE.value('CSP_PART_REQ_DEF_SHIP_TO');

4338: integration code as well.
4339: */
4340:
4341:
4342: --l_dflt_ship_add_prf := FND_PROFILE.value('CSP_PART_REQ_DEF_SHIP_TO');
4343:
4344: if l_dflt_ship_add_prf is null then
4345: l_dflt_ship_add_prf := 'NONE';
4346: end if;

Line 4610: l_lead_time_days := nvl(fnd_profile.value('CSP_PR_NEED_BY_LEAD_TIME'), 1);

4606: l_shift_date_start_local date;
4607: l_shift_datetime_end date;
4608: l_shift_datetime_end_local date;
4609: begin
4610: l_lead_time_days := nvl(fnd_profile.value('CSP_PR_NEED_BY_LEAD_TIME'), 1);
4611: l_start_date := sysdate+l_lead_time_days;
4612: l_end_date := sysdate+l_lead_time_days+30;
4613: x_shift_end_datetime := l_start_date;
4614: