APPS.JTY_TERR_TRIGGER_HANDLERS dependencies on JTF_TERR_USGS_ALL

Line 79: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S

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
83: A.rank_calc_flag = 'Y'

Line 120: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S

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
124: A.HIER_PROCESSING_FLAG = 'I'

Line 152: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S

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
156: A.rank_calc_flag = 'Y'

Line 188: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S

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
192: A.rank_calc_flag = 'Y'

Line 223: USING ( SELECT terr_id, source_id from jtf_terr_usgs_all where terr_id = p_terr_id ) S

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
227: A.rank_calc_flag = 'N'

Line 324: FROM jtf_terr_usgs_all

320:
321: BEGIN
322: SELECT source_id
323: INTO l_source_id
324: FROM jtf_terr_usgs_all
325: WHERE terr_id = l_terr_id;
326: EXCEPTION
327: WHEN OTHERS then
328: NULL;

Line 395: FROM jtf_terr_usgs_all

391:
392: BEGIN
393: SELECT source_id
394: INTO l_source_id
395: FROM jtf_terr_usgs_all
396: WHERE terr_id = p_terr_id;
397: EXCEPTION
398: WHEN OTHERS then
399: NULL;

Line 453: FROM jtf_terr_usgs_all

449:
450: BEGIN
451: SELECT source_id
452: INTO l_source_id
453: FROM jtf_terr_usgs_all
454: WHERE terr_id = p_terr_id;
455: EXCEPTION
456: WHEN OTHERS then
457: NULL;

Line 537: FROM jtf_terr_usgs_all

533:
534: BEGIN
535: SELECT source_id
536: INTO l_source_id
537: FROM jtf_terr_usgs_all
538: WHERE terr_id = l_terr_id;
539: EXCEPTION
540: WHEN OTHERS then
541: NULL;

Line 591: FROM jtf_terr_usgs_all

587:
588: BEGIN
589: SELECT source_id
590: INTO l_source_id
591: FROM jtf_terr_usgs_all
592: WHERE terr_id = p_terr_id;
593: EXCEPTION
594: WHEN OTHERS then
595: NULL;