APPS.JTF_NAV_NODE_TYPES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW
(X_tree_root_id in number,
 X_NODE_TYPE in VARCHAR2,
 X_AK_FLOW_NAME in VARCHAR2,
 X_AK_PARENT_PAGE_NAME in VARCHAR2,
 X_AK_PK_NAME in VARCHAR2,
 X_AK_WHERE_CLAUSE in VARCHAR2,
 X_AK_WHERE_BINDS in VARCHAR2,
 X_ICON_NAME in VARCHAR2,
 X_FORM_NAME in VARCHAR2,
 X_FORM_PARAM_LIST in VARCHAR2,
 X_STATIC_CHILD_FLAG 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

   l_node_type_id number := 0;

Line: 24

   SELECT jtf_nav_node_types_s.nextval
     INTO l_node_type_id
     FROM dual;

Line: 28

   insert into JTF_NAV_NODE_TYPES(
     node_type_id,
     tree_root_id,
     NODE_TYPE,
     AK_FLOW_NAME,
     AK_PARENT_PAGE_NAME,
     AK_PK_NAME,
     AK_WHERE_CLAUSE,
     AK_WHERE_BINDS,
     ICON_NAME,
     FORM_NAME,
     FORM_PARAM_LIST,
     STATIC_CHILD_FLAG,
     CREATED_BY,
     CREATION_DATE,
     LAST_UPDATE_LOGIN,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY) values (
     l_node_type_id,
     X_tree_root_id,
     X_NODE_TYPE,
     X_AK_FLOW_NAME,
     X_AK_PARENT_PAGE_NAME,
     X_AK_PK_NAME,
     X_AK_WHERE_CLAUSE,
     X_AK_WHERE_BINDS,
     X_ICON_NAME,
     X_FORM_NAME,
     X_FORM_PARAM_LIST,
     X_STATIC_CHILD_FLAG,
     X_CREATED_BY,
     X_CREATION_DATE,
     X_LAST_UPDATE_LOGIN,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY);

Line: 64

end INSERT_ROW;

Line: 80

  cursor c1 is select
      AK_FLOW_NAME,
      AK_PARENT_PAGE_NAME,
      AK_PK_NAME,
      AK_WHERE_CLAUSE,
      AK_WHERE_BINDS,
      ICON_NAME,
      FORM_NAME,
      FORM_PARAM_LIST,
      STATIC_CHILD_FLAG
    from JTF_NAV_NODE_TYPES
    WHERE NODE_type_id = X_NODE_type_id
    for update of node_type_id nowait;

Line: 131

procedure UPDATE_ROW
  (x_node_type_id IN number,
  X_tree_root_id in number,
  X_NODE_TYPE in VARCHAR2,
  X_AK_FLOW_NAME in VARCHAR2,
  X_AK_PARENT_PAGE_NAME in VARCHAR2,
  X_AK_PK_NAME in VARCHAR2,
  X_AK_WHERE_CLAUSE in VARCHAR2,
  X_AK_WHERE_BINDS in VARCHAR2,
  X_ICON_NAME in VARCHAR2,
  X_FORM_NAME in VARCHAR2,
  X_FORM_PARAM_LIST in VARCHAR2,
  X_STATIC_CHILD_FLAG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
   update JTF_NAV_NODE_TYPES SET
     node_type = x_node_type,
    AK_FLOW_NAME = X_AK_FLOW_NAME,
    AK_PARENT_PAGE_NAME = X_AK_PARENT_PAGE_NAME,
    AK_PK_NAME = X_AK_PK_NAME,
    AK_WHERE_CLAUSE = X_AK_WHERE_CLAUSE,
    AK_WHERE_BINDS = X_AK_WHERE_BINDS,
    ICON_NAME = X_ICON_NAME,
    FORM_NAME = X_FORM_NAME,
    FORM_PARAM_LIST = X_FORM_PARAM_LIST,
    STATIC_CHILD_FLAG = X_STATIC_CHILD_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where node_type_id = x_node_type_id;

Line: 168

end UPDATE_ROW;

Line: 170

procedure DELETE_ROW
  (X_NODE_type_ID in number) is
begin
  delete from JTF_NAV_NODE_TYPES
  where node_type_id = x_node_type_id;

Line: 180

end DELETE_ROW;