DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PUB dependencies on GMD_OPERATIONS

Line 1: PACKAGE GMD_OPERATIONS_PUB AS

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

Line 31: API Name : GMD_OPERATIONS_PUB

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

Line 60: * Call is made to insert_operation API of GMD_OPERATIONS_PVT package

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

Line 79: , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE

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

Line 80: , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type

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

Line 90: * Call is made to update_operation API of GMD_OPERATIONS_PVT package

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

Line 110: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL

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

Line 111: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL

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

Line 112: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL

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

Line 113: , p_update_table IN gmd_operations_pub.update_tbl_type

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

Line 122: * Call is made to delete_operation API of GMD_OPERATIONS_PVT package

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

Line 141: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL

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

Line 142: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL

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

Line 143: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL

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

Line 149: END GMD_OPERATIONS_PUB;

145: , x_message_list OUT NOCOPY VARCHAR2
146: , x_return_status OUT NOCOPY VARCHAR2
147: );
148:
149: END GMD_OPERATIONS_PUB;