eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_ITEM_PKG dependencies on FND_PROFILE

Line 88: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),

84: BEGIN
85: UPDATE MTL_SYSTEM_ITEMS
86: SET ENG_ITEM_FLAG = 'N',
87: --DESCRIPTION = X_mfg_description,
88: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),
89:
90: -----------------------------------
91: -- Commented out by AS on 04/14/98
92: -- See bug 647693.

Line 94: -- CREATED_BY = to_number(Fnd_Profile.Value('USER_ID')),

90: -----------------------------------
91: -- Commented out by AS on 04/14/98
92: -- See bug 647693.
93:
94: -- CREATED_BY = to_number(Fnd_Profile.Value('USER_ID')),
95: -- CREATION_DATE = SYSDATE,
96: -----------------------------------
97:
98: LAST_UPDATE_DATE = SYSDATE,

Line 99: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')),

95: -- CREATION_DATE = SYSDATE,
96: -----------------------------------
97:
98: LAST_UPDATE_DATE = SYSDATE,
99: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')),
100: ENGINEERING_DATE = SYSDATE,
101: ENGINEERING_ECN_CODE = X_ecn_name
102: WHERE INVENTORY_ITEM_ID = X_eng_item_id
103: AND ORGANIZATION_ID = X_org_id;

Line 136: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),

132: BEGIN
133: UPDATE MTL_SYSTEM_ITEMS
134: SET ENG_ITEM_FLAG = 'N',
135: --DESCRIPTION = X_mfg_description,
136: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),
137:
138: -----------------------------------
139: -- Commented out by AS on 04/14/98
140: -- See bug 647693.

Line 142: -- CREATED_BY = to_number(Fnd_Profile.Value('USER_ID')),

138: -----------------------------------
139: -- Commented out by AS on 04/14/98
140: -- See bug 647693.
141:
142: -- CREATED_BY = to_number(Fnd_Profile.Value('USER_ID')),
143: -- CREATION_DATE = SYSDATE,
144: -----------------------------------
145:
146: LAST_UPDATE_DATE = SYSDATE,

Line 147: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')),

143: -- CREATION_DATE = SYSDATE,
144: -----------------------------------
145:
146: LAST_UPDATE_DATE = SYSDATE,
147: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')),
148: ENGINEERING_DATE = SYSDATE,
149: ENGINEERING_ECN_CODE = X_ecn_name
150: WHERE INVENTORY_ITEM_ID = X_eng_item_id
151: AND ORGANIZATION_ID = X_master_org

Line 458: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),

454: ENG_COPY_TABLE_ROWS_PKG.C_MTL_ITEM_REVISIONS(X_inventory_item_id => X_mfg_item_id,
455: X_organization_id => X_master_org,
456: X_revision => X_bom_rev_starting,
457: X_last_update_date => SYSDATE,
458: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),
459: X_creation_date => SYSDATE,
460: X_created_by => to_number(Fnd_Profile.Value('USER_ID')),
461: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),
462: X_effectivity_date => SYSDATE,

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

456: X_revision => X_bom_rev_starting,
457: X_last_update_date => SYSDATE,
458: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),
459: X_creation_date => SYSDATE,
460: X_created_by => to_number(Fnd_Profile.Value('USER_ID')),
461: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),
462: X_effectivity_date => SYSDATE,
463: X_change_notice => X_ecn_name,
464: X_implementation_date => SYSDATE);

Line 461: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),

457: X_last_update_date => SYSDATE,
458: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),
459: X_creation_date => SYSDATE,
460: X_created_by => to_number(Fnd_Profile.Value('USER_ID')),
461: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),
462: X_effectivity_date => SYSDATE,
463: X_change_notice => X_ecn_name,
464: X_implementation_date => SYSDATE);
465: END IF;

Line 479: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),

475: ENG_COPY_TABLE_ROWS_PKG.C_MTL_ITEM_REVISIONS(X_inventory_item_id => X_mfg_item_id,
476: X_organization_id => X_org_id,
477: X_revision => X_bom_rev_starting,
478: X_last_update_date => SYSDATE,
479: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),
480: X_creation_date => SYSDATE,
481: X_created_by => to_number(Fnd_Profile.Value('USER_ID')),
482: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),
483: X_effectivity_date => SYSDATE,

