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 91: FROM jty_changed_terrs

87: (o_rank is not null and n_rank is null) OR
88: (o_rank <> n_rank) THEN
89: SELECT count(*)
90: INTO l_no_of_records
91: FROM jty_changed_terrs
92: WHERE terr_id = p_terr_id
93: AND change_type = 'CREATE'
94: AND star_request_id IS NULL;
95:

Line 97: MERGE INTO jty_changed_terrs A

93: AND change_type = 'CREATE'
94: AND star_request_id IS NULL;
95:
96: IF (l_no_of_records = 0) THEN
97: MERGE INTO jty_changed_terrs A
98: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
99: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
100: WHEN MATCHED THEN
101: UPDATE SET

Line 115: jty_changed_terrs_s.nextval

111: ,A.PROCESS_ATTR_VALUES_FLAG
112: ,A.MATCHING_SQL_FLAG
113: ,A.HIER_PROCESSING_FLAG)
114: VALUES (
115: jty_changed_terrs_s.nextval
116: ,0
117: ,S.terr_id
118: ,S.source_id
119: ,'UPDATE'

Line 169: FROM jty_changed_terrs

165: (o_num_winners is not null and n_num_winners is null) OR
166: (o_num_winners <> n_num_winners) THEN
167: SELECT count(*)
168: INTO l_no_of_records
169: FROM jty_changed_terrs
170: WHERE terr_id = p_terr_id
171: AND change_type = 'CREATE'
172: AND star_request_id IS NULL;
173:

Line 175: MERGE INTO jty_changed_terrs A

171: AND change_type = 'CREATE'
172: AND star_request_id IS NULL;
173:
174: IF (l_no_of_records = 0) THEN
175: MERGE INTO jty_changed_terrs A
176: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
177: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
178: WHEN MATCHED THEN
179: UPDATE SET

Line 193: jty_changed_terrs_s.nextval

189: ,A.PROCESS_ATTR_VALUES_FLAG
190: ,A.MATCHING_SQL_FLAG
191: ,A.HIER_PROCESSING_FLAG)
192: VALUES (
193: jty_changed_terrs_s.nextval
194: ,0
195: ,S.terr_id
196: ,S.source_id
197: ,'UPDATE'

Line 244: MERGE INTO jty_changed_terrs A

240: END IF; /* end IF (n_num_winners <> o_num_winners) */
241:
242: IF (n_parent_territory_id <> o_parent_territory_id) THEN
243:
244: MERGE INTO jty_changed_terrs A
245: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
246: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
247: WHEN MATCHED THEN
248: UPDATE SET

Line 265: jty_changed_terrs_s.nextval

261: ,A.PROCESS_ATTR_VALUES_FLAG
262: ,A.MATCHING_SQL_FLAG
263: ,A.HIER_PROCESSING_FLAG)
264: VALUES (
265: jty_changed_terrs_s.nextval
266: ,0
267: ,S.terr_id
268: ,S.source_id
269: ,'UPDATE'

Line 311: MERGE INTO jty_changed_terrs A

307: IF ((o_end_date_active < sysdate and o_start_date_active < sysdate) OR
308: (o_end_date_active > sysdate and o_start_date_active > sysdate)) THEN
309: IF (n_start_date_active < sysdate and n_end_date_active > sysdate) THEN
310: /* future or inactive territory has become active as a result of the change */
311: MERGE INTO jty_changed_terrs A
312: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
313: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
314: WHEN MATCHED THEN
315: UPDATE SET

Line 332: jty_changed_terrs_s.nextval

328: ,A.PROCESS_ATTR_VALUES_FLAG
329: ,A.MATCHING_SQL_FLAG
330: ,A.HIER_PROCESSING_FLAG)
331: VALUES (
332: jty_changed_terrs_s.nextval
333: ,0
334: ,S.terr_id
335: ,S.source_id
336: ,'UPDATE'

Line 378: MERGE INTO jty_changed_terrs A

374: ELSIF (o_start_date_active < sysdate and o_end_date_active > sysdate) THEN
375: IF ((n_end_date_active < sysdate and n_start_date_active < sysdate) OR
376: (n_end_date_active > sysdate and n_start_date_active > sysdate)) THEN
377: /* active territory has become future or inactive as a resukt of the change */
378: MERGE INTO jty_changed_terrs A
379: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
380: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
381: WHEN MATCHED THEN
382: UPDATE SET

Line 399: jty_changed_terrs_s.nextval

395: ,A.PROCESS_ATTR_VALUES_FLAG
396: ,A.MATCHING_SQL_FLAG
397: ,A.HIER_PROCESSING_FLAG)
398: VALUES (
399: jty_changed_terrs_s.nextval
400: ,0
401: ,S.terr_id
402: ,S.source_id
403: ,'UPDATE'

Line 442: MERGE INTO jty_changed_terrs A

438: ,'Y'
439: ,'D');
440: ELSIF ((n_end_date_active > sysdate and n_end_date_active <> o_end_date_active)) THEN
441: /* active territory has become future or inactive as a resukt of the change */
442: MERGE INTO jty_changed_terrs A
443: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
444: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
445: WHEN MATCHED THEN
446: UPDATE SET

