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.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTY_TERR_VALUES_IDX_DETAILS

Line 135: INSERT INTO jty_terr_values_idx_details (

131: ,'Y'
132: ,'N');
133:
134: IF (p_cp_tbl(i) IS NOT NULL) THEN
135: INSERT INTO jty_terr_values_idx_details (
136: terr_values_idx_details_id
137: ,terr_values_idx_header_id
138: ,last_update_date
139: ,last_updated_by

Line 147: jty_terr_values_idx_details_s.nextval

143: ,values_col_map
144: ,input_selectivity
145: ,input_ordinal_selectivity )
146: VALUES (
147: jty_terr_values_idx_details_s.nextval
148: ,l_header_seq
149: ,G_SYSDATE
150: ,G_USER_ID
151: ,G_SYSDATE

Line 160: INSERT INTO jty_terr_values_idx_details (

156: ,null);
157: END IF;
158:
159: IF (p_lvc_id_tbl(i) IS NOT NULL) THEN
160: INSERT INTO jty_terr_values_idx_details (
161: terr_values_idx_details_id
162: ,terr_values_idx_header_id
163: ,last_update_date
164: ,last_updated_by

Line 172: jty_terr_values_idx_details_s.nextval

168: ,values_col_map
169: ,input_selectivity
170: ,input_ordinal_selectivity )
171: VALUES (
172: jty_terr_values_idx_details_s.nextval
173: ,l_header_seq
174: ,G_SYSDATE
175: ,G_USER_ID
176: ,G_SYSDATE

Line 185: INSERT INTO jty_terr_values_idx_details (

181: ,null);
182: END IF;
183:
184: IF (p_lvc_tbl(i) IS NOT NULL) THEN
185: INSERT INTO jty_terr_values_idx_details (
186: terr_values_idx_details_id
187: ,terr_values_idx_header_id
188: ,last_update_date
189: ,last_updated_by

Line 197: jty_terr_values_idx_details_s.nextval

193: ,values_col_map
194: ,input_selectivity
195: ,input_ordinal_selectivity )
196: VALUES (
197: jty_terr_values_idx_details_s.nextval
198: ,l_header_seq
199: ,G_SYSDATE
200: ,G_USER_ID
201: ,G_SYSDATE

Line 210: INSERT INTO jty_terr_values_idx_details (

206: ,null);
207: END IF;
208:
209: IF (p_hvc_tbl(i) IS NOT NULL) THEN
210: INSERT INTO jty_terr_values_idx_details (
211: terr_values_idx_details_id
212: ,terr_values_idx_header_id
213: ,last_update_date
214: ,last_updated_by

Line 222: jty_terr_values_idx_details_s.nextval

218: ,values_col_map
219: ,input_selectivity
220: ,input_ordinal_selectivity )
221: VALUES (
222: jty_terr_values_idx_details_s.nextval
223: ,l_header_seq
224: ,G_SYSDATE
225: ,G_USER_ID
226: ,G_SYSDATE

Line 235: INSERT INTO jty_terr_values_idx_details (

231: ,null);
232: END IF;
233:
234: IF (p_lvn_tbl(i) IS NOT NULL) THEN
235: INSERT INTO jty_terr_values_idx_details (
236: terr_values_idx_details_id
237: ,terr_values_idx_header_id
238: ,last_update_date
239: ,last_updated_by

Line 247: jty_terr_values_idx_details_s.nextval

243: ,values_col_map
244: ,input_selectivity
245: ,input_ordinal_selectivity )
246: VALUES (
247: jty_terr_values_idx_details_s.nextval
248: ,l_header_seq
249: ,G_SYSDATE
250: ,G_USER_ID
251: ,G_SYSDATE

Line 260: INSERT INTO jty_terr_values_idx_details (

256: ,null);
257: END IF;
258:
259: IF (p_hvn_tbl(i) IS NOT NULL) THEN
260: INSERT INTO jty_terr_values_idx_details (
261: terr_values_idx_details_id
262: ,terr_values_idx_header_id
263: ,last_update_date
264: ,last_updated_by

Line 272: jty_terr_values_idx_details_s.nextval

268: ,values_col_map
269: ,input_selectivity
270: ,input_ordinal_selectivity )
271: VALUES (
272: jty_terr_values_idx_details_s.nextval
273: ,l_header_seq
274: ,G_SYSDATE
275: ,G_USER_ID
276: ,G_SYSDATE

Line 285: INSERT INTO jty_terr_values_idx_details (

281: ,null);
282: END IF;
283:
284: IF (p_it_id_tbl(i) IS NOT NULL) THEN
285: INSERT INTO jty_terr_values_idx_details (
286: terr_values_idx_details_id
287: ,terr_values_idx_header_id
288: ,last_update_date
289: ,last_updated_by

Line 297: jty_terr_values_idx_details_s.nextval

293: ,values_col_map
294: ,input_selectivity
295: ,input_ordinal_selectivity )
296: VALUES (
297: jty_terr_values_idx_details_s.nextval
298: ,l_header_seq
299: ,G_SYSDATE
300: ,G_USER_ID
301: ,G_SYSDATE

Line 310: INSERT INTO jty_terr_values_idx_details (

306: ,null);
307: END IF;
308:
309: IF (p_pic_id_tbl(i) IS NOT NULL) THEN
310: INSERT INTO jty_terr_values_idx_details (
311: terr_values_idx_details_id
312: ,terr_values_idx_header_id
313: ,last_update_date
314: ,last_updated_by

Line 322: jty_terr_values_idx_details_s.nextval

318: ,values_col_map
319: ,input_selectivity
320: ,input_ordinal_selectivity )
321: VALUES (
322: jty_terr_values_idx_details_s.nextval
323: ,l_header_seq
324: ,G_SYSDATE
325: ,G_USER_ID
326: ,G_SYSDATE

Line 335: INSERT INTO jty_terr_values_idx_details (

331: ,null);
332: END IF;
333:
334: IF (p_sic_id_tbl(i) IS NOT NULL) THEN
335: INSERT INTO jty_terr_values_idx_details (
336: terr_values_idx_details_id
337: ,terr_values_idx_header_id
338: ,last_update_date
339: ,last_updated_by

Line 347: jty_terr_values_idx_details_s.nextval

343: ,values_col_map
344: ,input_selectivity
345: ,input_ordinal_selectivity )
346: VALUES (
347: jty_terr_values_idx_details_s.nextval
348: ,l_header_seq
349: ,G_SYSDATE
350: ,G_USER_ID
351: ,G_SYSDATE

Line 360: INSERT INTO jty_terr_values_idx_details (

356: ,null);
357: END IF;
358:
359: IF (p_curr_tbl(i) IS NOT NULL) THEN
360: INSERT INTO jty_terr_values_idx_details (
361: terr_values_idx_details_id
362: ,terr_values_idx_header_id
363: ,last_update_date
364: ,last_updated_by

Line 372: jty_terr_values_idx_details_s.nextval

368: ,values_col_map
369: ,input_selectivity
370: ,input_ordinal_selectivity )
371: VALUES (
372: jty_terr_values_idx_details_s.nextval
373: ,l_header_seq
374: ,G_SYSDATE
375: ,G_USER_ID
376: ,G_SYSDATE

Line 385: INSERT INTO jty_terr_values_idx_details (

381: ,null);
382: END IF;
383:
384: IF (p_value1_id_tbl(i) IS NOT NULL) THEN
385: INSERT INTO jty_terr_values_idx_details (
386: terr_values_idx_details_id
387: ,terr_values_idx_header_id
388: ,last_update_date
389: ,last_updated_by

Line 397: jty_terr_values_idx_details_s.nextval

393: ,values_col_map
394: ,input_selectivity
395: ,input_ordinal_selectivity )
396: VALUES (
397: jty_terr_values_idx_details_s.nextval
398: ,l_header_seq
399: ,G_SYSDATE
400: ,G_USER_ID
401: ,G_SYSDATE

Line 410: INSERT INTO jty_terr_values_idx_details (

406: ,null);
407: END IF;
408:
409: IF (p_value2_id_tbl(i) IS NOT NULL) THEN
410: INSERT INTO jty_terr_values_idx_details (
411: terr_values_idx_details_id
412: ,terr_values_idx_header_id
413: ,last_update_date
414: ,last_updated_by

Line 422: jty_terr_values_idx_details_s.nextval

418: ,values_col_map
419: ,input_selectivity
420: ,input_ordinal_selectivity )
421: VALUES (
422: jty_terr_values_idx_details_s.nextval
423: ,l_header_seq
424: ,G_SYSDATE
425: ,G_USER_ID
426: ,G_SYSDATE

Line 435: INSERT INTO jty_terr_values_idx_details (

431: ,null);
432: END IF;
433:
434: IF (p_value3_id_tbl(i) IS NOT NULL) THEN
435: INSERT INTO jty_terr_values_idx_details (
436: terr_values_idx_details_id
437: ,terr_values_idx_header_id
438: ,last_update_date
439: ,last_updated_by

Line 447: jty_terr_values_idx_details_s.nextval

443: ,values_col_map
444: ,input_selectivity
445: ,input_ordinal_selectivity )
446: VALUES (
447: jty_terr_values_idx_details_s.nextval
448: ,l_header_seq
449: ,G_SYSDATE
450: ,G_USER_ID
451: ,G_SYSDATE

Line 460: INSERT INTO jty_terr_values_idx_details (

456: ,null);
457: END IF;
458:
459: IF (p_value4_id_tbl(i) IS NOT NULL) THEN
460: INSERT INTO jty_terr_values_idx_details (
461: terr_values_idx_details_id
462: ,terr_values_idx_header_id
463: ,last_update_date
464: ,last_updated_by

Line 472: jty_terr_values_idx_details_s.nextval

468: ,values_col_map
469: ,input_selectivity
470: ,input_ordinal_selectivity )
471: VALUES (
472: jty_terr_values_idx_details_s.nextval
473: ,l_header_seq
474: ,G_SYSDATE
475: ,G_USER_ID
476: ,G_SYSDATE

Line 485: INSERT INTO jty_terr_values_idx_details (

481: ,null);
482: END IF;
483:
484: IF (p_fc_tbl(i) IS NOT NULL) THEN
485: INSERT INTO jty_terr_values_idx_details (
486: terr_values_idx_details_id
487: ,terr_values_idx_header_id
488: ,last_update_date
489: ,last_updated_by

Line 497: jty_terr_values_idx_details_s.nextval

493: ,values_col_map
494: ,input_selectivity
495: ,input_ordinal_selectivity )
496: VALUES (
497: jty_terr_values_idx_details_s.nextval
498: ,l_header_seq
499: ,G_SYSDATE
500: ,G_USER_ID
501: ,G_SYSDATE