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_GEOSOURCE_PUB dependencies on JTF_TTY_GEOGRAPHIES

Line 80: FROM jtf_tty_geographies

76: elsif (p_geo_type = 'STATE') THEN
77: BEGIN
78: SELECT 'Y'
79: into p_parent_exists_flag
80: FROM jtf_tty_geographies
81: WHERE geo_type = 'COUNTRY'
82: AND geo_code = p_country_code
83: AND ROWNUM < 2;
84: EXCEPTION

Line 100: FROM jtf_tty_geographies

96: end if;
97: BEGIN
98: SELECT 'Y'
99: into p_exists_flag
100: FROM jtf_tty_geographies
101: WHERE geo_type = 'STATE'
102: AND country_code = p_country_code
103: AND state_code = p_state_code
104: AND ROWNUM < 2;

Line 122: FROM jtf_tty_geographies

118: elsif (p_geo_type = 'PROVINCE') THEN
119: BEGIN
120: SELECT 'Y'
121: into p_parent_exists_flag
122: FROM jtf_tty_geographies
123: WHERE geo_type = 'COUNTRY'
124: AND geo_code = p_country_code
125: AND ROWNUM < 2;
126: EXCEPTION

Line 142: FROM jtf_tty_geographies

138: end if;
139: BEGIN
140: SELECT 'Y'
141: into p_exists_flag
142: FROM jtf_tty_geographies
143: WHERE geo_type = 'PROVINCE'
144: AND country_code = p_country_code
145: AND province_code = p_province_code
146: AND ROWNUM < 2;

Line 165: FROM jtf_tty_geographies

161: BEGIN
162: IF (p_state_code is not NULL) THEN
163: SELECT 'Y'
164: into p_parent_exists_flag
165: FROM jtf_tty_geographies
166: WHERE geo_type = 'STATE'
167: AND country_code = p_country_code
168: AND state_code = p_state_code
169: AND ROWNUM < 2;

Line 173: FROM jtf_tty_geographies

169: AND ROWNUM < 2;
170: ELSE
171: SELECT 'Y'
172: into p_parent_exists_flag
173: FROM jtf_tty_geographies
174: WHERE geo_type = 'PROVINCE'
175: AND country_code = p_country_code
176: AND province_code = p_province_code
177: AND ROWNUM < 2;

Line 196: FROM jtf_tty_geographies

192: elsif (p_geo_type = 'CITY') THEN
193: BEGIN
194: SELECT 'Y'
195: into p_parent_exists_flag
196: FROM jtf_tty_geographies
197: WHERE ((geo_type = 'STATE' and (p_state_code is not null and p_county_code is null))
198: or
199: (geo_type = 'PROVINCE' and (p_province_code is not null and p_county_code is null))
200: or

Line 225: FROM jtf_tty_geographies

221: elsif (p_geo_type = 'POSTAL_CODE') THEN
222: BEGIN
223: SELECT 'Y'
224: into p_parent_exists_flag
225: FROM jtf_tty_geographies
226: WHERE (
227: (p_city_code is not null and geo_type = 'CITY')
228: OR
229: ((p_city_code is null and p_county_code is not null) and geo_type = 'COUNTY')

Line 260: INSERT INTO jtf_tty_geographies(

256: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
257: RAISE fnd_api.g_exc_error;
258: END IF;
259: -- Create the geography, validations done
260: INSERT INTO jtf_tty_geographies(
261: geo_id,
262: geo_name,
263: geo_type,
264: geo_code,

Line 277: jtf_tty_geographies_s.nextval,

273: creation_date,
274: last_updated_by,
275: last_update_date)
276: VALUES(
277: jtf_tty_geographies_s.nextval,
278: p_geo_name,
279: p_geo_type,
280: p_geo_code,
281: p_country_code,

Line 342: FROM jtf_tty_geographies

338: END IF;
339: BEGIN
340: SELECT 'Y'
341: into p_exists_flag
342: FROM jtf_tty_geographies
343: WHERE geo_id = p_geo_id;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: p_exists_flag := 'N';

Line 359: UPDATE jtf_tty_geographies

355: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
356: RAISE fnd_api.g_exc_error;
357: END IF;
358: -- passed all validations, now perform update operation
359: UPDATE jtf_tty_geographies
360: SET geo_name = p_geo_name,
361: last_updated_by = p_user_id,
362: last_update_date = p_date
363: WHERE geo_id = p_geo_id;

Line 413: FROM jtf_tty_geographies

409: p_date := sysdate;
410: BEGIN
411: SELECT 'Y'
412: INTO p_exists_flag
413: FROM jtf_tty_geographies
414: WHERE country_code = p_country_code
415: AND geo_code = p_geo_code
416: AND geo_type = p_geo_type
417: AND (p_state_code is null or state_code = p_state_code)

Line 461: FROM jtf_tty_geographies

457: if (p_delete_cascade_flag = 'N') THEN
458: BEGIN
459: SELECT 'Y'
460: into p_child_exists_flag
461: FROM jtf_tty_geographies
462: WHERE geo_type <> 'COUNTRY'
463: AND country_code = p_country_code
464: AND ROWNUM < 2;
465: EXCEPTION

Line 480: FROM jtf_tty_geographies

476: if (p_delete_cascade_flag = 'N') THEN
477: BEGIN
478: SELECT 'Y'
479: into p_child_exists_flag
480: FROM jtf_tty_geographies
481: WHERE (geo_type = 'COUNTY'
482: or geo_type = 'CITY'
483: or geo_type = 'POSTAL_CODE')
484: AND country_code = p_country_code

Line 502: FROM jtf_tty_geographies

498: if (p_delete_cascade_flag = 'N') THEN
499: BEGIN
500: SELECT 'Y'
501: into p_child_exists_flag
502: FROM jtf_tty_geographies
503: WHERE (geo_type = 'COUNTY'
504: or geo_type = 'CITY'
505: or geo_type = 'POSTAL_CODE')
506: AND country_code = p_country_code

Line 524: FROM jtf_tty_geographies

520: if (p_delete_cascade_flag = 'N') THEN
521: BEGIN
522: SELECT 'Y'
523: into p_child_exists_flag
524: FROM jtf_tty_geographies
525: WHERE (geo_type = 'CITY' or geo_type = 'POSTAL_CODE')
526: AND country_code = p_country_code
527: AND ((p_province_code is not null or province_code = p_province_code)
528: OR

Line 547: FROM jtf_tty_geographies

543: if (p_delete_cascade_flag = 'N') THEN
544: BEGIN
545: SELECT 'Y'
546: into p_child_exists_flag
547: FROM jtf_tty_geographies
548: WHERE geo_type = 'POSTAL_CODE'
549: AND country_code = p_country_code
550: AND ((p_province_code is not null or province_code = p_province_code)
551: OR

Line 575: DELETE from jtf_tty_geographies

571: END IF;
572: -- delete the geography, validations done
573: IF (p_geo_type = 'STATE') THEN
574: if (p_delete_cascade_flag = 'Y') THEN
575: DELETE from jtf_tty_geographies
576: WHERE state_code = p_geo_code
577: AND country_code = p_country_code;
578: else
579: DELETE from jtf_tty_geographies

Line 579: DELETE from jtf_tty_geographies

575: DELETE from jtf_tty_geographies
576: WHERE state_code = p_geo_code
577: AND country_code = p_country_code;
578: else
579: DELETE from jtf_tty_geographies
580: WHERE state_code = p_geo_code
581: AND geo_type = 'STATE'
582: AND country_code = p_country_code;
583: end if;