[Home] [Help]
PACKAGE: APPS.PNRX_SP_ASSIGN_BY_LOC
Source
1 PACKAGE pnrx_sp_assign_by_loc AUTHID CURRENT_USER AS
2 /* $Header: PNRXSALS.pls 115.7 2002/11/14 20:24:19 stripath ship $ */
3
4 PROCEDURE pn_space_assign_loc(
5 property_code_low IN VARCHAR2,
6 property_code_high IN VARCHAR2,
7 location_code_low IN VARCHAR2,
8 location_code_high IN VARCHAR2,
9 location_type IN VARCHAR2,
10 as_of_date IN DATE,
11 report_type IN VARCHAR2,
12 l_request_id IN NUMBER,
13 l_user_id IN NUMBER,
14 retcode OUT NOCOPY VARCHAR2,
15 errbuf OUT NOCOPY VARCHAR2
16 );
17 FUNCTION compare_assign_emploc(
18 p_location_id IN NUMBER,
19 p_person_id IN NUMBER,
20 p_cost_center IN VARCHAR2,
21 p_request_id IN NUMBER)
22 RETURN BOOLEAN;
23
24 FUNCTION compare_assign_custloc(
25 p_location_id IN NUMBER,
26 p_account_id IN VARCHAR2,
27 p_request_id IN NUMBER)
28 RETURN BOOLEAN;
29 END pnrx_sp_assign_by_loc;