DBA Data[Home] [Help]

APPS.ENG_BOM_PKG dependencies on FND_PROFILE

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

68:
69: UPDATE BOM_BILL_OF_MATERIALS
70: SET ASSEMBLY_TYPE = 1,
71: LAST_UPDATE_DATE = sysdate,
72: LAST_UPDATED_BY = to_number(fnd_profile.value('USER_ID'))
73: WHERE ORGANIZATION_ID = X_org_id
74: AND ASSEMBLY_ITEM_ID = X_eng_item_id
75: AND ((X_designator_option = 2 AND
76: ALTERNATE_BOM_DESIGNATOR IS NULL)

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

272: X_mfg_item_id,
273: ORGANIZATION_ID,
274: BOM_T.ALTERNATE_BOM_DESIGNATOR,
275: SYSDATE,
276: to_number(Fnd_Profile.Value('USER_ID')),
277: SYSDATE,
278: to_number(Fnd_Profile.Value('USER_ID')),
279: to_number(Fnd_Profile.Value('LOGIN_ID')),
280: BOM_T.COMMON_ASSEMBLY_ITEM_ID,

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

274: BOM_T.ALTERNATE_BOM_DESIGNATOR,
275: SYSDATE,
276: to_number(Fnd_Profile.Value('USER_ID')),
277: SYSDATE,
278: to_number(Fnd_Profile.Value('USER_ID')),
279: to_number(Fnd_Profile.Value('LOGIN_ID')),
280: BOM_T.COMMON_ASSEMBLY_ITEM_ID,
281: BOM_T.SPECIFIC_ASSEMBLY_COMMENT,
282: BOM_T.PENDING_FROM_ECN,

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

275: SYSDATE,
276: to_number(Fnd_Profile.Value('USER_ID')),
277: SYSDATE,
278: to_number(Fnd_Profile.Value('USER_ID')),
279: to_number(Fnd_Profile.Value('LOGIN_ID')),
280: BOM_T.COMMON_ASSEMBLY_ITEM_ID,
281: BOM_T.SPECIFIC_ASSEMBLY_COMMENT,
282: BOM_T.PENDING_FROM_ECN,
283: BOM_T.ATTRIBUTE_CATEGORY,

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

381: to_sequence_id => BOM1.BILL_SEQUENCE_ID,
382: from_org_id => X_org_id,
383: to_org_id => X_org_id,
384: display_option => X_transfer_option,
385: user_id => to_number(Fnd_Profile.Value('USER_ID')),
386: to_item_id => X_mfg_item_id,
387: direction => 4,
388: to_alternate => BOM1.ALTERNATE_BOM_DESIGNATOR,
389: rev_date => X_effectivity_date,