APPS.PQH_RT_MATRIX_NODE_VALUES_BK2 SQL Statements

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

Line: 5

procedure UPDATE_RT_MATRIX_NODE_VALUE_A
(P_EFFECTIVE_DATE in DATE
,P_NODE_VALUE_ID in NUMBER
,P_RATE_MATRIX_NODE_ID in NUMBER
,P_SHORT_CODE in VARCHAR2
,P_CHAR_VALUE1 in VARCHAR2
,P_CHAR_VALUE2 in VARCHAR2
,P_CHAR_VALUE3 in VARCHAR2
,P_CHAR_VALUE4 in VARCHAR2
,P_NUMBER_VALUE1 in NUMBER
,P_NUMBER_VALUE2 in NUMBER
,P_NUMBER_VALUE3 in NUMBER
,P_NUMBER_VALUE4 in NUMBER
,P_DATE_VALUE1 in DATE
,P_DATE_VALUE2 in DATE
,P_DATE_VALUE3 in DATE
,P_DATE_VALUE4 in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_LEGISLATION_CODE in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: PQH_RT_MATRIX_NODE_VALUES_BK2.UPDATE_RT_MATRIX_NODE_VALUE_A', 10);

Line: 28

hr_utility.set_location(' Leaving: PQH_RT_MATRIX_NODE_VALUES_BK2.UPDATE_RT_MATRIX_NODE_VALUE_A', 20);

Line: 29

end UPDATE_RT_MATRIX_NODE_VALUE_A;

Line: 30

procedure UPDATE_RT_MATRIX_NODE_VALUE_B
(P_EFFECTIVE_DATE in DATE
,P_NODE_VALUE_ID in NUMBER
,P_RATE_MATRIX_NODE_ID in NUMBER
,P_SHORT_CODE in VARCHAR2
,P_CHAR_VALUE1 in VARCHAR2
,P_CHAR_VALUE2 in VARCHAR2
,P_CHAR_VALUE3 in VARCHAR2
,P_CHAR_VALUE4 in VARCHAR2
,P_NUMBER_VALUE1 in NUMBER
,P_NUMBER_VALUE2 in NUMBER
,P_NUMBER_VALUE3 in NUMBER
,P_NUMBER_VALUE4 in NUMBER
,P_DATE_VALUE1 in DATE
,P_DATE_VALUE2 in DATE
,P_DATE_VALUE3 in DATE
,P_DATE_VALUE4 in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_LEGISLATION_CODE in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: PQH_RT_MATRIX_NODE_VALUES_BK2.UPDATE_RT_MATRIX_NODE_VALUE_B', 10);

Line: 53

hr_utility.set_location(' Leaving: PQH_RT_MATRIX_NODE_VALUES_BK2.UPDATE_RT_MATRIX_NODE_VALUE_B', 20);

Line: 54

end UPDATE_RT_MATRIX_NODE_VALUE_B;