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 177: FROM hz_locations hzl

173: , x_state_or_province
174: , x_postal_code
175: , x_territory_short_name
176: , x_iso_territory_code
177: FROM hz_locations hzl
178: , fnd_territories fte
179: , fnd_territories_tl ftel
180: , fnd_lookup_values flv1
181: , fnd_lookup_values flv2

Line 276: ** hr_locations or from hz_locations

272: ** Created for ER 2291745
273: ** Logic
274: ** 1. The x_temp_location_id will be set if the location exists in hr_Locations
275: ** 2. Based on the x_temp_location_id the address will be selected from either
276: ** hr_locations or from hz_locations
277: **
278: ********************************************************************************/
279:
280: PROCEDURE get_address

Line 322: ** hr_locations or from hz_locations

318: ** Created for FPJ PO Communication Enhancement
319: ** Logic
320: ** 1. The x_temp_location_id will be set if the location exists in hr_Locations
321: ** 2. Based on the x_temp_location_id the address will be selected from either
322: ** hr_locations or from hz_locations
323: **--Change Hisotry: bug#3438608 added the out variables x_town_or_city
324: --x_postal_code and x_state_or_province
325: ********************************************************************************/
326: PROCEDURE get_address

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

449: End; /* hr_locations */
450:
451: else
452:
453: /* If the l_addr_select_qry location id is null then select the address from hz_locations */
454: /*
455: bug#3463617: address4 is selected from hz_locations.
456: */
457: Begin

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

451: else
452:
453: /* If the l_addr_select_qry location id is null then select the address from hz_locations */
454: /*
455: bug#3463617: address4 is selected from hz_locations.
456: */
457: Begin
458: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */
459: SELECT

Line 481: HZ_LOCATIONS HLC,

477: l_postal_code,
478: x_territory_short_name,
479: x_address_line_4
480: FROM
481: HZ_LOCATIONS HLC,
482: FND_TERRITORIES_TL FTE,
483: FND_LOOKUP_VALUES FCL1,
484: FND_LOOKUP_VALUES FCL2,
485: FND_LOOKUP_VALUES FCL3

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

515: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
516: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
517: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
518: /*
519: In hz_locations table there is no columns for location code, phone and fax.
520: */
521: --bug#3438608 nulling out the columns for hz_locations table where there is no column for location_code
522: --phone and fax..
523: x_location_name := null;

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

517: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
518: /*
519: In hz_locations table there is no columns for location code, phone and fax.
520: */
521: --bug#3438608 nulling out the columns for hz_locations table where there is no column for location_code
522: --phone and fax..
523: x_location_name := null;
524: x_contact_phone :=null;
525: x_contact_fax :=null;

Line 546: END; /* HZ_LOCATIONS */

542: x_contact_phone := '';
543: x_contact_fax := '';
544: x_address_line_4 := '';
545:
546: END; /* HZ_LOCATIONS */
547:
548: end if;
549:
550: If (l_town_or_city is null) then

Line 586: ** HR_LOCATIONS or HZ_LOCATIONS.

582: /*********************************************************************************************
583: **
584: ** Procedure: get_alladdress_lines
585: ** This procedure is used to retriev the address values mapped to
586: ** HR_LOCATIONS or HZ_LOCATIONS.
587: **
588: ** The prompts and the columns names where the prompts are mapped to
589: ** HR_LOCATIONS table is retrieved by using fnd_dflex package. fnd_dflex package is
590: ** is having functions and procedures to retrieve prompts names and the column names

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

592: ** Note: Some look up codes are stored in HR_LOCATIONS table. Current procedure is not
593: ** retrieving the loop up values for these codes.
594: **
595: ** There is no package available to retrieve the prompts and column names
596: ** that are mapped to HZ_LOCATIONS. But HZ_FORMAT_PUB package is having a procedure
597: ** FORMAT_ADDRESS which returns the formatted address values for a given location id
598: ** and style code. This procedure doesn't give the prompts and column names of
599: ** HZ_LOCATIONS table where the address details are stored. Only address values are
600: ** retrieved for HZ_LOCATIONS.

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

595: ** There is no package available to retrieve the prompts and column names
596: ** that are mapped to HZ_LOCATIONS. But HZ_FORMAT_PUB package is having a procedure
597: ** FORMAT_ADDRESS which returns the formatted address values for a given location id
598: ** and style code. This procedure doesn't give the prompts and column names of
599: ** HZ_LOCATIONS table where the address details are stored. Only address values are
600: ** retrieved for HZ_LOCATIONS.
601: **
602: ** Note: Since address are customizable and there is no limitaion in using the
603: ** number of segments, this procedure assumed that a max of 20 segments are enabled.

Line 600: ** retrieved for HZ_LOCATIONS.

596: ** that are mapped to HZ_LOCATIONS. But HZ_FORMAT_PUB package is having a procedure
597: ** FORMAT_ADDRESS which returns the formatted address values for a given location id
598: ** and style code. This procedure doesn't give the prompts and column names of
599: ** HZ_LOCATIONS table where the address details are stored. Only address values are
600: ** retrieved for HZ_LOCATIONS.
601: **
602: ** Note: Since address are customizable and there is no limitaion in using the
603: ** number of segments, this procedure assumed that a max of 20 segments are enabled.
604: ** If more than 20 values are enabled this procedure will retrieve first 20 segment values.

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

635: l_count number := 0;
636: l_addr_col_names varchar2(4000) :=NULL; -- Contains list of column names
637: --l_addr_into_qry varchar2(4000) :=NULL;
638:
639: /*Bug 5854013 l_style_code holds the address_style from hz_locations also.Hence declaring the variable
640: to hold the length same as of HZ_LOCATIONS.ADDRESS_STYLE which is bigger than HR_LOCATIONS.STYLE
641: l_style_code HR_LOCATIONS.STYLE%type := null; */
642: l_style_code HZ_LOCATIONS.ADDRESS_STYLE%type := null;
643:

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

