APPS.CS_SR_SAVED_ADV_CRITERIA_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (  X_ROWID in out nocopy VARCHAR2,
		    X_SEARCH_ID in NUMBER,
		    X_FIELD_NAME in VARCHAR2,
		    X_ROWNUM_IN_LAYOUT in NUMBER,
		    X_FIELD_NAME_ID in VARCHAR2,
		    X_CONDITION in VARCHAR2,
		    X_FIELD_VALUE_ID in VARCHAR2,
		    X_OBJECT_VERSION_NUMBER in NUMBER,
		    X_FIELD_VALUE in VARCHAR2,
		    X_CREATION_DATE in DATE,
		    X_CREATED_BY in NUMBER,
		    X_LAST_UPDATE_DATE in DATE,
		    X_LAST_UPDATED_BY in NUMBER,
		    X_LAST_UPDATE_LOGIN in NUMBER,
                    X_COMMIT_FLAG in VARCHAR2) is

	cursor C is select ROWID from CS_SR_SAVED_ADV_CRITERIA
	where SEARCH_ID = X_SEARCH_ID
	and FIELD_NAME = X_FIELD_NAME ;

Line: 26

	insert into CS_SR_SAVED_ADV_CRITERIA (
			       ROWNUM_IN_LAYOUT,
			       FIELD_NAME,
			       FIELD_NAME_ID,
			       CONDITION,
			       FIELD_VALUE,
			       FIELD_VALUE_ID,
			       OBJECT_VERSION_NUMBER,
			       LAST_UPDATE_LOGIN,
			       SEARCH_ID,
			       LAST_UPDATE_DATE,
			       LAST_UPDATED_BY,
			       CREATION_DATE,
			       CREATED_BY    )
                      values    (X_ROWNUM_IN_LAYOUT,
			        X_FIELD_NAME,
                                X_FIELD_NAME_ID,
                                X_CONDITION,
                                X_FIELD_VALUE,
                                X_FIELD_VALUE_ID,
                                X_OBJECT_VERSION_NUMBER,
                                X_LAST_UPDATE_LOGIN,
		                X_SEARCH_ID,
				X_LAST_UPDATE_DATE,
			        X_LAST_UPDATED_BY,
			        X_CREATION_DATE,
			        X_CREATED_BY);

Line: 67

end INSERT_ROW;

Line: 83

procedure UPDATE_ROW (  X_SEARCH_ID in NUMBER,
		      X_FIELD_NAME in VARCHAR2,
		      X_ROWNUM_IN_LAYOUT in NUMBER,
		      X_FIELD_NAME_ID in VARCHAR2,
		      X_CONDITION in VARCHAR2,
		      X_FIELD_VALUE_ID in VARCHAR2,
		      X_OBJECT_VERSION_NUMBER in NUMBER,
		      X_SECURITY_GROUP_ID in NUMBER,
		      X_FIELD_VALUE in VARCHAR2,
		      X_LAST_UPDATE_DATE in DATE,
		      X_LAST_UPDATED_BY in NUMBER,
		      X_LAST_UPDATE_LOGIN in NUMBER) is

begin
       null;

Line: 99

end UPDATE_ROW;

Line: 101

procedure DELETE_ROW (  X_SEARCH_ID in NUMBER) is

begin

           delete from CS_SR_SAVED_ADV_CRITERIA
           where SEARCH_ID = X_SEARCH_ID;

Line: 112

end DELETE_ROW;