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.WSH_REGIONS_PKG dependencies on WSH_REGIONS_GLOBAL_DATA

Line 4036: delete from wsh_regions_global_data;

4032:
4033: x_regions_processed := l_regions_processed;
4034:
4035: -- Truncating records from Global Temp Tables
4036: delete from wsh_regions_global_data;
4037: delete from wsh_regions_global;
4038: COMMIT;
4039: EXCEPTION
4040: WHEN OTHERS THEN

Line 4650: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and

4646: --
4647: -- PROCEDURE : Init_Global_Table
4648: --
4649: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
4650: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
4651: -- Wsh_Regions_Tl based on parameter p_populate_type.
4652: --
4653:
4654: PROCEDURE Init_Global_Table (

Line 4726: DELETE FROM WSH_REGIONS_GLOBAL_DATA;

4722: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4723: t1 := dbms_utility.get_time;
4724:
4725: IF ( p_country_flag = 'Y' ) THEN -- { Region type 0 i.e., Country
4726: DELETE FROM WSH_REGIONS_GLOBAL_DATA;
4727:
4728: --
4729: -- Debug Statements
4730: --

Line 4732: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);

4728: --
4729: -- Debug Statements
4730: --
4731: IF l_debug_on THEN
4732: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4733: END IF;
4734: --
4735:
4736: INSERT INTO wsh_regions_global_data

Line 4736: INSERT INTO wsh_regions_global_data

4732: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4733: END IF;
4734: --
4735:
4736: INSERT INTO wsh_regions_global_data
4737: ( REGION_ID,
4738: REGION_TYPE,
4739: PARENT_REGION_ID,
4740: COUNTRY,

Line 4772: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);

4768: --
4769: -- Debug Statements
4770: --
4771: IF l_debug_on THEN
4772: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
4773: END IF;
4774: --
4775:
4776: DELETE FROM WSH_REGIONS_GLOBAL;

Line 4848: DELETE FROM WSH_REGIONS_GLOBAL_DATA

4844: END IF;
4845: END LOOP;
4846: END IF;
4847:
4848: DELETE FROM WSH_REGIONS_GLOBAL_DATA
4849: WHERE REGION_TYPE in ( 1, 2, 3 );
4850:
4851: --
4852: -- Debug Statements

Line 4855: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);

4851: --
4852: -- Debug Statements
4853: --
4854: IF l_debug_on THEN
4855: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4856: END IF;
4857: --
4858:
4859: INSERT INTO wsh_regions_global_data

Line 4859: INSERT INTO wsh_regions_global_data

4855: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4856: END IF;
4857: --
4858:
4859: INSERT INTO wsh_regions_global_data
4860: ( REGION_ID,
4861: REGION_TYPE,
4862: PARENT_REGION_ID,
4863: COUNTRY,

Line 4903: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);

4899: --
4900: -- Debug Statements
4901: --
4902: IF l_debug_on THEN
4903: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
4904: END IF;
4905: --
4906:
4907: DELETE FROM WSH_REGIONS_GLOBAL

Line 4948: DELETE FROM WSH_REGIONS_GLOBAL_DATA

4944: END IF; -- } Region type 1 i.e., State
4945:
4946: IF ( p_city_flag = 'Y' ) THEN -- { Region type 2,3 i.e., City, Postal Codes
4947:
4948: DELETE FROM WSH_REGIONS_GLOBAL_DATA
4949: WHERE REGION_TYPE in ( 2, 3 );
4950:
4951: --
4952: -- Debug Statements

Line 4955: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);

4951: --
4952: -- Debug Statements
4953: --
4954: IF l_debug_on THEN
4955: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4956: END IF;
4957: --
4958:
4959: INSERT INTO wsh_regions_global_data

Line 4959: INSERT INTO wsh_regions_global_data

4955: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4956: END IF;
4957: --
4958:
4959: INSERT INTO wsh_regions_global_data
4960: ( REGION_ID,
4961: REGION_TYPE,
4962: PARENT_REGION_ID,
4963: COUNTRY,

Line 5038: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);

5034: --
5035: -- Debug Statements
5036: --
5037: IF l_debug_on THEN
5038: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
5039: END IF;
5040: --
5041:
5042: DELETE FROM WSH_REGIONS_GLOBAL

Line 5103: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

5099: --
5100: -- PROCEDURE : Insert_Global_Table
5101: --
5102: -- PURPOSE : Inserts the data in Global Temp tables
5103: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
5104:
5105: PROCEDURE Insert_Global_Table (
5106: p_country IN VARCHAR2,
5107: p_state IN VARCHAR2,

Line 5181: INSERT INTO wsh_regions_global_data

5177: ELSE
5178: l_parent_region_id := p_parent_region_id;
5179: END IF;
5180:
5181: INSERT INTO wsh_regions_global_data
5182: ( REGION_ID,
5183: REGION_TYPE,
5184: PARENT_REGION_ID,
5185: COUNTRY,

Line 5212: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);

5208: --
5209: -- Debug Statements
5210: --
5211: IF l_debug_on THEN
5212: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
5213: END IF;
5214: --
5215:
5216: IF ( p_tl_only_flag <> 'Y' AND

Line 5261: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

5257: --
5258: -- PROCEDURE : Update_Global_Table
5259: --
5260: -- PURPOSE : Updates the data in Global Temp tables
5261: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
5262:
5263: PROCEDURE Update_Global_Table (
5264: p_country IN VARCHAR2,
5265: p_state IN VARCHAR2,

Line 5280: FROM wsh_regions_global_data

5276: AS
5277:
5278: CURSOR child_regions IS
5279: SELECT region_id, region_type, parent_region_id
5280: FROM wsh_regions_global_data
5281: START WITH region_id = p_region_id
5282: CONNECT BY PRIOR region_id = parent_region_id;
5283:
5284: CURSOR get_state_code(l_region_id NUMBER) IS

Line 5382: UPDATE wsh_regions_global_data

5378: l_region_ins_cnt := l_region_ins_cnt + sql%rowcount;
5379: END IF;
5380: END IF;
5381:
5382: UPDATE wsh_regions_global_data
5383: SET country = nvl(UPPER(p_country), country),
5384: state = nvl(UPPER(p_state), state),
5385: city = nvl(UPPER(p_city), city),
5386: country_code = nvl(UPPER(p_country_code), country_code),

Line 5405: INSERT INTO wsh_regions_global_data

5401: l_region_data_upd_cnt := l_region_data_upd_cnt + sql%rowcount;
5402:
5403: IF ( sql%rowcount = 0 )
5404: THEN
5405: INSERT INTO wsh_regions_global_data
5406: ( REGION_ID,
5407: REGION_TYPE,
5408: PARENT_REGION_ID,
5409: COUNTRY,

Line 5448: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global_data', l_region_data_upd_cnt);

5444: --
5445: IF l_debug_on THEN
5446: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global', l_region_upd_cnt);
5447: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', l_region_ins_cnt);
5448: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global_data', l_region_data_upd_cnt);
5449: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', l_region_data_ins_cnt);
5450: END IF;
5451: --
5452:

Line 5449: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', l_region_data_ins_cnt);

5445: IF l_debug_on THEN
5446: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global', l_region_upd_cnt);
5447: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', l_region_ins_cnt);
5448: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global_data', l_region_data_upd_cnt);
5449: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', l_region_data_ins_cnt);
5450: END IF;
5451: --
5452:
5453: --