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_DEA_TERRS

Line 65: INSERT INTO jty_changed_dea_terrs (

61: ,'I'
62: ,decode(n_named_acct_flag, 'Y', 'N', 'Y')
63: ,'I');
64:
65: INSERT INTO jty_changed_dea_terrs (
66: CHANGED_TERRITORY_ID
67: ,OBJECT_VERSION_NUMBER
68: ,TERR_ID
69: ,CHANGE_TYPE

Line 75: jty_changed_dea_terrs_s.nextval

71: ,PROCESS_ATTR_VALUES_FLAG
72: ,MATCHING_SQL_FLAG
73: ,HIER_PROCESSING_FLAG)
74: VALUES (
75: jty_changed_dea_terrs_s.nextval
76: ,0
77: ,p_terr_id
78: ,'CREATE'
79: ,'Y'

Line 128: FROM jty_changed_dea_terrs

124: END IF; /* end IF (l_no_of_records = 0) */
125:
126: SELECT count(*)
127: INTO l_no_of_records
128: FROM jty_changed_dea_terrs
129: WHERE terr_id = p_terr_id
130: AND change_type = 'CREATE'
131: AND star_request_id IS NULL;
132:

Line 134: MERGE INTO jty_changed_dea_terrs A

130: AND change_type = 'CREATE'
131: AND star_request_id IS NULL;
132:
133: IF (l_no_of_records = 0) THEN
134: MERGE INTO jty_changed_dea_terrs A
135: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
136: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
137: WHEN MATCHED THEN
138: UPDATE SET

Line 152: jty_changed_dea_terrs_s.nextval

148: ,A.PROCESS_ATTR_VALUES_FLAG
149: ,A.MATCHING_SQL_FLAG
150: ,A.HIER_PROCESSING_FLAG)
151: VALUES (
152: jty_changed_dea_terrs_s.nextval
153: ,0
154: ,S.terr_id
155: ,S.source_id
156: ,'UPDATE'

Line 206: FROM jty_changed_dea_terrs

202: END IF; /* end IF (l_no_of_records = 0) */
203:
204: SELECT count(*)
205: INTO l_no_of_records
206: FROM jty_changed_dea_terrs
207: WHERE terr_id = p_terr_id
208: AND change_type = 'CREATE'
209: AND star_request_id IS NULL;
210:

Line 212: MERGE INTO jty_changed_dea_terrs A

208: AND change_type = 'CREATE'
209: AND star_request_id IS NULL;
210:
211: IF (l_no_of_records = 0) THEN
212: MERGE INTO jty_changed_dea_terrs A
213: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
214: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
215: WHEN MATCHED THEN
216: UPDATE SET

Line 230: jty_changed_dea_terrs_s.nextval

226: ,A.PROCESS_ATTR_VALUES_FLAG
227: ,A.MATCHING_SQL_FLAG
228: ,A.HIER_PROCESSING_FLAG)
229: VALUES (
230: jty_changed_dea_terrs_s.nextval
231: ,0
232: ,S.terr_id
233: ,S.source_id
234: ,'UPDATE'

Line 275: MERGE INTO jty_changed_dea_terrs A

271: ,'I'
272: ,'Y'
273: ,'I');
274:
275: MERGE INTO jty_changed_dea_terrs A
276: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
277: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
278: WHEN MATCHED THEN
279: UPDATE SET

Line 296: jty_changed_dea_terrs_s.nextval

292: ,A.PROCESS_ATTR_VALUES_FLAG
293: ,A.MATCHING_SQL_FLAG
294: ,A.HIER_PROCESSING_FLAG)
295: VALUES (
296: jty_changed_dea_terrs_s.nextval
297: ,0
298: ,S.terr_id
299: ,S.source_id
300: ,'UPDATE'

Line 343: MERGE INTO jty_changed_dea_terrs A

339: ,'Y'
340: ,'I');
341:
342: /* future or inactive territory has become active as a result of the change */
343: MERGE INTO jty_changed_dea_terrs A
344: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
345: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
346: WHEN MATCHED THEN
347: UPDATE SET

Line 364: jty_changed_dea_terrs_s.nextval

