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.HR_FULL_SYNC_MESSAGES dependencies on FND_TERRITORIES_VL

Line 153: p_cntry_code fnd_territories_vl.territory_code%type;

149: PROCEDURE HR_STATE_FULL_SYNC(errbuf OUT NOCOPY VARCHAR2
150: ,retcode OUT NOCOPY VARCHAR2)
151: is
152:
153: p_cntry_code fnd_territories_vl.territory_code%type;
154: p_state_code fnd_common_lookups.lookup_code%type;
155: p_state_desc fnd_common_lookups.meaning%type;
156: p_enabled_flag fnd_common_lookups.enabled_flag%type;
157: p_effective_date date default sysdate;

Line 163: from fnd_common_lookups fcl,fnd_territories_vl ft

159:
160:
161: cursor fet_state_sync is
162: select ft.territory_code,fcl.lookup_code,fcl.meaning,fcl.enabled_flag
163: from fnd_common_lookups fcl,fnd_territories_vl ft
164: where fcl.lookup_type = (ft.territory_code ||'_STATE')
165: order by ft.territory_code;
166:
167: cursor fet_psft_sync is

Line 224: p_cntry_code fnd_territories_vl.territory_code%type;

220: PROCEDURE HR_COUNTRY_FULL_SYNC(errbuf OUT NOCOPY VARCHAR2
221: ,retcode OUT NOCOPY VARCHAR2)
222: is
223:
224: p_cntry_code fnd_territories_vl.territory_code%type;
225: p_cntry_desc fnd_territories_vl.territory_short_name%type;
226: p_obsolete_flag fnd_territories_vl.obsolete_flag%type;
227: p_effective_date date default sysdate;
228:

Line 225: p_cntry_desc fnd_territories_vl.territory_short_name%type;

221: ,retcode OUT NOCOPY VARCHAR2)
222: is
223:
224: p_cntry_code fnd_territories_vl.territory_code%type;
225: p_cntry_desc fnd_territories_vl.territory_short_name%type;
226: p_obsolete_flag fnd_territories_vl.obsolete_flag%type;
227: p_effective_date date default sysdate;
228:
229: cursor fet_cntry_fsync is

Line 226: p_obsolete_flag fnd_territories_vl.obsolete_flag%type;

222: is
223:
224: p_cntry_code fnd_territories_vl.territory_code%type;
225: p_cntry_desc fnd_territories_vl.territory_short_name%type;
226: p_obsolete_flag fnd_territories_vl.obsolete_flag%type;
227: p_effective_date date default sysdate;
228:
229: cursor fet_cntry_fsync is
230: select ft.territory_code,

Line 233: from fnd_territories_vl ft

229: cursor fet_cntry_fsync is
230: select ft.territory_code,
231: ft.territory_short_name ,
232: ft.territory_code,ft.obsolete_flag
233: from fnd_territories_vl ft
234: order by ft.territory_code;
235:
236: cursor fet_psft_sync is
237: select count('x')