APPS.GMD_ROUTINGS_PVT dependencies on GMD_ROUTINGS

Line 1: PACKAGE GMD_ROUTINGS_PVT AS

1: PACKAGE GMD_ROUTINGS_PVT AS
2: /* $Header: GMDVROUS.pls 120.1.12010000.1 2008/07/24 10:02:19 appldev ship $ */
3:
4: m_api_version CONSTANT NUMBER := 1;
5: m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_ROUTINGS_PVT';

Line 5: m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_ROUTINGS_PVT';

1: PACKAGE GMD_ROUTINGS_PVT AS
2: /* $Header: GMDVROUS.pls 120.1.12010000.1 2008/07/24 10:02:19 appldev 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

Line 8: ( p_routings IN gmd_routings%ROWTYPE

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: );

Line 15: ( p_routing_id IN gmd_routings.routing_id%TYPE := NULL

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

Line 16: , p_update_table IN gmd_routings_pub.update_tbl_type

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: );

Line 23: (p_routing_id IN gmd_routings.routing_id%TYPE

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;

Line 27: END GMD_ROUTINGS_PVT;

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;