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 5533: If fnd_profile.value('WSM_CREATE_LBJ_COPY_ROUTING') = WIP_CONSTANTS.YES Then

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

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

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

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

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

Line 5663: l_mfg_org_id := fnd_profile.value_specific(

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

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

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