APPS.CSP_REPAIR_PO_PVT dependencies on FND_PROFILE

Line 441: l_line_rec.dest_subinventory := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');

437: --l_line_rec.item_description := 'Sentinel Standard Desktop';
438: l_line_rec.sourced_from := 'INVENTORY';
439: l_line_rec.ordered_quantity := CSP_RESERVED_LINES_rec.quantity;
440: l_line_rec.unit_of_measure := l_primary_uom_code;
441: l_line_rec.dest_subinventory := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');
442: --l_line_rec.dest_subinventory := 'FldSvc';
443: l_line_rec.source_organization_id := CSP_RESERVED_LINES_rec.defective_organization_id;
444: --l_line_Rec.order_line_id := 50762;
445: --l_line_rec.source_subinventory := 'Stores';

Line 464: l_sec_inv_name := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');

460: 2. Completion Date - Repair_Lead_Time = Start date of the wip job
461: Here Internal order Need_by_date should be equal to Start date of the wip job.
462: **/
463:
464: l_sec_inv_name := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');
465:
466: Begin
467: SELECT LOCATION_ID
468: INTO l_ship_to_location_id

Line 500: FND_PROFILE.GET('CSP_ORDER_TYPE', l_header_rec.order_type_id);

496: End if;
497:
498: --l_header_rec.description := 'Test Req';
499: --l_header_rec.order_type_id := 1430;
500: FND_PROFILE.GET('CSP_ORDER_TYPE', l_header_rec.order_type_id);
501: l_header_rec.dest_organization_id := l_dest_organization_id;
502: l_header_rec.operation := csp_parts_order.G_OPR_CREATE;
503: l_header_rec.ship_to_location_id := l_ship_to_location_id;
504: l_header_rec.requisition_number := NULL;

Line 950: l_usable_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_USABLE_SUBINV');

946: from CSP_REPAIR_PO_LINES
947: where REPAIR_PO_HEADER_ID = CSP_REPAIR_PO_HEADERS_rec.REPAIR_PO_HEADER_ID
948: group by REPAIR_PO_HEADER_ID;
949:
950: l_usable_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_USABLE_SUBINV');
951:
952: If PO_REQ_RECEIVED_QTY_rec.quantity_received >= CSP_REPAIR_PO_HEADERS_rec.quantity - l_total_scrap_adjust_qty then
953: -- nvl(CSP_REPAIR_PO_HEADERS_rec.received_qty,0) = PO_REQ_RECEIVED_QTY_rec.quantity_received
954: FINAL_COMPLETION_FLAG := 'Y';

Line 1442: l_defective_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');

1438: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', X_ITEM_NUMBER,TRUE);
1439: FND_MSG_PUB.ADD;
1440: RAISE EXCP_USER_DEFINED;
1441: Else
1442: l_defective_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');
1443:
1444: Select sum(nvl(scrap_qty,0) + nvl(adjusted_qty,0))
1445: into l_total_scrap_adjust_qty
1446: from CSP_REPAIR_PO_LINES