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.PO_HR_LOCATION dependencies on HZ_LOCATIONS

Line 188: FROM hz_locations hzl

184: , x_state_or_province
185: , x_postal_code
186: , x_territory_short_name
187: , x_iso_territory_code
188: FROM hz_locations hzl
189: , fnd_territories fte
190: , fnd_territories_tl ftel
191: , fnd_lookup_values flv1
192: , fnd_lookup_values flv2

Line 287: ** hr_locations or from hz_locations

283: ** Created for ER 2291745
284: ** Logic
285: ** 1. The x_temp_location_id will be set if the location exists in hr_Locations
286: ** 2. Based on the x_temp_location_id the address will be selected from either
287: ** hr_locations or from hz_locations
288: **
289: ********************************************************************************/
290:
291: PROCEDURE get_address

Line 333: ** hr_locations or from hz_locations

329: ** Created for FPJ PO Communication Enhancement
330: ** Logic
331: ** 1. The x_temp_location_id will be set if the location exists in hr_Locations
332: ** 2. Based on the x_temp_location_id the address will be selected from either
333: ** hr_locations or from hz_locations
334: **--Change Hisotry: bug#3438608 added the out variables x_town_or_city
335: --x_postal_code and x_state_or_province
336: ********************************************************************************/
337: PROCEDURE get_address

Line 475: /* If the l_addr_select_qry location id is null then select the address from hz_locations */

471: End; /* hr_locations */
472:
473: else
474:
475: /* If the l_addr_select_qry location id is null then select the address from hz_locations */
476: /*
477: bug#3463617: address4 is selected from hz_locations.
478: */
479: Begin

Line 477: bug#3463617: address4 is selected from hz_locations.

473: else
474:
475: /* If the l_addr_select_qry location id is null then select the address from hz_locations */
476: /*
477: bug#3463617: address4 is selected from hz_locations.
478: */
479: Begin
480: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */
481: SELECT

Line 503: HZ_LOCATIONS HLC,

499: l_postal_code,
500: x_territory_short_name,
501: x_address_line_4
502: FROM
503: HZ_LOCATIONS HLC,
504: FND_TERRITORIES_TL FTE,
505: FND_LOOKUP_VALUES FCL1,
506: FND_LOOKUP_VALUES FCL2,
507: FND_LOOKUP_VALUES FCL3

Line 541: In hz_locations table there is no columns for location code, phone and fax.

537: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
538: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
539: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
540: /*
541: In hz_locations table there is no columns for location code, phone and fax.
542: */
543: --bug#3438608 nulling out the columns for hz_locations table where there is no column for location_code
544: --phone and fax..
545: x_location_name := null;

Line 543: --bug#3438608 nulling out the columns for hz_locations table where there is no column for location_code

539: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
540: /*
541: In hz_locations table there is no columns for location code, phone and fax.
542: */
543: --bug#3438608 nulling out the columns for hz_locations table where there is no column for location_code
544: --phone and fax..
545: x_location_name := null;
546: x_contact_phone :=null;
547: x_contact_fax :=null;

Line 568: END; /* HZ_LOCATIONS */

564: x_contact_phone := '';
565: x_contact_fax := '';
566: x_address_line_4 := '';
567:
568: END; /* HZ_LOCATIONS */
569:
570: end if;
571:
572: If (l_town_or_city is null) then

Line 608: ** HR_LOCATIONS or HZ_LOCATIONS.

604: /*********************************************************************************************
605: **
606: ** Procedure: get_alladdress_lines
607: ** This procedure is used to retriev the address values mapped to
608: ** HR_LOCATIONS or HZ_LOCATIONS.
609: **
610: ** The prompts and the columns names where the prompts are mapped to
611: ** HR_LOCATIONS table is retrieved by using fnd_dflex package. fnd_dflex package is
612: ** is having functions and procedures to retrieve prompts names and the column names

Line 618: ** that are mapped to HZ_LOCATIONS. But HZ_FORMAT_PUB package is having a procedure

614: ** Note: Some look up codes are stored in HR_LOCATIONS table. Current procedure is not
615: ** retrieving the loop up values for these codes.
616: **
617: ** There is no package available to retrieve the prompts and column names
618: ** that are mapped to HZ_LOCATIONS. But HZ_FORMAT_PUB package is having a procedure
619: ** FORMAT_ADDRESS which returns the formatted address values for a given location id
620: ** and style code. This procedure doesn't give the prompts and column names of
621: ** HZ_LOCATIONS table where the address details are stored. Only address values are
622: ** retrieved for HZ_LOCATIONS.

Line 621: ** HZ_LOCATIONS table where the address details are stored. Only address values are

617: ** There is no package available to retrieve the prompts and column names
618: ** that are mapped to HZ_LOCATIONS. But HZ_FORMAT_PUB package is having a procedure
619: ** FORMAT_ADDRESS which returns the formatted address values for a given location id
620: ** and style code. This procedure doesn't give the prompts and column names of
621: ** HZ_LOCATIONS table where the address details are stored. Only address values are
622: ** retrieved for HZ_LOCATIONS.
623: **
624: ** Note: Since address are customizable and there is no limitaion in using the
625: ** number of segments, this procedure assumed that a max of 20 segments are enabled.

Line 622: ** retrieved for HZ_LOCATIONS.

618: ** that are mapped to HZ_LOCATIONS. But HZ_FORMAT_PUB package is having a procedure
619: ** FORMAT_ADDRESS which returns the formatted address values for a given location id
620: ** and style code. This procedure doesn't give the prompts and column names of
621: ** HZ_LOCATIONS table where the address details are stored. Only address values are
622: ** retrieved for HZ_LOCATIONS.
623: **
624: ** Note: Since address are customizable and there is no limitaion in using the
625: ** number of segments, this procedure assumed that a max of 20 segments are enabled.
626: ** If more than 20 values are enabled this procedure will retrieve first 20 segment values.

Line 661: /*Bug 5854013 l_style_code holds the address_style from hz_locations also.Hence declaring the variable

657: l_count number := 0;
658: l_addr_col_names varchar2(4000) :=NULL; -- Contains list of column names
659: --l_addr_into_qry varchar2(4000) :=NULL;
660:
661: /*Bug 5854013 l_style_code holds the address_style from hz_locations also.Hence declaring the variable
662: to hold the length same as of HZ_LOCATIONS.ADDRESS_STYLE which is bigger than HR_LOCATIONS.STYLE
663: l_style_code HR_LOCATIONS.STYLE%type := null; */
664: l_style_code HZ_LOCATIONS.ADDRESS_STYLE%type := null;
665:

