APPS.AR_BPA_RULE_TEMPLATES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_RULE_TEMPLATE_ID in NUMBER,
  X_TEMPLATE_ID in NUMBER,
  X_RULE_ID in NUMBER,
  X_EFFECTIVE_FROM_DATE in DATE,
  X_EFFECTIVE_TO_DATE in DATE,
  X_ASSIGNED_TEMPLATE_PURPOSE 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
) is
  cursor C is select ROWID from AR_BPA_RULE_TEMPLATES
    where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID
    ;

Line: 21

  insert into AR_BPA_RULE_TEMPLATES (
    RULE_TEMPLATE_ID,
    TEMPLATE_ID,
    RULE_ID,
    EFFECTIVE_FROM_DATE,
    EFFECTIVE_TO_DATE,
    ASSIGNED_TEMPLATE_PURPOSE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  ) select
    X_RULE_TEMPLATE_ID,
    X_TEMPLATE_ID,
    X_RULE_ID,
    X_EFFECTIVE_FROM_DATE,
    X_EFFECTIVE_TO_DATE,
    X_ASSIGNED_TEMPLATE_PURPOSE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN
  from dual;

Line: 55

end INSERT_ROW;

Line: 65

  cursor c is select
      RULE_TEMPLATE_ID,
      TEMPLATE_ID,
      RULE_ID,
      EFFECTIVE_FROM_DATE,
      EFFECTIVE_TO_DATE,
      ASSIGNED_TEMPLATE_PURPOSE
    from AR_BPA_RULE_TEMPLATES
    where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID
    for update of RULE_TEMPLATE_ID nowait;

Line: 82

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 103

procedure UPDATE_ROW (
  X_RULE_TEMPLATE_ID in NUMBER,
  X_TEMPLATE_ID in NUMBER,
  X_RULE_ID in NUMBER,
  X_EFFECTIVE_FROM_DATE in DATE,
  X_EFFECTIVE_TO_DATE in DATE,
  X_ASSIGNED_TEMPLATE_PURPOSE IN VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AR_BPA_RULE_TEMPLATES set
    RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID,
    TEMPLATE_ID = X_TEMPLATE_ID,
    RULE_ID = X_RULE_ID,
    EFFECTIVE_FROM_DATE = X_EFFECTIVE_FROM_DATE,
    EFFECTIVE_TO_DATE = X_EFFECTIVE_TO_DATE,
    ASSIGNED_TEMPLATE_PURPOSE = X_ASSIGNED_TEMPLATE_PURPOSE ,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID;

Line: 130

end UPDATE_ROW;

Line: 132

procedure DELETE_ROW (
  X_RULE_TEMPLATE_ID in NUMBER
) is
begin
  delete from AR_BPA_RULE_TEMPLATES
  where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID;

Line: 143

end DELETE_ROW;

Line: 163

    AR_BPA_RULE_TEMPLATES_PKG.UPDATE_ROW (
        X_RULE_TEMPLATE_ID 		=> X_RULE_TEMPLATE_ID,
        X_TEMPLATE_ID 			=> X_TEMPLATE_ID,
        X_RULE_ID 				=> X_RULE_ID,
        X_EFFECTIVE_FROM_DATE 	=> X_EFFECTIVE_FROM_DATE,
        X_EFFECTIVE_TO_DATE 	=> X_EFFECTIVE_TO_DATE,
        X_ASSIGNED_TEMPLATE_PURPOSE =>   X_ASSIGNED_TEMPLATE_PURPOSE ,
        X_LAST_UPDATE_DATE 		=> sysdate,
        X_LAST_UPDATED_BY 		=> user_id,
        X_LAST_UPDATE_LOGIN 	=> 0);

Line: 175

           AR_BPA_RULE_TEMPLATES_PKG.INSERT_ROW (
                X_ROWID 				=> row_id,
		        X_RULE_TEMPLATE_ID 		=> X_RULE_TEMPLATE_ID,
		        X_TEMPLATE_ID 			=> X_TEMPLATE_ID,
		        X_RULE_ID 				=> X_RULE_ID,
		        X_EFFECTIVE_FROM_DATE 	=> X_EFFECTIVE_FROM_DATE,
		        X_EFFECTIVE_TO_DATE 	=> X_EFFECTIVE_TO_DATE,
                    X_ASSIGNED_TEMPLATE_PURPOSE =>   X_ASSIGNED_TEMPLATE_PURPOSE ,
				X_CREATION_DATE 		=> sysdate,
                X_CREATED_BY 			=> user_id,
                X_LAST_UPDATE_DATE 		=> sysdate,
                X_LAST_UPDATED_BY 		=> user_id,
                X_LAST_UPDATE_LOGIN 	=> 0);