Line 481: X_created_by => to_number(Fnd_Profile.Value('USER_ID')),

477: X_revision => X_bom_rev_starting,
478: X_last_update_date => SYSDATE,
479: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),
480: X_creation_date => SYSDATE,
481: X_created_by => to_number(Fnd_Profile.Value('USER_ID')),
482: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),
483: X_effectivity_date => SYSDATE,
484: X_change_notice => X_ecn_name,
485: X_implementation_date => SYSDATE);

Line 482: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),

478: X_last_update_date => SYSDATE,
479: X_last_updated_by => to_number(Fnd_Profile.Value('USER_ID')),
480: X_creation_date => SYSDATE,
481: X_created_by => to_number(Fnd_Profile.Value('USER_ID')),
482: X_last_update_login => to_number(Fnd_Profile.Value('LOGIN_ID')),
483: X_effectivity_date => SYSDATE,
484: X_change_notice => X_ecn_name,
485: X_implementation_date => SYSDATE);
486:

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

594:
595: for comp in comp_rows(bill.bill_sequence_id) loop
596: if l_parent_BIT = 4 and l_PTO_flag = 'Y'
597: and comp.bom_item_type = 4 and comp.replenish_to_order_flag = 'Y'
598: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
599: then
600: raise ATO_IN_KIT_EXCEPTION;
601: end if;
602:

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

602:
603:
604: if l_parent_BIT = 1 and l_PTO_flag = 'Y'
605: and comp.bom_item_type = 4 and comp.replenish_to_order_flag = 'Y' and nvl(comp.optional, 1) = 2
606: and nvl(FND_PROFILE.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1
607: then
608: raise ATO_IN_MODEL_EXCEPTION;
609: end if;
610:

Line 648: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */

644:
645: BEGIN
646: UPDATE MTL_SYSTEM_ITEMS
647: SET ENG_ITEM_FLAG = 'N',
648: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
649: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
650: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */
651: WHERE ORGANIZATION_ID = X_org_id
652: AND ENG_ITEM_FLAG <> 'N'

Line 649: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */

645: BEGIN
646: UPDATE MTL_SYSTEM_ITEMS
647: SET ENG_ITEM_FLAG = 'N',
648: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
649: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
650: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */
651: WHERE ORGANIZATION_ID = X_org_id
652: AND ENG_ITEM_FLAG <> 'N'
653: AND INVENTORY_ITEM_ID IN

Line 687: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */

683:
684: BEGIN
685: UPDATE MTL_SYSTEM_ITEMS
686: SET ENG_ITEM_FLAG = 'N',
687: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
688: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
689: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */
690: WHERE ORGANIZATION_ID = X_org_id
691: AND ENG_ITEM_FLAG <> 'N'

Line 688: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */

684: BEGIN
685: UPDATE MTL_SYSTEM_ITEMS
686: SET ENG_ITEM_FLAG = 'N',
687: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
688: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
689: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */
690: WHERE ORGANIZATION_ID = X_org_id
691: AND ENG_ITEM_FLAG <> 'N'
692: AND INVENTORY_ITEM_ID IN

Line 745: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */

741: X_stmt_num := 200;
742: BEGIN
743: UPDATE MTL_SYSTEM_ITEMS
744: SET ENG_ITEM_FLAG = 'N',
745: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
746: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
747: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */
748: WHERE ORGANIZATION_ID = X_master_org
749: AND ENG_ITEM_FLAG <> 'N'

Line 746: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */

742: BEGIN
743: UPDATE MTL_SYSTEM_ITEMS
744: SET ENG_ITEM_FLAG = 'N',
745: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
746: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
747: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */
748: WHERE ORGANIZATION_ID = X_master_org
749: AND ENG_ITEM_FLAG <> 'N'
750: AND INVENTORY_ITEM_ID IN