PACKAGE: APPS.GMD_ROUTINGS_PVT

Source

1 PACKAGE GMD_ROUTINGS_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMDVROUS.pls 120.2 2010/11/04 20:11:05 rnalla ship $ */
3 
4   m_api_version   CONSTANT NUMBER         := 1;
5   m_pkg_name      CONSTANT VARCHAR2 (30)  := 'GMD_ROUTINGS_PVT';
6 
7   PROCEDURE insert_routing
8   ( p_routings          IN             gmd_routings%ROWTYPE
9   , x_message_count 	OUT NOCOPY     NUMBER
10   , x_message_list 	OUT NOCOPY     VARCHAR2
11   , x_return_status     OUT NOCOPY     VARCHAR2
12   );
13 
14   PROCEDURE update_routing
15   ( p_routing_id	IN	        gmd_routings.routing_id%TYPE    := NULL
16   , p_update_table	IN	        gmd_routings_pub.update_tbl_type
17   , x_message_count 	OUT NOCOPY 	NUMBER
18   , x_message_list 	OUT NOCOPY 	VARCHAR2
19   , x_return_status	OUT NOCOPY 	VARCHAR2
20   );
21   -- BUG 5197863 Added
22   Function Validate_dates
23   (p_routing_id  IN gmd_routings.routing_id%TYPE
24   ,p_effective_start_date IN DATE
25   ,p_effective_end_date  IN  DATE) RETURN NUMBER;
26 
27 END GMD_ROUTINGS_PVT;