APPS.WSMPUTIL dependencies on FND_PROFILE

Line 2525: if ( nvl(FND_PROFILE.value('WSM_COMPLETE_SEC_LOT_EXTN_LEVEL'), '1') = 2 ) then

2521:
2522: if p_completion_subinventory is not null then
2523: /* ST bug fix 3722383 if WSM: Complete Job Sector lot extension level is set at Item level,
2524: then sector extension for the subinventory is not mandatory */
2525: if ( nvl(FND_PROFILE.value('WSM_COMPLETE_SEC_LOT_EXTN_LEVEL'), '1') = 2 ) then
2526:
2527:
2528: BEGIN
2529: select 1

Line 5536: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then

5532: l_count NUMBER := 0;
5533:
5534: Begin
5535:
5536: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then
5537:
5538: Return FALSE;
5539:
5540: End If;

Line 5597: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then

5593: l_count NUMBER := 0;
5594:
5595: Begin
5596:
5597: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then
5598:
5599: Return FALSE;
5600:
5601: End If;

Line 5659: return to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING'));

5655: BEGIN
5656:
5657: /****************** I M P O R T A N T ********************************/
5658: -- YOU SHOULD UNCOMMENT THE NEXT LINE AFTER FP.J UT/ST ---------------
5659: return to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING'));
5660: ----------------------------------------------------------------------
5661:
5662: /****************** I M P O R T A N T ********************************/
5663: /***** Following code should be commented out after UT/ST for FP.J ***

Line 5666: l_mfg_org_id := fnd_profile.value_specific(

5662: /****************** I M P O R T A N T ********************************/
5663: /***** Following code should be commented out after UT/ST for FP.J ***
5664: ----------------------------------------------------------------------
5665:
5666: l_mfg_org_id := fnd_profile.value_specific(
5667: NAME => 'MFG_ORGANIZATION_ID'
5668: , USER_ID => FND_GLOBAL.user_id);
5669:
5670:

Line 5736: -- return to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING'));

5732: return WIP_CONSTANTS.NO;
5733:
5734: /****************** I M P O R T A N T ********************************/
5735: -- YOU SHOULD UNCOMMENT THE NEXT LINE AFTER FP.J UT/ST ---------------
5736: -- return to_number(fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING'));
5737: ----------------------------------------------------------------------
5738:
5739: /****************** I M P O R T A N T ********************************/
5740: /***** Following code should be commented out after UT/ST for FP.J ***