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 HR_LOCATIONS

Line 47: -- See if this location is in HR_LOCATIONS or if it

43: END IF;
44:
45: d_progress := '100';
46:
47: -- See if this location is in HR_LOCATIONS or if it
48: -- is a drop ship location
49: BEGIN
50: SELECT hrl.location_id
51: INTO l_temp_location_id

Line 52: FROM hr_locations hrl

48: -- is a drop ship location
49: BEGIN
50: SELECT hrl.location_id
51: INTO l_temp_location_id
52: FROM hr_locations hrl
53: WHERE hrl.location_id = p_location_id;
54:
55: d_progress := '110';
56:

Line 94: FROM hr_locations_all hrl

90: , x_state_or_province
91: , x_postal_code
92: , x_territory_short_name
93: , x_iso_territory_code
94: FROM hr_locations_all hrl
95: , fnd_territories fte
96: , fnd_territories_tl ftel
97: , fnd_lookup_values flv1
98: , fnd_lookup_values flv2

Line 274: ** 1. The x_temp_location_id will be set if the location exists in hr_Locations

270: **
271: ** Procedure get_address
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: ********************************************************************************/

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 288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;

284: Address_line_3 OUT NOCOPY Varchar2,
285: Territory_short_name OUT NOCOPY VArchar2,
286: Address_info OUT NOCOPY Varchar2 )
287: IS
288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
291: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
292:

Line 289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;

285: Territory_short_name OUT NOCOPY VArchar2,
286: Address_info OUT NOCOPY Varchar2 )
287: IS
288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
291: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
292:
293: Begin

Line 290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;

286: Address_info OUT NOCOPY Varchar2 )
287: IS
288: l_town_or_city HR_LOCATIONS_ALL.town_or_city%TYPE;
289: l_state_or_province HR_LOCATIONS_ALL.region_1%TYPE;
290: l_postal_code HR_LOCATIONS_ALL.postal_code%TYPE;
291: l_iso_territory_code FND_TERRITORIES.iso_territory_code%TYPE;
292:
293: Begin
294:

Line 320: ** 1. The x_temp_location_id will be set if the location exists in hr_Locations

316: **
317: ** Procedure get_address (with over loading)
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

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 337: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type,

333: x_location_name OUT NOCOPY Varchar2,
334: x_contact_phone OUT NOCOPY Varchar2,
335: x_contact_fax OUT NOCOPY Varchar2,
336: x_address_line_4 OUT NOCOPY Varchar2,
337: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type,
338: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
339: x_state_or_province OUT NOCOPY varchar2)
340:
341: IS

Line 338: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,

334: x_contact_phone OUT NOCOPY Varchar2,
335: x_contact_fax OUT NOCOPY Varchar2,
336: x_address_line_4 OUT NOCOPY Varchar2,
337: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type,
338: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
339: x_state_or_province OUT NOCOPY varchar2)
340:
341: IS
342: l_town_or_city Varchar2(240);

Line 348: /* Select the location id from hr_locations. If the location is in hr_locations

344: l_postal_code Varchar2(240);
345: l_temp_location_id Number := NULL ;
346: Begin
347:
348: /* Select the location id from hr_locations. If the location is in hr_locations
349: it will be populated. Else the l_temp_location_id will be made NULL */
350:
351: Begin
352: Select location_id into l_temp_location_id

Line 353: from hr_locations

349: it will be populated. Else the l_temp_location_id will be made NULL */
350:
351: Begin
352: Select location_id into l_temp_location_id
353: from hr_locations
354: where location_id = p_location_id;
355: exception
356: WHEN NO_DATA_FOUND THEN
357: l_temp_location_id := NULL;

Line 363: /* If the l_addr_select_qry location id is not null then get the address from hr_locations */

359:
360:
361: if (l_temp_location_id is not null) then
362:
363: /* If the l_addr_select_qry location id is not null then get the address from hr_locations */
364:
365: Begin
366: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */
367: Select HLC.ADDRESS_LINE_1,

Line 392: HR_LOCATIONS HLC,

388: x_location_name,
389: x_contact_phone,
390: x_contact_fax
391: FROM
392: HR_LOCATIONS HLC,
393: FND_TERRITORIES_TL FTE,
394: FND_LOOKUP_VALUES FCL1,
395: FND_LOOKUP_VALUES FCL2,
396: FND_LOOKUP_VALUES FCL3

Line 449: End; /* hr_locations */

445: x_location_name := '';
446: x_contact_phone := '';
447: x_contact_fax := '';
448:
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 */

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 589: ** HR_LOCATIONS table is retrieved by using fnd_dflex package. fnd_dflex package is

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
591: ** of HR_LOCATIONS where the address details are stored.
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.

Line 591: ** of HR_LOCATIONS where the address details are stored.

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
591: ** of HR_LOCATIONS where the address details are stored.
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

Line 592: ** Note: Some look up codes are stored in HR_LOCATIONS table. Current procedure is not

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
591: ** of HR_LOCATIONS where the address details are stored.
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

