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 145: INSERT INTO jty_terr_values_idx_details (

141: ,'Y'
142: ,'N');
143:
144: IF (p_cp_tbl(i) IS NOT NULL) THEN
145: INSERT INTO jty_terr_values_idx_details (
146: terr_values_idx_details_id
147: ,terr_values_idx_header_id
148: ,last_update_date
149: ,last_updated_by

Line 157: jty_terr_values_idx_details_s.nextval

153: ,values_col_map
154: ,input_selectivity
155: ,input_ordinal_selectivity )
156: VALUES (
157: jty_terr_values_idx_details_s.nextval
158: ,l_header_seq
159: ,G_SYSDATE
160: ,G_USER_ID
161: ,G_SYSDATE

Line 170: INSERT INTO jty_terr_values_idx_details (

166: ,null);
167: END IF;
168:
169: IF (p_lvc_id_tbl(i) IS NOT NULL) THEN
170: INSERT INTO jty_terr_values_idx_details (
171: terr_values_idx_details_id
172: ,terr_values_idx_header_id
173: ,last_update_date
174: ,last_updated_by

Line 182: jty_terr_values_idx_details_s.nextval

178: ,values_col_map
179: ,input_selectivity
180: ,input_ordinal_selectivity )
181: VALUES (
182: jty_terr_values_idx_details_s.nextval
183: ,l_header_seq
184: ,G_SYSDATE
185: ,G_USER_ID
186: ,G_SYSDATE

Line 195: INSERT INTO jty_terr_values_idx_details (

191: ,null);
192: END IF;
193:
194: IF (p_lvc_tbl(i) IS NOT NULL) THEN
195: INSERT INTO jty_terr_values_idx_details (
196: terr_values_idx_details_id
197: ,terr_values_idx_header_id
198: ,last_update_date
199: ,last_updated_by

Line 207: jty_terr_values_idx_details_s.nextval

203: ,values_col_map
204: ,input_selectivity
205: ,input_ordinal_selectivity )
206: VALUES (
207: jty_terr_values_idx_details_s.nextval
208: ,l_header_seq
209: ,G_SYSDATE
210: ,G_USER_ID
211: ,G_SYSDATE

Line 220: INSERT INTO jty_terr_values_idx_details (

216: ,null);
217: END IF;
218:
219: IF (p_hvc_tbl(i) IS NOT NULL) THEN
220: INSERT INTO jty_terr_values_idx_details (
221: terr_values_idx_details_id
222: ,terr_values_idx_header_id
223: ,last_update_date
224: ,last_updated_by

Line 232: jty_terr_values_idx_details_s.nextval

228: ,values_col_map
229: ,input_selectivity
230: ,input_ordinal_selectivity )
231: VALUES (
232: jty_terr_values_idx_details_s.nextval
233: ,l_header_seq
234: ,G_SYSDATE
235: ,G_USER_ID
236: ,G_SYSDATE

Line 245: INSERT INTO jty_terr_values_idx_details (

241: ,null);
242: END IF;
243:
244: IF (p_lvn_tbl(i) IS NOT NULL) THEN
245: INSERT INTO jty_terr_values_idx_details (
246: terr_values_idx_details_id
247: ,terr_values_idx_header_id
248: ,last_update_date
249: ,last_updated_by

Line 257: jty_terr_values_idx_details_s.nextval

253: ,values_col_map
254: ,input_selectivity
255: ,input_ordinal_selectivity )
256: VALUES (
257: jty_terr_values_idx_details_s.nextval
258: ,l_header_seq
259: ,G_SYSDATE
260: ,G_USER_ID
261: ,G_SYSDATE

Line 270: INSERT INTO jty_terr_values_idx_details (

266: ,null);
267: END IF;
268:
269: IF (p_hvn_tbl(i) IS NOT NULL) THEN
270: INSERT INTO jty_terr_values_idx_details (
271: terr_values_idx_details_id
272: ,terr_values_idx_header_id
273: ,last_update_date
274: ,last_updated_by

Line 282: jty_terr_values_idx_details_s.nextval

278: ,values_col_map
279: ,input_selectivity
280: ,input_ordinal_selectivity )
281: VALUES (
282: jty_terr_values_idx_details_s.nextval
283: ,l_header_seq
284: ,G_SYSDATE
285: ,G_USER_ID
286: ,G_SYSDATE

Line 295: INSERT INTO jty_terr_values_idx_details (

291: ,null);
292: END IF;
293:
294: IF (p_it_id_tbl(i) IS NOT NULL) THEN
295: INSERT INTO jty_terr_values_idx_details (
296: terr_values_idx_details_id
297: ,terr_values_idx_header_id
298: ,last_update_date
299: ,last_updated_by

Line 307: jty_terr_values_idx_details_s.nextval

303: ,values_col_map
304: ,input_selectivity
305: ,input_ordinal_selectivity )
306: VALUES (
307: jty_terr_values_idx_details_s.nextval
308: ,l_header_seq
309: ,G_SYSDATE
310: ,G_USER_ID
311: ,G_SYSDATE

Line 320: INSERT INTO jty_terr_values_idx_details (

316: ,null);
317: END IF;
318:
319: IF (p_pic_id_tbl(i) IS NOT NULL) THEN
320: INSERT INTO jty_terr_values_idx_details (
321: terr_values_idx_details_id
322: ,terr_values_idx_header_id
323: ,last_update_date
324: ,last_updated_by

Line 332: jty_terr_values_idx_details_s.nextval

328: ,values_col_map
329: ,input_selectivity
330: ,input_ordinal_selectivity )
331: VALUES (
332: jty_terr_values_idx_details_s.nextval
333: ,l_header_seq
334: ,G_SYSDATE
335: ,G_USER_ID
336: ,G_SYSDATE

Line 345: INSERT INTO jty_terr_values_idx_details (

341: ,null);
342: END IF;
343:
344: IF (p_sic_id_tbl(i) IS NOT NULL) THEN
345: INSERT INTO jty_terr_values_idx_details (
346: terr_values_idx_details_id
347: ,terr_values_idx_header_id
348: ,last_update_date
349: ,last_updated_by

Line 357: jty_terr_values_idx_details_s.nextval

353: ,values_col_map
354: ,input_selectivity
355: ,input_ordinal_selectivity )
356: VALUES (
357: jty_terr_values_idx_details_s.nextval
358: ,l_header_seq
359: ,G_SYSDATE
360: ,G_USER_ID
361: ,G_SYSDATE

Line 370: INSERT INTO jty_terr_values_idx_details (

366: ,null);
367: END IF;
368:
369: IF (p_curr_tbl(i) IS NOT NULL) THEN
370: INSERT INTO jty_terr_values_idx_details (
371: terr_values_idx_details_id
372: ,terr_values_idx_header_id
373: ,last_update_date
374: ,last_updated_by

Line 382: jty_terr_values_idx_details_s.nextval

378: ,values_col_map
379: ,input_selectivity
380: ,input_ordinal_selectivity )
381: VALUES (
382: jty_terr_values_idx_details_s.nextval
383: ,l_header_seq
384: ,G_SYSDATE
385: ,G_USER_ID
386: ,G_SYSDATE

Line 395: INSERT INTO jty_terr_values_idx_details (

391: ,null);
392: END IF;
393:
394: IF (p_value1_id_tbl(i) IS NOT NULL) THEN
395: INSERT INTO jty_terr_values_idx_details (
396: terr_values_idx_details_id
397: ,terr_values_idx_header_id
398: ,last_update_date
399: ,last_updated_by

Line 407: jty_terr_values_idx_details_s.nextval

403: ,values_col_map
404: ,input_selectivity
405: ,input_ordinal_selectivity )
406: VALUES (
407: jty_terr_values_idx_details_s.nextval
408: ,l_header_seq
409: ,G_SYSDATE
410: ,G_USER_ID
411: ,G_SYSDATE

Line 420: INSERT INTO jty_terr_values_idx_details (

416: ,null);
417: END IF;
418:
419: IF (p_value2_id_tbl(i) IS NOT NULL) THEN
420: INSERT INTO jty_terr_values_idx_details (
421: terr_values_idx_details_id
422: ,terr_values_idx_header_id
423: ,last_update_date
424: ,last_updated_by

Line 432: jty_terr_values_idx_details_s.nextval

428: ,values_col_map
429: ,input_selectivity
430: ,input_ordinal_selectivity )
431: VALUES (
432: jty_terr_values_idx_details_s.nextval
433: ,l_header_seq
434: ,G_SYSDATE
435: ,G_USER_ID
436: ,G_SYSDATE

Line 445: INSERT INTO jty_terr_values_idx_details (

441: ,null);
442: END IF;
443:
444: IF (p_value3_id_tbl(i) IS NOT NULL) THEN
445: INSERT INTO jty_terr_values_idx_details (
446: terr_values_idx_details_id
447: ,terr_values_idx_header_id
448: ,last_update_date
449: ,last_updated_by

Line 457: jty_terr_values_idx_details_s.nextval

453: ,values_col_map
454: ,input_selectivity
455: ,input_ordinal_selectivity )
456: VALUES (
457: jty_terr_values_idx_details_s.nextval
458: ,l_header_seq
459: ,G_SYSDATE
460: ,G_USER_ID
461: ,G_SYSDATE

Line 470: INSERT INTO jty_terr_values_idx_details (

466: ,null);
467: END IF;
468:
469: IF (p_value4_id_tbl(i) IS NOT NULL) THEN
470: INSERT INTO jty_terr_values_idx_details (
471: terr_values_idx_details_id
472: ,terr_values_idx_header_id
473: ,last_update_date
474: ,last_updated_by

Line 482: jty_terr_values_idx_details_s.nextval

478: ,values_col_map
479: ,input_selectivity
480: ,input_ordinal_selectivity )
481: VALUES (
482: jty_terr_values_idx_details_s.nextval
483: ,l_header_seq
484: ,G_SYSDATE
485: ,G_USER_ID
486: ,G_SYSDATE

Line 495: INSERT INTO jty_terr_values_idx_details (

491: ,null);
492: END IF;
493:
494: IF (p_fc_tbl(i) IS NOT NULL) THEN
495: INSERT INTO jty_terr_values_idx_details (
496: terr_values_idx_details_id
497: ,terr_values_idx_header_id
498: ,last_update_date
499: ,last_updated_by

Line 507: jty_terr_values_idx_details_s.nextval

503: ,values_col_map
504: ,input_selectivity
505: ,input_ordinal_selectivity )
506: VALUES (
507: jty_terr_values_idx_details_s.nextval
508: ,l_header_seq
509: ,G_SYSDATE
510: ,G_USER_ID
511: ,G_SYSDATE