APPS.FND_XDFAWINTERFACE_PKG SQL Statements

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

Line: 9

procedure INSERT_AW_DEF_INTERFACE(
    X_OBJECT_NAME in VARCHAR2,
    X_OBJECT_TYPE in VARCHAR2,
    X_OBJECT_OWNER in VARCHAR2,
    X_OBJECT_DEFINITION IN CLOB,
    X_AW_NAME in VARCHAR2,
    X_LAST_UPDATE_DATE IN DATE,
    X_LAST_UPDATED_BY  IN NUMBER,
    X_CREATION_DATE IN DATE,
    X_CREATED_BY  IN NUMBER,
    X_LAST_UPDATE_LOGIN  IN NUMBER
) IS
BEGIN
INSERT INTO FND_AW_DEF_INTERFACE(
	OBJECT_NAME,
	OBJECT_TYPE,
	OBJECT_OWNER,
	OBJECT_DEFINITION,
        AW_NAME,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_LOGIN)
	VALUES(
	X_OBJECT_NAME,
	X_OBJECT_TYPE,
	X_OBJECT_OWNER,
	X_OBJECT_DEFINITION,
	X_AW_NAME,
	X_LAST_UPDATE_DATE,
	X_LAST_UPDATED_BY,
	X_CREATION_DATE,
	X_CREATED_BY,
	X_LAST_UPDATE_LOGIN);

Line: 44

END INSERT_AW_DEF_INTERFACE;

Line: 52

    X_LAST_UPDATE_DATE IN VARCHAR2,
    X_CUSTOM_MODE IN VARCHAR2,
    X_LAST_UPDATED_BY  in VARCHAR2
)IS
  F_LUBY    NUMBER;  -- entity owner in file

Line: 57

  F_LUDATE  DATE;    -- entity update date in file

Line: 59

  DB_LUDATE DATE;    -- entity update date in db

Line: 65

  F_LUDATE := NVL(TO_DATE(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), SYSDATE);

Line: 68

    SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
    INTO DB_LUBY, DB_LUDATE
    FROM FND_AW_DEF_INTERFACE
    WHERE OBJECT_NAME = X_OBJECT_NAME AND OBJECT_TYPE = X_OBJECT_TYPE;

Line: 74

	 UPDATE FND_AW_DEF_INTERFACE SET
	 OBJECT_NAME = X_OBJECT_NAME,
	 OBJECT_TYPE = X_OBJECT_TYPE,
	 OBJECT_OWNER = X_OBJECT_OWNER,
	 OBJECT_DEFINITION = X_OBJECT_DEFINITION,
	 AW_NAME = X_AW_NAME,
	 LAST_UPDATE_DATE = F_LUDATE,
	 LAST_UPDATED_BY = F_LUBY,
         LAST_UPDATE_LOGIN = F_LUBY
	 WHERE OBJECT_NAME = X_OBJECT_NAME AND OBJECT_TYPE = X_OBJECT_TYPE;

Line: 86

    FND_XDFAWINTERFACE_PKG.INSERT_AW_DEF_INTERFACE(
	X_OBJECT_NAME,
	X_OBJECT_TYPE,
	X_OBJECT_OWNER,
	X_OBJECT_DEFINITION,
	X_AW_NAME,
	F_LUDATE,
	F_LUBY,
	F_LUDATE,
	F_LUBY,
	0);