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 636: FROM hr_api_transactions hat,

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

Line 781: FROM hr_api_transactions

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

Line 791: FROM hr_api_transaction_steps

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

Line 1115: FROM hr_api_transaction_steps

1111: Declare
1112: --
1113: CURSOR cur_asg_step IS
1114: SELECT transaction_step_id
1115: FROM hr_api_transaction_steps
1116: WHERE transaction_id = p_txnId
1117: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1118: --
1119: --

Line 1122: FROM hr_api_transaction_values tv,

1118: --
1119: --
1120: CURSOR cur_match_ovn (c_txn_step_id NUMBER, c_effDate DATE) IS
1121: SELECT 'X'
1122: FROM hr_api_transaction_values tv,
1123: per_assignments_f af
1124: WHERE af.assignment_id = p_assignmentId
1125: AND tv.transaction_step_id = c_txn_step_id
1126: AND tv.name = 'P_OBJECT_VERSION_NUMBER'

Line 1452: FROM hr_api_transactions

1448: l_newStatus VARCHAR2(10);
1449: --
1450: CURSOR cur_txn_status IS
1451: SELECT transaction_id, status, transaction_state
1452: FROM hr_api_transactions
1453: WHERE item_type = p_itemType
1454: AND item_key = p_itemKey;
1455: --
1456: BEGIN

Line 1785: FROM hr_api_transaction_steps

1781: ,p_effectiveDateOption IN VARCHAR2 ) IS
1782: --
1783: CURSOR cur_asgn IS
1784: SELECT api_name,transaction_step_id
1785: FROM hr_api_transaction_steps
1786: WHERE transaction_id = p_txnId;
1787: --
1788: -- AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1789: --

Line 1826: UPDATE hr_api_transaction_values

1822: -- Note: Termination step may also have to be added in case the
1823: -- Notification date is to be set to as of approval date
1824: -- ====================================================================
1825: IF ( NVL(p_effectiveDateOption,'E') = 'A' ) THEN
1826: UPDATE hr_api_transaction_values
1827: SET date_value = l_effectiveDate
1828: WHERE transaction_step_id = I.transaction_step_id
1829: AND name like 'P%DATE%';
1830: END IF;

Line 1876: -- FROM hr_api_transactions

1872: l_step_id NUMBER(15);
1873: --
1874: -- CURSOR cur_status IS
1875: -- SELECT status
1876: -- FROM hr_api_transactions
1877: -- WHERE transaction_id = l_transactionId;
1878: BEGIN
1879: IF (funcmode <> wf_engine.eng_run) THEN
1880: result := wf_engine.eng_null;

Line 1899: from hr_api_transactions

1895:
1896: -- need to check status too
1897: begin
1898: select status into l_status
1899: from hr_api_transactions
1900: where transaction_id=l_transactionId;
1901: exception
1902: when others then
1903: null;

Line 1976: FROM hr_api_transactions

1972: --
1973: -- ItemType aNd ItemKey are for the approval wf process
1974: CURSOR cur_txn IS
1975: SELECT NVL(status,'N')
1976: FROM hr_api_transactions
1977: WHERE item_type = itemType
1978: AND item_key = itemKey;
1979: l_status VARCHAR2(10);
1980: --

Line 2349: FROM hr_api_transactions

2345: CURSOR cur_txn (c_itemType VARCHAR2, c_itemKey VARCHAR2) IS
2346: SELECT -- to_char(NVL(transaction_effective_date,sysdate),g_date_format),
2347: -- assignment_id, selected_person_id,
2348: NVL(status,'N'), NVL(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
2349: FROM hr_api_transactions
2350: WHERE item_type = c_itemType
2351: AND item_key = c_itemKey;
2352: --
2353: BEGIN

Line 2427: FROM hr_api_transactions

2423: result OUT NOCOPY VARCHAR2 ) IS
2424: --
2425: CURSOR cur_txn IS
2426: SELECT transaction_id, NVL(effective_date_option,'X')
2427: FROM hr_api_transactions
2428: WHERE item_type = itemType
2429: AND item_key = itemKey;
2430: --
2431: l_txnId NUMBER(15);

Line 2474: UPDATE hr_api_transaction_values

2470: -- clause name like 'P%DATE%'.
2471: -- If it is decided that notified date must be as of approval then
2472: -- then add the where clause api_name = 'HR_TERMINATION_SS.PROCESS_API'
2473: -- ==================================================================
2474: UPDATE hr_api_transaction_values
2475: SET date_value = l_effectiveDate
2476: WHERE datatype = 'DATE'
2477: AND name = 'P_PASSED_EFFECTIVE_DATE'
2478: AND transaction_step_id = (

Line 2480: FROM hr_api_transaction_steps

2476: WHERE datatype = 'DATE'
2477: AND name = 'P_PASSED_EFFECTIVE_DATE'
2478: AND transaction_step_id = (
2479: SELECT transaction_step_id
2480: FROM hr_api_transaction_steps
2481: WHERE transaction_id = l_txnId
2482: AND api_name = 'HR_SUPERVISOR_SS.PROCESS_API' );
2483: --
2484: END IF;