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

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

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

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

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

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;
4750:
4751: --
4752: -- Debug Statements
4753: --

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

4751: --
4752: -- Debug Statements
4753: --
4754: IF l_debug_on THEN
4755: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4756: END IF;
4757: --
4758:
4759: INSERT INTO wsh_regions_global

Line 4759: INSERT INTO wsh_regions_global

4755: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4756: END IF;
4757: --
4758:
4759: INSERT INTO wsh_regions_global
4760: ( REGION_ID,
4761: REGION_TYPE,
4762: COUNTRY_CODE,
4763: STATE_CODE,

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

4774: --
4775: -- Debug Statements
4776: --
4777: IF l_debug_on THEN
4778: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
4779: END IF;
4780: --
4781: END IF; -- } Region Type 0 ie., Country
4782:

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

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
4881: WHERE REGION_TYPE in ( 1, 2, 3 );
4882:
4883: --
4884: -- Debug Statements

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

4883: --
4884: -- Debug Statements
4885: --
4886: IF l_debug_on THEN
4887: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4888: END IF;
4889: --
4890:
4891: INSERT INTO wsh_regions_global

Line 4891: INSERT INTO wsh_regions_global

4887: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4888: END IF;
4889: --
4890:
4891: INSERT INTO wsh_regions_global
4892: ( REGION_ID,
4893: REGION_TYPE,
4894: COUNTRY_CODE,
4895: STATE_CODE,

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

4909: --
4910: -- Debug Statements
4911: --
4912: IF l_debug_on THEN
4913: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
4914: END IF;
4915: --
4916:
4917: END IF; -- } Region type 1 i.e., State

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

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
4980: WHERE REGION_TYPE in ( 2, 3 );
4981:
4982: --
4983: -- Debug Statements

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

4982: --
4983: -- Debug Statements
4984: --
4985: IF l_debug_on THEN
4986: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4987: END IF;
4988: --
4989:
4990: INSERT INTO wsh_regions_global

Line 4990: INSERT INTO wsh_regions_global

4986: WSH_DEBUG_SV.log(l_module_name, 'No of rows deleted from wsh_regions_global', sql%rowcount);
4987: END IF;
4988: --
4989:
4990: INSERT INTO wsh_regions_global
4991: ( REGION_ID,
4992: REGION_TYPE,
4993: COUNTRY_CODE,
4994: STATE_CODE,

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

5009: --
5010: -- Debug Statements
5011: --
5012: IF l_debug_on THEN
5013: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
5014: END IF;
5015: --
5016:
5017: END IF; -- } Region type 2,3 i.e., City, Postal Codes

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

5152:
5153: IF ( p_tl_only_flag <> 'Y' AND
5154: p_region_type in ( 0, 1, 2 ) )
5155: THEN
5156: INSERT INTO wsh_regions_global
5157: ( REGION_ID,
5158: REGION_TYPE,
5159: COUNTRY_CODE,
5160: STATE_CODE,

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

5168: --
5169: -- Debug Statements
5170: --
5171: IF l_debug_on THEN
5172: WSH_DEBUG_SV.log(l_module_name, 'No of rows inserted in wsh_regions_global', sql%rowcount);
5173: END IF;
5174: --
5175: END IF;
5176:

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

5280: CLOSE get_state_code;
5281:
5282: IF ( i.region_type in ( 0, 1, 2 ) )
5283: THEN
5284: UPDATE wsh_regions_global
5285: SET COUNTRY_CODE = nvl(UPPER(p_country_code), COUNTRY_CODE),
5286: state_code = decode(i.region_type,
5287: 2, UPPER(l_update_state_code),
5288: 3, UPPER(l_update_state_code),

Line 5301: INSERT INTO wsh_regions_global

5297: l_region_upd_cnt := l_region_upd_cnt + sql%rowcount;
5298:
5299: IF ( sql%rowcount = 0 )
5300: THEN
5301: INSERT INTO wsh_regions_global
5302: ( REGION_ID,
5303: REGION_TYPE,
5304: COUNTRY_CODE,
5305: STATE_CODE,

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

5379: --
5380: -- Debug Statements
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;

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

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

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