DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on FND_GLOBAL

Line 5209: execute immediate l_stmt USING fnd_global.CONC_REQUEST_ID, sysdate;

5205: -- after table creation : the next migration will NOT create the backup table but will reuse it
5206: -- hence we need to update the conc_request_id to the current request id
5207:
5208: l_stmt := 'UPDATE '||c_comments_bak||' set CONC_REQUEST_ID = :1, migration_date = :2';
5209: execute immediate l_stmt USING fnd_global.CONC_REQUEST_ID, sysdate;
5210:
5211: EXCEPTION
5212: WHEN OTHERS THEN
5213: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 5641: last_updated_by = BSC_APPS.fnd_global_user_id,

5637: -- At this point, the system is inconsistent until everything have been migrated
5638: -- So, we flag the system like if it is not in the latest version.
5639: UPDATE bsc_sys_init
5640: SET property_value = 'UNAPPLIED',
5641: last_updated_by = BSC_APPS.fnd_global_user_id,
5642: last_update_date = SYSDATE
5643: WHERE property_code = 'TARGET_STATUS';
5644: COMMIT;
5645:

Line 5711: last_updated_by = BSC_APPS.fnd_global_user_id,

5707: -- So, we flag the system like if it is not in the latest version.
5708: -- I do it again because the records in BSC_SYS_INIT have been migrated from the source.
5709: UPDATE bsc_sys_init
5710: SET property_value = 'UNAPPLIED',
5711: last_updated_by = BSC_APPS.fnd_global_user_id,
5712: last_update_date = SYSDATE
5713: WHERE property_code = 'TARGET_STATUS';
5714: COMMIT;
5715:

Line 6031: last_updated_by = BSC_APPS.fnd_global_user_id,

6027:
6028: -- At this point, the system is consistent
6029: UPDATE bsc_sys_init
6030: SET property_value = 'APPLIED',
6031: last_updated_by = BSC_APPS.fnd_global_user_id,
6032: last_update_date = SYSDATE
6033: WHERE property_code = 'TARGET_STATUS';
6034: COMMIT;
6035:

Line 8452: X_USER_ID => fnd_global.user_id,

8448:
8449: -- Create the ak region in the target
8450: BIS_AK_REGION_PUB.INSERT_REGION_ROW (
8451: X_ROWID => h_rowid,
8452: X_USER_ID => fnd_global.user_id,
8453: X_REGION_APPLICATION_ID => h_region_application_id,
8454: X_REGION_CODE => p_region_code,
8455: X_DATABASE_OBJECT_NAME => h_database_object_name,
8456: X_NAME => h_name,

Line 8550: X_USER_ID => fnd_global.user_id,

8546: EXIT WHEN h_cursor%NOTFOUND;
8547:
8548: BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW (
8549: X_ROWID => h_rowid,
8550: X_USER_ID => fnd_global.user_id,
8551: X_REGION_APPLICATION_ID => h_region_application_id,
8552: X_REGION_CODE => p_region_code,
8553: X_ATTRIBUTE_APPLICATION_ID => h_attribute_application_id,
8554: X_ATTRIBUTE_CODE => h_attribute_code,

Line 8765: X_CREATED_BY => fnd_global.user_id,

8761: X_TYPE => h_type,
8762: X_USER_FUNCTION_NAME => h_user_function_name,
8763: X_DESCRIPTION => h_description,
8764: X_CREATION_DATE => sysdate,
8765: X_CREATED_BY => fnd_global.user_id,
8766: X_LAST_UPDATE_DATE => sysdate,
8767: X_LAST_UPDATED_BY => fnd_global.user_id,
8768: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8769: X_MAINTENANCE_MODE_SUPPORT => h_maintenance_mode_support,

Line 8767: X_LAST_UPDATED_BY => fnd_global.user_id,

8763: X_DESCRIPTION => h_description,
8764: X_CREATION_DATE => sysdate,
8765: X_CREATED_BY => fnd_global.user_id,
8766: X_LAST_UPDATE_DATE => sysdate,
8767: X_LAST_UPDATED_BY => fnd_global.user_id,
8768: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8769: X_MAINTENANCE_MODE_SUPPORT => h_maintenance_mode_support,
8770: X_CONTEXT_DEPENDENCE => h_context_dependence,
8771: X_JRAD_REF_PATH => h_jrad_ref_path

Line 8768: X_LAST_UPDATE_LOGIN => fnd_global.user_id,

8764: X_CREATION_DATE => sysdate,
8765: X_CREATED_BY => fnd_global.user_id,
8766: X_LAST_UPDATE_DATE => sysdate,
8767: X_LAST_UPDATED_BY => fnd_global.user_id,
8768: X_LAST_UPDATE_LOGIN => fnd_global.user_id,
8769: X_MAINTENANCE_MODE_SUPPORT => h_maintenance_mode_support,
8770: X_CONTEXT_DEPENDENCE => h_context_dependence,
8771: X_JRAD_REF_PATH => h_jrad_ref_path
8772: );

Line 9479: X_CREATED_BY => fnd_global.user_id,

9475: X_ATTRIBUTE_LABEL_LONG => null,
9476: X_ATTRIBUTE_LABEL_SHORT => null,
9477: X_DESCRIPTION => null,
9478: X_CREATION_DATE => sysdate,
9479: X_CREATED_BY => fnd_global.user_id,
9480: X_LAST_UPDATE_DATE => sysdate,
9481: X_LAST_UPDATED_BY => fnd_global.user_id,
9482: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
9483: END IF;

Line 9481: X_LAST_UPDATED_BY => fnd_global.user_id,

9477: X_DESCRIPTION => null,
9478: X_CREATION_DATE => sysdate,
9479: X_CREATED_BY => fnd_global.user_id,
9480: X_LAST_UPDATE_DATE => sysdate,
9481: X_LAST_UPDATED_BY => fnd_global.user_id,
9482: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
9483: END IF;
9484: END LOOP;
9485: CLOSE c_cursor;

Line 9482: X_LAST_UPDATE_LOGIN => fnd_global.user_id);

9478: X_CREATION_DATE => sysdate,
9479: X_CREATED_BY => fnd_global.user_id,
9480: X_LAST_UPDATE_DATE => sysdate,
9481: X_LAST_UPDATED_BY => fnd_global.user_id,
9482: X_LAST_UPDATE_LOGIN => fnd_global.user_id);
9483: END IF;
9484: END LOOP;
9485: CLOSE c_cursor;
9486: