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_FLOW_GRP SQL Statements

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

Line: 37


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: 76


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: 142


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: 184


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: 264


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: 313


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: 379


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: 426


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: 492


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: 539


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: 591


procedure DELETE_FLOW (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 603


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

Line: 620


savepoint start_delete_flow;

Line: 623


AK_FLOW_PVT.DELETE_FLOW (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_delete_cascade => p_delete_cascade
);

Line: 645


rollback to start_delete_flow;

Line: 648


rollback to start_delete_flow;

Line: 652


end DELETE_FLOW;

Line: 681


procedure DELETE_PAGE (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 695


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

Line: 712


savepoint start_delete_page;

Line: 715


AK_FLOW_PVT.DELETE_PAGE (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_delete_cascade => p_delete_cascade
);

Line: 739


rollback to start_delete_page;

Line: 742


rollback to start_delete_page;

Line: 746


end DELETE_PAGE;

Line: 777


procedure DELETE_PAGE_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 793


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

Line: 810


savepoint start_delete_page_region;

Line: 813


AK_FLOW_PVT.DELETE_PAGE_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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_delete_cascade => p_delete_cascade
);

Line: 839


rollback to start_delete_page_region;

Line: 842


rollback to start_delete_page_region;

Line: 846


end DELETE_PAGE_REGION;

Line: 879


procedure DELETE_PAGE_REGION_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 897


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

Line: 914


savepoint start_delete_item;

Line: 917


AK_FLOW_PVT.DELETE_PAGE_REGION_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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_delete_cascade => p_delete_cascade
);

Line: 945


rollback to start_delete_item;

Line: 948


rollback to start_delete_item;

Line: 952


end DELETE_PAGE_REGION_ITEM;

Line: 988


procedure DELETE_REGION_RELATION (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_foreign_key_name         IN      VARCHAR2,
p_from_page_appl_id        IN      NUMBER,
p_from_page_code           IN      VARCHAR2,
p_from_region_appl_id      IN      NUMBER,
p_from_region_code         IN      VARCHAR2,
p_to_page_appl_id          IN      NUMBER,
p_to_page_code             IN      VARCHAR2,
p_to_region_appl_id        IN      NUMBER,
p_to_region_code           IN      VARCHAR2,
p_delete_cascade           IN      VARCHAR2 := 'N'
) is
l_api_version_number CONSTANT number := 1.0;

Line: 1009


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

Line: 1026


savepoint start_delete_relation;

Line: 1029


AK_FLOW_PVT.DELETE_REGION_RELATION (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_foreign_key_name => p_foreign_key_name,
p_from_page_appl_id => p_from_page_appl_id,
p_from_page_code => p_from_page_code,
p_from_region_appl_id => p_from_region_appl_id,
p_from_region_code => p_from_region_code,
p_to_page_appl_id => p_to_page_appl_id,
p_to_page_code => p_to_page_code,
p_to_region_appl_id => p_to_region_appl_id,
p_to_region_code => p_to_region_code,
p_delete_cascade => p_delete_cascade
);

Line: 1060


rollback to start_delete_relation;

Line: 1063


rollback to start_delete_relation;

Line: 1067


end DELETE_REGION_RELATION;

Line: 1177


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

Line: 1252


