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.JTF_TERRITORY_PUB dependencies on DBMS_SQL

Line 196: ( resource_id DBMS_SQL.NUMBER_TABLE,

192:
193:
194:
195: TYPE JTF_WIN_RSC_BULK_REC_TYPE IS RECORD
196: ( resource_id DBMS_SQL.NUMBER_TABLE,
197: resource_name DBMS_SQL.VARCHAR2_TABLE,
198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,
199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,

Line 197: resource_name DBMS_SQL.VARCHAR2_TABLE,

193:
194:
195: TYPE JTF_WIN_RSC_BULK_REC_TYPE IS RECORD
196: ( resource_id DBMS_SQL.NUMBER_TABLE,
197: resource_name DBMS_SQL.VARCHAR2_TABLE,
198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,
199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,

Line 198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,

194:
195: TYPE JTF_WIN_RSC_BULK_REC_TYPE IS RECORD
196: ( resource_id DBMS_SQL.NUMBER_TABLE,
197: resource_name DBMS_SQL.VARCHAR2_TABLE,
198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,
199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,

Line 199: resource_phone DBMS_SQL.VARCHAR2_TABLE,

195: TYPE JTF_WIN_RSC_BULK_REC_TYPE IS RECORD
196: ( resource_id DBMS_SQL.NUMBER_TABLE,
197: resource_name DBMS_SQL.VARCHAR2_TABLE,
198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,
199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,

Line 200: resource_email DBMS_SQL.VARCHAR2_TABLE,

196: ( resource_id DBMS_SQL.NUMBER_TABLE,
197: resource_name DBMS_SQL.VARCHAR2_TABLE,
198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,
199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,

Line 201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,

197: resource_name DBMS_SQL.VARCHAR2_TABLE,
198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,
199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,

Line 202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,

198: resource_job_title DBMS_SQL.VARCHAR2_TABLE,
199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,

Line 203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,

199: resource_phone DBMS_SQL.VARCHAR2_TABLE,
200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,

Line 204: terr_id DBMS_SQL.NUMBER_TABLE,

200: resource_email DBMS_SQL.VARCHAR2_TABLE,
201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,
208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,

Line 205: absolute_rank DBMS_SQL.NUMBER_TABLE,

201: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,
202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,
208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,
209: resource_property3 DBMS_SQL.VARCHAR2_TABLE,

Line 206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,

202: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,
203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,
208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,
209: resource_property3 DBMS_SQL.VARCHAR2_TABLE,
210: resource_property4 DBMS_SQL.VARCHAR2_TABLE

Line 207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,

203: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,
204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,
208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,
209: resource_property3 DBMS_SQL.VARCHAR2_TABLE,
210: resource_property4 DBMS_SQL.VARCHAR2_TABLE
211: );

Line 208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,

204: terr_id DBMS_SQL.NUMBER_TABLE,
205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,
208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,
209: resource_property3 DBMS_SQL.VARCHAR2_TABLE,
210: resource_property4 DBMS_SQL.VARCHAR2_TABLE
211: );
212:

Line 209: resource_property3 DBMS_SQL.VARCHAR2_TABLE,

205: absolute_rank DBMS_SQL.NUMBER_TABLE,
206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,
208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,
209: resource_property3 DBMS_SQL.VARCHAR2_TABLE,
210: resource_property4 DBMS_SQL.VARCHAR2_TABLE
211: );
212:
213: ---------------------------------------------------------

Line 210: resource_property4 DBMS_SQL.VARCHAR2_TABLE

206: top_level_terr_id DBMS_SQL.NUMBER_TABLE,
207: resource_property1 DBMS_SQL.VARCHAR2_TABLE,
208: resource_property2 DBMS_SQL.VARCHAR2_TABLE,
209: resource_property3 DBMS_SQL.VARCHAR2_TABLE,
210: resource_property4 DBMS_SQL.VARCHAR2_TABLE
211: );
212:
213: ---------------------------------------------------------
214: -- Winning Territory Record: WinningTerr_rec_type