APPS.WIP_MOVPROC_PRIV dependencies on FND_PROFILE

Line 7038: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) THEN

7034: END LOOP;
7035:
7036: /*Bug 13768020: Do not launch "Req Import" when there is po receipt resource and profile WIP_OSP_REQ is set to No.*/
7037: IF( l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7038: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) THEN
7039: l_launch_req_import := WIP_CONSTANTS.NO;
7040: END IF;
7041:
7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/

Line 7045: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.YES AND

7041:
7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/
7043: IF(l_launch_req_import = WIP_CONSTANTS.NO AND
7044: l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7045: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.YES AND
7046: fnd_profile.value('WIP_OSP_WF') = WIP_CONSTANTS.NO) THEN
7047: l_launch_req_import := WIP_CONSTANTS.YES;
7048: END IF;
7049:

Line 7046: fnd_profile.value('WIP_OSP_WF') = WIP_CONSTANTS.NO) THEN

7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/
7043: IF(l_launch_req_import = WIP_CONSTANTS.NO AND
7044: l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7045: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.YES AND
7046: fnd_profile.value('WIP_OSP_WF') = WIP_CONSTANTS.NO) THEN
7047: l_launch_req_import := WIP_CONSTANTS.YES;
7048: END IF;
7049:
7050: -- If OSP item exists, and there is no workflow launch yet, we have to launch

Line 7074: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

7070: WHEN NO_DATA_FOUND THEN
7071: raise fnd_api.g_exc_unexpected_error;
7072: END;
7073: /*ER 4276433*/
7074: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
7075: l_init_reqappr := 'N';
7076: else
7077: l_init_reqappr := 'Y';
7078: end if;