DBA Data[Home] [Help]

APPS.PN_SPACE_ASSIGN_CUST_PKG dependencies on PN_LOCATIONS

Line 6: TYPE loc_id_tbl IS TABLE OF pn_locations.location_id%TYPE INDEX BY BINARY_INTEGER;

2: /* $Header: PNSPCUSS.pls 120.3 2005/07/12 11:33:20 appldev ship $ */
3:
4: tlcustinfo pn_space_assign_cust_all%ROWTYPE;
5:
6: TYPE loc_id_tbl IS TABLE OF pn_locations.location_id%TYPE INDEX BY BINARY_INTEGER;
7:
8: PROCEDURE Insert_Row (
9: X_ROWID IN OUT NOCOPY VARCHAR2,
10: X_CUST_SPACE_ASSIGN_ID IN OUT NOCOPY NUMBER,

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,