DBA Data[Home] [Help]

APPS.GR_UPDATE_REBUILD_IND SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52

** 12-JUN-2001 Mercy Thomas  BUG 1766048 Added this procedure to update
**                                       the rebuild Indicator
** 11-Feb-2003 GK Bug 2190522 Made changes to the section update action = 4
**	and also I am only checking for items exploding for all
**	other update actions except 4.
*/

PROCEDURE Update_Rebuild_Flag
				(errbuf OUT NOCOPY VARCHAR2,
                                 retcode OUT NOCOPY VARCHAR2,
                                 p_commit IN VARCHAR2,
				 p_init_msg_list IN VARCHAR2,
				 p_validation_level IN NUMBER,
				 p_api_version IN NUMBER,
				 p_called_by_form IN VARCHAR2,
				 p_update_action IN NUMBER,
				 p_update_code IN VARCHAR2,
				 p_update_code1 IN VARCHAR2,
				 x_return_status OUT NOCOPY VARCHAR2,
				 x_msg_count OUT NOCOPY NUMBER,
				 x_msg_data OUT NOCOPY VARCHAR2)
IS
BEGIN

 NULL;
Line: 85

END Update_Rebuild_Flag;
Line: 115

** 12-JUN-2001 Mercy Thomas  BUG 1766048 Added this procedure to update
**                                       the rebuild Indicator
**
**
*/

PROCEDURE Handle_Error_Messages
				(p_called_by_form IN VARCHAR2,
				 p_message_code IN VARCHAR2,
				 p_token_name IN VARCHAR2,
				 p_token_value IN VARCHAR2,
				 x_msg_count IN OUT NOCOPY NUMBER,
				 x_msg_data IN OUT NOCOPY VARCHAR2,
				 x_return_status OUT NOCOPY VARCHAR2)
IS
BEGIN

 NULL;
Line: 147

**  The next stage is to check for and update any generic items.
*/

PROCEDURE Get_Item_Usage
                   (p_commit IN VARCHAR2,
				    p_called_by_form IN VARCHAR2,
					p_item_code IN VARCHAR2,
					p_document_code IN VARCHAR2,
				    x_msg_data OUT NOCOPY VARCHAR2,
					x_return_status OUT NOCOPY VARCHAR2)
IS
BEGIN

 NULL;