APPS.PO_HR_LOCATION dependencies on HZ_FORMAT_PUB

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 672: /* Variables used in HZ_FORMAT_PUB.FORMAT_ADDRESS procedure */

668: l_table_count number := 0;
669:
670: /*end of variables*/
671:
672: /* Variables used in HZ_FORMAT_PUB.FORMAT_ADDRESS procedure */
673:
674: x_formatted_address_tbl HZ_FORMAT_PUB.string_tbl_type;
675: x_return_status VARCHAR2(2) ;
676: x_msg_count NUMBER ;

Line 674: x_formatted_address_tbl HZ_FORMAT_PUB.string_tbl_type;

670: /*end of variables*/
671:
672: /* Variables used in HZ_FORMAT_PUB.FORMAT_ADDRESS procedure */
673:
674: x_formatted_address_tbl HZ_FORMAT_PUB.string_tbl_type;
675: x_return_status VARCHAR2(2) ;
676: x_msg_count NUMBER ;
677: x_msg_data VARCHAR2(4000) ;
678: x_formatted_address VARCHAR2(4000) ;

Line 1103: HZ_FORMAT_PUB.FORMAT_ADDRESS(p_location_id => p_location_id,

1099: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'p_location_id:'|| p_location_id);
1100: END IF;
1101:
1102:
1103: HZ_FORMAT_PUB.FORMAT_ADDRESS(p_location_id => p_location_id,
1104: -- output parameters
1105: x_return_status => x_return_status, x_msg_count => x_msg_count,
1106: x_msg_data => x_msg_data, x_formatted_address => x_formatted_address,
1107: x_formatted_lines_cnt => x_formatted_lines_cnt,