360: ,A.PROCESS_ATTR_VALUES_FLAG
361: ,A.MATCHING_SQL_FLAG
362: ,A.HIER_PROCESSING_FLAG)
363: VALUES (
364: jty_changed_dea_terrs_s.nextval
365: ,0
366: ,S.terr_id
367: ,S.source_id
368: ,'UPDATE'

Line 410: MERGE INTO jty_changed_dea_terrs A

406: ,'Y'
407: ,'D');
408:
409: /* active territory has become future or inactive as a resukt of the change */
410: MERGE INTO jty_changed_dea_terrs A
411: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
412: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
413: WHEN MATCHED THEN
414: UPDATE SET

Line 431: jty_changed_dea_terrs_s.nextval

427: ,A.PROCESS_ATTR_VALUES_FLAG
428: ,A.MATCHING_SQL_FLAG
429: ,A.HIER_PROCESSING_FLAG)
430: VALUES (
431: jty_changed_dea_terrs_s.nextval
432: ,0
433: ,S.terr_id
434: ,S.source_id
435: ,'UPDATE'

Line 474: MERGE INTO jty_changed_dea_terrs A

470: ,'Y'
471: ,'I');
472:
473: /* active territory has become future or inactive as a resukt of the change */
474: MERGE INTO jty_changed_dea_terrs A
475: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
476: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
477: WHEN MATCHED THEN
478: UPDATE SET

Line 495: jty_changed_dea_terrs_s.nextval

491: ,A.PROCESS_ATTR_VALUES_FLAG
492: ,A.MATCHING_SQL_FLAG
493: ,A.HIER_PROCESSING_FLAG)
494: VALUES (
495: jty_changed_dea_terrs_s.nextval
496: ,0
497: ,S.terr_id
498: ,S.source_id
499: ,'UPDATE'

Line 506: MERGE INTO jty_changed_dea_terrs A

502: ,'Y'
503: ,'I');
504: ELSIF ((n_end_date_active >= sysdate and n_start_date_active <> o_start_date_active)) THEN
505: /* active territory has become future or inactive as a resukt of the change */
506: MERGE INTO jty_changed_dea_terrs A
507: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S
508: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
509: WHEN MATCHED THEN
510: UPDATE SET

Line 527: jty_changed_dea_terrs_s.nextval

523: ,A.PROCESS_ATTR_VALUES_FLAG
524: ,A.MATCHING_SQL_FLAG
525: ,A.HIER_PROCESSING_FLAG)
526: VALUES (
527: jty_changed_dea_terrs_s.nextval
528: ,0
529: ,S.terr_id
530: ,S.source_id
531: ,'UPDATE'

Line 570: MERGE INTO jty_changed_dea_terrs A

566: ,'D'
567: ,decode(o_named_acct_flag, 'Y', 'N', 'Y')
568: ,'D');
569:
570: MERGE INTO jty_changed_dea_terrs A
571: USING ( SELECT p_terr_id terr_id from dual ) S
572: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
573: WHEN MATCHED THEN
574: UPDATE SET

Line 591: jty_changed_dea_terrs_s.nextval

