DBA Data[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;