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 4027: delete from wsh_regions_global_data;

4023:
4024: x_regions_processed := l_regions_processed;
4025:
4026: -- Truncating records from Global Temp Tables
4027: delete from wsh_regions_global_data;
4028: delete from wsh_regions_global;
4029: COMMIT;
4030: EXCEPTION
4031: WHEN OTHERS THEN

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

4619: --
4620: -- PROCEDURE : Init_Global_Table
4621: --
4622: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
4623: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
4624: -- Wsh_Regions_Tl based on parameter p_populate_type.
4625: --
4626:
4627: PROCEDURE Init_Global_Table (

Line 4699: DELETE FROM WSH_REGIONS_GLOBAL_DATA;

4695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4696: t1 := dbms_utility.get_time;
4697:
4698: IF ( p_country_flag = 'Y' ) THEN -- { Region type 0 i.e., Country
4699: DELETE FROM WSH_REGIONS_GLOBAL_DATA;
4700:
4701: --
4702: -- Debug Statements
4703: --

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

4701: --
4702: -- Debug Statements
4703: --
4704: IF l_debug_on THEN
4705: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4706: END IF;
4707: --
4708:
4709: INSERT INTO wsh_regions_global_data

Line 4709: INSERT INTO wsh_regions_global_data

4705: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4706: END IF;
4707: --
4708:
4709: INSERT INTO wsh_regions_global_data
4710: ( REGION_ID,
4711: REGION_TYPE,
4712: PARENT_REGION_ID,
4713: COUNTRY,

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

4741: --
4742: -- Debug Statements
4743: --
4744: IF l_debug_on THEN
4745: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
4746: END IF;
4747: --
4748:
4749: DELETE FROM WSH_REGIONS_GLOBAL;

Line 4821: DELETE FROM WSH_REGIONS_GLOBAL_DATA

4817: END IF;
4818: END LOOP;
4819: END IF;
4820:
4821: DELETE FROM WSH_REGIONS_GLOBAL_DATA
4822: WHERE REGION_TYPE in ( 1, 2, 3 );
4823:
4824: --
4825: -- Debug Statements

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

4824: --
4825: -- Debug Statements
4826: --
4827: IF l_debug_on THEN
4828: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4829: END IF;
4830: --
4831:
4832: INSERT INTO wsh_regions_global_data

Line 4832: INSERT INTO wsh_regions_global_data

4828: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4829: END IF;
4830: --
4831:
4832: INSERT INTO wsh_regions_global_data
4833: ( REGION_ID,
4834: REGION_TYPE,
4835: PARENT_REGION_ID,
4836: COUNTRY,

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

4872: --
4873: -- Debug Statements
4874: --
4875: IF l_debug_on THEN
4876: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
4877: END IF;
4878: --
4879:
4880: DELETE FROM WSH_REGIONS_GLOBAL

Line 4921: DELETE FROM WSH_REGIONS_GLOBAL_DATA

4917: END IF; -- } Region type 1 i.e., State
4918:
4919: IF ( p_city_flag = 'Y' ) THEN -- { Region type 2,3 i.e., City, Postal Codes
4920:
4921: DELETE FROM WSH_REGIONS_GLOBAL_DATA
4922: WHERE REGION_TYPE in ( 2, 3 );
4923:
4924: --
4925: -- Debug Statements

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

4924: --
4925: -- Debug Statements
4926: --
4927: IF l_debug_on THEN
4928: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4929: END IF;
4930: --
4931:
4932: INSERT INTO wsh_regions_global_data

Line 4932: INSERT INTO wsh_regions_global_data

4928: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global_data', sql%rowcount);
4929: END IF;
4930: --
4931:
4932: INSERT INTO wsh_regions_global_data
4933: ( REGION_ID,
4934: REGION_TYPE,
4935: PARENT_REGION_ID,
4936: COUNTRY,

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

4971: --
4972: -- Debug Statements
4973: --
4974: IF l_debug_on THEN
4975: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
4976: END IF;
4977: --
4978:
4979: DELETE FROM WSH_REGIONS_GLOBAL

Line 5040: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

5036: --
5037: -- PROCEDURE : Insert_Global_Table
5038: --
5039: -- PURPOSE : Inserts the data in Global Temp tables
5040: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
5041:
5042: PROCEDURE Insert_Global_Table (
5043: p_country IN VARCHAR2,
5044: p_state IN VARCHAR2,

Line 5118: INSERT INTO wsh_regions_global_data

5114: ELSE
5115: l_parent_region_id := p_parent_region_id;
5116: END IF;
5117:
5118: INSERT INTO wsh_regions_global_data
5119: ( REGION_ID,
5120: REGION_TYPE,
5121: PARENT_REGION_ID,
5122: COUNTRY,

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

5145: --
5146: -- Debug Statements
5147: --
5148: IF l_debug_on THEN
5149: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', sql%rowcount);
5150: END IF;
5151: --
5152:
5153: IF ( p_tl_only_flag <> 'Y' AND

Line 5198: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )

5194: --
5195: -- PROCEDURE : Update_Global_Table
5196: --
5197: -- PURPOSE : Updates the data in Global Temp tables
5198: -- ( Wsh_Regions_Global_Data and Wsh_Regions_Global tables )
5199:
5200: PROCEDURE Update_Global_Table (
5201: p_country IN VARCHAR2,
5202: p_state IN VARCHAR2,

Line 5217: FROM wsh_regions_global_data

5213: AS
5214:
5215: CURSOR child_regions IS
5216: SELECT region_id, region_type, parent_region_id
5217: FROM wsh_regions_global_data
5218: START WITH region_id = p_region_id
5219: CONNECT BY PRIOR region_id = parent_region_id;
5220:
5221: CURSOR get_state_code(l_region_id NUMBER) IS

Line 5319: UPDATE wsh_regions_global_data

5315: l_region_ins_cnt := l_region_ins_cnt + sql%rowcount;
5316: END IF;
5317: END IF;
5318:
5319: UPDATE wsh_regions_global_data
5320: SET country = nvl(UPPER(p_country), country),
5321: state = nvl(UPPER(p_state), state),
5322: city = nvl(UPPER(p_city), city),
5323: country_code = nvl(UPPER(p_country_code), country_code),

Line 5342: INSERT INTO wsh_regions_global_data

5338: l_region_data_upd_cnt := l_region_data_upd_cnt + sql%rowcount;
5339:
5340: IF ( sql%rowcount = 0 )
5341: THEN
5342: INSERT INTO wsh_regions_global_data
5343: ( REGION_ID,
5344: REGION_TYPE,
5345: PARENT_REGION_ID,
5346: COUNTRY,

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

5381: --
5382: IF l_debug_on THEN
5383: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global', l_region_upd_cnt);
5384: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', l_region_ins_cnt);
5385: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global_data', l_region_data_upd_cnt);
5386: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', l_region_data_ins_cnt);
5387: END IF;
5388: --
5389:

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

5382: IF l_debug_on THEN
5383: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global', l_region_upd_cnt);
5384: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', l_region_ins_cnt);
5385: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global_data', l_region_data_upd_cnt);
5386: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global_data', l_region_data_ins_cnt);
5387: END IF;
5388: --
5389:
5390: --