1: PACKAGE pn_space_assign_cust_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNSPCUSS.pls 120.3 2005/07/12 11:33:20 appldev ship $ */
3:
4: tlcustinfo pn_space_assign_cust_all%ROWTYPE;
5:
1: PACKAGE pn_space_assign_cust_pkg AUTHID CURRENT_USER AS
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 (
185: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
186: );
187:
188: PROCEDURE delete_other_assignments_cust (
189: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,
190: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,
191: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,
192: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
193: );
186: );
187:
188: PROCEDURE delete_other_assignments_cust (
189: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,
190: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,
191: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,
192: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
193: );
194:
187:
188: PROCEDURE delete_other_assignments_cust (
189: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,
190: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,
191: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,
192: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
193: );
194:
195: END pn_space_assign_cust_pkg;
191: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,
192: x_loc_id_tbl OUT NOCOPY LOC_ID_TBL
193: );
194:
195: END pn_space_assign_cust_pkg;