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.CN_SYS_TABLES_PVT dependencies on FND_GLOBAL

Line 109: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

105: l_count number := 0;
106: l_object_id number := 0;
107:
108: G_LAST_UPDATE_DATE DATE := Sysdate;
109: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
110: G_CREATION_DATE DATE := Sysdate;
111: G_CREATED_BY NUMBER := fnd_global.user_id;
112: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
113:

Line 111: G_CREATED_BY NUMBER := fnd_global.user_id;

107:
108: G_LAST_UPDATE_DATE DATE := Sysdate;
109: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
110: G_CREATION_DATE DATE := Sysdate;
111: G_CREATED_BY NUMBER := fnd_global.user_id;
112: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
113:
114: CURSOR l_repository_csr IS
115: SELECT repository_id

Line 112: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

108: G_LAST_UPDATE_DATE DATE := Sysdate;
109: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
110: G_CREATION_DATE DATE := Sysdate;
111: G_CREATED_BY NUMBER := fnd_global.user_id;
112: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
113:
114: CURSOR l_repository_csr IS
115: SELECT repository_id
116: FROM cn_repositories

Line 280: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

276: l_row cn_obj_tables_v%ROWTYPE;
277: l_repository_id number;
278:
279: G_LAST_UPDATE_DATE DATE := Sysdate;
280: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
281: G_CREATION_DATE DATE := Sysdate;
282: G_CREATED_BY NUMBER := fnd_global.user_id;
283: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
284:

Line 282: G_CREATED_BY NUMBER := fnd_global.user_id;

278:
279: G_LAST_UPDATE_DATE DATE := Sysdate;
280: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
281: G_CREATION_DATE DATE := Sysdate;
282: G_CREATED_BY NUMBER := fnd_global.user_id;
283: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
284:
285: CURSOR l_old_row_csr IS
286: SELECT *

Line 283: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

279: G_LAST_UPDATE_DATE DATE := Sysdate;
280: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
281: G_CREATION_DATE DATE := Sysdate;
282: G_CREATED_BY NUMBER := fnd_global.user_id;
283: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
284:
285: CURSOR l_old_row_csr IS
286: SELECT *
287: FROM cn_obj_tables_v

Line 452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

448: l_api_name CONSTANT VARCHAR2(30)
449: := 'Delete_Table';
450: l_api_version CONSTANT NUMBER := 1.0;
451: G_LAST_UPDATE_DATE DATE := Sysdate;
452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
453: G_CREATION_DATE DATE := Sysdate;
454: G_CREATED_BY NUMBER := fnd_global.user_id;
455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
456:

Line 454: G_CREATED_BY NUMBER := fnd_global.user_id;

450: l_api_version CONSTANT NUMBER := 1.0;
451: G_LAST_UPDATE_DATE DATE := Sysdate;
452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
453: G_CREATION_DATE DATE := Sysdate;
454: G_CREATED_BY NUMBER := fnd_global.user_id;
455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
456:
457: -- By Hithanki For Bug Fix : 2698989
458: -------

Line 455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

451: G_LAST_UPDATE_DATE DATE := Sysdate;
452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
453: G_CREATION_DATE DATE := Sysdate;
454: G_CREATED_BY NUMBER := fnd_global.user_id;
455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
456:
457: -- By Hithanki For Bug Fix : 2698989
458: -------
459: l_dest_count NUMBER := 0;

Line 617: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

613: l_table_name varchar2(30);
614: l_dim_value_ctr number := 0;
615:
616: G_LAST_UPDATE_DATE DATE := Sysdate;
617: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
618: G_CREATION_DATE DATE := Sysdate;
619: G_CREATED_BY NUMBER := fnd_global.user_id;
620: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
621:

Line 619: G_CREATED_BY NUMBER := fnd_global.user_id;

615:
616: G_LAST_UPDATE_DATE DATE := Sysdate;
617: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
618: G_CREATION_DATE DATE := Sysdate;
619: G_CREATED_BY NUMBER := fnd_global.user_id;
620: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
621:
622: CURSOR l_table_csr IS
623: SELECT cotv.table_id, cotv.name

Line 620: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

616: G_LAST_UPDATE_DATE DATE := Sysdate;
617: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
618: G_CREATION_DATE DATE := Sysdate;
619: G_CREATED_BY NUMBER := fnd_global.user_id;
620: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
621:
622: CURSOR l_table_csr IS
623: SELECT cotv.table_id, cotv.name
624: FROM cn_obj_columns_v cocv, cn_obj_tables_v cotv

Line 853: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

849: := 'Insert_Column';
850: l_api_version CONSTANT NUMBER := 1.0;
851:
852: G_LAST_UPDATE_DATE DATE := Sysdate;
853: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
854: G_CREATION_DATE DATE := Sysdate;
855: G_CREATED_BY NUMBER := fnd_global.user_id;
856: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
857:

Line 855: G_CREATED_BY NUMBER := fnd_global.user_id;

851:
852: G_LAST_UPDATE_DATE DATE := Sysdate;
853: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
854: G_CREATION_DATE DATE := Sysdate;
855: G_CREATED_BY NUMBER := fnd_global.user_id;
856: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
857:
858: l_table_id number := 0;
859: l_col_count number := 0;

Line 856: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

852: G_LAST_UPDATE_DATE DATE := Sysdate;
853: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
854: G_CREATION_DATE DATE := Sysdate;
855: G_CREATED_BY NUMBER := fnd_global.user_id;
856: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
857:
858: l_table_id number := 0;
859: l_col_count number := 0;
860: l_data_type VARCHAR2(9);

Line 1091: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

1087:
1088: l_table_id number := 0;
1089:
1090: G_LAST_UPDATE_DATE DATE := Sysdate;
1091: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1092: G_CREATION_DATE DATE := Sysdate;
1093: G_CREATED_BY NUMBER := fnd_global.user_id;
1094: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1095:

Line 1093: G_CREATED_BY NUMBER := fnd_global.user_id;

1089:
1090: G_LAST_UPDATE_DATE DATE := Sysdate;
1091: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1092: G_CREATION_DATE DATE := Sysdate;
1093: G_CREATED_BY NUMBER := fnd_global.user_id;
1094: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1095:
1096: CURSOR l_delete_csr ( p_column_id number ) IS
1097: SELECT table_id

Line 1094: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

1090: G_LAST_UPDATE_DATE DATE := Sysdate;
1091: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1092: G_CREATION_DATE DATE := Sysdate;
1093: G_CREATED_BY NUMBER := fnd_global.user_id;
1094: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1095:
1096: CURSOR l_delete_csr ( p_column_id number ) IS
1097: SELECT table_id
1098: FROM cn_obj_columns_v