[Home] [Help]
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;