APPS.PQH_SS_WORKFLOW dependencies on HR_API_TRANSACTION_VALUES

Line 32: hr_api_transaction_values table

28: --
29: /* **************************************************************
30: UPDATE_TXN_CURRENT_VALUES
31: Private procedure to update current values to previous values in
32: hr_api_transaction_values table
33: *************************************************************** */
34: PROCEDURE update_txn_current_values ( p_transactionId NUMBER) IS
35: BEGIN
36: IF ( p_transactionId IS NULL ) THEN

Line 40: UPDATE hr_api_transaction_values

36: IF ( p_transactionId IS NULL ) THEN
37: RETURN;
38: END IF;
39: --
40: UPDATE hr_api_transaction_values
41: SET varchar2_value = previous_varchar2_value,
42: number_value = previous_number_value,
43: date_value = previous_date_value
44: WHERE transaction_step_id IN (

Line 79: hr_api_transaction_values table

75: END;
76: /* **************************************************************
77: UPDATE_TXN_PREVIOUS_VALUES
78: Private procedure to update previous values to current values in
79: hr_api_transaction_values table
80: *************************************************************** */
81: --
82: PROCEDURE update_txn_previous_values ( p_transactionId NUMBER) IS
83: --

Line 90: UPDATE hr_api_transaction_values

86: IF ( p_transactionId IS NULL ) THEN
87: RETURN;
88: END IF;
89: --
90: UPDATE hr_api_transaction_values
91: SET previous_varchar2_value = varchar2_value,
92: previous_date_value = date_value,
93: previous_number_value = number_value
94: WHERE transaction_step_id IN (

Line 1143: FROM hr_api_transaction_values tv,

1139: --
1140: --
1141: CURSOR cur_match_ovn (c_txn_step_id NUMBER, c_effDate DATE) IS
1142: SELECT 'X'
1143: FROM hr_api_transaction_values tv,
1144: per_assignments_f af
1145: WHERE af.assignment_id = p_assignmentId
1146: AND tv.transaction_step_id = c_txn_step_id
1147: AND tv.name = 'P_OBJECT_VERSION_NUMBER'

Line 1849: UPDATE hr_api_transaction_values

1845: -- Note: Termination step may also have to be added in case the
1846: -- Notification date is to be set to as of approval date
1847: -- ====================================================================
1848: IF ( NVL(p_effectiveDateOption,'E') = 'A' ) THEN
1849: UPDATE hr_api_transaction_values
1850: SET date_value = l_effectiveDate
1851: WHERE transaction_step_id = I.transaction_step_id
1852: AND name like 'P%DATE%';
1853: END IF;

Line 2497: UPDATE hr_api_transaction_values

2493: -- clause name like 'P%DATE%'.
2494: -- If it is decided that notified date must be as of approval then
2495: -- then add the where clause api_name = 'HR_TERMINATION_SS.PROCESS_API'
2496: -- ==================================================================
2497: UPDATE hr_api_transaction_values
2498: SET date_value = l_effectiveDate
2499: WHERE datatype = 'DATE'
2500: AND name = 'P_PASSED_EFFECTIVE_DATE'
2501: AND transaction_step_id = (