APPS.BIS_RS_RUN_HISTORY_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(p_Request_set_id   NUMBER
			, p_Set_app_id       NUMBER
			, p_request_set_name VARCHAR2
			, p_Request_id       NUMBER
			, p_rs_refresh_type  VARCHAR2
			, p_Start_date       DATE
			, p_Completion_date  DATE
			, p_Phase_code	     Varchar2
			, p_Status_code      VARCHAR2
			, p_Creation_date    DATE
			, p_Created_by       NUMBER
			, p_Last_update_date DATE
			, p_Last_updated_by  NUMBER
                        , p_completion_text  VARCHAR2)
IS
CURSOR C_check IS SELECT ROWID from BIS_RS_RUN_HISTORY
where Request_set_id =p_Request_set_id;

Line: 23

insert into BIS_RS_RUN_HISTORY
			(Request_set_id
			,Set_app_id
			,Request_id
			,request_set_type
			,Start_date
			,Completion_date
			, Phase_code
			, Status_code
			, Creation_date
			, Created_by
			, Last_update_date
			, Last_updated_by
                        , Completion_Text
			, REQUEST_SET_NAME)
			values
			( p_Request_set_id
			, p_Set_app_id
			, p_Request_id
			, p_rs_refresh_type
			, p_Start_date
			, p_Completion_date
			, p_Phase_code
			, p_Status_code
			, p_Creation_date
			, p_Created_by
			, p_Last_update_date
			, p_Last_updated_by
			, p_completion_text
			, p_request_set_name
			);

Line: 64

     BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Insert_Row ' ||  sqlerrm);

Line: 68

FUNCTION Update_Row ( p_Request_id       NUMBER
			, p_Request_set_id        NUMBER     DEFAULT NULL
			, p_Set_app_id       NUMBER DEFAULT NULL
			, p_Start_date       DATE DEFAULT NULL
			, p_Completion_date  DATE DEFAULT NULL
			, p_Phase_code	     VARCHAR2 DEFAULT NULL
			, p_Status_code      VARCHAR2 DEFAULT NULL
			, p_Last_update_date DATE
			, p_Last_updated_by  NUMBER
                        , p_completion_text  VARCHAR2  DEFAULT NULL) RETURN boolean
IS
setClause varchar2(1024):=null;

Line: 108

setClause :=setClause || 'Last_update_date = ''' || p_Last_update_date  || ''', ' ;

Line: 109

setClause :=setClause || 'Last_updated_by= ' || p_Last_updated_by ;

Line: 112

stmt := 'update BIS_RS_RUN_HISTORY set ' || setClause ;

Line: 119

  update BIS_RS_RUN_HISTORY
  set Completion_text = p_completion_text
  where Request_id = p_Request_id;

Line: 129

     BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Update_Row ' ||  sqlerrm);

Line: 135

PROCEDURE Delete_Row(p_last_update_date date)
IS
BEGIN

	DELETE FROM BIS_RS_RUN_HISTORY
	   WHERE Last_update_date <= p_last_update_date;

Line: 145

     BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Delete_Row ' ||  sqlerrm);