636: l_addr_col_names varchar2(4000) :=NULL; -- Contains list of column names
637: --l_addr_into_qry varchar2(4000) :=NULL;
638:
639: /*Bug 5854013 l_style_code holds the address_style from hz_locations also.Hence declaring the variable
640: to hold the length same as of HZ_LOCATIONS.ADDRESS_STYLE which is bigger than HR_LOCATIONS.STYLE
641: l_style_code HR_LOCATIONS.STYLE%type := null; */
642: l_style_code HZ_LOCATIONS.ADDRESS_STYLE%type := null;
643:
644: l_temp_location_id Number := NULL ;

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

638:
639: /*Bug 5854013 l_style_code holds the address_style from hz_locations also.Hence declaring the variable
640: to hold the length same as of HZ_LOCATIONS.ADDRESS_STYLE which is bigger than HR_LOCATIONS.STYLE
641: l_style_code HR_LOCATIONS.STYLE%type := null; */
642: l_style_code HZ_LOCATIONS.ADDRESS_STYLE%type := null;
643:
644: l_temp_location_id Number := NULL ;
645: l_addr_select_qry varchar2(4000);
646: l_table_count number := 0;

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

962: End; /* hr_locations */
963:
964: else
965:
966: /* If location id is null then select the address from hz_locations */
967: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
968: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');
969: END IF;
970: Begin

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

964: else
965:
966: /* If location id is null then select the address from hz_locations */
967: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
968: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');
969: END IF;
970: Begin
971: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */
972: SELECT

Line 996: HZ_LOCATIONS HLC,

992: x_territory_short_name,
993: x_address_line_4,
994: l_style_code
995: FROM
996: HZ_LOCATIONS HLC,
997: FND_TERRITORIES_TL FTE,
998: FND_LOOKUP_VALUES FCL1,
999: FND_LOOKUP_VALUES FCL2,
1000: FND_LOOKUP_VALUES FCL3

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

1030: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
1031: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
1032: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
1033: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1034: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');
1035: END IF;
1036:
1037: /* hz_locations table doesn't have columns for location code, phone and fax. */
1038:

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

1033: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1034: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');
1035: END IF;
1036:
1037: /* hz_locations table doesn't have columns for location code, phone and fax. */
1038:
1039: x_location_name := null;
1040: x_contact_phone :=null;
1041: x_contact_fax :=null;

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

1089: END IF;
1090: END LOOP;
1091: END IF;
1092: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1093: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before adding HZ_LOCATIONS to PL/SQL tables');
1094: END IF;
1095: /* Assigning the values to global PL/SQL table */
1096: g_address_details(l_table_count).addr_data_1 := l_addr_values_array(1);
1097: g_address_details(l_table_count).addr_data_2 := l_addr_values_array(2);

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

1113: g_address_details(l_table_count).addr_data_18 := l_addr_values_array(18);
1114: g_address_details(l_table_count).addr_data_19 := l_addr_values_array(19);
1115: g_address_details(l_table_count).addr_data_20 := l_addr_values_array(20);
1116: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1117: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After adding HZ_LOCATIONS to PL/SQL tables');
1118: END IF;
1119:
1120: END IF;
1121:

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

1121:
1122: Exception
1123: WHEN OTHERS then
1124: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1125: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception in retrieving data from HZ_LOCATIONS');
1126: END IF;
1127: x_address_line_1 := '';
1128: x_address_line_2 := '';
1129: x_address_line_3 := '';

Line 1139: END; /* HZ_LOCATIONS */

1135: x_contact_phone := '';
1136: x_contact_fax := '';
1137: x_address_line_4 := '';
1138:
1139: END; /* HZ_LOCATIONS */
1140:
1141: end if;
1142:
1143: If (x_town_or_city is null) then