The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Check_Configuration_delete
(
X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
X_CUSTOMIZATION_CODE IN VARCHAR2,
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
l_count NUMBER;
SELECT
COUNT(*)
INTO
l_count
FROM
EGO_CUSTOMIZATION_EXT
WHERE
RF_CUSTOMIZATION_APPL_ID = X_CUSTOMIZATION_APPLICATION_ID
AND RF_CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND RF_REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND RF_REGION_CODE = X_REGION_CODE;
SELECT
property_varchar2_value INTO l_name
FROM
ak_custom_regions_tl
WHERE
property_name = 'RESULT_NAME'
AND LANGUAGE = userenv('LANG')
AND customization_application_id = x_customization_application_id
AND customization_code = x_customization_code
AND region_application_id = x_region_application_id
AND region_code = x_region_code ;
SELECT
NAME INTO l_name
FROM
EGO_RESULTS_FORMAT_V
WHERE
CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE;
END Check_Configuration_delete;
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
l_Sysdate DATE := Sysdate;
AK_CUSTOM_REGIONS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_PROPERTY_NAME => 'CONFIG_NAME',
X_PROPERTY_VARCHAR2_VALUE => X_NAME,
X_PROPERTY_NUMBER_VALUE => NULL,
X_CRITERIA_JOIN_CONDITION => NULL,
X_CREATED_BY => X_CREATED_BY,
X_CREATION_DATE => X_CREATION_DATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
INSERT INTO EGO_CUSTOMIZATION_EXT
(
CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
CLASSIFICATION1,
CLASSIFICATION2,
CLASSIFICATION3,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
VALUES
(
X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID,
X_REGION_CODE,
X_CLASSIFICATION_1,
X_CLASSIFICATION_2,
X_CLASSIFICATION_3,
g_current_user_id,
l_Sysdate,
g_current_user_id,
l_Sysdate,
g_current_user_id
);
PROCEDURE update_type_Config
(
X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
X_CUSTOMIZATION_CODE IN VARCHAR2,
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_NAME IN VARCHAR2,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
l_Sysdate DATE := Sysdate;
AK_CUSTOM_REGIONS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_PROPERTY_NAME => 'CONFIG_NAME',
X_PROPERTY_VARCHAR2_VALUE => X_NAME,
X_PROPERTY_NUMBER_VALUE => NULL,
X_CRITERIA_JOIN_CONDITION => NULL,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
END update_type_Config;
PROCEDURE delete_type_config
(
X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
X_CUSTOMIZATION_CODE IN VARCHAR2,
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
BEGIN
IF FND_API.To_Boolean(x_init_msg_list) THEN
FND_MSG_PUB.Initialize;
Check_Configuration_delete
(
X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID,
X_REGION_CODE,
FND_API.G_FALSE,
X_RETURN_STATUS,
X_ERRORCODE
);
DELETE FROM AK_CUSTOM_REGIONS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE;
DELETE FROM AK_CUSTOM_REGIONS_TL
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE;
DELETE FROM EGO_CUSTOMIZATION_EXT
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE;
DELETE FROM AK_CUSTOM_REGION_ITEMS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE;
DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE;
END delete_type_config;
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
l_Sysdate DATE := Sysdate;
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'DISPLAY_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE => null,
X_PROPERTY_NUMBER_VALUE => X_DISPLAY_SEQUENCE,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_CREATED_BY,
X_CREATION_DATE => X_CREATION_DATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'ORDER_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE => NULL,
X_PROPERTY_NUMBER_VALUE => X_ORDER_SEQUENCE,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_CREATED_BY,
X_CREATION_DATE => X_CREATION_DATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'ORDER_DIRECTION',
X_PROPERTY_VARCHAR2_VALUE => X_ORDER_DIRECTION,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_CREATED_BY,
X_CREATION_DATE => X_CREATION_DATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'COLUMN_NAME',
X_PROPERTY_VARCHAR2_VALUE => X_COLUMN_NAME,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_CREATED_BY,
X_CREATION_DATE => X_CREATION_DATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'SHOW_TOTAL',
X_PROPERTY_VARCHAR2_VALUE => X_SHOW_TOTAL,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_CREATED_BY,
X_CREATION_DATE => X_CREATION_DATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
PROCEDURE update_Primary_Attribute
(
X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
X_CUSTOMIZATION_CODE IN VARCHAR2,
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
X_ATTRIBUTE_CODE IN VARCHAR2,
X_DISPLAY_SEQUENCE IN NUMBER,
X_ORDER_SEQUENCE IN NUMBER,
X_ORDER_DIRECTION IN VARCHAR2,
X_COLUMN_NAME IN VARCHAR2 := NULL,
X_SHOW_TOTAL IN VARCHAR2 := NULL,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
l_Sysdate DATE := Sysdate;
AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'DISPLAY_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE => NULL,
X_PROPERTY_NUMBER_VALUE => X_DISPLAY_SEQUENCE,
X_PROPERTY_DATE_VALUE => NULL,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
SELECT
COUNT(*) INTO l_count
FROM
AK_CUSTOM_REGION_ITEMS
WHERE
CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'ORDER_SEQUENCE';
DELETE FROM AK_CUSTOM_REGION_ITEMS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'ORDER_SEQUENCE';
AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'ORDER_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE => NULL,
X_PROPERTY_NUMBER_VALUE => X_ORDER_SEQUENCE,
X_PROPERTY_DATE_VALUE => NULL,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'ORDER_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE => NULL,
X_PROPERTY_NUMBER_VALUE => X_ORDER_SEQUENCE,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_LAST_UPDATED_BY,
X_CREATION_DATE => SYSDATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
SELECT
COUNT(*) INTO l_count
FROM
AK_CUSTOM_REGION_ITEMS
WHERE
CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'ORDER_DIRECTION';
DELETE FROM AK_CUSTOM_REGION_ITEMS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'ORDER_DIRECTION';
AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'ORDER_DIRECTION',
X_PROPERTY_VARCHAR2_VALUE => X_ORDER_DIRECTION,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'ORDER_DIRECTION',
X_PROPERTY_VARCHAR2_VALUE => X_ORDER_DIRECTION,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_LAST_UPDATED_BY,
X_CREATION_DATE => SYSDATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
SELECT
COUNT(*) INTO l_count
FROM
AK_CUSTOM_REGION_ITEMS
WHERE
CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'COLUMN_NAME';
DELETE FROM AK_CUSTOM_REGION_ITEMS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'COLUMN_NAME';
AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'COLUMN_NAME',
X_PROPERTY_VARCHAR2_VALUE => X_COLUMN_NAME,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'COLUMN_NAME',
X_PROPERTY_VARCHAR2_VALUE => X_COLUMN_NAME,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_LAST_UPDATED_BY,
X_CREATION_DATE => SYSDATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
SELECT
COUNT(*) INTO l_count
FROM
AK_CUSTOM_REGION_ITEMS
WHERE
CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'SHOW_TOTAL';
DELETE FROM AK_CUSTOM_REGION_ITEMS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
AND PROPERTY_NAME = 'SHOW_TOTAL';
AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'SHOW_TOTAL',
X_PROPERTY_VARCHAR2_VALUE => X_SHOW_TOTAL,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'SHOW_TOTAL',
X_PROPERTY_VARCHAR2_VALUE => X_SHOW_TOTAL,
X_PROPERTY_NUMBER_VALUE => NULL,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_LAST_UPDATED_BY,
X_CREATION_DATE => SYSDATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
END update_Primary_Attribute;
PROCEDURE delete_Primary_Attribute
(
X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
X_CUSTOMIZATION_CODE IN VARCHAR2,
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
X_ATTRIBUTE_CODE IN VARCHAR2,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
BEGIN
IF FND_API.To_Boolean(x_init_msg_list) THEN
FND_MSG_PUB.Initialize;
DELETE FROM AK_CUSTOM_REGION_ITEMS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
END delete_Primary_Attribute;
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
l_Sysdate DATE := Sysdate;
AK_CUSTOM_REGION_ITEMS_PKG.INSERT_ROW(
X_ROWID => l_rowid,
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'SECTION_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE => NULL,
X_PROPERTY_NUMBER_VALUE => X_DISPLAY_SEQUENCE,
X_PROPERTY_DATE_VALUE => NULL,
X_CREATED_BY => X_CREATED_BY,
X_CREATION_DATE => X_CREATION_DATE,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
PROCEDURE update_config_section
(
X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
X_CUSTOMIZATION_CODE IN VARCHAR2,
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
X_ATTRIBUTE_CODE IN VARCHAR2,
X_DISPLAY_SEQUENCE IN NUMBER,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
l_Sysdate DATE := Sysdate;
AK_CUSTOM_REGION_ITEMS_PKG.UPDATE_ROW(
X_CUSTOMIZATION_APPLICATION_ID => X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE => X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID => X_REGION_APPLICATION_ID,
X_REGION_CODE => X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
X_PROPERTY_NAME => 'SECTION_SEQUENCE',
X_PROPERTY_VARCHAR2_VALUE => NULL,
X_PROPERTY_NUMBER_VALUE => X_DISPLAY_SEQUENCE,
X_PROPERTY_DATE_VALUE => NULL,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
);
END update_config_section;
PROCEDURE delete_config_section
(
X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
X_CUSTOMIZATION_CODE IN VARCHAR2,
X_REGION_APPLICATION_ID IN NUMBER,
X_REGION_CODE IN VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
X_ATTRIBUTE_CODE IN VARCHAR2,
X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_ERRORCODE OUT NOCOPY NUMBER
)
IS
BEGIN
IF FND_API.To_Boolean(x_init_msg_list) THEN
FND_MSG_PUB.Initialize;
DELETE FROM AK_CUSTOM_REGION_ITEMS
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
DELETE FROM AK_CUSTOM_REGION_ITEMS_TL
WHERE CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
AND ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
END delete_config_section;
SELECT
COUNT(*)
INTO
l_count
FROM
EGO_RESULTS_FORMAT_V
WHERE
NAME = X_NAME
AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND (CUSTOMIZATION_LEVEL_ID = 60 OR (CUSTOMIZATION_LEVEL_ID = 30 AND WEB_USER_ID = X_WEB_USER_ID))
AND CUSTOMIZATION_CODE <> X_CUSTOMIZATION_CODE
AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);
SELECT
COUNT(*)
INTO
l_count
FROM
EGO_RESULTS_FORMAT_V
WHERE
NAME = X_NAME
AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND CUSTOMIZATION_CODE <> X_CUSTOMIZATION_CODE
AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);
SELECT
COUNT(*)
INTO
l_count
FROM
EGO_RESULTS_FORMAT_V
WHERE
NAME = X_NAME
AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND (CUSTOMIZATION_LEVEL_ID = 60 OR (CUSTOMIZATION_LEVEL_ID = 30 AND WEB_USER_ID = X_WEB_USER_ID))
AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);
SELECT
COUNT(*)
INTO
l_count
FROM
EGO_RESULTS_FORMAT_V
WHERE
NAME = X_NAME
AND CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
AND REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
AND REGION_CODE = X_REGION_CODE
AND NVL(X_CLASSIFICATION1, g_null_value) = NVL(CLASSIFICATION1, g_null_value)
AND NVL(X_CLASSIFICATION2, g_null_value) = NVL(CLASSIFICATION2, g_null_value)
AND NVL(X_CLASSIFICATION3, g_null_value) = NVL(CLASSIFICATION3, g_null_value);