eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_CUSTOM_GRP SQL Statements

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

Line: 50


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_api_version_number CONSTANT number := 1.0;

Line: 107


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 172


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_api_version_number CONSTANT number := 1.0;

Line: 219


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 286


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_api_version_number CONSTANT number := 1.0;

Line: 335


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 404


p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
p_pass                     IN      NUMBER,
p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
l_api_version_number CONSTANT number := 1.0;

Line: 455


p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_loader_timestamp => p_loader_timestamp,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 585


select userenv('LANG') into l_nls_language
from dual;

Line: 664


procedure UPDATE_CUSTOM (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_custom_appl_id	     IN      NUMBER,
p_custom_appl_code	     IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code		     IN      VARCHAR2,
p_verticalization_id       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_localization_code	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_org_id		     IN      NUMBER := FND_API.G_MISS_NUM,
p_site_id		     IN      NUMBER := FND_API.G_MISS_NUM,
p_responsibility_id 	     IN      NUMBER := FND_API.G_MISS_NUM,
p_web_user_id		     IN      NUMBER := FND_API.G_MISS_NUM,
p_default_customization_flag   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_customization_level_id   IN      NUMBER := FND_API.G_MISS_NUM,
p_developer_mode	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_reference_path	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_function_name	     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_start_date_active	     IN      DATE := FND_API.G_MISS_DATE,
p_end_date_active	     IN      DATE := FND_API.G_MISS_DATE,
p_name 		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_description		     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 697


l_api_name           CONSTANT varchar2(30) := 'Update_Custom';

Line: 716


savepoint start_update_custom;

Line: 719


AK_CUSTOM_PVT.UPDATE_CUSTOM (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_custom_appl_id => p_custom_appl_id,
p_custom_code => p_custom_appl_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_verticalization_id => p_verticalization_id,
p_localization_code => p_localization_code,
p_org_id => p_org_id,
p_site_id => p_site_id,
p_responsibility_id => p_responsibility_id,
p_web_user_id => p_web_user_id,
p_default_customization_flag => p_default_customization_flag,
p_customization_level_id => p_customization_level_id,
p_developer_mode => p_developer_mode,
p_reference_path => p_reference_path,
p_function_name => p_function_name,
p_start_date_active => p_start_date_active,
p_end_date_active => p_end_date_active,
p_name => p_name,
p_description => p_description,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 765


rollback to start_update_custom;

Line: 768


rollback to start_update_custom;

Line: 772


end UPDATE_CUSTOM;

Line: 792


procedure UPDATE_CUST_REGION (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_custom_appl_id           IN      NUMBER,
p_custom_appl_code         IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_property_name	     IN      VARCHAR2,
p_property_varchar2_value  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_property_number_value    IN      NUMBER := FND_API.G_MISS_NUM,
p_criteria_join_condition  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_property_varchar2_value_tl  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 815


l_api_name           CONSTANT varchar2(30) := 'Update_Cust_Region';

Line: 834


savepoint start_update_cust_region;

Line: 837


AK_CUSTOM_PVT.UPDATE_CUST_REGION (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_custom_appl_id => p_custom_appl_id,
p_custom_code => p_custom_appl_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_property_name => p_property_name,
p_property_varchar2_value => p_property_varchar2_value,
p_property_number_value => p_property_number_value,
p_criteria_join_condition => p_criteria_join_condition,
p_property_varchar2_value_tl => p_property_varchar2_value_tl,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 873


rollback to start_update_cust_region;

Line: 876


rollback to start_update_cust_region;

Line: 880


end UPDATE_CUST_REGION;

Line: 900


procedure UPDATE_CUST_REG_ITEM (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_custom_appl_id           IN      NUMBER,
p_custom_appl_code         IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_appl_id	     IN      NUMBER,
p_attribute_code	     IN      VARCHAR2,
p_property_name            IN      VARCHAR2,
p_property_varchar2_value  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_property_number_value    IN      NUMBER := FND_API.G_MISS_NUM,
p_property_date_value      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_property_varchar2_value_tl  IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 925


l_api_name           CONSTANT varchar2(30) := 'Update_Cust_Reg_Item';

Line: 944


savepoint start_update_cust_reg_item;

Line: 947


AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_custom_appl_id => p_custom_appl_id,
p_custom_code => p_custom_appl_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_appl_id => p_attribute_appl_id,
p_attribute_code => p_attribute_code,
p_property_name => p_property_name,
p_property_varchar2_value => p_property_varchar2_value,
p_property_number_value => p_property_number_value,
p_property_date_value => p_property_date_value,
p_property_varchar2_value_tl => p_property_varchar2_value_tl,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 985


rollback to start_update_cust_reg_item;

Line: 988


rollback to start_update_cust_reg_item;

Line: 992


end UPDATE_CUST_REG_ITEM;

Line: 1012


procedure UPDATE_CRITERIA (
p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_api_version_number       IN      NUMBER,
p_init_msg_tbl             IN      BOOLEAN := FALSE,
p_msg_count                OUT NOCOPY     NUMBER,
p_msg_data                 OUT NOCOPY     VARCHAR2,
p_return_status            OUT NOCOPY     VARCHAR2,
p_custom_appl_id           IN      NUMBER,
p_custom_appl_code         IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_appl_id        IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_sequence_number          IN      NUMBER,
p_operation		     IN      VARCHAR2,
p_value_varchar2           IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_value_number             IN      NUMBER := FND_API.G_MISS_NUM,
p_value_date               IN      DATE := FND_API.G_MISS_DATE,
p_start_date_active	     IN      DATE := FND_API.G_MISS_DATE,
p_end_date_active 	     IN      DATE := FND_API.G_MISS_DATE,
p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM
) is
l_api_version_number CONSTANT number := 1.0;

Line: 1039


l_api_name           CONSTANT varchar2(30) := 'Update_Criteria';

Line: 1058


savepoint start_update_cust_reg_item;

Line: 1061


AK_CUSTOM_PVT.UPDATE_CRITERIA (
p_validation_level => p_validation_level,
p_api_version_number => 1.0,
p_msg_count => p_msg_count,
p_msg_data => p_msg_data,
p_return_status => l_return_status,
p_custom_appl_id => p_custom_appl_id,
p_custom_code => p_custom_appl_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_appl_id => p_attribute_appl_id,
p_attribute_code => p_attribute_code,
p_sequence_number => p_sequence_number,
p_operation => p_operation,
p_value_varchar2 => p_value_varchar2,
p_value_number => p_value_number,
p_value_date => p_value_date,
p_start_date_active => p_start_date_active,
p_end_date_Active => p_end_date_active,
p_created_by => p_created_by,
p_creation_date => p_creation_date,
p_last_updated_by => p_last_updated_by,
p_last_update_date => p_last_update_date,
p_last_update_login => p_last_update_login,
p_pass => l_pass,
p_copy_redo_flag => l_copy_redo_flag
);

Line: 1101


rollback to start_update_critieria;

Line: 1104


rollback to start_update_criteria;

Line: 1108


end UPDATE_CRITERIA;