DBA Data[Home] [Help]

APPS.PN_SPACE_ASSIGN_CUST_PKG dependencies on PN_LOCATIONS_ALL

Line 157: PROCEDURE assignment_split(p_location_id IN PN_LOCATIONS_ALL.location_id%TYPE,

153:
154: FUNCTION check_assign_arcl_line(p_cust_space_assign_id IN NUMBER)
155: RETURN BOOLEAN;
156:
157: PROCEDURE assignment_split(p_location_id IN PN_LOCATIONS_ALL.location_id%TYPE,
158: p_start_date IN pn_locations_all.active_start_date%TYPE,
159: p_end_date IN pn_locations_all.active_end_date%TYPE);
160:
161: Procedure AREA_PCT_AND_AREA (

Line 158: p_start_date IN pn_locations_all.active_start_date%TYPE,

154: FUNCTION check_assign_arcl_line(p_cust_space_assign_id IN NUMBER)
155: RETURN BOOLEAN;
156:
157: PROCEDURE assignment_split(p_location_id IN PN_LOCATIONS_ALL.location_id%TYPE,
158: p_start_date IN pn_locations_all.active_start_date%TYPE,
159: p_end_date IN pn_locations_all.active_end_date%TYPE);
160:
161: Procedure AREA_PCT_AND_AREA (
162: x_usable_area number,

Line 159: p_end_date IN pn_locations_all.active_end_date%TYPE);

155: RETURN BOOLEAN;
156:
157: PROCEDURE assignment_split(p_location_id IN PN_LOCATIONS_ALL.location_id%TYPE,
158: p_start_date IN pn_locations_all.active_start_date%TYPE,
159: p_end_date IN pn_locations_all.active_end_date%TYPE);
160:
161: Procedure AREA_PCT_AND_AREA (
162: x_usable_area number,
163: x_location_id number,

Line 179: PROCEDURE Defrag_Contig_Assign(p_location_id IN pn_locations_all.location_id%TYPE);

175: x_start_date IN date,
176: x_end_date IN date)
177: RETURN NUMBER;
178:
179: PROCEDURE Defrag_Contig_Assign(p_location_id IN pn_locations_all.location_id%TYPE);
180:
181: PROCEDURE delete_other_assignments_emp (
182: x_person_id IN pn_space_assign_emp.person_id%TYPE,
183: x_emp_assign_start_date IN pn_space_assign_emp.emp_assign_start_date%TYPE,