APPS.IBC_CTYPE_GROUP_NODES_PKG SQL Statements

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

Line: 10

PROCEDURE INSERT_ROW (
  x_ROWID  OUT NOCOPY VARCHAR2,
  px_CTYPE_GROUP_NODE_ID IN OUT NOCOPY NUMBER,
  p_CONTENT_TYPE_CODE IN VARCHAR2,
  p_DIRECTORY_NODE_ID IN NUMBER,
  p_OBJECT_VERSION_NUMBER IN NUMBER,
  p_CREATION_DATE IN DATE,
  p_CREATED_BY IN NUMBER,
  p_LAST_UPDATE_DATE IN DATE,
  p_LAST_UPDATED_BY IN NUMBER,
  p_LAST_UPDATE_LOGIN IN NUMBER
) IS
  CURSOR C IS SELECT ROWID FROM Ibc_Ctype_Group_Nodes
    WHERE CTYPE_GROUP_NODE_ID = px_CTYPE_GROUP_NODE_ID;

Line: 25

  CURSOR c2 IS SELECT Ibc_Ctype_Group_Nodes_s1.NEXTVAL FROM dual;

Line: 38

INSERT INTO IBC_CTYPE_GROUP_NODES (
 CTYPE_GROUP_NODE_ID
 ,CONTENT_TYPE_CODE
 ,DIRECTORY_NODE_ID
 ,OBJECT_VERSION_NUMBER
 ,CREATION_DATE
 ,CREATED_BY
 ,LAST_UPDATE_DATE
 ,LAST_UPDATED_BY
 ,LAST_UPDATE_LOGIN
) VALUES (
    px_CTYPE_GROUP_NODE_ID,
    p_CONTENT_TYPE_CODE,
    p_DIRECTORY_NODE_ID,
    p_OBJECT_VERSION_NUMBER,
    DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
           p_creation_date),
    DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
           NULL, FND_GLOBAL.user_id, p_created_by),
    DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
           p_last_update_date),
    DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
           NULL, FND_GLOBAL.user_id, p_last_updated_by),
    DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
           NULL, FND_GLOBAL.login_id, p_last_update_login)
 );

Line: 73

END INSERT_ROW;

Line: 78

PROCEDURE UPDATE_ROW (
p_CTYPE_GROUP_NODE_ID	IN  NUMBER,
p_CONTENT_TYPE_CODE	IN  VARCHAR2  DEFAULT  NULL,
p_DIRECTORY_NODE_ID     IN  NUMBER DEFAULT  NULL,
p_LAST_UPDATED_BY	IN  NUMBER  DEFAULT  NULL,
p_LAST_UPDATE_DATE	IN  DATE DEFAULT  NULL,
p_LAST_UPDATE_LOGIN	IN  NUMBER DEFAULT  NULL
) IS
BEGIN
  UPDATE IBC_CTYPE_GROUP_NODES SET
	CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE,
	DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID,
	last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
                              NULL, SYSDATE, p_last_update_date),
	last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
                             FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
                             p_last_updated_by),
	last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
                             FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
                             p_last_update_login)
  WHERE CTYPE_GROUP_NODE_ID = p_CTYPE_GROUP_NODE_ID;

Line: 104

END UPDATE_ROW;

Line: 107

PROCEDURE DELETE_ROW (
  p_CTYPE_GROUP_NODE_ID IN  NUMBER
) IS
BEGIN
  DELETE FROM IBC_CTYPE_GROUP_NODES
  WHERE CTYPE_GROUP_NODE_ID = p_CTYPE_GROUP_NODE_ID;

Line: 117

END DELETE_ROW;

Line: 127

  p_LAST_UPDATE_DATE IN VARCHAR2) IS
BEGIN
  DECLARE
    l_user_id    NUMBER := 0;

Line: 131

    l_last_update_date DATE;

Line: 136

    db_last_update_date DATE;

Line: 139

	--get last updated by user id
	l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);

Line: 142

	--translate data type VARCHAR2 to DATE for last_update_date
	l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);

Line: 145

	-- get updatedby  and update_date values if existing in db
	SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
	FROM IBC_CTYPE_GROUP_NODES
	WHERE CTYPE_GROUP_NODE_ID = p_CTYPE_GROUP_NODE_ID;

Line: 150

	IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
		db_user_id, db_last_update_date, p_upload_mode )) THEN

		Ibc_Ctype_Group_Nodes_Pkg.UPDATE_ROW (
		   p_CTYPE_GROUP_NODE_ID		=>	p_CTYPE_GROUP_NODE_ID,
		   p_CONTENT_TYPE_CODE			=>	p_CONTENT_TYPE_CODE,
		   p_DIRECTORY_NODE_ID			=>	p_DIRECTORY_NODE_ID,
		   p_LAST_UPDATED_BY			=>	l_user_id,
		   p_LAST_UPDATE_DATE			=>	SYSDATE,
		   p_LAST_UPDATE_LOGIN			=>	l_user_id
		);

Line: 164

        Ibc_Ctype_Group_Nodes_Pkg.INSERT_ROW (
		x_ROWID				=>  l_row_id,
		px_CTYPE_GROUP_NODE_ID		=>  lx_CTYPE_GROUP_NODE_ID,
		p_CONTENT_TYPE_CODE		=>  p_CONTENT_TYPE_CODE,
		p_DIRECTORY_NODE_ID		=>  p_DIRECTORY_NODE_ID,
		p_OBJECT_VERSION_NUMBER         =>  1,
		p_CREATED_BY			=>  l_user_id,
		p_CREATION_DATE			=>  SYSDATE,
		p_LAST_UPDATED_BY		=>  l_user_id,
		p_LAST_UPDATE_DATE		=>  SYSDATE,
		p_LAST_UPDATE_LOGIN		=>  l_user_id
	);

Line: 185

  p_LAST_UPDATE_DATE IN VARCHAR2) IS
BEGIN
	IF (p_UPLOAD_MODE = 'NLS') THEN
		NULL;

Line: 196

		p_last_update_date => p_LAST_UPDATE_DATE);