Line 463: jty_changed_terrs_s.nextval

459: ,A.PROCESS_ATTR_VALUES_FLAG
460: ,A.MATCHING_SQL_FLAG
461: ,A.HIER_PROCESSING_FLAG)
462: VALUES (
463: jty_changed_terrs_s.nextval
464: ,0
465: ,S.terr_id
466: ,S.source_id
467: ,'UPDATE'

Line 540: MERGE INTO jty_changed_terrs A

536: END IF;
537: END IF;
538: ELSIF (Trigger_Mode = 'ON-DELETE') THEN
539:
540: MERGE INTO jty_changed_terrs A
541: USING ( SELECT p_terr_id terr_id from dual ) S
542: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
543: WHEN MATCHED THEN
544: UPDATE SET

Line 561: jty_changed_terrs_s.nextval

557: ,A.PROCESS_ATTR_VALUES_FLAG
558: ,A.MATCHING_SQL_FLAG
559: ,A.HIER_PROCESSING_FLAG)
560: VALUES (
561: jty_changed_terrs_s.nextval
562: ,0
563: ,S.terr_id
564: ,'DELETE'
565: ,'N'

Line 650: FROM jty_changed_terrs

646: SELECT change_type,
647: process_attr_values_flag
648: INTO l_change_type,
649: l_process_attr_values_flag
650: FROM jty_changed_terrs
651: WHERE terr_id = l_terr_id
652: AND star_request_id IS NULL;
653:
654: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN

Line 655: UPDATE jty_changed_terrs

651: WHERE terr_id = l_terr_id
652: AND star_request_id IS NULL;
653:
654: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN
655: UPDATE jty_changed_terrs
656: SET process_attr_values_flag = 'I'
657: WHERE terr_id = l_terr_id
658: AND star_request_id IS NULL;
659: END IF;

Line 662: INSERT INTO jty_changed_terrs (

658: AND star_request_id IS NULL;
659: END IF;
660: EXCEPTION
661: WHEN NO_DATA_FOUND THEN
662: INSERT INTO jty_changed_terrs (
663: CHANGED_TERRITORY_ID
664: ,OBJECT_VERSION_NUMBER
665: ,TERR_ID
666: ,SOURCE_ID

Line 673: jty_changed_terrs_s.nextval

669: ,PROCESS_ATTR_VALUES_FLAG
670: ,MATCHING_SQL_FLAG
671: ,HIER_PROCESSING_FLAG)
672: VALUES (
673: jty_changed_terrs_s.nextval
674: ,0
675: ,l_terr_id
676: ,l_source_id
677: ,'UPDATE'

Line 762: FROM jty_changed_terrs

758: END;
759:
760: SELECT count(*)
761: INTO l_no_of_records
762: FROM jty_changed_terrs
763: WHERE terr_id = p_terr_id
764: AND tap_request_id IS NULL;
765:
766: IF (l_no_of_records = 0) THEN

Line 767: INSERT INTO jty_changed_terrs (

763: WHERE terr_id = p_terr_id
764: AND tap_request_id IS NULL;
765:
766: IF (l_no_of_records = 0) THEN
767: INSERT INTO jty_changed_terrs (
768: CHANGED_TERRITORY_ID
769: ,OBJECT_VERSION_NUMBER
770: ,TERR_ID
771: ,SOURCE_ID

Line 778: jty_changed_terrs_s.nextval

774: ,PROCESS_ATTR_VALUES_FLAG
775: ,MATCHING_SQL_FLAG
776: ,HIER_PROCESSING_FLAG)
777: VALUES (
778: jty_changed_terrs_s.nextval
779: ,0
780: ,p_terr_id
781: ,l_source_id
782: ,'UPDATE'

Line 853: FROM jty_changed_terrs

849: SELECT change_type,
850: process_attr_values_flag
851: INTO l_change_type,
852: l_process_attr_values_flag
853: FROM jty_changed_terrs
854: WHERE terr_id = p_terr_id
855: AND star_request_id IS NULL;
856:
857: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN

Line 858: UPDATE jty_changed_terrs

854: WHERE terr_id = p_terr_id
855: AND star_request_id IS NULL;
856:
857: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN
858: UPDATE jty_changed_terrs
859: SET process_attr_values_flag = 'I',
860: matching_sql_flag = 'Y'
861: WHERE terr_id = p_terr_id
862: AND star_request_id IS NULL;

Line 866: INSERT INTO jty_changed_terrs (

862: AND star_request_id IS NULL;
863: END IF;
864: EXCEPTION
865: WHEN NO_DATA_FOUND THEN
866: INSERT INTO jty_changed_terrs (
867: CHANGED_TERRITORY_ID
868: ,OBJECT_VERSION_NUMBER
869: ,TERR_ID
870: ,SOURCE_ID

Line 877: jty_changed_terrs_s.nextval

873: ,PROCESS_ATTR_VALUES_FLAG
874: ,MATCHING_SQL_FLAG
875: ,HIER_PROCESSING_FLAG)
876: VALUES (
877: jty_changed_terrs_s.nextval
878: ,0
879: ,p_terr_id
880: ,l_source_id
881: ,'UPDATE'

Line 978: FROM jty_changed_terrs

974: END;
975:
976: SELECT count(*)
977: INTO l_no_of_records
978: FROM jty_changed_terrs
979: WHERE terr_id = l_terr_id
980: AND tap_request_id IS NULL;
981:
982: IF (l_no_of_records = 0) THEN

Line 983: INSERT INTO jty_changed_terrs (

979: WHERE terr_id = l_terr_id
980: AND tap_request_id IS NULL;
981:
982: IF (l_no_of_records = 0) THEN
983: INSERT INTO jty_changed_terrs (
984: CHANGED_TERRITORY_ID
985: ,OBJECT_VERSION_NUMBER
986: ,TERR_ID
987: ,SOURCE_ID

Line 994: jty_changed_terrs_s.nextval

990: ,PROCESS_ATTR_VALUES_FLAG
991: ,MATCHING_SQL_FLAG
992: ,HIER_PROCESSING_FLAG)
993: VALUES (
994: jty_changed_terrs_s.nextval
995: ,0
996: ,l_terr_id
997: ,l_source_id
998: ,'UPDATE'

Line 1065: FROM jty_changed_terrs

1061: SELECT change_type,
1062: matching_sql_flag
1063: INTO l_change_type,
1064: l_matching_sql_flag
1065: FROM jty_changed_terrs
1066: WHERE terr_id = p_terr_id
1067: AND star_request_id IS NULL;
1068:
1069: IF ((l_change_type = 'UPDATE') AND (l_matching_sql_flag <> 'Y')) THEN

Line 1070: UPDATE jty_changed_terrs

1066: WHERE terr_id = p_terr_id
1067: AND star_request_id IS NULL;
1068:
1069: IF ((l_change_type = 'UPDATE') AND (l_matching_sql_flag <> 'Y')) THEN
1070: UPDATE jty_changed_terrs
1071: SET matching_sql_flag = 'Y'
1072: WHERE terr_id = p_terr_id
1073: AND star_request_id IS NULL;
1074: END IF;

Line 1077: INSERT INTO jty_changed_terrs (

1073: AND star_request_id IS NULL;
1074: END IF;
1075: EXCEPTION
1076: WHEN NO_DATA_FOUND THEN
1077: INSERT INTO jty_changed_terrs (
1078: CHANGED_TERRITORY_ID
1079: ,OBJECT_VERSION_NUMBER
1080: ,TERR_ID
1081: ,SOURCE_ID

Line 1088: jty_changed_terrs_s.nextval

1084: ,PROCESS_ATTR_VALUES_FLAG
1085: ,MATCHING_SQL_FLAG
1086: ,HIER_PROCESSING_FLAG)
1087: VALUES (
1088: jty_changed_terrs_s.nextval
1089: ,0
1090: ,p_terr_id
1091: ,l_source_id
1092: ,'UPDATE'

Line 1161: MERGE INTO jty_changed_terrs A

1157: triggering_mode IN VARCHAR2)
1158: IS
1159: BEGIN
1160: IF (triggering_mode = 'ON-INSERT') THEN
1161: MERGE INTO jty_changed_terrs A
1162: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1163: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1164: WHEN MATCHED THEN
1165: UPDATE SET

Line 1179: jty_changed_terrs_s.nextval

1175: ,A.PROCESS_ATTR_VALUES_FLAG
1176: ,A.MATCHING_SQL_FLAG
1177: ,A.HIER_PROCESSING_FLAG)
1178: VALUES (
1179: jty_changed_terrs_s.nextval
1180: ,0
1181: ,S.terr_id
1182: ,S.source_id
1183: ,'CREATE'

Line 1217: MERGE INTO jty_changed_terrs A

1213: ,'I'
1214: ,'Y'
1215: ,'I');
1216: ELSIF (triggering_mode = 'ON-DELETE') THEN
1217: MERGE INTO jty_changed_terrs A
1218: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1219: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1220: WHEN MATCHED THEN
1221: UPDATE SET

Line 1235: jty_changed_terrs_s.nextval

1231: ,A.PROCESS_ATTR_VALUES_FLAG
1232: ,A.MATCHING_SQL_FLAG
1233: ,A.HIER_PROCESSING_FLAG)
1234: VALUES (
1235: jty_changed_terrs_s.nextval
1236: ,0
1237: ,S.terr_id
1238: ,S.source_id
1239: ,'DELETE'