APPS.WSH_PICK_LIST dependencies on FND_PROFILE

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

398: END IF;
399:
400: x_org_info.express_pick_flag := 'N';
401:
402: l_express_pick_profile := NVL(FND_PROFILE.VALUE('WSH_EXPRESS_PICK'), 'N');
403: IF l_debug_on THEN
404: WSH_DEBUG_SV.logmsg(l_module_name,'Profile WSH_EXPRESS_PICK value '||l_express_pick_profile);
405: END IF;
406:

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

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

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

2475:
2476: -- Determine Pick Release Batch Size based on Profile
2477: --Bug 5137504 Handling if Batch size is set to value less than 1 or is aphanumeric
2478: BEGIN
2479: l_pr_batch_size := TO_NUMBER(FND_PROFILE.VALUE('WSH_PICK_RELEASE_BATCH_SIZE'));
2480: IF l_pr_batch_size IS NULL OR l_pr_batch_size < 1 THEN
2481: l_pr_batch_size := 50;
2482: ELSIF l_pr_batch_size > 1000 THEN
2483: l_pr_batch_size := 1000;

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

4861: AND (l_completion_status <> 'ERROR') THEN --{
4862:
4863: --Bug 5137504 Handling if Batch size is set to value less than 1 or is aphanumeric
4864: BEGIN
4865: l_pr_batch_size := TO_NUMBER(FND_PROFILE.VALUE('WSH_PICK_RELEASE_BATCH_SIZE'));
4866: IF l_pr_batch_size IS NULL OR l_pr_batch_size < 1 THEN
4867: l_pr_batch_size := 50;
4868: ELSIF l_pr_batch_size > 1000 THEN
4869: l_pr_batch_size := 1000;

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

5464:
5465: --}
5466: ELSE --{
5467: --set the l_completion_status based on the other programs
5468: FND_PROFILE.Get('CONC_REQUEST_ID', l_this_request);
5469: OPEN c_requests(l_this_request);
5470: FETCH c_requests BULK COLLECT INTO l_child_req_ids;
5471: CLOSE c_requests;
5472: l_errors := 0;

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

6120: --}
6121:
6122: IF l_mode = 'PS' THEN --{
6123: --set the l_completion_status based on the other programs
6124: FND_PROFILE.Get('CONC_REQUEST_ID', l_this_request);
6125: OPEN c_requests(l_this_request);
6126: FETCH c_requests BULK COLLECT INTO l_child_req_ids;
6127: CLOSE c_requests;
6128: l_errors := 0;