DBA Data[Home] [Help]

APPS.PN_SPACE_ASSIGN_CUST_PKG dependencies on PN_SPACE_ASSIGN_CUST

Line 1: PACKAGE pn_space_assign_cust_pkg AUTHID CURRENT_USER AS

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:

Line 4: tlcustinfo pn_space_assign_cust_all%ROWTYPE;

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 (

Line 189: x_cust_account_id IN pn_space_assign_cust.cust_account_id%TYPE,

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: );

Line 190: x_cust_assign_start_date IN pn_space_assign_cust.cust_assign_start_date%TYPE,

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:

Line 191: x_cust_space_assign_id IN pn_space_assign_cust.cust_space_assign_id%TYPE,

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;

Line 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;