DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PUB dependencies on GMD_OPERATIONS

Line 1: PACKAGE GMD_OPERATIONS_PUB AUTHID CURRENT_USER AS

1: PACKAGE GMD_OPERATIONS_PUB AUTHID CURRENT_USER AS
2: /* $Header: GMDPOPSS.pls 120.1.12020000.2 2012/10/25 07:22:21 yanpewan ship $ */
3: /*#
4: * This interface is used to create, update and delete operations.
5: * This package defines and implements the procedures and datatypes

Line 36: API Name : GMD_OPERATIONS_PUB

32: | characters for update operation |
33: | description through api. |
34: | |
35: +=========================================================================+
36: API Name : GMD_OPERATIONS_PUB
37: Type : Public
38: Function : This package contains public procedures used to create, modify, and delete operations
39: Pre-reqs : N/A
40: Parameters: Per function

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

61:
62: /*#
63: * Insert a new Operation
64: * This is a PL/SQL procedure to insert a new Operation in Operations Table
65: * Call is made to insert_operation API of GMD_OPERATIONS_PVT package
66: * @param p_api_version API version field
67: * @param p_init_msg_list Flag to check if message list intialized
68: * @param p_commit Flag to check for commit
69: * @param p_operations Row type of Operations table

Line 84: , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE

80: PROCEDURE insert_operation
81: ( p_api_version IN NUMBER DEFAULT 1
82: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
83: , p_commit IN BOOLEAN DEFAULT FALSE
84: , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
85: , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
86: , x_message_count OUT NOCOPY NUMBER
87: , x_message_list OUT NOCOPY VARCHAR2
88: , x_return_status OUT NOCOPY VARCHAR2

Line 85: , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type

81: ( p_api_version IN NUMBER DEFAULT 1
82: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
83: , p_commit IN BOOLEAN DEFAULT FALSE
84: , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
85: , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
86: , x_message_count OUT NOCOPY NUMBER
87: , x_message_list OUT NOCOPY VARCHAR2
88: , x_return_status OUT NOCOPY VARCHAR2
89: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type --Added w.r.t. bug 3408799

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

91:
92: /*#
93: * Update an Operation
94: * This is a PL/SQL procedure to update an Operation in Operations Table
95: * Call is made to update_operation API of GMD_OPERATIONS_PVT package
96: * @param p_api_version API version field
97: * @param p_init_msg_list Flag to check if message list intialized
98: * @param p_commit Flag to check for commit
99: * @param p_oprn_id Operation ID

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

111: PROCEDURE update_operation
112: ( p_api_version IN NUMBER DEFAULT 1
113: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
114: , p_commit IN BOOLEAN DEFAULT FALSE
115: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
116: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
117: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
118: , p_update_table IN gmd_operations_pub.update_tbl_type
119: , x_message_count OUT NOCOPY NUMBER

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

112: ( p_api_version IN NUMBER DEFAULT 1
113: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
114: , p_commit IN BOOLEAN DEFAULT FALSE
115: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
116: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
117: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
118: , p_update_table IN gmd_operations_pub.update_tbl_type
119: , x_message_count OUT NOCOPY NUMBER
120: , x_message_list OUT NOCOPY VARCHAR2

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

113: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
114: , p_commit IN BOOLEAN DEFAULT FALSE
115: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
116: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
117: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
118: , p_update_table IN gmd_operations_pub.update_tbl_type
119: , x_message_count OUT NOCOPY NUMBER
120: , x_message_list OUT NOCOPY VARCHAR2
121: , x_return_status OUT NOCOPY VARCHAR2

Line 118: , p_update_table IN gmd_operations_pub.update_tbl_type

114: , p_commit IN BOOLEAN DEFAULT FALSE
115: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
116: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
117: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
118: , p_update_table IN gmd_operations_pub.update_tbl_type
119: , x_message_count OUT NOCOPY NUMBER
120: , x_message_list OUT NOCOPY VARCHAR2
121: , x_return_status OUT NOCOPY VARCHAR2
122: );

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

123:
124: /*#
125: * Delete an Operation
126: * This is a PL/SQL procedure to delete an Operation in Operations Table
127: * Call is made to delete_operation API of GMD_OPERATIONS_PVT package
128: * @param p_api_version API version field
129: * @param p_init_msg_list Flag to check if message list intialized
130: * @param p_commit Flag to check for commit
131: * @param p_oprn_id Operation ID

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

142: PROCEDURE delete_operation
143: ( p_api_version IN NUMBER DEFAULT 1
144: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
145: , p_commit IN BOOLEAN DEFAULT FALSE
146: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
147: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
148: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
149: , x_message_count OUT NOCOPY NUMBER
150: , x_message_list OUT NOCOPY VARCHAR2

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

143: ( p_api_version IN NUMBER DEFAULT 1
144: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
145: , p_commit IN BOOLEAN DEFAULT FALSE
146: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
147: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
148: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
149: , x_message_count OUT NOCOPY NUMBER
150: , x_message_list OUT NOCOPY VARCHAR2
151: , x_return_status OUT NOCOPY VARCHAR2

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

144: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
145: , p_commit IN BOOLEAN DEFAULT FALSE
146: , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
147: , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
148: , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
149: , x_message_count OUT NOCOPY NUMBER
150: , x_message_list OUT NOCOPY VARCHAR2
151: , x_return_status OUT NOCOPY VARCHAR2
152: );

Line 154: END GMD_OPERATIONS_PUB;

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