APPS.GR_PROCESS_DOCUMENTS SQL Statements

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

Line: 223

PROCEDURE Third_Phrase_Insert_Row
			                           (p_session_id IN NUMBER,
                                 p_sequence_number IN NUMBER,
                                 p_source_itemcode IN VARCHAR2,
                                 p_document_code IN VARCHAR2,
                                 p_main_heading_code IN VARCHAR2,
                                 p_main_display_order IN NUMBER,
                                 p_sub_heading_code IN VARCHAR2,
                                 p_sub_display_order IN NUMBER,
                                 p_structure_display_order IN NUMBER,
                                 p_third_phrase IN VARCHAR2,
                                 x_return_status OUT NOCOPY VARCHAR2)
	IS
BEGIN

 NULL;

Line: 240

END Third_Phrase_Insert_Row;

Line: 301

PROCEDURE Insert_Worksheet_Message
						(p_message_name IN VARCHAR2,
						 p_token_name IN VARCHAR2,
						 p_token_value IN VARCHAR2,
						 p_item_code IN VARCHAR2,
						 x_return_status OUT NOCOPY VARCHAR2,
						 p_token_name2 IN VARCHAR2,
						 p_token_value2 IN VARCHAR2)
	IS
BEGIN

 NULL;

Line: 321

END Insert_Worksheet_Message;

Line: 425

/*  12-May-2003  Geraldine Kelly  Bug 2948796 - Modified code to check for the document version label 00006 and that it selects from the
				   Item_Doc_Statuses table in procedure Print_Label_Lines.*/

PROCEDURE Print_Label_Lines
				(p_label_code IN VARCHAR2,
				 p_source_action IN VARCHAR2,
				 x_return_status OUT NOCOPY VARCHAR2)
 	IS
BEGIN

 NULL;

Line: 473

PROCEDURE Update_Phrase_Groups
				(p_commit IN VARCHAR2,
				 p_api_version IN NUMBER,
				 p_init_msg_list IN VARCHAR2,
				 p_validation_level IN NUMBER,
				 p_called_by_form IN VARCHAR2,
				 p_update_option IN VARCHAR2,
				 p_rebuild_document_flag IN VARCHAR2,
				 p_phrase_group_code IN VARCHAR2,
				 p_phrase_code IN VARCHAR2,
				 x_return_status OUT NOCOPY VARCHAR2,
				 x_msg_count OUT NOCOPY NUMBER,
				 x_msg_data OUT NOCOPY VARCHAR2)
	IS
BEGIN

 NULL;

Line: 497

END Update_Phrase_Groups;

Line: 1192

                            p_last_updated_by       IN  NUMBER,
                            p_last_update_login     IN  NUMBER,
                            p_last_update_date      IN  DATE,
                            x_return_status        OUT  NOCOPY  VARCHAR2,
                            x_msg_data             OUT  NOCOPY  VARCHAR2)  IS
BEGIN

 NULL;