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_TRANSACTION_API

Line 166: HR_TRANSACTION_API.set_number_value (

162: FETCH cur_orig INTO l_step_history_id, l_datatype, l_name, l_originalValue;
163: EXIT WHEN cur_orig%NOTFOUND;
164: --
165: IF ( l_datatype = 'NUMBER') THEN
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

Line 174: HR_TRANSACTION_API.set_date_value (

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

Line 182: HR_TRANSACTION_API.set_varchar2_value (

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

Line 196: l_dateOption := HR_TRANSACTION_API.get_varchar2_value (

192:
193: IF ( l_step_history_id IS NOT NULL) THEN
194: -- Fetch the effective date and date option from transaction Values
195: -- table and set it to the appropriate columns in transaction (header) table
196: l_dateOption := HR_TRANSACTION_API.get_varchar2_value (
197: p_transaction_step_id => l_step_history_id
198: ,p_name => 'P_EFFECTIVE_DATE_OPTION' );
199: --
200: IF (NVL(l_dateOption,'X') = 'E') THEN

Line 201: l_effectiveDate := HR_TRANSACTION_API.get_date_value (

197: p_transaction_step_id => l_step_history_id
198: ,p_name => 'P_EFFECTIVE_DATE_OPTION' );
199: --
200: IF (NVL(l_dateOption,'X') = 'E') THEN
201: l_effectiveDate := HR_TRANSACTION_API.get_date_value (
202: p_transaction_step_id => l_step_history_id
203: ,p_name => 'P_EFFECTIVE_DATE' );
204: --
205: ELSE

Line 209: HR_TRANSACTION_API.update_transaction (

205: ELSE
206: l_effectiveDate := sysdate;
207: END IF;
208: --
209: HR_TRANSACTION_API.update_transaction (
210: p_transaction_id => p_txnId
211: ,p_transaction_effective_date => l_effectiveDate
212: ,p_effective_date_option => NVL(l_dateOption,'E') );
213: --

Line 1354: hr_transaction_api.update_transaction(

1350: --
1351: elsIF ( l_newState <> NVL(p_state,'**') ) THEN
1352: --
1353: -- update only if no revert is made
1354: hr_transaction_api.update_transaction(
1355: p_transaction_id => p_txnId,
1356: p_status => p_status,
1357: p_transaction_state => l_newState );
1358: END IF;

Line 1525: hr_transaction_api.update_transaction(

1521: END IF;
1522:
1523:
1524:
1525: hr_transaction_api.update_transaction(
1526: p_transaction_id => l_transactionId,
1527: p_status => l_newStatus,
1528: p_transaction_state => l_newState );
1529:

Line 1560: hr_transaction_api.update_transaction(

1556: --
1557: l_newState := null; -- New state will be null.
1558: -- If transaction submitted or Edited and Submitted then set to Y
1559: l_newStatus := 'Y';
1560: hr_transaction_api.update_transaction(
1561: p_transaction_id => l_transactionId,
1562: p_status => l_newStatus,
1563: p_transaction_state => l_newState );
1564:

Line 1583: hr_transaction_api.update_transaction(

1579: ELSIF (p_action = 'APPROVE') THEN
1580: l_newStatus := 'Y';
1581: l_newState := null;
1582:
1583: hr_transaction_api.update_transaction(
1584: p_transaction_id => l_transactionId,
1585: p_status => l_newStatus,
1586: p_transaction_state => l_newState );
1587:

Line 1658: hr_transaction_api.update_transaction(

1654: l_newStatus := 'RO';
1655: END IF;
1656: END IF;
1657: l_newState := null; -- no change to state.
1658: hr_transaction_api.update_transaction(
1659: p_transaction_id => l_transactionId,
1660: p_status => l_newStatus,
1661: p_transaction_state => l_newState );
1662: -- update the transaction state table too

Line 1670: /*hr_transaction_api.update_transaction(

1666: p_transaction_state=>l_newState);
1667:
1668: END IF;
1669: --
1670: /*hr_transaction_api.update_transaction(
1671: p_transaction_id => l_transactionId,
1672: p_status => l_newStatus,
1673: p_transaction_state => l_newState );*/
1674: wf_engine.SetItemAttrText(

Line 1822: HR_TRANSACTION_API.update_transaction (

1818: IF ( NVL(p_effectiveDateOption,'E') = 'A') THEN
1819: l_effectiveDate := sysdate;
1820: END IF;
1821:
1822: HR_TRANSACTION_API.update_transaction (
1823: p_transaction_id => p_txnId
1824: ,p_transaction_effective_date => l_effectiveDate
1825: ,p_effective_date_option => NVL(p_effectiveDateOption,'E') );
1826: --

Line 1831: HR_TRANSACTION_API.set_date_value (

1827:
1828: FOR I IN cur_asgn
1829: LOOP
1830: IF (I.api_name = 'HR_SUPERVISOR_SS.PROCESS_API' ) THEN
1831: HR_TRANSACTION_API.set_date_value (
1832: p_transaction_step_id => I.transaction_step_id
1833: ,p_person_id => null
1834: ,p_name => 'P_PASSED_EFFECTIVE_DATE'
1835: ,p_value => l_effectiveDate );

Line 1859: HR_TRANSACTION_API.set_date_value (

1855: */
1856: ELSE
1857: --
1858: --
1859: HR_TRANSACTION_API.set_date_value (
1860: p_transaction_step_id => I.transaction_step_id
1861: ,p_person_id => null -- used to validate, no other usage
1862: ,p_name => 'P_EFFECTIVE_DATE'
1863: ,p_value => p_effectiveDate );

Line 1865: HR_TRANSACTION_API.set_varchar2_value (

1861: ,p_person_id => null -- used to validate, no other usage
1862: ,p_name => 'P_EFFECTIVE_DATE'
1863: ,p_value => p_effectiveDate );
1864: --
1865: HR_TRANSACTION_API.set_varchar2_value (
1866: p_transaction_step_id => I.transaction_step_id
1867: ,p_person_id => null -- used to validate, no other usage
1868: ,p_name => 'P_EFFECTIVE_DATE_OPTION'
1869: ,p_value => NVL(p_effectiveDateOption,'E') );

Line 1932: hr_transaction_api.rollback_transaction

1928: --
1929:
1930: -- Remove transaction if it's a new one, else revert back to previous values
1931: IF ( l_ntfId IS NULL and l_status='W' ) THEN
1932: hr_transaction_api.rollback_transaction
1933: (p_transaction_id => l_transactionId );
1934:
1935: --3099089 change starts
1936: --need to remove transaction_id from wf_item_attribute_values also

Line 1964: /* hr_transaction_api.update_transaction (

1960: --vegopala fix for bug 5436747.Commenting as it is not
1961: -- reqd to set to T.
1962: -- Set the state to T once the activities are completed.
1963: --
1964: /* hr_transaction_api.update_transaction (
1965: p_transaction_id => l_transactionId
1966: ,p_transaction_state => 'T' );
1967: */
1968: --

Line 2471: HR_TRANSACTION_API.update_transaction (

2467:
2468: IF ( l_effDateOption = 'A' ) THEN
2469: l_effectiveDate := sysdate;
2470:
2471: HR_TRANSACTION_API.update_transaction (
2472: p_transaction_id => l_txnId
2473: ,p_transaction_effective_date => l_effectiveDate );
2474: --
2475: wf_engine.setItemAttrText

Line 2943: hr_transaction_api.update_transaction(

2939:
2940: -- Bug 3035702: Allow starting new transaction if existing transaction is in error
2941: -- Set transaction status to 'E - Error' so that it does not block any other transaction
2942: -- and can be picked up for cleanup.
2943: hr_transaction_api.update_transaction(
2944: p_transaction_id => get_transaction_id(itemType,itemKey),
2945: p_status => 'E');
2946:
2947: -- Fix for bug 8334527 :

Line 3130: hr_transaction_api.rollback_transaction(p_transactionId);

3126: p_activity => l_activity_id,
3127: p_otherAct => 'THIS',
3128: p_resultCode => 'DEL' );
3129: elsif p_transactionId is not null then
3130: hr_transaction_api.rollback_transaction(p_transactionId);
3131: end if;
3132: --
3133: /*
3134: exception

Line 3136: hr_transaction_api.rollback_transaction

3132: --
3133: /*
3134: exception
3135: when others then
3136: hr_transaction_api.rollback_transaction
3137: (p_transaction_id => p_transactionid);
3138: */
3139: end;
3140: --

Line 3220: hr_transaction_api.update_transaction(

3216: --
3217: -- Bug 3035702: Allow starting new transaction if existing transaction is in error
3218: -- Set transaction status to 'E - Error' so that it does not block any other transaction
3219: -- and can be picked up for cleanup.
3220: hr_transaction_api.update_transaction(
3221: p_transaction_id => get_transaction_id(itemType,itemKey),
3222: p_status => 'E');
3223: END IF;
3224: --