APPS.HR_DELTA_SYNC_MESSAGES dependencies on FND_TERRITORIES_VL

Line 83: p_cntry_code fnd_territories_vl.territory_code%type;

79: PROCEDURE hr_country_delta_sync(errbuf OUT NOCOPY VARCHAR2
80: ,retcode OUT NOCOPY VARCHAR2
81: ,p_party_site_id in NUMBER)
82: is
83: p_cntry_code fnd_territories_vl.territory_code%type;
84: p_cntry_desc fnd_territories_vl.territory_short_name%type;
85: p_obs_flag fnd_territories_vl.obsolete_flag%type;
86: p_effective_date date default sysdate;
87: l_params WF_PARAMETER_LIST_T;

Line 84: p_cntry_desc fnd_territories_vl.territory_short_name%type;

80: ,retcode OUT NOCOPY VARCHAR2
81: ,p_party_site_id in NUMBER)
82: is
83: p_cntry_code fnd_territories_vl.territory_code%type;
84: p_cntry_desc fnd_territories_vl.territory_short_name%type;
85: p_obs_flag fnd_territories_vl.obsolete_flag%type;
86: p_effective_date date default sysdate;
87: l_params WF_PARAMETER_LIST_T;
88: p_last_update_date date;

Line 85: p_obs_flag fnd_territories_vl.obsolete_flag%type;

81: ,p_party_site_id in NUMBER)
82: is
83: p_cntry_code fnd_territories_vl.territory_code%type;
84: p_cntry_desc fnd_territories_vl.territory_short_name%type;
85: p_obs_flag fnd_territories_vl.obsolete_flag%type;
86: p_effective_date date default sysdate;
87: l_params WF_PARAMETER_LIST_T;
88: p_last_update_date date;
89: p_unique_key number;

Line 99: from fnd_territories_vl ft

95: cursor fet_cntry_fsync(p_max_run_date date) is
96: select ft.territory_code,
97: ft.territory_short_name ,
98: ft.territory_code,ft.obsolete_flag,ft.row_id,ft.last_update_date
99: from fnd_territories_vl ft
100: where ft.last_update_date > p_max_run_date
101: and (ft.territory_code,ft.row_id) not in (select cntry.country_code,cntry.row_id
102: from hr_country_delta_sync cntry
103: where ft.territory_code = cntry.country_code

Line 128: from fnd_territories_vl ft

124: is
125: select ft.territory_code,
126: ft.territory_short_name ,
127: ft.territory_code,ft.obsolete_flag,ft.row_id,ft.last_update_date
128: from fnd_territories_vl ft
129: where territory_code = p_country_code
130: and row_id = p_row1_id;
131:
132: p_cntry_delta_sts varchar2(10);

Line 293: p_cntry_code fnd_territories_vl.territory_code%type;

289: ,retcode OUT NOCOPY VARCHAR2
290: ,p_party_site_id in NUMBER)
291: is
292:
293: p_cntry_code fnd_territories_vl.territory_code%type;
294: p_state_code fnd_common_lookups.lookup_code%type;
295: p_state_desc fnd_common_lookups.meaning%type;
296: p_enable_flag fnd_common_lookups.enabled_flag%type;
297: p_effective_date date default sysdate;

Line 324: from fnd_common_lookups fcl,fnd_territories_vl ft

320: where document_id = p_evn_key;
321:
322: cursor fet_state_sync(p_max_run_date date) is
323: select ft.territory_code,fcl.lookup_code,fcl.meaning,fcl.enabled_flag,fcl.last_update_date
324: from fnd_common_lookups fcl,fnd_territories_vl ft
325: where fcl.lookup_type = (ft.territory_code ||'_STATE')
326: and fcl.last_update_date > p_max_run_date
327: and (ft.territory_code ,fcl.lookup_code) not in (select state.country_code,state.state_code
328: from hr_state_delta_sync state

Line 347: from fnd_common_lookups fcl,fnd_territories_vl ft

343:
344: cursor fet_state_qsync(p_country_code varchar2,p_stt_code varchar2)
345: is
346: select ft.territory_code,fcl.lookup_code,fcl.meaning,fcl.enabled_flag,fcl.last_update_date
347: from fnd_common_lookups fcl,fnd_territories_vl ft
348: where fcl.lookup_type = (ft.territory_code ||'_STATE')
349: and fcl.lookup_type = (p_country_code||'_STATE')
350: and fcl.lookup_code = p_stt_code;
351: