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

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 4037: delete from wsh_regions_global;

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
4041: x_status := 2;

Line 4649: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global

4645:
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:

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 4776: DELETE FROM WSH_REGIONS_GLOBAL;

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;
4777:
4778: --
4779: -- Debug Statements
4780: --

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

4778: --
4779: -- Debug Statements
4780: --
4781: IF l_debug_on THEN
4782: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4783: END IF;
4784: --
4785:
4786: INSERT INTO wsh_regions_global

Line 4786: INSERT INTO wsh_regions_global

4782: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4783: END IF;
4784: --
4785:
4786: INSERT INTO wsh_regions_global
4787: ( REGION_ID,
4788: REGION_TYPE,
4789: COUNTRY_CODE,
4790: STATE_CODE,

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

4801: --
4802: -- Debug Statements
4803: --
4804: IF l_debug_on THEN
4805: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
4806: END IF;
4807: --
4808: END IF; -- } Region Type 0 ie., Country
4809:

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 4907: DELETE FROM WSH_REGIONS_GLOBAL

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
4908: WHERE REGION_TYPE in ( 1, 2, 3 );
4909:
4910: --
4911: -- Debug Statements

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

4910: --
4911: -- Debug Statements
4912: --
4913: IF l_debug_on THEN
4914: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4915: END IF;
4916: --
4917:
4918: INSERT INTO wsh_regions_global

Line 4918: INSERT INTO wsh_regions_global

4914: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4915: END IF;
4916: --
4917:
4918: INSERT INTO wsh_regions_global
4919: ( REGION_ID,
4920: REGION_TYPE,
4921: COUNTRY_CODE,
4922: STATE_CODE,

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

4936: --
4937: -- Debug Statements
4938: --
4939: IF l_debug_on THEN
4940: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
4941: END IF;
4942: --
4943:
4944: END IF; -- } Region type 1 i.e., State

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 5042: DELETE FROM WSH_REGIONS_GLOBAL

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
5043: WHERE REGION_TYPE in ( 2, 3 );
5044:
5045: --
5046: -- Debug Statements

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

5045: --
5046: -- Debug Statements
5047: --
5048: IF l_debug_on THEN
5049: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
5050: END IF;
5051: --
5052:
5053: INSERT INTO wsh_regions_global

Line 5053: INSERT INTO wsh_regions_global

5049: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
5050: END IF;
5051: --
5052:
5053: INSERT INTO wsh_regions_global
5054: ( REGION_ID,
5055: REGION_TYPE,
5056: COUNTRY_CODE,
5057: STATE_CODE,

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

5072: --
5073: -- Debug Statements
5074: --
5075: IF l_debug_on THEN
5076: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
5077: END IF;
5078: --
5079:
5080: END IF; -- } Region type 2,3 i.e., City, Postal Codes

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 5219: INSERT INTO wsh_regions_global

5215:
5216: IF ( p_tl_only_flag <> 'Y' AND
5217: p_region_type in ( 0, 1, 2 ) )
5218: THEN
5219: INSERT INTO wsh_regions_global
5220: ( REGION_ID,
5221: REGION_TYPE,
5222: COUNTRY_CODE,
5223: STATE_CODE,

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

5231: --
5232: -- Debug Statements
5233: --
5234: IF l_debug_on THEN
5235: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
5236: END IF;
5237: --
5238: END IF;
5239:

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 5347: UPDATE wsh_regions_global

5343: CLOSE get_state_code;
5344:
5345: IF ( i.region_type in ( 0, 1, 2 ) )
5346: THEN
5347: UPDATE wsh_regions_global
5348: SET COUNTRY_CODE = nvl(UPPER(p_country_code), COUNTRY_CODE),
5349: state_code = decode(i.region_type,
5350: 2, UPPER(l_update_state_code),
5351: 3, UPPER(l_update_state_code),

Line 5364: INSERT INTO wsh_regions_global

5360: l_region_upd_cnt := l_region_upd_cnt + sql%rowcount;
5361:
5362: IF ( sql%rowcount = 0 )
5363: THEN
5364: INSERT INTO wsh_regions_global
5365: ( REGION_ID,
5366: REGION_TYPE,
5367: COUNTRY_CODE,
5368: STATE_CODE,

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 5446: WSH_DEBUG_SV.log(l_module_name, 'No of rows updated in wsh_regions_global', l_region_upd_cnt);

5442: --
5443: -- Debug Statements
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;

Line 5447: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', l_region_ins_cnt);

5443: -- Debug Statements
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: --

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: --