APPS.JTF_TERR_TRIGGER_HANDLERS dependencies on JTF_TERR_USGS

Line 88: from jtf_terr_usgs

84: -- only add / modify records in jtf_changed_terr all
85: BEGIN
86: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_VAL) terr_id = ' || l_terr_id);
87: Select source_id into l_source_id
88: from jtf_terr_usgs
89: where terr_id = l_terr_id
90: and source_id = -1001;
91: EXCEPTION
92: When NO_DATA_FOUND then

Line 382: from jtf_terr_usgs

378: -- only add / modify records in jtf_changed_terr all
379: BEGIN
380: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_VAL) terr_id = ' || l_terr_id);
381: Select source_id into l_source_id
382: from jtf_terr_usgs
383: where terr_id = l_terr_id
384: and source_id = -1001;
385: EXCEPTION
386: When NO_DATA_FOUND then

Line 662: from jtf_terr_usgs

658: -- only add / modify records in jtf_changed_terr all
659: BEGIN
660: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_RSC) terr_id = ' || l_terr_id);
661: Select source_id into l_source_id
662: from jtf_terr_usgs
663: where terr_id = l_terr_id
664: and source_id = -1001;
665: EXCEPTION
666: When NO_DATA_FOUND then

Line 888: from jtf_terr_usgs

884: -- only add / modify records in jtf_changed_terr all
885: BEGIN
886: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_QTYPE) terr_id = ' || l_terr_id);
887: Select source_id into l_source_id
888: from jtf_terr_usgs
889: where terr_id = l_terr_id
890: and source_id = -1001;
891: EXCEPTION
892: When NO_DATA_FOUND then

Line 1100: from jtf_terr_usgs

1096: -- only add / modify records in jtf_changed_terr all
1097: BEGIN
1098: --dbms_output.put_line('JTF_TERR_TRIGGER_HANDLER: (TERR_RSC_ACCESS) terr_id = ' || l_terr_id);
1099: Select source_id into l_source_id
1100: from jtf_terr_usgs
1101: where terr_id = l_terr_id
1102: and source_id = -1001;
1103: EXCEPTION
1104: When NO_DATA_FOUND then