APPS.FND_PORTLET_DEPENDENCY_PKG SQL Statements

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

Line: 4

procedure INSERT_CONCURRENT_ROW (
  X_CONCURRENT_PROGRAM_NAME in VARCHAR2,
  X_CONCURRENT_APPLICATION_CODE in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2
) IS

l_rowid rowid;

Line: 14

   FND_PORTLET_DEPENDENCY_PKG.INSERT_ROW (
      l_rowid,
      X_CONCURRENT_PROGRAM_NAME,
      X_CONCURRENT_APPLICATION_CODE,
      X_FUNCTION_NAME,
      sysdate,
      2,
      sysdate,
      2,
      0);

Line: 25

end INSERT_CONCURRENT_ROW;

Line: 27

procedure DELETE_CONCURRENT_ROW (
  X_CONCURRENT_PROGRAM_NAME in VARCHAR2,
  X_CONCURRENT_APPLICATION_CODE in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2
) IS


begin

   FND_PORTLET_DEPENDENCY_PKG.DELETE_ROW (
      X_CONCURRENT_PROGRAM_NAME,
      X_CONCURRENT_APPLICATION_CODE,
      X_FUNCTION_NAME);

Line: 41

end DELETE_CONCURRENT_ROW;

Line: 43

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_REFRESH_DEPENDENCY in VARCHAR2,
  X_REFRESH_DEPENDENCY_CONTEXT in VARCHAR2,
  X_FUNCTION_NAME 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 FND_PORTLET_DEPENDENCY
    where REFRESH_DEPENDENCY = X_REFRESH_DEPENDENCY
    and REFRESH_DEPENDENCY_CONTEXT = X_REFRESH_DEPENDENCY_CONTEXT
    and FUNCTION_NAME = X_FUNCTION_NAME
    ;

Line: 61

  insert into FND_PORTLET_DEPENDENCY (
    REFRESH_DEPENDENCY,
    REFRESH_DEPENDENCY_CONTEXT,
    FUNCTION_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) SELECT
    X_REFRESH_DEPENDENCY,
    X_REFRESH_DEPENDENCY_CONTEXT,
    X_FUNCTION_NAME,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
    FROM DUAL
    where not exists
    (select NULL
    from FND_PORTLET_DEPENDENCY D
    where D.REFRESH_DEPENDENCY = X_REFRESH_DEPENDENCY
      and D.REFRESH_DEPENDENCY_CONTEXT = X_REFRESH_DEPENDENCY_CONTEXT
      and D.FUNCTION_NAME = X_FUNCTION_NAME);

Line: 95

end INSERT_ROW;

Line: 97

procedure DELETE_ROW (
  X_REFRESH_DEPENDENCY in VARCHAR2,
  X_REFRESH_DEPENDENCY_CONTEXT in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2
) is
begin
  delete from FND_PORTLET_DEPENDENCY
  where REFRESH_DEPENDENCY = X_REFRESH_DEPENDENCY
  and   REFRESH_DEPENDENCY_CONTEXT = X_REFRESH_DEPENDENCY_CONTEXT
  and   FUNCTION_NAME = X_FUNCTION_NAME;

Line: 112

end DELETE_ROW;

Line: 124

    select PORT.FUNCTION_NAME FUNCTION_NAME
    from  FND_PORTLET_DEPENDENCY PORT
    where PORT.REFRESH_DEPENDENCY = c_REFRESH_DEPENDENCY
     and  PORT.REFRESH_DEPENDENCY_CONTEXT = c_REFRESH_DEPENDENCY_CONTEXT;

Line: 139

   select p.concurrent_program_name, a.APPLICATION_SHORT_NAME
     into program_name, program_application_name
     from fnd_application A, fnd_concurrent_programs P
    where P.concurrent_program_id = fnd_global.conc_program_id
      and P.application_id = fnd_global.prog_appl_id
      and P.application_id = A.application_id;