procedure UPDATE_FLOW (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_primary_page_appl_id     IN      NUMBER := FND_API.G_MISS_NUM,
p_primary_page_code        IN      VARCHAR2 := FND_API.G_MISS_CHAR,
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: 1272


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

Line: 1291


savepoint start_update_flow;

Line: 1294


AK_FLOW_PVT.UPDATE_FLOW (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_primary_page_appl_id => p_primary_page_appl_id,
p_primary_page_code => p_primary_page_code,
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: 1326


rollback to start_update_flow;

Line: 1329


rollback to start_update_flow;

Line: 1333


end UPDATE_FLOW;

Line: 1356


procedure UPDATE_PAGE (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_primary_region_appl_id   IN      NUMBER := FND_API.G_MISS_NUM,
p_primary_region_code      IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_name                     IN      VARCHAR2,
p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_set_primary_page         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: 1379


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

Line: 1398


savepoint start_update_page;

Line: 1401


AK_FLOW_PVT.UPDATE_PAGE (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_primary_region_appl_id => p_primary_region_appl_id,
p_primary_region_code => p_primary_region_code,
p_name => p_name,
p_description => p_description,
p_set_primary_page => p_set_primary_page,
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: 1436


rollback to start_update_page;

Line: 1439


rollback to start_update_page;

Line: 1443


end UPDATE_PAGE;

Line: 1475


procedure UPDATE_PAGE_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_display_sequence         IN      NUMBER := FND_API.G_MISS_NUM,
p_region_style             IN      VARCHAR2,
p_num_columns              IN      NUMBER := FND_API.G_MISS_NUM,
p_icx_custom_call          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_parent_region_application_id IN  NUMBER := FND_API.G_MISS_NUM,
p_parent_region_code       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_foreign_key_name         IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_set_primary_region       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: 1503


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

Line: 1522


savepoint start_update_page_region;

Line: 1525


AK_FLOW_PVT.UPDATE_PAGE_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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_display_sequence => p_display_sequence,
p_region_style => p_region_style,
p_num_columns => p_num_columns,
p_icx_custom_call => p_icx_custom_call,
p_parent_region_application_id => p_parent_region_application_id,
p_parent_region_code => p_parent_region_code,
p_foreign_key_name => p_foreign_key_name,
p_set_primary_region => p_set_primary_region,
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: 1565


rollback to start_update_page_region;

Line: 1568


rollback to start_update_page_region;

Line: 1572


end UPDATE_PAGE_REGION;

Line: 1592


procedure UPDATE_PAGE_REGION_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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_page_application_id      IN      NUMBER,
p_page_code                IN      VARCHAR2,
p_region_application_id    IN      NUMBER,
p_region_code              IN      VARCHAR2,
p_attribute_application_id IN      NUMBER,
p_attribute_code           IN      VARCHAR2,
p_to_page_appl_id          IN      NUMBER := FND_API.G_MISS_NUM,
p_to_page_code             IN      VARCHAR2 := FND_API.G_MISS_CHAR,
p_to_url_attribute_appl_id IN      NUMBER := FND_API.G_MISS_NUM,
p_to_url_attribute_code    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: 1618


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

Line: 1637


savepoint start_update_item;

Line: 1640


AK_FLOW_PVT.UPDATE_PAGE_REGION_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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_page_application_id => p_page_application_id,
p_page_code => p_page_code,
p_region_application_id => p_region_application_id,
p_region_code => p_region_code,
p_attribute_application_id => p_attribute_application_id,
p_attribute_code => p_attribute_code,
p_to_page_appl_id => p_to_page_appl_id,
p_to_page_code => p_to_page_code,
p_to_url_attribute_appl_id => p_to_url_attribute_appl_id,
p_to_url_attribute_code => p_to_url_attribute_code,
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: 1678


rollback to start_update_item;

Line: 1681


rollback to start_update_item;

Line: 1685


end UPDATE_PAGE_REGION_ITEM;

Line: 1705


procedure UPDATE_REGION_RELATION (
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_flow_application_id      IN      NUMBER,
p_flow_code                IN      VARCHAR2,
p_foreign_key_name         IN      VARCHAR2,
p_from_page_appl_id        IN      NUMBER,
p_from_page_code           IN      VARCHAR2,
p_from_region_appl_id      IN      NUMBER,
p_from_region_code         IN      VARCHAR2,
p_to_page_appl_id          IN      NUMBER,
p_to_page_code             IN      VARCHAR2,
p_to_region_appl_id        IN      NUMBER,
p_to_region_code           IN      VARCHAR2,
p_application_id           IN      NUMBER,
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: 1731


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

Line: 1750


savepoint start_update_relation;

Line: 1753


AK_FLOW_PVT.UPDATE_REGION_RELATION (
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_flow_application_id => p_flow_application_id,
p_flow_code => p_flow_code,
p_foreign_key_name => p_foreign_key_name,
p_from_page_appl_id => p_from_page_appl_id,
p_from_page_code => p_from_page_code,
p_from_region_appl_id => p_from_region_appl_id,
p_from_region_code => p_from_region_code,
p_to_page_appl_id => p_to_page_appl_id,
p_to_page_code => p_to_page_code,
p_to_region_appl_id => p_to_region_appl_id,
p_to_region_code => p_to_region_code,
p_application_id => p_application_id,
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: 1791


rollback to start_update_relation;

Line: 1794


rollback to start_update_relation;

Line: 1798


end UPDATE_REGION_RELATION;