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.POS_WCAPPROVE_PVT dependencies on HR_LOCATIONS_ALL

Line 3960: X_location_code hr_locations_all.location_code%TYPE;

3956:
3957: X_emp_id number;
3958: X_emp_name per_employees_current_x.full_name%TYPE;
3959: X_location_id number;
3960: X_location_code hr_locations_all.location_code%TYPE;
3961: X_is_buyer BOOLEAN;
3962: X_emp_flag BOOLEAN;
3963: l_emp_ok BOOLEAN;
3964: l_uom_code mtl_units_of_measure.uom_code%type;

Line 5281: l_deliver_to_location hr_locations_all_tl.location_code%type;

5277:
5278: FUNCTION GET_DELIVER_TO_LOCATION (p_wc_id IN NUMBER)
5279: RETURN VARCHAR2 IS
5280: l_count number;
5281: l_deliver_to_location hr_locations_all_tl.location_code%type;
5282: begin
5283:
5284: select count(*)
5285: into l_count

Line 5286: from hr_locations_all_tl hl,

5282: begin
5283:
5284: select count(*)
5285: into l_count
5286: from hr_locations_all_tl hl,
5287: po_distributions_all pod
5288: where pod.deliver_to_location_id = hl.location_id and
5289: hl.language (+) =userenv('LANG') and
5290: pod.po_distribution_id = p_wc_id;

Line 5298: from hr_locations_all_tl hl,

5294: return to_char(null);
5295: else
5296: select hl.location_code
5297: into l_deliver_to_location
5298: from hr_locations_all_tl hl,
5299: po_distributions_all pod
5300: where pod.deliver_to_location_id = hl.location_id and
5301: hl.language (+) =userenv('LANG') and
5302: pod.po_distribution_id = p_wc_id;