PACKAGE: APPS.GMD_ROUTING_STEPS_PVT

Source

1 PACKAGE GMD_ROUTING_STEPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: GMDVRTSS.pls 115.2 2002/11/07 20:31:02 rajreddy noship $ */
3 
4   m_api_version   CONSTANT NUMBER         := 1;
5   m_pkg_name      CONSTANT VARCHAR2 (30)  := 'GMD_ROUTING_STEPS_PVT';
6 
7 PROCEDURE insert_routing_steps
8 (
9   p_routing_id             IN   gmd_routings.routing_id%TYPE
10 , p_routing_step_rec       IN   fm_rout_dtl%ROWTYPE
11 , x_return_status          OUT NOCOPY  VARCHAR2
12 );
13 
14 PROCEDURE insert_step_dependencies
15 (
16   p_routing_id             IN   gmd_routings.routing_id%TYPE
17 , p_routingstep_no         IN   fm_rout_dtl.routingstep_no%TYPE
18 , p_routings_step_dep_tbl  IN   gmd_routings_pub.gmd_routings_step_dep_tab
19 , x_return_status          OUT NOCOPY 	VARCHAR2
20 );
21 
22 PROCEDURE update_routing_steps
23 ( p_routingstep_id	IN	fm_rout_dtl.routingstep_id%TYPE
24 , p_update_table	IN	gmd_routings_pub.update_tbl_type
25 , x_return_status       OUT NOCOPY     VARCHAR2
26 );
27 
28 PROCEDURE update_step_dependencies
29 ( p_routingstep_no	IN	fm_rout_dep.routingstep_no%TYPE
30 , p_dep_routingstep_no	IN	fm_rout_dep.routingstep_no%TYPE
31 , p_routing_id 		IN	fm_rout_dep.routing_id%TYPE
32 , p_update_table	IN	gmd_routings_pub.update_tbl_type
33 , x_return_status       OUT NOCOPY     VARCHAR2
34 );
35 
36 PROCEDURE delete_routing_step
37 ( p_routingstep_id	IN	fm_rout_dtl.routingstep_id%TYPE
38 , p_routing_id 		IN	gmd_routings.routing_id%TYPE 	:=  NULL
39 , x_return_status       OUT NOCOPY     VARCHAR2
40 );
41 
42 PROCEDURE delete_step_dependencies
43 ( p_routingstep_no	IN	fm_rout_dep.routingstep_no%TYPE
44 , p_dep_routingstep_no	IN	fm_rout_dep.routingstep_no%TYPE := NULL
45 , p_routing_id 		IN	fm_rout_dep.routing_id%TYPE
46 , x_return_status       OUT NOCOPY     VARCHAR2
47 );
48 
49 
50 END GMD_ROUTING_STEPS_PVT;