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_TRIGGER_HANDLERS dependencies on JTY_CHANGED_TERRS

Line 46: INSERT INTO jty_changed_terrs (

42:
43: IF (Trigger_Mode = 'ON-INSERT') THEN
44:
45: IF ((n_start_date_active < sysdate) AND (n_end_date_active > sysdate)) THEN
46: INSERT INTO jty_changed_terrs (
47: CHANGED_TERRITORY_ID
48: ,OBJECT_VERSION_NUMBER
49: ,TERR_ID
50: ,CHANGE_TYPE

Line 56: jty_changed_terrs_s.nextval

52: ,PROCESS_ATTR_VALUES_FLAG
53: ,MATCHING_SQL_FLAG
54: ,HIER_PROCESSING_FLAG)
55: VALUES (
56: jty_changed_terrs_s.nextval
57: ,0
58: ,p_terr_id
59: ,'CREATE'
60: ,'Y'

Line 72: FROM jty_changed_terrs

68: (o_rank is not null and n_rank is null) OR
69: (o_rank <> n_rank) THEN
70: SELECT count(*)
71: INTO l_no_of_records
72: FROM jty_changed_terrs
73: WHERE terr_id = p_terr_id
74: AND change_type = 'CREATE'
75: AND star_request_id IS NULL;
76:

Line 78: MERGE INTO jty_changed_terrs A

74: AND change_type = 'CREATE'
75: AND star_request_id IS NULL;
76:
77: IF (l_no_of_records = 0) THEN
78: MERGE INTO jty_changed_terrs A
79: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
80: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
81: WHEN MATCHED THEN
82: UPDATE SET

Line 96: jty_changed_terrs_s.nextval

92: ,A.PROCESS_ATTR_VALUES_FLAG
93: ,A.MATCHING_SQL_FLAG
94: ,A.HIER_PROCESSING_FLAG)
95: VALUES (
96: jty_changed_terrs_s.nextval
97: ,0
98: ,S.terr_id
99: ,S.source_id
100: ,'UPDATE'

Line 113: FROM jty_changed_terrs

109: (o_num_winners is not null and n_num_winners is null) OR
110: (o_num_winners <> n_num_winners) THEN
111: SELECT count(*)
112: INTO l_no_of_records
113: FROM jty_changed_terrs
114: WHERE terr_id = p_terr_id
115: AND change_type = 'CREATE'
116: AND star_request_id IS NULL;
117:

Line 119: MERGE INTO jty_changed_terrs A

115: AND change_type = 'CREATE'
116: AND star_request_id IS NULL;
117:
118: IF (l_no_of_records = 0) THEN
119: MERGE INTO jty_changed_terrs A
120: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
121: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
122: WHEN MATCHED THEN
123: UPDATE SET

Line 137: jty_changed_terrs_s.nextval

133: ,A.PROCESS_ATTR_VALUES_FLAG
134: ,A.MATCHING_SQL_FLAG
135: ,A.HIER_PROCESSING_FLAG)
136: VALUES (
137: jty_changed_terrs_s.nextval
138: ,0
139: ,S.terr_id
140: ,S.source_id
141: ,'UPDATE'

Line 151: MERGE INTO jty_changed_terrs A

147: END IF; /* end IF (n_num_winners <> o_num_winners) */
148:
149: IF (n_parent_territory_id <> o_parent_territory_id) THEN
150:
151: MERGE INTO jty_changed_terrs A
152: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
153: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
154: WHEN MATCHED THEN
155: UPDATE SET

Line 172: jty_changed_terrs_s.nextval

168: ,A.PROCESS_ATTR_VALUES_FLAG
169: ,A.MATCHING_SQL_FLAG
170: ,A.HIER_PROCESSING_FLAG)
171: VALUES (
172: jty_changed_terrs_s.nextval
173: ,0
174: ,S.terr_id
175: ,S.source_id
176: ,'UPDATE'

Line 187: MERGE INTO jty_changed_terrs A

183: IF ((o_end_date_active < sysdate and o_start_date_active < sysdate) OR
184: (o_end_date_active > sysdate and o_start_date_active > sysdate)) THEN
185: IF (n_start_date_active < sysdate and n_end_date_active > sysdate) THEN
186: /* future or inactive territory has become active as a result of the change */
187: MERGE INTO jty_changed_terrs A
188: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
189: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
190: WHEN MATCHED THEN
191: UPDATE SET

Line 208: jty_changed_terrs_s.nextval

204: ,A.PROCESS_ATTR_VALUES_FLAG
205: ,A.MATCHING_SQL_FLAG
206: ,A.HIER_PROCESSING_FLAG)
207: VALUES (
208: jty_changed_terrs_s.nextval
209: ,0
210: ,S.terr_id
211: ,S.source_id
212: ,'UPDATE'

Line 222: MERGE INTO jty_changed_terrs A

218: ELSIF (o_start_date_active < sysdate and o_end_date_active > sysdate) THEN
219: IF ((n_end_date_active < sysdate and n_start_date_active < sysdate) OR
220: (n_end_date_active > sysdate and n_start_date_active > sysdate)) THEN
221: /* active territory has become future or inactive as a resukt of the change */
222: MERGE INTO jty_changed_terrs A
223: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
224: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
225: WHEN MATCHED THEN
226: UPDATE SET

Line 243: jty_changed_terrs_s.nextval

239: ,A.PROCESS_ATTR_VALUES_FLAG
240: ,A.MATCHING_SQL_FLAG
241: ,A.HIER_PROCESSING_FLAG)
242: VALUES (
243: jty_changed_terrs_s.nextval
244: ,0
245: ,S.terr_id
246: ,S.source_id
247: ,'UPDATE'

Line 256: MERGE INTO jty_changed_terrs A

252: END IF;
253: END IF;
254: ELSIF (Trigger_Mode = 'ON-DELETE') THEN
255:
256: MERGE INTO jty_changed_terrs A
257: USING ( SELECT p_terr_id terr_id from dual ) S
258: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
259: WHEN MATCHED THEN
260: UPDATE SET

Line 277: jty_changed_terrs_s.nextval

273: ,A.PROCESS_ATTR_VALUES_FLAG
274: ,A.MATCHING_SQL_FLAG
275: ,A.HIER_PROCESSING_FLAG)
276: VALUES (
277: jty_changed_terrs_s.nextval
278: ,0
279: ,S.terr_id
280: ,'DELETE'
281: ,'N'

Line 336: FROM jty_changed_terrs

332: SELECT change_type,
333: process_attr_values_flag
334: INTO l_change_type,
335: l_process_attr_values_flag
336: FROM jty_changed_terrs
337: WHERE terr_id = l_terr_id
338: AND star_request_id IS NULL;
339:
340: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN

Line 341: UPDATE jty_changed_terrs

337: WHERE terr_id = l_terr_id
338: AND star_request_id IS NULL;
339:
340: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN
341: UPDATE jty_changed_terrs
342: SET process_attr_values_flag = 'I'
343: WHERE terr_id = l_terr_id
344: AND star_request_id IS NULL;
345: END IF;

Line 348: INSERT INTO jty_changed_terrs (

344: AND star_request_id IS NULL;
345: END IF;
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: INSERT INTO jty_changed_terrs (
349: CHANGED_TERRITORY_ID
350: ,OBJECT_VERSION_NUMBER
351: ,TERR_ID
352: ,SOURCE_ID

Line 359: jty_changed_terrs_s.nextval

355: ,PROCESS_ATTR_VALUES_FLAG
356: ,MATCHING_SQL_FLAG
357: ,HIER_PROCESSING_FLAG)
358: VALUES (
359: jty_changed_terrs_s.nextval
360: ,0
361: ,l_terr_id
362: ,l_source_id
363: ,'UPDATE'

Line 404: FROM jty_changed_terrs

400: END;
401:
402: SELECT count(*)
403: INTO l_no_of_records
404: FROM jty_changed_terrs
405: WHERE terr_id = p_terr_id
406: AND tap_request_id IS NULL;
407:
408: IF (l_no_of_records = 0) THEN

Line 409: INSERT INTO jty_changed_terrs (

405: WHERE terr_id = p_terr_id
406: AND tap_request_id IS NULL;
407:
408: IF (l_no_of_records = 0) THEN
409: INSERT INTO jty_changed_terrs (
410: CHANGED_TERRITORY_ID
411: ,OBJECT_VERSION_NUMBER
412: ,TERR_ID
413: ,SOURCE_ID

Line 420: jty_changed_terrs_s.nextval

416: ,PROCESS_ATTR_VALUES_FLAG
417: ,MATCHING_SQL_FLAG
418: ,HIER_PROCESSING_FLAG)
419: VALUES (
420: jty_changed_terrs_s.nextval
421: ,0
422: ,p_terr_id
423: ,l_source_id
424: ,'UPDATE'

Line 465: FROM jty_changed_terrs

461: SELECT change_type,
462: process_attr_values_flag
463: INTO l_change_type,
464: l_process_attr_values_flag
465: FROM jty_changed_terrs
466: WHERE terr_id = p_terr_id
467: AND star_request_id IS NULL;
468:
469: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN

Line 470: UPDATE jty_changed_terrs

466: WHERE terr_id = p_terr_id
467: AND star_request_id IS NULL;
468:
469: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN
470: UPDATE jty_changed_terrs
471: SET process_attr_values_flag = 'I',
472: matching_sql_flag = 'Y'
473: WHERE terr_id = p_terr_id
474: AND star_request_id IS NULL;

Line 478: INSERT INTO jty_changed_terrs (

474: AND star_request_id IS NULL;
475: END IF;
476: EXCEPTION
477: WHEN NO_DATA_FOUND THEN
478: INSERT INTO jty_changed_terrs (
479: CHANGED_TERRITORY_ID
480: ,OBJECT_VERSION_NUMBER
481: ,TERR_ID
482: ,SOURCE_ID

Line 489: jty_changed_terrs_s.nextval

485: ,PROCESS_ATTR_VALUES_FLAG
486: ,MATCHING_SQL_FLAG
487: ,HIER_PROCESSING_FLAG)
488: VALUES (
489: jty_changed_terrs_s.nextval
490: ,0
491: ,p_terr_id
492: ,l_source_id
493: ,'UPDATE'

Line 546: FROM jty_changed_terrs

542: END;
543:
544: SELECT count(*)
545: INTO l_no_of_records
546: FROM jty_changed_terrs
547: WHERE terr_id = l_terr_id
548: AND tap_request_id IS NULL;
549:
550: IF (l_no_of_records = 0) THEN

Line 551: INSERT INTO jty_changed_terrs (

547: WHERE terr_id = l_terr_id
548: AND tap_request_id IS NULL;
549:
550: IF (l_no_of_records = 0) THEN
551: INSERT INTO jty_changed_terrs (
552: CHANGED_TERRITORY_ID
553: ,OBJECT_VERSION_NUMBER
554: ,TERR_ID
555: ,SOURCE_ID

Line 562: jty_changed_terrs_s.nextval

558: ,PROCESS_ATTR_VALUES_FLAG
559: ,MATCHING_SQL_FLAG
560: ,HIER_PROCESSING_FLAG)
561: VALUES (
562: jty_changed_terrs_s.nextval
563: ,0
564: ,l_terr_id
565: ,l_source_id
566: ,'UPDATE'

Line 603: FROM jty_changed_terrs

599: SELECT change_type,
600: matching_sql_flag
601: INTO l_change_type,
602: l_matching_sql_flag
603: FROM jty_changed_terrs
604: WHERE terr_id = p_terr_id
605: AND star_request_id IS NULL;
606:
607: IF ((l_change_type = 'UPDATE') AND (l_matching_sql_flag <> 'Y')) THEN

Line 608: UPDATE jty_changed_terrs

604: WHERE terr_id = p_terr_id
605: AND star_request_id IS NULL;
606:
607: IF ((l_change_type = 'UPDATE') AND (l_matching_sql_flag <> 'Y')) THEN
608: UPDATE jty_changed_terrs
609: SET matching_sql_flag = 'Y'
610: WHERE terr_id = p_terr_id
611: AND star_request_id IS NULL;
612: END IF;

Line 615: INSERT INTO jty_changed_terrs (

611: AND star_request_id IS NULL;
612: END IF;
613: EXCEPTION
614: WHEN NO_DATA_FOUND THEN
615: INSERT INTO jty_changed_terrs (
616: CHANGED_TERRITORY_ID
617: ,OBJECT_VERSION_NUMBER
618: ,TERR_ID
619: ,SOURCE_ID

Line 626: jty_changed_terrs_s.nextval

622: ,PROCESS_ATTR_VALUES_FLAG
623: ,MATCHING_SQL_FLAG
624: ,HIER_PROCESSING_FLAG)
625: VALUES (
626: jty_changed_terrs_s.nextval
627: ,0
628: ,p_terr_id
629: ,l_source_id
630: ,'UPDATE'

Line 656: MERGE INTO jty_changed_terrs A

652: triggering_mode IN VARCHAR2)
653: IS
654: BEGIN
655: IF (triggering_mode = 'ON-INSERT') THEN
656: MERGE INTO jty_changed_terrs A
657: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
658: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
659: WHEN MATCHED THEN
660: UPDATE SET

Line 674: jty_changed_terrs_s.nextval

670: ,A.PROCESS_ATTR_VALUES_FLAG
671: ,A.MATCHING_SQL_FLAG
672: ,A.HIER_PROCESSING_FLAG)
673: VALUES (
674: jty_changed_terrs_s.nextval
675: ,0
676: ,S.terr_id
677: ,S.source_id
678: ,'CREATE'

Line 684: MERGE INTO jty_changed_terrs A

680: ,'I'
681: ,'Y'
682: ,'I');
683: ELSIF (triggering_mode = 'ON-DELETE') THEN
684: MERGE INTO jty_changed_terrs A
685: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
686: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
687: WHEN MATCHED THEN
688: UPDATE SET

Line 702: jty_changed_terrs_s.nextval

698: ,A.PROCESS_ATTR_VALUES_FLAG
699: ,A.MATCHING_SQL_FLAG
700: ,A.HIER_PROCESSING_FLAG)
701: VALUES (
702: jty_changed_terrs_s.nextval
703: ,0
704: ,S.terr_id
705: ,S.source_id
706: ,'DELETE'