APPS.ENG_BOM_PKG dependencies on FND_PROFILE

Line 107: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1

103: for comp in comp_rows(bill.bill_sequence_id)
104: loop
105: if l_parent_BIT = 4 and l_PTO_flag = 'Y'
106: and comp.bom_item_type = 4 and comp.replenish_to_order_flag = 'Y'
107: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
108: then
109: raise ATO_IN_KIT_EXCEPTION;
110: end if;
111:

Line 115: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1

111:
112:
113: if l_parent_BIT = 1 and l_PTO_flag = 'Y'
114: and comp.bom_item_type = 4 and comp.replenish_to_order_flag = 'Y' and nvl(comp.optional, 1) = 2
115: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
116: then
117: raise ATO_IN_MODEL_EXCEPTION;
118: end if;
119:

Line 133: LAST_UPDATED_BY = to_number(fnd_profile.value('USER_ID'))

129:
130: UPDATE BOM_BILL_OF_MATERIALS
131: SET ASSEMBLY_TYPE = 1,
132: LAST_UPDATE_DATE = sysdate,
133: LAST_UPDATED_BY = to_number(fnd_profile.value('USER_ID'))
134: WHERE ORGANIZATION_ID = X_org_id
135: AND ASSEMBLY_ITEM_ID = X_eng_item_id
136: AND ((X_designator_option = 2 AND
137: ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 149: LAST_UPDATED_BY = to_number(fnd_profile.value('USER_ID'))

145: OR STRUCTURE_TYPE_ID IS NULL); --added for bug 9436790
146: UPDATE BOM_EXPLOSIONS_ALL -- Update Sql added for bug#9260472
147: SET ASSEMBLY_TYPE = 1,
148: LAST_UPDATE_DATE = sysdate,
149: LAST_UPDATED_BY = to_number(fnd_profile.value('USER_ID'))
150: WHERE ORGANIZATION_ID = X_org_id
151: AND COMPONENT_ITEM_ID = X_eng_item_id
152: AND ((X_designator_option = 2 AND
153: ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 353: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1

349:
350: for comp in comp_rows(bill.bill_sequence_id) loop
351: if l_parent_BIT = 4 and l_PTO_flag = 'Y'
352: and comp.bom_item_type = 4 and comp.replenish_to_order_flag = 'Y'
353: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
354: then
355: raise ATO_IN_KIT_EXCEPTION;
356: end if;
357:

Line 361: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1

357:
358:
359: if l_parent_BIT = 1 and l_PTO_flag = 'Y'
360: and comp.bom_item_type = 4 and comp.replenish_to_order_flag = 'Y' and nvl(comp.optional, 1) = 2
361: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
362: then
363: raise ATO_IN_MODEL_EXCEPTION;
364: end if;
365:

Line 460: to_number(Fnd_Profile.Value('USER_ID')),

456: X_mfg_item_id,
457: ORGANIZATION_ID,
458: BOM_T.ALTERNATE_BOM_DESIGNATOR,
459: SYSDATE,
460: to_number(Fnd_Profile.Value('USER_ID')),
461: SYSDATE,
462: to_number(Fnd_Profile.Value('USER_ID')),
463: to_number(Fnd_Profile.Value('LOGIN_ID')),
464: BOM_T.COMMON_ASSEMBLY_ITEM_ID,

Line 462: to_number(Fnd_Profile.Value('USER_ID')),

458: BOM_T.ALTERNATE_BOM_DESIGNATOR,
459: SYSDATE,
460: to_number(Fnd_Profile.Value('USER_ID')),
461: SYSDATE,
462: to_number(Fnd_Profile.Value('USER_ID')),
463: to_number(Fnd_Profile.Value('LOGIN_ID')),
464: BOM_T.COMMON_ASSEMBLY_ITEM_ID,
465: BOM_T.SPECIFIC_ASSEMBLY_COMMENT,
466: BOM_T.PENDING_FROM_ECN,

Line 463: to_number(Fnd_Profile.Value('LOGIN_ID')),

459: SYSDATE,
460: to_number(Fnd_Profile.Value('USER_ID')),
461: SYSDATE,
462: to_number(Fnd_Profile.Value('USER_ID')),
463: to_number(Fnd_Profile.Value('LOGIN_ID')),
464: BOM_T.COMMON_ASSEMBLY_ITEM_ID,
465: BOM_T.SPECIFIC_ASSEMBLY_COMMENT,
466: BOM_T.PENDING_FROM_ECN,
467: BOM_T.ATTRIBUTE_CATEGORY,

Line 571: user_id => to_number(Fnd_Profile.Value('USER_ID')),

567: to_sequence_id => BOM1.BILL_SEQUENCE_ID,
568: from_org_id => X_org_id,
569: to_org_id => X_org_id,
570: display_option => X_transfer_option,
571: user_id => to_number(Fnd_Profile.Value('USER_ID')),
572: to_item_id => X_mfg_item_id,
573: direction => 4,
574: to_alternate => BOM1.ALTERNATE_BOM_DESIGNATOR,
575: rev_date => X_effectivity_date,