Line 619: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type,

615: x_location_name OUT NOCOPY Varchar2,
616: x_contact_phone OUT NOCOPY Varchar2,
617: x_contact_fax OUT NOCOPY Varchar2,
618: x_address_line_4 OUT NOCOPY Varchar2,
619: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type,
620: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
621: x_state_or_province OUT NOCOPY varchar2)
622:
623: IS

Line 620: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,

616: x_contact_phone OUT NOCOPY Varchar2,
617: x_contact_fax OUT NOCOPY Varchar2,
618: x_address_line_4 OUT NOCOPY Varchar2,
619: x_town_or_city OUT NOCOPY HR_LOCATIONS.town_or_city%type,
620: x_postal_code OUT NOCOPY HR_LOCATIONS.postal_code%type,
621: x_state_or_province OUT NOCOPY varchar2)
622:
623: IS
624:

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 641: l_style_code HR_LOCATIONS.STYLE%type := null; */

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 ;
645: l_addr_select_qry varchar2(4000);

Line 671: /* Select the location id from hr_locations. If the location is in hr_locations

667:
668:
669: Begin
670:
671: /* Select the location id from hr_locations. If the location is in hr_locations
672: it will be populated. Else the l_temp_location_id will be made NULL */
673:
674: Begin
675: Select location_id, style into l_temp_location_id, l_style_code

Line 676: from hr_locations

672: it will be populated. Else the l_temp_location_id will be made NULL */
673:
674: Begin
675: Select location_id, style into l_temp_location_id, l_style_code
676: from hr_locations
677: where location_id = p_location_id;
678: exception
679: WHEN NO_DATA_FOUND THEN
680: l_temp_location_id := NULL;

Line 687: /* If location id is not null then get the address from hr_locations */

683:
684:
685: if (l_temp_location_id is not null) then
686:
687: /* If location id is not null then get the address from hr_locations */
688:
689: Begin
690: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');

Line 691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');

687: /* If location id is not null then get the address from hr_locations */
688:
689: Begin
690: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');
692: END IF;
693: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);
695: END IF;

Line 726: HR_LOCATIONS HLC,

722: x_location_name,
723: x_contact_phone,
724: x_contact_fax
725: FROM
726: HR_LOCATIONS HLC,
727: FND_TERRITORIES_TL FTE,
728: FND_LOOKUP_VALUES FCL1,
729: FND_LOOKUP_VALUES FCL2,
730: FND_LOOKUP_VALUES FCL3

Line 863: -- Query to retrieve the address values from HR_LOCATIONS.

859: END IF;
860:
861: END LOOP;
862:
863: -- Query to retrieve the address values from HR_LOCATIONS.
864: l_addr_select_qry := 'select '|| l_addr_col_names || ' from hr_locations where location_id = :1 ' ;
865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'select query:'||l_addr_select_qry);
867: END IF;

Line 864: l_addr_select_qry := 'select '|| l_addr_col_names || ' from hr_locations where location_id = :1 ' ;

860:
861: END LOOP;
862:
863: -- Query to retrieve the address values from HR_LOCATIONS.
864: l_addr_select_qry := 'select '|| l_addr_col_names || ' from hr_locations where location_id = :1 ' ;
865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'select query:'||l_addr_select_qry);
867: END IF;
868:

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

923: -- End bug#3622675
924: g_addr_prompt_query(l_addr_prompt_query_count).query := l_addr_select_qry;
925: END IF;
926: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
927: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HR_LOCATIONS query');
928: END IF;
929:
930: execute immediate l_addr_select_qry INTO g_address_details(l_table_count).addr_data_1, g_address_details(l_table_count).addr_data_2, g_address_details(l_table_count).addr_data_3,
931: g_address_details(l_table_count).addr_data_4, g_address_details(l_table_count).addr_data_5, g_address_details(l_table_count).addr_data_6,

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

934: g_address_details(l_table_count).addr_data_13, g_address_details(l_table_count).addr_data_14, g_address_details(l_table_count).addr_data_15,
935: g_address_details(l_table_count).addr_data_16, g_address_details(l_table_count).addr_data_17, g_address_details(l_table_count).addr_data_18,
936: g_address_details(l_table_count).addr_data_19, g_address_details(l_table_count).addr_data_20 USING p_location_id ;
937: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
938: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HR_LOCATIONS query');
939: END IF;
940:
941:
942:

Line 949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception while retrieving data from HR_LOCATIONS');

945:
946: Exception
947: WHEN OTHERS then
948: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception while retrieving data from HR_LOCATIONS');
950: END IF;
951: x_address_line_1 := '';
952: x_address_line_2 := '';
953: x_address_line_3 := '';

Line 962: End; /* hr_locations */

958: x_location_name := '';
959: x_contact_phone := '';
960: x_contact_fax := '';
961:
962: End; /* hr_locations */
963:
964: else
965:
966: /* If location id is null then select the address from hz_locations */