DBA Data[Home] [Help]

PACKAGE: APPS.WSH_DSNO

Source


1 PACKAGE WSH_DSNO AUTHID CURRENT_USER as
2 /* $Header: WSHDSNOS.pls 120.0.12010000.1 2008/07/29 06:02:06 appldev ship $ */
3 
4   --
5   -- PROCEDURE:         Submit
6   -- Purpose:           Submit DSNO for a Trip Stop
7   -- Arguments:         p_trip_stop_id - Trip Stop Identifier
8   -- Description:       Submits DSNO for a trip stop
9   --
10 --  Bug 2425936 : added a parameter p_trip_id included in
11 --                concurrent program for performance issue
12 PROCEDURE Submit (
13 	errbuf	        OUT NOCOPY      VARCHAR2,
14 	retcode 	OUT NOCOPY      VARCHAR2,
15 	p_trip_id	IN	NUMBER  DEFAULT NULL,
16 	p_trip_stop_id	IN	NUMBER);
17 
18 
19 -- start bug 1578251: new procedure submit_trip_stop with x_completion_status
20   --
21   -- PROCEDURE:         Submit_Trip_stop
22   -- Purpose:           Submit DSNO for a Trip Stop
23   -- Arguments:         p_trip_stop_id - Trip Stop Identifier
24   --                    x_completion_status - result of this submission
25   -- Description:       Submits DSNO for a trip stop
26   --
27 
28 PROCEDURE Submit_Trip_Stop (
29 	p_trip_stop_id      IN	NUMBER,
30         x_completion_status OUT NOCOPY  VARCHAR2);
31 -- end bug 1578251: new procedure submit_trip_stop with x_completion_status
32 
33 
34 END WSH_DSNO;