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 198: ( resource_id DBMS_SQL.NUMBER_TABLE,

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

Line 199: resource_name DBMS_SQL.VARCHAR2_TABLE,

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

Line 200: resource_job_title DBMS_SQL.VARCHAR2_TABLE,

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

Line 201: resource_phone DBMS_SQL.VARCHAR2_TABLE,

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

Line 202: resource_email DBMS_SQL.VARCHAR2_TABLE,

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

Line 203: resource_mgr_name DBMS_SQL.VARCHAR2_TABLE,

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

Line 204: resource_mgr_phone DBMS_SQL.VARCHAR2_TABLE,

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

Line 205: resource_mgr_email DBMS_SQL.VARCHAR2_TABLE,

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

Line 206: terr_id DBMS_SQL.NUMBER_TABLE,

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

Line 207: absolute_rank DBMS_SQL.NUMBER_TABLE,

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

Line 208: top_level_terr_id DBMS_SQL.NUMBER_TABLE,

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

Line 209: resource_property1 DBMS_SQL.VARCHAR2_TABLE,

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

Line 210: resource_property2 DBMS_SQL.VARCHAR2_TABLE,

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

Line 211: resource_property3 DBMS_SQL.VARCHAR2_TABLE,

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

Line 212: resource_property4 DBMS_SQL.VARCHAR2_TABLE

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