587: ,A.PROCESS_ATTR_VALUES_FLAG
588: ,A.MATCHING_SQL_FLAG
589: ,A.HIER_PROCESSING_FLAG)
590: VALUES (
591: jty_changed_dea_terrs_s.nextval
592: ,0
593: ,S.terr_id
594: ,'DELETE'
595: ,'N'

Line 693: FROM jty_changed_dea_terrs

689: SELECT change_type,
690: process_attr_values_flag
691: INTO l_change_type,
692: l_process_attr_values_flag
693: FROM jty_changed_dea_terrs
694: WHERE terr_id = l_terr_id
695: AND star_request_id IS NULL;
696:
697: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN

Line 698: UPDATE jty_changed_dea_terrs

694: WHERE terr_id = l_terr_id
695: AND star_request_id IS NULL;
696:
697: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN
698: UPDATE jty_changed_dea_terrs
699: SET process_attr_values_flag = 'I'
700: WHERE terr_id = l_terr_id
701: AND star_request_id IS NULL;
702: END IF;

Line 705: INSERT INTO jty_changed_dea_terrs (

701: AND star_request_id IS NULL;
702: END IF;
703: EXCEPTION
704: WHEN NO_DATA_FOUND THEN
705: INSERT INTO jty_changed_dea_terrs (
706: CHANGED_TERRITORY_ID
707: ,OBJECT_VERSION_NUMBER
708: ,TERR_ID
709: ,SOURCE_ID

Line 716: jty_changed_dea_terrs_s.nextval

712: ,PROCESS_ATTR_VALUES_FLAG
713: ,MATCHING_SQL_FLAG
714: ,HIER_PROCESSING_FLAG)
715: VALUES (
716: jty_changed_dea_terrs_s.nextval
717: ,0
718: ,l_terr_id
719: ,l_source_id
720: ,'UPDATE'

Line 791: FROM jty_changed_dea_terrs

787: END IF;
788:
789: SELECT count(*)
790: INTO l_no_of_records
791: FROM jty_changed_dea_terrs
792: WHERE terr_id = p_terr_id
793: AND tap_request_id IS NULL;
794:
795: IF (l_no_of_records = 0) THEN

Line 796: INSERT INTO jty_changed_dea_terrs (

792: WHERE terr_id = p_terr_id
793: AND tap_request_id IS NULL;
794:
795: IF (l_no_of_records = 0) THEN
796: INSERT INTO jty_changed_dea_terrs (
797: CHANGED_TERRITORY_ID
798: ,OBJECT_VERSION_NUMBER
799: ,TERR_ID
800: ,SOURCE_ID

Line 807: jty_changed_dea_terrs_s.nextval

803: ,PROCESS_ATTR_VALUES_FLAG
804: ,MATCHING_SQL_FLAG
805: ,HIER_PROCESSING_FLAG)
806: VALUES (
807: jty_changed_dea_terrs_s.nextval
808: ,0
809: ,p_terr_id
810: ,l_source_id
811: ,'UPDATE'

Line 897: FROM jty_changed_dea_terrs

893: SELECT change_type,
894: process_attr_values_flag
895: INTO l_change_type,
896: l_process_attr_values_flag
897: FROM jty_changed_dea_terrs
898: WHERE terr_id = p_terr_id
899: AND star_request_id IS NULL;
900:
901: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN

Line 902: UPDATE jty_changed_dea_terrs

898: WHERE terr_id = p_terr_id
899: AND star_request_id IS NULL;
900:
901: IF ((l_change_type = 'UPDATE') AND (l_process_attr_values_flag <> 'I')) THEN
902: UPDATE jty_changed_dea_terrs
903: SET process_attr_values_flag = 'I',
904: matching_sql_flag = 'Y'
905: WHERE terr_id = p_terr_id
906: AND star_request_id IS NULL;

Line 910: INSERT INTO jty_changed_dea_terrs (

906: AND star_request_id IS NULL;
907: END IF;
908: EXCEPTION
909: WHEN NO_DATA_FOUND THEN
910: INSERT INTO jty_changed_dea_terrs (
911: CHANGED_TERRITORY_ID
912: ,OBJECT_VERSION_NUMBER
913: ,TERR_ID
914: ,SOURCE_ID

Line 921: jty_changed_dea_terrs_s.nextval

917: ,PROCESS_ATTR_VALUES_FLAG
918: ,MATCHING_SQL_FLAG
919: ,HIER_PROCESSING_FLAG)
920: VALUES (
921: jty_changed_dea_terrs_s.nextval
922: ,0
923: ,p_terr_id
924: ,l_source_id
925: ,'UPDATE'

Line 1007: FROM jty_changed_dea_terrs

1003: END IF;
1004:
1005: SELECT count(*)
1006: INTO l_no_of_records
1007: FROM jty_changed_dea_terrs
1008: WHERE terr_id = l_terr_id
1009: AND tap_request_id IS NULL;
1010:
1011: IF (l_no_of_records = 0) THEN

Line 1012: INSERT INTO jty_changed_dea_terrs (

1008: WHERE terr_id = l_terr_id
1009: AND tap_request_id IS NULL;
1010:
1011: IF (l_no_of_records = 0) THEN
1012: INSERT INTO jty_changed_dea_terrs (
1013: CHANGED_TERRITORY_ID
1014: ,OBJECT_VERSION_NUMBER
1015: ,TERR_ID
1016: ,SOURCE_ID

Line 1023: jty_changed_dea_terrs_s.nextval

1019: ,PROCESS_ATTR_VALUES_FLAG
1020: ,MATCHING_SQL_FLAG
1021: ,HIER_PROCESSING_FLAG)
1022: VALUES (
1023: jty_changed_dea_terrs_s.nextval
1024: ,0
1025: ,l_terr_id
1026: ,l_source_id
1027: ,'UPDATE'

Line 1108: FROM jty_changed_dea_terrs

1104: SELECT change_type,
1105: matching_sql_flag
1106: INTO l_change_type,
1107: l_matching_sql_flag
1108: FROM jty_changed_dea_terrs
1109: WHERE terr_id = p_terr_id
1110: AND star_request_id IS NULL;
1111:
1112: IF ((l_change_type = 'UPDATE') AND (l_matching_sql_flag <> 'Y')) THEN

Line 1113: UPDATE jty_changed_dea_terrs

1109: WHERE terr_id = p_terr_id
1110: AND star_request_id IS NULL;
1111:
1112: IF ((l_change_type = 'UPDATE') AND (l_matching_sql_flag <> 'Y')) THEN
1113: UPDATE jty_changed_dea_terrs
1114: SET matching_sql_flag = 'Y'
1115: WHERE terr_id = p_terr_id
1116: AND star_request_id IS NULL;
1117: END IF;

Line 1120: INSERT INTO jty_changed_dea_terrs (

1116: AND star_request_id IS NULL;
1117: END IF;
1118: EXCEPTION
1119: WHEN NO_DATA_FOUND THEN
1120: INSERT INTO jty_changed_dea_terrs (
1121: CHANGED_TERRITORY_ID
1122: ,OBJECT_VERSION_NUMBER
1123: ,TERR_ID
1124: ,SOURCE_ID

Line 1131: jty_changed_dea_terrs_s.nextval

1127: ,PROCESS_ATTR_VALUES_FLAG
1128: ,MATCHING_SQL_FLAG
1129: ,HIER_PROCESSING_FLAG)
1130: VALUES (
1131: jty_changed_dea_terrs_s.nextval
1132: ,0
1133: ,p_terr_id
1134: ,l_source_id
1135: ,'UPDATE'

Line 1189: MERGE INTO jty_changed_dea_terrs A

1185: ,'I'
1186: ,'Y'
1187: ,'I');
1188:
1189: MERGE INTO jty_changed_dea_terrs A
1190: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1191: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1192: WHEN MATCHED THEN
1193: UPDATE SET

Line 1207: jty_changed_dea_terrs_s.nextval

1203: ,A.PROCESS_ATTR_VALUES_FLAG
1204: ,A.MATCHING_SQL_FLAG
1205: ,A.HIER_PROCESSING_FLAG)
1206: VALUES (
1207: jty_changed_dea_terrs_s.nextval
1208: ,0
1209: ,S.terr_id
1210: ,S.source_id
1211: ,'CREATE'

Line 1245: MERGE INTO jty_changed_dea_terrs A

1241: ,'D'
1242: ,'Y'
1243: ,'D');
1244:
1245: MERGE INTO jty_changed_dea_terrs A
1246: USING ( SELECT p_terr_id terr_id, p_source_id source_id from dual ) S
1247: ON ( A.terr_id = S.terr_id AND A.star_request_id IS NULL )
1248: WHEN MATCHED THEN
1249: UPDATE SET

Line 1263: jty_changed_dea_terrs_s.nextval

1259: ,A.PROCESS_ATTR_VALUES_FLAG
1260: ,A.MATCHING_SQL_FLAG
1261: ,A.HIER_PROCESSING_FLAG)
1262: VALUES (
1263: jty_changed_dea_terrs_s.nextval
1264: ,0
1265: ,S.terr_id
1266: ,S.source_id
1267: ,'DELETE'