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.PQH_TRAN_CATEGORY_BK2 SQL Statements

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

Line: 5


procedure UPDATE_TRAN_CATEGORY_A
(P_TRANSACTION_CATEGORY_ID in NUMBER
,P_CUSTOM_WF_PROCESS_NAME in VARCHAR2
,P_CUSTOM_WORKFLOW_NAME in VARCHAR2
,P_FORM_NAME in VARCHAR2
,P_FREEZE_STATUS_CD in VARCHAR2
,P_FUTURE_ACTION_CD in VARCHAR2
,P_MEMBER_CD in VARCHAR2
,P_NAME in VARCHAR2
,P_SHORT_NAME in VARCHAR2
,P_POST_STYLE_CD in VARCHAR2
,P_POST_TXN_FUNCTION in VARCHAR2
,P_ROUTE_VALIDATED_TXN_FLAG in VARCHAR2
,P_PREVENT_APPROVER_SKIP in VARCHAR2
,P_WORKFLOW_ENABLE_FLAG in VARCHAR2
,P_ENABLE_FLAG in VARCHAR2
,P_TIMEOUT_DAYS in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_CONSOLIDATED_TABLE_ROUTE_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_SETUP_TYPE_CD in VARCHAR2
,P_MASTER_TABLE_ROUTE_ID in NUMBER
,P_EFFECTIVE_DATE in DATE
)is
begin
hr_utility.set_location('Entering: PQH_TRAN_CATEGORY_BK2.UPDATE_TRAN_CATEGORY_A', 10);

Line: 31


hr_utility.set_location(' Leaving: PQH_TRAN_CATEGORY_BK2.UPDATE_TRAN_CATEGORY_A', 20);

Line: 32


end UPDATE_TRAN_CATEGORY_A;

Line: 33


procedure UPDATE_TRAN_CATEGORY_B
(P_TRANSACTION_CATEGORY_ID in NUMBER
,P_CUSTOM_WF_PROCESS_NAME in VARCHAR2
,P_CUSTOM_WORKFLOW_NAME in VARCHAR2
,P_FORM_NAME in VARCHAR2
,P_FREEZE_STATUS_CD in VARCHAR2
,P_FUTURE_ACTION_CD in VARCHAR2
,P_MEMBER_CD in VARCHAR2
,P_NAME in VARCHAR2
,P_SHORT_NAME in VARCHAR2
,P_POST_STYLE_CD in VARCHAR2
,P_POST_TXN_FUNCTION in VARCHAR2
,P_ROUTE_VALIDATED_TXN_FLAG in VARCHAR2
,P_PREVENT_APPROVER_SKIP in VARCHAR2
,P_WORKFLOW_ENABLE_FLAG in VARCHAR2
,P_ENABLE_FLAG in VARCHAR2
,P_TIMEOUT_DAYS in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_CONSOLIDATED_TABLE_ROUTE_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_SETUP_TYPE_CD in VARCHAR2
,P_MASTER_TABLE_ROUTE_ID in NUMBER
,P_EFFECTIVE_DATE in DATE
)is
begin
hr_utility.set_location('Entering: PQH_TRAN_CATEGORY_BK2.UPDATE_TRAN_CATEGORY_B', 10);

Line: 59


hr_utility.set_location(' Leaving: PQH_TRAN_CATEGORY_BK2.UPDATE_TRAN_CATEGORY_B', 20);

Line: 60


end UPDATE_TRAN_CATEGORY_B;