PACKAGE: APPS.FTE_WSH_INTERFACE_PKG

Source

1 PACKAGE FTE_WSH_INTERFACE_PKG AUTHID CURRENT_USER AS
2 /* $Header: FTEWSHIS.pls 120.1 2005/06/03 16:27:52 appldev  $ */
3 --{
4     G_PKG_NAME      CONSTANT VARCHAR2(30):= 'FTE_WSH_INTERFACE_PKG';
5     --
6     --
7     -- These constants indicate type of change for each record.
8     --
9     G_ADD       CONSTANT VARCHAR2(30) := 'ADD';
10     G_UPDATE    CONSTANT VARCHAR2(30) := 'UPDATE';
11     G_DELETE    CONSTANT VARCHAR2(30) := 'DELETE';
12     G_NO_CHANGE CONSTANT VARCHAR2(30) := 'NO_CHANGE';
13     G_TRIP_SEGMENT_DELETE CONSTANT VARCHAR2(30) := 'TRIP_SEGMENT_DELETE';
14     --
15     --
16     TYPE tripSegmentChangeInRecType
17     IS
18     RECORD
19       (
20         action_type VARCHAR2(32767)
21       );
22     --
23     --
24     TYPE tripSegmentChangeOutRecType
25     IS
26     RECORD
27       (
28         parameter1 VARCHAR2(32767) DEFAULT FND_API.G_MISS_CHAR
29       );
30     --
31     --
32     TYPE segmentStopChangeInRecType
33     IS
34     RECORD
35       (
36         action_type VARCHAR2(32767)
37       );
38     --
39     --
40     TYPE segmentStopChangeOutRecType
41     IS
42     RECORD
43       (
44         parameter1 VARCHAR2(32767) DEFAULT FND_API.G_MISS_CHAR
45       );
46     --
47     --
48     --
49     PROCEDURE trip_segment_change
50 		(
51 	          P_api_version		    IN	   NUMBER,
52 	          P_init_msg_list	    IN	   VARCHAR2 DEFAULT FND_API.G_FALSE,
53 	          P_commit		    IN	   VARCHAR2 DEFAULT FND_API.G_FALSE,
54 	          X_return_status	    OUT NOCOPY	   VARCHAR2,
55 	          X_msg_count		    OUT NOCOPY	   NUMBER,
56 	          X_msg_data		    OUT NOCOPY	   VARCHAR2,
57 	          P_old_trip_segment_rec    IN	   WSH_TRIPS_PVT.Trip_Rec_Type,
58 	          P_new_trip_segment_rec    IN	   WSH_TRIPS_PVT.Trip_Rec_Type,
59 		  p_tripSegmentChangeInRec  IN     tripSegmentChangeInRecType,
60 		  p_tripSegmentChangeOutRec OUT NOCOPY    tripSegmentChangeOutRecType
61 		);
62     --
63     --
64     PROCEDURE segment_stop_change
65 		(
66 	          P_api_version		    IN	   NUMBER,
67 	          P_init_msg_list	    IN	   VARCHAR2 DEFAULT FND_API.G_FALSE,
68 	          P_commit		    IN	   VARCHAR2 DEFAULT FND_API.G_FALSE,
69 	          X_return_status	    OUT NOCOPY	   VARCHAR2,
70 	          X_msg_count		    OUT NOCOPY	   NUMBER,
71 	          X_msg_data		    OUT NOCOPY	   VARCHAR2,
72 	          P_trip_segment_rec        IN	   WSH_TRIPS_PVT.Trip_Rec_Type,
73 	          P_old_segment_stop_rec    IN	   WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
74 	          P_new_segment_stop_rec    IN	   WSH_TRIP_STOPS_PVT.trip_stop_rec_type,
75 		  p_segmentStopChangeInRec  IN     segmentStopChangeInRecType,
76 		  p_segmentStopChangeOutRec OUT NOCOPY     segmentStopChangeOutRecType
77 		);
78 --}
79 
80 --{
81 -- Rel12 HBHAGAVA
82 
83 PROCEDURE GET_ORG_ORGANIZATION_INFO(
84 	    p_init_msg_list          IN   		VARCHAR2,
85 	    x_return_status          OUT NOCOPY 	VARCHAR2,
86 	    x_msg_count              OUT NOCOPY 	NUMBER,
87 	    x_msg_data               OUT NOCOPY 	VARCHAR2,
88 	    x_organization_id	     OUT NOCOPY		NUMBER,
89 	    x_org_id		     OUT NOCOPY		NUMBER,
90 	    p_entity_id	     	     IN			NUMBER,
91 	    p_entity_type	     IN			VARCHAR2,
92 	    p_org_id_flag	     IN			VARCHAR2 DEFAULT FND_API.G_FALSE);
93 
94 
95 --}
96 
97 END FTE_WSH_INTERFACE_PKG;