1: PACKAGE GMD_OPERATIONS_PUB AS
2: /* $Header: GMDPOPSS.pls 120.1 2006/10/03 18:11:45 rajreddy noship $ */
3: /*#
4: * This interface is used to create, update and delete operations.
5: * This package defines and implements the procedures and datatypes
27: | added to proceudre to pass the resource|
28: | details for activities w.r.t. |
29: | bug# 3408799 |
30: +=========================================================================+
31: API Name : GMD_OPERATIONS_PUB
32: Type : Public
33: Function : This package contains public procedures used to create, modify, and delete operations
34: Pre-reqs : N/A
35: Parameters: Per function
56:
57: /*#
58: * Insert a new Operation
59: * This is a PL/SQL procedure to insert a new Operation in Operations Table
60: * Call is made to insert_operation API of GMD_OPERATIONS_PVT package
61: * @param p_api_version API version field
62: * @param p_init_msg_list Flag to check if message list intialized
63: * @param p_commit Flag to check for commit
64: * @param p_operations Row type of Operations table
75: PROCEDURE insert_operation
76: ( p_api_version IN NUMBER DEFAULT 1
77: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
78: , p_commit IN BOOLEAN DEFAULT FALSE
79: , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
80: , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
81: , x_message_count OUT NOCOPY NUMBER
82: , x_message_list OUT NOCOPY VARCHAR2
83: , x_return_status OUT NOCOPY VARCHAR2
76: ( p_api_version IN NUMBER DEFAULT 1
77: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
78: , p_commit IN BOOLEAN DEFAULT FALSE
79: , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
80: , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
81: , x_message_count OUT NOCOPY NUMBER
82: , x_message_list OUT NOCOPY VARCHAR2
83: , x_return_status OUT NOCOPY VARCHAR2
84: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type --Added w.r.t. bug 3408799
86:
87: /*#
88: * Update an Operation
89: * This is a PL/SQL procedure to update an Operation in Operations Table
90: * Call is made to update_operation API of GMD_OPERATIONS_PVT package
91: * @param p_api_version API version field
92: * @param p_init_msg_list Flag to check if message list intialized
93: * @param p_commit Flag to check for commit
94: * @param p_oprn_id Operation ID
106: PROCEDURE update_operation
107: ( p_api_version IN NUMBER DEFAULT 1
108: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
109: , p_commit IN BOOLEAN DEFAULT FALSE
110: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
111: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
112: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
113: , p_update_table IN gmd_operations_pub.update_tbl_type
114: , x_message_count OUT NOCOPY NUMBER
107: ( p_api_version IN NUMBER DEFAULT 1
108: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
109: , p_commit IN BOOLEAN DEFAULT FALSE
110: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
111: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
112: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
113: , p_update_table IN gmd_operations_pub.update_tbl_type
114: , x_message_count OUT NOCOPY NUMBER
115: , x_message_list OUT NOCOPY VARCHAR2
108: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
109: , p_commit IN BOOLEAN DEFAULT FALSE
110: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
111: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
112: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
113: , p_update_table IN gmd_operations_pub.update_tbl_type
114: , x_message_count OUT NOCOPY NUMBER
115: , x_message_list OUT NOCOPY VARCHAR2
116: , x_return_status OUT NOCOPY VARCHAR2
109: , p_commit IN BOOLEAN DEFAULT FALSE
110: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
111: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
112: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
113: , p_update_table IN gmd_operations_pub.update_tbl_type
114: , x_message_count OUT NOCOPY NUMBER
115: , x_message_list OUT NOCOPY VARCHAR2
116: , x_return_status OUT NOCOPY VARCHAR2
117: );
118:
119: /*#
120: * Delete an Operation
121: * This is a PL/SQL procedure to delete an Operation in Operations Table
122: * Call is made to delete_operation API of GMD_OPERATIONS_PVT package
123: * @param p_api_version API version field
124: * @param p_init_msg_list Flag to check if message list intialized
125: * @param p_commit Flag to check for commit
126: * @param p_oprn_id Operation ID
137: PROCEDURE delete_operation
138: ( p_api_version IN NUMBER DEFAULT 1
139: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
140: , p_commit IN BOOLEAN DEFAULT FALSE
141: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
142: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
143: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
144: , x_message_count OUT NOCOPY NUMBER
145: , x_message_list OUT NOCOPY VARCHAR2
138: ( p_api_version IN NUMBER DEFAULT 1
139: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
140: , p_commit IN BOOLEAN DEFAULT FALSE
141: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
142: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
143: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
144: , x_message_count OUT NOCOPY NUMBER
145: , x_message_list OUT NOCOPY VARCHAR2
146: , x_return_status OUT NOCOPY VARCHAR2
139: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
140: , p_commit IN BOOLEAN DEFAULT FALSE
141: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
142: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
143: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
144: , x_message_count OUT NOCOPY NUMBER
145: , x_message_list OUT NOCOPY VARCHAR2
146: , x_return_status OUT NOCOPY VARCHAR2
147: );
145: , x_message_list OUT NOCOPY VARCHAR2
146: , x_return_status OUT NOCOPY VARCHAR2
147: );
148:
149: END GMD_OPERATIONS_PUB;