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_SS_WORKFLOW dependencies on HR_API

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 46: FROM hr_api_transaction_steps

42: number_value = previous_number_value,
43: date_value = previous_date_value
44: WHERE transaction_step_id IN (
45: SELECT transaction_step_id
46: FROM hr_api_transaction_steps
47: WHERE transaction_id = p_transactionId
48: --AND api_name <> 'HR_SUPERVISOR_SS.PROCESS_API');
49: AND api_name NOT in ('HR_SUPERVISOR_SS.PROCESS_API'
50: ,'HR_PROCESS_SIT_SS.PROCESS_API'

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 96: FROM hr_api_transaction_steps

92: previous_date_value = date_value,
93: previous_number_value = number_value
94: WHERE transaction_step_id IN (
95: SELECT transaction_step_id
96: FROM hr_api_transaction_steps
97: WHERE transaction_id = p_transactionId
98: --AND api_name <> 'HR_SUPERVISOR_SS.PROCESS_API');
99: AND api_name NOT in ('HR_SUPERVISOR_SS.PROCESS_API'
100: ,'HR_PROCESS_SIT_SS.PROCESS_API'

Line 170: ,p_value => hr_api.g_number

166: HR_TRANSACTION_API.set_number_value (
167: p_transaction_step_id => l_step_history_id
168: ,p_person_id => null
169: ,p_name => l_name
170: ,p_value => hr_api.g_number
171: ,p_original_value => l_originalValue
172: );
173: ELSIF ( l_datatype = 'DATE') THEN
174: HR_TRANSACTION_API.set_date_value (

Line 178: ,p_value => hr_api.g_date

174: HR_TRANSACTION_API.set_date_value (
175: p_transaction_step_id => l_step_history_id
176: ,p_person_id => null
177: ,p_name => l_name
178: ,p_value => hr_api.g_date
179: ,p_original_value => fnd_date.canonical_to_date(l_originalValue)
180: );
181: ELSE
182: HR_TRANSACTION_API.set_varchar2_value (

Line 186: ,p_value => hr_api.g_varchar2

182: HR_TRANSACTION_API.set_varchar2_value (
183: p_transaction_step_id => l_step_history_id
184: ,p_person_id => null
185: ,p_name => l_name
186: ,p_value => hr_api.g_varchar2
187: ,p_original_value => l_originalValue
188: );
189: END IF;
190: END LOOP;

Line 283: FROM hr_api_transactions

279: p_itemType IN VARCHAR2
280: ,p_itemKey IN VARCHAR2 ) RETURN NUMBER IS
281: CURSOR cur_txn IS
282: SELECT transaction_id
283: FROM hr_api_transactions
284: WHERE item_type = p_itemType
285: AND item_key = p_itemKey;
286: l_transactionId NUMBER;
287: BEGIN

Line 639: FROM hr_api_transactions hat,

635:
636: CURSOR cur_sfl IS
637: SELECT nvl(decode(wav.text_value, null, hat.status,
638: decode(hat.status,'S','SUBMIT',hat.status)),'N')
639: FROM hr_api_transactions hat,
640: wf_item_attribute_values wav
641: WHERE hat.item_type = wav.item_Type
642: AND hat.item_key = wav.item_Key
643: AND wav.item_type = itemType

Line 784: FROM hr_api_transactions

780: CURSOR cur_txn IS
781: SELECT transaction_id, status, transaction_state, NVL(transaction_effective_date,sysdate),
782: assignment_id, effective_date_option, plan_id, rptg_grp_id,
783: NVL(selected_person_id,-1), process_name,function_id
784: FROM hr_api_transactions
785: WHERE item_type = p_itemType
786: AND item_key = p_itemKey;
787: --
788: -- Bug 2969312: 21-May-2003: ns

Line 794: FROM hr_api_transaction_steps

790: -- if so flag is set
791: -- Check if the transaction is on an assignment
792: CURSOR cur_chk_asg (c_txnId NUMBER) IS
793: SELECT 'X'
794: FROM hr_api_transaction_steps
795: WHERE transaction_id = c_txnId
796: AND api_name IN (
797: 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API',
798: 'HR_SUPERVISOR_SS.PROCESS_API',

Line 1136: FROM hr_api_transaction_steps

1132: Declare
1133: --
1134: CURSOR cur_asg_step IS
1135: SELECT transaction_step_id
1136: FROM hr_api_transaction_steps
1137: WHERE transaction_id = p_txnId
1138: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1139: --
1140: --

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 1474: FROM hr_api_transactions

1470: --
1471: l_activity_id NUMBER; -- -- added for bug 12561019
1472: CURSOR cur_txn_status IS
1473: SELECT transaction_id, status, transaction_state
1474: FROM hr_api_transactions
1475: WHERE item_type = p_itemType
1476: AND item_key = p_itemKey;
1477: --
1478: BEGIN

Line 1808: FROM hr_api_transaction_steps

1804: ,p_effectiveDateOption IN VARCHAR2 ) IS
1805: --
1806: CURSOR cur_asgn IS
1807: SELECT api_name,transaction_step_id
1808: FROM hr_api_transaction_steps
1809: WHERE transaction_id = p_txnId;
1810: --
1811: -- AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1812: --

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 1899: -- FROM hr_api_transactions

1895: l_step_id NUMBER(15);
1896: --
1897: -- CURSOR cur_status IS
1898: -- SELECT status
1899: -- FROM hr_api_transactions
1900: -- WHERE transaction_id = l_transactionId;
1901: BEGIN
1902: IF (funcmode <> wf_engine.eng_run) THEN
1903: result := wf_engine.eng_null;

Line 1922: from hr_api_transactions

1918:
1919: -- need to check status too
1920: begin
1921: select status into l_status
1922: from hr_api_transactions
1923: where transaction_id=l_transactionId;
1924: exception
1925: when others then
1926: null;

Line 1999: FROM hr_api_transactions

1995: --
1996: -- ItemType aNd ItemKey are for the approval wf process
1997: CURSOR cur_txn IS
1998: SELECT NVL(status,'N')
1999: FROM hr_api_transactions
2000: WHERE item_type = itemType
2001: AND item_key = itemKey;
2002: l_status VARCHAR2(10);
2003: --

Line 2372: FROM hr_api_transactions

2368: CURSOR cur_txn (c_itemType VARCHAR2, c_itemKey VARCHAR2) IS
2369: SELECT -- to_char(NVL(transaction_effective_date,sysdate),g_date_format),
2370: -- assignment_id, selected_person_id,
2371: NVL(status,'N'), NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
2372: FROM hr_api_transactions
2373: WHERE item_type = c_itemType
2374: AND item_key = c_itemKey;
2375: --
2376: BEGIN

Line 2450: FROM hr_api_transactions

2446: result OUT NOCOPY VARCHAR2 ) IS
2447: --
2448: CURSOR cur_txn IS
2449: SELECT transaction_id, NVL(effective_date_option,'X')
2450: FROM hr_api_transactions
2451: WHERE item_type = itemType
2452: AND item_key = itemKey;
2453: --
2454: l_txnId NUMBER(15);

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 = (

Line 2503: FROM hr_api_transaction_steps

2499: WHERE datatype = 'DATE'
2500: AND name = 'P_PASSED_EFFECTIVE_DATE'
2501: AND transaction_step_id = (
2502: SELECT transaction_step_id
2503: FROM hr_api_transaction_steps
2504: WHERE transaction_id = l_txnId
2505: AND api_name = 'HR_SUPERVISOR_SS.PROCESS_API' );
2506: --
2507: END IF;