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_COMMUNICATION_PVT dependencies on PO_HR_LOCATION

Line 5497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);

5493: -- bug#3580225 Start --
5494:
5495: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
5496: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
5498: END IF;
5499:
5500: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
5501: PO_HR_LOCATION.populate_gt();

Line 5500: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/

5496: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
5498: END IF;
5499:
5500: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
5501: PO_HR_LOCATION.populate_gt();
5502:
5503: BEGIN
5504: context := dbms_xmlgen.newContext(''select * from po_address_details_gt '');

Line 5501: PO_HR_LOCATION.populate_gt();

5497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
5498: END IF;
5499:
5500: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
5501: PO_HR_LOCATION.populate_gt();
5502:
5503: BEGIN
5504: context := dbms_xmlgen.newContext(''select * from po_address_details_gt '');
5505: dbms_xmlgen.setRowsetTag(context,''ADDRESS_DETAILS'');

Line 5866: --to the procedure PO_HR_LOCATION.get_alladdress_lines

5862: --bug#3438608
5863:
5864: --bug#3438608 passed the out variables PO_COMMUNICATION_PVT.g_town_or_city
5865: --PO_COMMUNICATION_PVT.g_postal_code,PO_COMMUNICATION_PVT.g_state_or_province
5866: --to the procedure PO_HR_LOCATION.get_alladdress_lines
5867:
5868: -- bug#3580225: changed the procedure name to get_alladdress_lines from get_address--
5869: po_hr_location.get_alladdress_lines(p_location_id,
5870: PO_COMMUNICATION_PVT.g_address_line1,

Line 5869: po_hr_location.get_alladdress_lines(p_location_id,

5865: --PO_COMMUNICATION_PVT.g_postal_code,PO_COMMUNICATION_PVT.g_state_or_province
5866: --to the procedure PO_HR_LOCATION.get_alladdress_lines
5867:
5868: -- bug#3580225: changed the procedure name to get_alladdress_lines from get_address--
5869: po_hr_location.get_alladdress_lines(p_location_id,
5870: PO_COMMUNICATION_PVT.g_address_line1,
5871: PO_COMMUNICATION_PVT.g_address_line2,
5872: PO_COMMUNICATION_PVT.g_address_line3,
5873: PO_COMMUNICATION_PVT.g_Territory_short_name,

Line 6017: /* Bug#3580225: Changed the function to call po_hr_location.get_alladdress_lines PROCEDURE*/

6013: begin
6014: return PO_COMMUNICATION_PVT.g_location_name;
6015: end;
6016:
6017: /* Bug#3580225: Changed the function to call po_hr_location.get_alladdress_lines PROCEDURE*/
6018: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
6019: l_address_line4 varchar2(240) :=null;
6020: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6021: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;

Line 6024: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;

6020: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6021: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6022: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6023: l_address_info varchar2(500) := null;
6024: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
6025:
6026: begin
6027: if PO_COMMUNICATION_PVT.g_org_id <> p_org_id or
6028: PO_COMMUNICATION_PVT.g_org_id is null then

Line 6049: po_hr_location.get_alladdress_lines(l_location_id,

6045: WHERE organization_id = p_org_id;
6046:
6047: /* Call get_alladdress_lines procedure to retrieve address details*/
6048:
6049: po_hr_location.get_alladdress_lines(l_location_id,
6050: PO_COMMUNICATION_PVT.g_ou_address_line_1,
6051: PO_COMMUNICATION_PVT.g_ou_address_line_2,
6052: PO_COMMUNICATION_PVT.g_ou_address_line_3,
6053: PO_COMMUNICATION_PVT.g_ou_country,

Line 6694: /* call procedure get_address in po_hr_location package to retrieve

6690:
6691: /*End bug5983107 */
6692:
6693:
6694: /* call procedure get_address in po_hr_location package to retrieve
6695: address information for given location id*/
6696:
6697: po_hr_location.get_alladdress_lines(l_location_id,
6698: PO_COMMUNICATION_PVT.g_legal_entity_address_line_1,

Line 6697: po_hr_location.get_alladdress_lines(l_location_id,

6693:
6694: /* call procedure get_address in po_hr_location package to retrieve
6695: address information for given location id*/
6696:
6697: po_hr_location.get_alladdress_lines(l_location_id,
6698: PO_COMMUNICATION_PVT.g_legal_entity_address_line_1,
6699: PO_COMMUNICATION_PVT.g_legal_entity_address_line_2,
6700: PO_COMMUNICATION_PVT.g_legal_entity_address_line_3,
6701: PO_COMMUNICATION_PVT.g_legal_entity_country,