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.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TERR_VALUES_ALL

Line 851: INSERT INTO jtf_terr_values_all

847:
848:
849:
850: /* Insert a new row in terr_values_all table , using the geo_terr_value_id "n"*/
851: INSERT INTO jtf_terr_values_all
852: (
853: TERR_VALUE_ID
854: ,LAST_UPDATED_BY
855: ,LAST_UPDATE_DATE

Line 889: DELETE FROM jtf_terr_values_all

885: delete it and then insert it
886: */
887: BEGIN
888: --dbms_output.put_line(' before deletin terr_value_id ');
889: DELETE FROM jtf_terr_values_all
890: WHERE SELF_SERVICE_TERR_VALUE_ID = to_number(p_geo_terr_value_id);
891: --dbms_output.put_line(' After deletin terr_value_id and before insertin');
892: --dbms_output.put_line(' After inserting terr_value_id ');
893:

Line 901: INSERT INTO jtf_terr_values_all

897: WHEN OTHERS THEN
898: RAISE;
899: END;
900:
901: INSERT INTO jtf_terr_values_all
902: (
903: TERR_VALUE_ID
904: ,LAST_UPDATED_BY
905: ,LAST_UPDATE_DATE