Line 662: to hold the length same as of HZ_LOCATIONS.ADDRESS_STYLE which is bigger than HR_LOCATIONS.STYLE

658: l_addr_col_names varchar2(4000) :=NULL; -- Contains list of column names
659: --l_addr_into_qry varchar2(4000) :=NULL;
660:
661: /*Bug 5854013 l_style_code holds the address_style from hz_locations also.Hence declaring the variable
662: to hold the length same as of HZ_LOCATIONS.ADDRESS_STYLE which is bigger than HR_LOCATIONS.STYLE
663: l_style_code HR_LOCATIONS.STYLE%type := null; */
664: l_style_code HZ_LOCATIONS.ADDRESS_STYLE%type := null;
665:
666: l_temp_location_id Number := NULL ;

Line 664: l_style_code HZ_LOCATIONS.ADDRESS_STYLE%type := null;

660:
661: /*Bug 5854013 l_style_code holds the address_style from hz_locations also.Hence declaring the variable
662: to hold the length same as of HZ_LOCATIONS.ADDRESS_STYLE which is bigger than HR_LOCATIONS.STYLE
663: l_style_code HR_LOCATIONS.STYLE%type := null; */
664: l_style_code HZ_LOCATIONS.ADDRESS_STYLE%type := null;
665:
666: l_temp_location_id Number := NULL ;
667: l_addr_select_qry varchar2(4000);
668: l_table_count number := 0;

Line 999: /* If location id is null then select the address from hz_locations */

995: End; /* hr_locations */
996:
997: else
998:
999: /* If location id is null then select the address from hz_locations */
1000: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1001: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');
1002: END IF;
1003: Begin

Line 1001: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');

997: else
998:
999: /* If location id is null then select the address from hz_locations */
1000: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1001: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');
1002: END IF;
1003: Begin
1004: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */
1005: SELECT

Line 1029: HZ_LOCATIONS HLC,

1025: x_territory_short_name,
1026: x_address_line_4,
1027: l_style_code
1028: FROM
1029: HZ_LOCATIONS HLC,
1030: FND_TERRITORIES_TL FTE,
1031: FND_LOOKUP_VALUES FCL1,
1032: FND_LOOKUP_VALUES FCL2,
1033: FND_LOOKUP_VALUES FCL3

Line 1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');

1063: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
1064: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
1065: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');
1068: END IF;
1069:
1070: /* hz_locations table doesn't have columns for location code, phone and fax. */
1071:

Line 1070: /* hz_locations table doesn't have columns for location code, phone and fax. */

1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');
1068: END IF;
1069:
1070: /* hz_locations table doesn't have columns for location code, phone and fax. */
1071:
1072: x_location_name := null;
1073: x_contact_phone :=null;
1074: x_contact_fax :=null;

Line 1126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before adding HZ_LOCATIONS to PL/SQL tables');

1122: END IF;
1123: END LOOP;
1124: END IF;
1125: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before adding HZ_LOCATIONS to PL/SQL tables');
1127: END IF;
1128: /* Assigning the values to global PL/SQL table */
1129: g_address_details(l_table_count).addr_data_1 := l_addr_values_array(1);
1130: g_address_details(l_table_count).addr_data_2 := l_addr_values_array(2);

Line 1150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After adding HZ_LOCATIONS to PL/SQL tables');

1146: g_address_details(l_table_count).addr_data_18 := l_addr_values_array(18);
1147: g_address_details(l_table_count).addr_data_19 := l_addr_values_array(19);
1148: g_address_details(l_table_count).addr_data_20 := l_addr_values_array(20);
1149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After adding HZ_LOCATIONS to PL/SQL tables');
1151: END IF;
1152:
1153: END IF;
1154:

Line 1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception in retrieving data from HZ_LOCATIONS');

1154:
1155: Exception
1156: WHEN OTHERS then
1157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception in retrieving data from HZ_LOCATIONS');
1159: END IF;
1160: x_address_line_1 := '';
1161: x_address_line_2 := '';
1162: x_address_line_3 := '';

Line 1172: END; /* HZ_LOCATIONS */

1168: x_contact_phone := '';
1169: x_contact_fax := '';
1170: x_address_line_4 := '';
1171:
1172: END; /* HZ_LOCATIONS */
1173:
1174: end if;
1175:
1176: If (x_town_or_city is null) then