eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_ROUTINGS_PUB dependencies on GMD_ROUTINGS

Line 1: PACKAGE GMD_ROUTINGS_PUB AS

1: PACKAGE GMD_ROUTINGS_PUB AS
2: /* $Header: GMDPROUS.pls 120.1.12010000.1 2008/07/24 09:57:14 appldev ship $ */
3: /*#
4: * This interface is used to insert, update, delete and undelete routings
5: * This package defines and implements the procedures and datatypes

Line 16: m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_ROUTINGS_PUB';

12: * @rep:category BUSINESS_ENTITY GMD_ROUTING
13: */
14:
15: m_api_version CONSTANT NUMBER := 1;
16: m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_ROUTINGS_PUB';
17:
18: TYPE gmd_routings_step_tab IS TABLE OF fm_rout_dtl%ROWTYPE
19: INDEX BY BINARY_INTEGER;
20:

Line 18: TYPE gmd_routings_step_tab IS TABLE OF fm_rout_dtl%ROWTYPE

14:
15: m_api_version CONSTANT NUMBER := 1;
16: m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_ROUTINGS_PUB';
17:
18: TYPE gmd_routings_step_tab IS TABLE OF fm_rout_dtl%ROWTYPE
19: INDEX BY BINARY_INTEGER;
20:
21: TYPE gmd_routings_step_dep_tab IS TABLE OF fm_rout_dep%ROWTYPE
22: INDEX BY BINARY_INTEGER;

Line 21: TYPE gmd_routings_step_dep_tab IS TABLE OF fm_rout_dep%ROWTYPE

17:
18: TYPE gmd_routings_step_tab IS TABLE OF fm_rout_dtl%ROWTYPE
19: INDEX BY BINARY_INTEGER;
20:
21: TYPE gmd_routings_step_dep_tab IS TABLE OF fm_rout_dep%ROWTYPE
22: INDEX BY BINARY_INTEGER;
23:
24: /* define record and table type to specify the column that needs to
25: updated */

Line 40: * @param p_routings Row type of GMD_ROUTINGS table

36: * This is a PL/SQL procedure is responsible for inserting new routings
37: * @param p_api_version API version field
38: * @param p_init_msg_list Flag to check if message list intialized
39: * @param p_commit Flag to check for commit
40: * @param p_routings Row type of GMD_ROUTINGS table
41: * @param p_routings_step_tbl Table structure of Routings Step details table
42: * @param p_routings_step_dep_tbl Table structure of Routings Step dependency table
43: * @param x_message_count Number of msg's on message stack
44: * @param x_message_list Message list

Line 55: , p_routings IN gmd_routings%ROWTYPE

51: PROCEDURE insert_routing
52: ( p_api_version IN NUMBER := 1
53: , p_init_msg_list IN BOOLEAN := TRUE
54: , p_commit IN BOOLEAN := FALSE
55: , p_routings IN gmd_routings%ROWTYPE
56: , p_routings_step_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_tab
57: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
58: , x_message_count OUT NOCOPY NUMBER
59: , x_message_list OUT NOCOPY VARCHAR2

Line 56: , p_routings_step_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_tab

52: ( p_api_version IN NUMBER := 1
53: , p_init_msg_list IN BOOLEAN := TRUE
54: , p_commit IN BOOLEAN := FALSE
55: , p_routings IN gmd_routings%ROWTYPE
56: , p_routings_step_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_tab
57: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
58: , x_message_count OUT NOCOPY NUMBER
59: , x_message_list OUT NOCOPY VARCHAR2
60: , x_return_status OUT NOCOPY VARCHAR2

Line 57: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab

53: , p_init_msg_list IN BOOLEAN := TRUE
54: , p_commit IN BOOLEAN := FALSE
55: , p_routings IN gmd_routings%ROWTYPE
56: , p_routings_step_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_tab
57: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
58: , x_message_count OUT NOCOPY NUMBER
59: , x_message_list OUT NOCOPY VARCHAR2
60: , x_return_status OUT NOCOPY VARCHAR2
61: );

Line 85: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL

81: PROCEDURE update_routing
82: ( p_api_version IN NUMBER := 1
83: , p_init_msg_list IN BOOLEAN := TRUE
84: , p_commit IN BOOLEAN := FALSE
85: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
86: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
87: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
88: , p_update_table IN update_tbl_type
89: , x_message_count OUT NOCOPY NUMBER

Line 86: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

82: ( p_api_version IN NUMBER := 1
83: , p_init_msg_list IN BOOLEAN := TRUE
84: , p_commit IN BOOLEAN := FALSE
85: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
86: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
87: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
88: , p_update_table IN update_tbl_type
89: , x_message_count OUT NOCOPY NUMBER
90: , x_message_list OUT NOCOPY VARCHAR2

Line 87: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

83: , p_init_msg_list IN BOOLEAN := TRUE
84: , p_commit IN BOOLEAN := FALSE
85: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
86: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
87: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
88: , p_update_table IN update_tbl_type
89: , x_message_count OUT NOCOPY NUMBER
90: , x_message_list OUT NOCOPY VARCHAR2
91: , x_return_status OUT NOCOPY VARCHAR2

Line 115: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL

111: PROCEDURE delete_routing
112: ( p_api_version IN NUMBER := 1
113: , p_init_msg_list IN BOOLEAN := TRUE
114: , p_commit IN BOOLEAN := FALSE
115: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
116: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
117: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
118: , x_message_count OUT NOCOPY NUMBER
119: , x_message_list OUT NOCOPY VARCHAR2

Line 116: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

112: ( p_api_version IN NUMBER := 1
113: , p_init_msg_list IN BOOLEAN := TRUE
114: , p_commit IN BOOLEAN := FALSE
115: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
116: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
117: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
118: , x_message_count OUT NOCOPY NUMBER
119: , x_message_list OUT NOCOPY VARCHAR2
120: , x_return_status OUT NOCOPY VARCHAR2

Line 117: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

113: , p_init_msg_list IN BOOLEAN := TRUE
114: , p_commit IN BOOLEAN := FALSE
115: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
116: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
117: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
118: , x_message_count OUT NOCOPY NUMBER
119: , x_message_list OUT NOCOPY VARCHAR2
120: , x_return_status OUT NOCOPY VARCHAR2
121: );

Line 145: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL

141: PROCEDURE undelete_routing
142: ( p_api_version IN NUMBER := 1
143: , p_init_msg_list IN BOOLEAN := TRUE
144: , p_commit IN BOOLEAN := FALSE
145: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
146: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
147: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
148: , x_message_count OUT NOCOPY NUMBER
149: , x_message_list OUT NOCOPY VARCHAR2

Line 146: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

142: ( p_api_version IN NUMBER := 1
143: , p_init_msg_list IN BOOLEAN := TRUE
144: , p_commit IN BOOLEAN := FALSE
145: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
146: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
147: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
148: , x_message_count OUT NOCOPY NUMBER
149: , x_message_list OUT NOCOPY VARCHAR2
150: , x_return_status OUT NOCOPY VARCHAR2

Line 147: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

143: , p_init_msg_list IN BOOLEAN := TRUE
144: , p_commit IN BOOLEAN := FALSE
145: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
146: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
147: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
148: , x_message_count OUT NOCOPY NUMBER
149: , x_message_list OUT NOCOPY VARCHAR2
150: , x_return_status OUT NOCOPY VARCHAR2
151: );

Line 154: END GMD_ROUTINGS_PUB;

150: , x_return_status OUT NOCOPY VARCHAR2
151: );
152:
153:
154: END GMD_ROUTINGS_PUB;