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.PAY_IN_24Q_ER_RETURNS dependencies on HR_LOCATIONS

Line 815: -- IN : p_location_id hr_locations.location_id --

811: -- Access : Public --
812: -- Description : This function gets the gre location details --
813: -- --
814: -- Parameters : --
815: -- IN : p_location_id hr_locations.location_id --
816: -- : p_concatenate VARCHAR2 --
817: -- p_field VARCHAR2 --
818: --------------------------------------------------------------------------
819: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE

Line 819: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE

815: -- IN : p_location_id hr_locations.location_id --
816: -- : p_concatenate VARCHAR2 --
817: -- p_field VARCHAR2 --
818: --------------------------------------------------------------------------
819: FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
820: ,p_rep_email_id IN VARCHAR2
821: ,p_rep_phone IN VARCHAR2
822: ,p_segment_num IN NUMBER
823: ,p_person_type IN VARCHAR2)

Line 837: FROM hr_locations

833: NVL(hr_general.decode_lookup('IN_STATE_CODES',loc_information16),'^'),
834: NVL(postal_code,'^'),
835: NVL(LOC_INFORMATION17,'^'),
836: NVL(TELEPHONE_NUMBER_1,'^')
837: FROM hr_locations
838: WHERE location_id = p_location_id;
839:
840: l_add_1 hr_locations.address_line_1%TYPE;
841: l_add_2 hr_locations.address_line_2%TYPE;

Line 840: l_add_1 hr_locations.address_line_1%TYPE;

836: NVL(TELEPHONE_NUMBER_1,'^')
837: FROM hr_locations
838: WHERE location_id = p_location_id;
839:
840: l_add_1 hr_locations.address_line_1%TYPE;
841: l_add_2 hr_locations.address_line_2%TYPE;
842: l_add_3 hr_locations.address_line_3%TYPE;
843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;

Line 841: l_add_2 hr_locations.address_line_2%TYPE;

837: FROM hr_locations
838: WHERE location_id = p_location_id;
839:
840: l_add_1 hr_locations.address_line_1%TYPE;
841: l_add_2 hr_locations.address_line_2%TYPE;
842: l_add_3 hr_locations.address_line_3%TYPE;
843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;
845: l_email hr_locations.loc_information17%TYPE;

Line 842: l_add_3 hr_locations.address_line_3%TYPE;

838: WHERE location_id = p_location_id;
839:
840: l_add_1 hr_locations.address_line_1%TYPE;
841: l_add_2 hr_locations.address_line_2%TYPE;
842: l_add_3 hr_locations.address_line_3%TYPE;
843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;
845: l_email hr_locations.loc_information17%TYPE;
846: l_phone hr_locations.telephone_number_1%TYPE;

Line 843: l_add_4 hr_locations.loc_information14%TYPE;

839:
840: l_add_1 hr_locations.address_line_1%TYPE;
841: l_add_2 hr_locations.address_line_2%TYPE;
842: l_add_3 hr_locations.address_line_3%TYPE;
843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;
845: l_email hr_locations.loc_information17%TYPE;
846: l_phone hr_locations.telephone_number_1%TYPE;
847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524

Line 844: l_add_5 hr_locations.loc_information15%TYPE;

840: l_add_1 hr_locations.address_line_1%TYPE;
841: l_add_2 hr_locations.address_line_2%TYPE;
842: l_add_3 hr_locations.address_line_3%TYPE;
843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;
845: l_email hr_locations.loc_information17%TYPE;
846: l_phone hr_locations.telephone_number_1%TYPE;
847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524
848: l_state hr_lookups.meaning%TYPE;

Line 845: l_email hr_locations.loc_information17%TYPE;

841: l_add_2 hr_locations.address_line_2%TYPE;
842: l_add_3 hr_locations.address_line_3%TYPE;
843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;
845: l_email hr_locations.loc_information17%TYPE;
846: l_phone hr_locations.telephone_number_1%TYPE;
847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524
848: l_state hr_lookups.meaning%TYPE;
849: l_pin hr_locations.postal_code%TYPE;

Line 846: l_phone hr_locations.telephone_number_1%TYPE;

842: l_add_3 hr_locations.address_line_3%TYPE;
843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;
845: l_email hr_locations.loc_information17%TYPE;
846: l_phone hr_locations.telephone_number_1%TYPE;
847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524
848: l_state hr_lookups.meaning%TYPE;
849: l_pin hr_locations.postal_code%TYPE;
850: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;

Line 847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524

843: l_add_4 hr_locations.loc_information14%TYPE;
844: l_add_5 hr_locations.loc_information15%TYPE;
845: l_email hr_locations.loc_information17%TYPE;
846: l_phone hr_locations.telephone_number_1%TYPE;
847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524
848: l_state hr_lookups.meaning%TYPE;
849: l_pin hr_locations.postal_code%TYPE;
850: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
851: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;

Line 849: l_pin hr_locations.postal_code%TYPE;

845: l_email hr_locations.loc_information17%TYPE;
846: l_phone hr_locations.telephone_number_1%TYPE;
847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524
848: l_state hr_lookups.meaning%TYPE;
849: l_pin hr_locations.postal_code%TYPE;
850: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
851: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;
852: l_mob hr_locations.TELEPHONE_NUMBER_1%TYPE; -- Bug 12332524
853: l_remark VARCHAR2(75);

Line 850: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;

846: l_phone hr_locations.telephone_number_1%TYPE;
847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524
848: l_state hr_lookups.meaning%TYPE;
849: l_pin hr_locations.postal_code%TYPE;
850: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
851: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;
852: l_mob hr_locations.TELEPHONE_NUMBER_1%TYPE; -- Bug 12332524
853: l_remark VARCHAR2(75);
854: p_address1 VARCHAR2(60);

Line 851: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;

847: l_mobile hr_locations.telephone_number_1%TYPE; -- Bug 12332524
848: l_state hr_lookups.meaning%TYPE;
849: l_pin hr_locations.postal_code%TYPE;
850: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
851: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;
852: l_mob hr_locations.TELEPHONE_NUMBER_1%TYPE; -- Bug 12332524
853: l_remark VARCHAR2(75);
854: p_address1 VARCHAR2(60);
855: p_address2 VARCHAR2(60);

Line 852: l_mob hr_locations.TELEPHONE_NUMBER_1%TYPE; -- Bug 12332524

848: l_state hr_lookups.meaning%TYPE;
849: l_pin hr_locations.postal_code%TYPE;
850: l_std hr_locations.TELEPHONE_NUMBER_1%TYPE;
851: l_telph hr_locations.TELEPHONE_NUMBER_1%TYPE;
852: l_mob hr_locations.TELEPHONE_NUMBER_1%TYPE; -- Bug 12332524
853: l_remark VARCHAR2(75);
854: p_address1 VARCHAR2(60);
855: p_address2 VARCHAR2(60);
856: p_address3 VARCHAR2(60);