APPS.WSH_PICK_LIST dependencies on FND_PROFILE

Line 408: l_express_pick_profile := NVL(FND_PROFILE.VALUE('WSH_EXPRESS_PICK'), 'N');

404: END IF;
405:
406: x_org_info.express_pick_flag := 'N';
407:
408: l_express_pick_profile := NVL(FND_PROFILE.VALUE('WSH_EXPRESS_PICK'), 'N');
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'Profile WSH_EXPRESS_PICK value '||l_express_pick_profile);
411: END IF;
412:

Line 429: WSH_PR_CRITERIA.g_honor_pick_from := NVL(FND_PROFILE.VALUE('WSH_HONOR_PICK_FROM'), 'Y');

425: END IF;
426: -- Bug 4775539
427: WSH_PR_CRITERIA.g_honor_pick_from := 'Y';
428: --Get the honor pick from profile value default is Y.
429: WSH_PR_CRITERIA.g_honor_pick_from := NVL(FND_PROFILE.VALUE('WSH_HONOR_PICK_FROM'), 'Y');
430: END IF;
431:
432: -- 50. Check to see if rules need to be initialized for organization
433: IF (l_init_rules = FND_API.G_FALSE OR WSH_PR_CRITERIA.g_pick_grouping_rule_id IS NULL

Line 2541: l_pr_batch_size := TO_NUMBER(FND_PROFILE.VALUE('WSH_PICK_RELEASE_BATCH_SIZE'));

2537:
2538: -- Determine Pick Release Batch Size based on Profile
2539: --Bug 5137504 Handling if Batch size is set to value less than 1 or is aphanumeric
2540: BEGIN
2541: l_pr_batch_size := TO_NUMBER(FND_PROFILE.VALUE('WSH_PICK_RELEASE_BATCH_SIZE'));
2542: IF l_pr_batch_size IS NULL OR l_pr_batch_size < 1 THEN
2543: l_pr_batch_size := 50;
2544: ELSIF l_pr_batch_size > 1000 THEN
2545: l_pr_batch_size := 1000;

Line 4960: l_pr_batch_size := TO_NUMBER(FND_PROFILE.VALUE('WSH_PICK_RELEASE_BATCH_SIZE'));

4956: AND (l_completion_status <> 'ERROR') THEN --{
4957:
4958: --Bug 5137504 Handling if Batch size is set to value less than 1 or is aphanumeric
4959: BEGIN
4960: l_pr_batch_size := TO_NUMBER(FND_PROFILE.VALUE('WSH_PICK_RELEASE_BATCH_SIZE'));
4961: IF l_pr_batch_size IS NULL OR l_pr_batch_size < 1 THEN
4962: l_pr_batch_size := 50;
4963: ELSIF l_pr_batch_size > 1000 THEN
4964: l_pr_batch_size := 1000;

Line 5602: FND_PROFILE.Get('CONC_REQUEST_ID', l_this_request);

5598:
5599: --}
5600: ELSE --{
5601: --set the l_completion_status based on the other programs
5602: FND_PROFILE.Get('CONC_REQUEST_ID', l_this_request);
5603: OPEN c_requests(l_this_request);
5604: FETCH c_requests BULK COLLECT INTO l_child_req_ids;
5605: CLOSE c_requests;
5606: l_errors := 0;

Line 6259: FND_PROFILE.Get('CONC_REQUEST_ID', l_this_request);

6255: --}
6256:
6257: IF l_mode = 'PS' THEN --{
6258: --set the l_completion_status based on the other programs
6259: FND_PROFILE.Get('CONC_REQUEST_ID', l_this_request);
6260: OPEN c_requests(l_this_request);
6261: FETCH c_requests BULK COLLECT INTO l_child_req_ids;
6262: CLOSE c_requests;
6263: l_errors := 0;