DBA Data[Home] [Help]

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: