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 6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);

6534: -- bug#3580225 Start --
6535:
6536: select TO_CHAR(SYSDATE, ''DD-MON-YYYY HH24:MI:SS'') into l_time from dual;
6537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
6539: END IF;
6540:
6541: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
6542: PO_HR_LOCATION.populate_gt();

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

6537: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
6539: END IF;
6540:
6541: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
6542: PO_HR_LOCATION.populate_gt();
6543:
6544: BEGIN
6545: context := dbms_xmlgen.newContext(''select * from po_address_details_gt '');

Line 6542: PO_HR_LOCATION.populate_gt();

6538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||''Before calling PO_HR_LOCATION.populate_gt'', l_time);
6539: END IF;
6540:
6541: /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/
6542: PO_HR_LOCATION.populate_gt();
6543:
6544: BEGIN
6545: context := dbms_xmlgen.newContext(''select * from po_address_details_gt '');
6546: dbms_xmlgen.setRowsetTag(context,''ADDRESS_DETAILS'');

Line 6957: --to the procedure PO_HR_LOCATION.get_alladdress_lines

6953: --bug#3438608
6954:
6955: --bug#3438608 passed the out variables PO_COMMUNICATION_PVT.g_town_or_city
6956: --PO_COMMUNICATION_PVT.g_postal_code,PO_COMMUNICATION_PVT.g_state_or_province
6957: --to the procedure PO_HR_LOCATION.get_alladdress_lines
6958:
6959: -- bug#3580225: changed the procedure name to get_alladdress_lines from get_address--
6960: po_hr_location.get_alladdress_lines(p_location_id,
6961: PO_COMMUNICATION_PVT.g_address_line1,

Line 6960: po_hr_location.get_alladdress_lines(p_location_id,

6956: --PO_COMMUNICATION_PVT.g_postal_code,PO_COMMUNICATION_PVT.g_state_or_province
6957: --to the procedure PO_HR_LOCATION.get_alladdress_lines
6958:
6959: -- bug#3580225: changed the procedure name to get_alladdress_lines from get_address--
6960: po_hr_location.get_alladdress_lines(p_location_id,
6961: PO_COMMUNICATION_PVT.g_address_line1,
6962: PO_COMMUNICATION_PVT.g_address_line2,
6963: PO_COMMUNICATION_PVT.g_address_line3,
6964: PO_COMMUNICATION_PVT.g_Territory_short_name,

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

7121: begin
7122: return PO_COMMUNICATION_PVT.g_location_name;
7123: end;
7124:
7125: /* Bug#3580225: Changed the function to call po_hr_location.get_alladdress_lines PROCEDURE*/
7126: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
7127: l_address_line4 varchar2(240) := null;
7128: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7129: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;

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

7128: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7129: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7130: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7131: l_address_info varchar2(500) := null;
7132: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
7133:
7134: begin
7135: if PO_COMMUNICATION_PVT.g_org_id <> p_org_id or
7136: PO_COMMUNICATION_PVT.g_org_id is null then

Line 7157: po_hr_location.get_alladdress_lines(l_location_id,

7153: WHERE organization_id = p_org_id;
7154:
7155: /* Call get_alladdress_lines procedure to retrieve address details*/
7156:
7157: po_hr_location.get_alladdress_lines(l_location_id,
7158: PO_COMMUNICATION_PVT.g_ou_address_line_1,
7159: PO_COMMUNICATION_PVT.g_ou_address_line_2,
7160: PO_COMMUNICATION_PVT.g_ou_address_line_3,
7161: PO_COMMUNICATION_PVT.g_ou_country,

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

7882:
7883: /*End bug5983107 */
7884:
7885:
7886: /* call procedure get_address in po_hr_location package to retrieve
7887: address information for given location id*/
7888:
7889: po_hr_location.get_alladdress_lines(l_location_id,
7890: PO_COMMUNICATION_PVT.g_legal_entity_address_line_1,

Line 7889: po_hr_location.get_alladdress_lines(l_location_id,

7885:
7886: /* call procedure get_address in po_hr_location package to retrieve
7887: address information for given location id*/
7888:
7889: po_hr_location.get_alladdress_lines(l_location_id,
7890: PO_COMMUNICATION_PVT.g_legal_entity_address_line_1,
7891: PO_COMMUNICATION_PVT.g_legal_entity_address_line_2,
7892: PO_COMMUNICATION_PVT.g_legal_entity_address_line_3,
7893: PO_COMMUNICATION_PVT.g_legal_entity_country,