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 108: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

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

Line 110: G_CREATED_BY NUMBER := fnd_global.user_id;

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

Line 111: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

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

Line 279: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

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

Line 281: G_CREATED_BY NUMBER := fnd_global.user_id;

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

Line 282: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

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

Line 451: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

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

Line 453: G_CREATED_BY NUMBER := fnd_global.user_id;

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

Line 454: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

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

Line 616: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

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

Line 618: G_CREATED_BY NUMBER := fnd_global.user_id;

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

Line 619: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

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

Line 852: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

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

Line 854: G_CREATED_BY NUMBER := fnd_global.user_id;

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

Line 855: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

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

Line 1088: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

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

Line 1090: G_CREATED_BY NUMBER := fnd_global.user_id;

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

Line 1091: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

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