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 1333: hr_transaction_api.update_transaction(

1329: --
1330: elsIF ( l_newState <> NVL(p_state,'**') ) THEN
1331: --
1332: -- update only if no revert is made
1333: hr_transaction_api.update_transaction(
1334: p_transaction_id => p_txnId,
1335: p_status => p_status,
1336: p_transaction_state => l_newState );
1337: END IF;

Line 1502: hr_transaction_api.update_transaction(

1498: END IF;
1499:
1500:
1501:
1502: hr_transaction_api.update_transaction(
1503: p_transaction_id => l_transactionId,
1504: p_status => l_newStatus,
1505: p_transaction_state => l_newState );
1506:

Line 1537: hr_transaction_api.update_transaction(

1533: --
1534: l_newState := null; -- New state will be null.
1535: -- If transaction submitted or Edited and Submitted then set to Y
1536: l_newStatus := 'Y';
1537: hr_transaction_api.update_transaction(
1538: p_transaction_id => l_transactionId,
1539: p_status => l_newStatus,
1540: p_transaction_state => l_newState );
1541:

Line 1560: hr_transaction_api.update_transaction(

1556: ELSIF (p_action = 'APPROVE') THEN
1557: l_newStatus := 'Y';
1558: l_newState := null;
1559:
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 1635: hr_transaction_api.update_transaction(

1631: l_newStatus := 'RO';
1632: END IF;
1633: END IF;
1634: l_newState := null; -- no change to state.
1635: hr_transaction_api.update_transaction(
1636: p_transaction_id => l_transactionId,
1637: p_status => l_newStatus,
1638: p_transaction_state => l_newState );
1639: -- update the transaction state table too

Line 1647: /*hr_transaction_api.update_transaction(

1643: p_transaction_state=>l_newState);
1644:
1645: END IF;
1646: --
1647: /*hr_transaction_api.update_transaction(
1648: p_transaction_id => l_transactionId,
1649: p_status => l_newStatus,
1650: p_transaction_state => l_newState );*/
1651: wf_engine.SetItemAttrText(

Line 1799: HR_TRANSACTION_API.update_transaction (

1795: IF ( NVL(p_effectiveDateOption,'E') = 'A') THEN
1796: l_effectiveDate := sysdate;
1797: END IF;
1798:
1799: HR_TRANSACTION_API.update_transaction (
1800: p_transaction_id => p_txnId
1801: ,p_transaction_effective_date => l_effectiveDate
1802: ,p_effective_date_option => NVL(p_effectiveDateOption,'E') );
1803: --

Line 1808: HR_TRANSACTION_API.set_date_value (

1804:
1805: FOR I IN cur_asgn
1806: LOOP
1807: IF (I.api_name = 'HR_SUPERVISOR_SS.PROCESS_API' ) THEN
1808: HR_TRANSACTION_API.set_date_value (
1809: p_transaction_step_id => I.transaction_step_id
1810: ,p_person_id => null
1811: ,p_name => 'P_PASSED_EFFECTIVE_DATE'
1812: ,p_value => l_effectiveDate );

Line 1836: HR_TRANSACTION_API.set_date_value (

1832: */
1833: ELSE
1834: --
1835: --
1836: HR_TRANSACTION_API.set_date_value (
1837: p_transaction_step_id => I.transaction_step_id
1838: ,p_person_id => null -- used to validate, no other usage
1839: ,p_name => 'P_EFFECTIVE_DATE'
1840: ,p_value => p_effectiveDate );

Line 1842: HR_TRANSACTION_API.set_varchar2_value (

1838: ,p_person_id => null -- used to validate, no other usage
1839: ,p_name => 'P_EFFECTIVE_DATE'
1840: ,p_value => p_effectiveDate );
1841: --
1842: HR_TRANSACTION_API.set_varchar2_value (
1843: p_transaction_step_id => I.transaction_step_id
1844: ,p_person_id => null -- used to validate, no other usage
1845: ,p_name => 'P_EFFECTIVE_DATE_OPTION'
1846: ,p_value => NVL(p_effectiveDateOption,'E') );

Line 1909: hr_transaction_api.rollback_transaction

1905: --
1906:
1907: -- Remove transaction if it's a new one, else revert back to previous values
1908: IF ( l_ntfId IS NULL and l_status='W' ) THEN
1909: hr_transaction_api.rollback_transaction
1910: (p_transaction_id => l_transactionId );
1911:
1912: --3099089 change starts
1913: --need to remove transaction_id from wf_item_attribute_values also

Line 1941: /* hr_transaction_api.update_transaction (

1937: --vegopala fix for bug 5436747.Commenting as it is not
1938: -- reqd to set to T.
1939: -- Set the state to T once the activities are completed.
1940: --
1941: /* hr_transaction_api.update_transaction (
1942: p_transaction_id => l_transactionId
1943: ,p_transaction_state => 'T' );
1944: */
1945: --

Line 2448: HR_TRANSACTION_API.update_transaction (

2444:
2445: IF ( l_effDateOption = 'A' ) THEN
2446: l_effectiveDate := sysdate;
2447:
2448: HR_TRANSACTION_API.update_transaction (
2449: p_transaction_id => l_txnId
2450: ,p_transaction_effective_date => l_effectiveDate );
2451: --
2452: wf_engine.setItemAttrText

Line 2919: hr_transaction_api.update_transaction(

2915:
2916: -- Bug 3035702: Allow starting new transaction if existing transaction is in error
2917: -- Set transaction status to 'E - Error' so that it does not block any other transaction
2918: -- and can be picked up for cleanup.
2919: hr_transaction_api.update_transaction(
2920: p_transaction_id => get_transaction_id(itemType,itemKey),
2921: p_status => 'E');
2922:
2923: result := 'COMPLETE:FAILURE';

Line 3098: hr_transaction_api.rollback_transaction(p_transactionId);

3094: p_activity => l_activity_id,
3095: p_otherAct => 'THIS',
3096: p_resultCode => 'DEL' );
3097: elsif p_transactionId is not null then
3098: hr_transaction_api.rollback_transaction(p_transactionId);
3099: end if;
3100: --
3101: /*
3102: exception

Line 3104: hr_transaction_api.rollback_transaction

3100: --
3101: /*
3102: exception
3103: when others then
3104: hr_transaction_api.rollback_transaction
3105: (p_transaction_id => p_transactionid);
3106: */
3107: end;
3108: --

Line 3188: hr_transaction_api.update_transaction(

3184: --
3185: -- Bug 3035702: Allow starting new transaction if existing transaction is in error
3186: -- Set transaction status to 'E - Error' so that it does not block any other transaction
3187: -- and can be picked up for cleanup.
3188: hr_transaction_api.update_transaction(
3189: p_transaction_id => get_transaction_id(itemType,itemKey),
3190: p_status => 'E');
3191: END IF;
3192: --