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.HR_TRANSACTION_SWI dependencies on HR_API_TRANSACTIONS

Line 61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;

57: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
58: )
59: is
60:
61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;
62: l_creator_role hr_api_transactions.creator_role%type;
63: l_last_update_role hr_api_transactions.last_update_role%type;
64:
65:

Line 62: l_creator_role hr_api_transactions.creator_role%type;

58: )
59: is
60:
61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;
62: l_creator_role hr_api_transactions.creator_role%type;
63: l_last_update_role hr_api_transactions.last_update_role%type;
64:
65:
66: PRAGMA AUTONOMOUS_TRANSACTION;

Line 63: l_last_update_role hr_api_transactions.last_update_role%type;

59: is
60:
61: l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;
62: l_creator_role hr_api_transactions.creator_role%type;
63: l_last_update_role hr_api_transactions.last_update_role%type;
64:
65:
66: PRAGMA AUTONOMOUS_TRANSACTION;
67: begin

Line 293: l_last_update_role hr_api_transactions.last_update_role%type;

289: ,P_VALIDATE IN NUMBER default hr_api.g_false_num
290: )
291: is
292: l_proc varchar2(72) := 'update_transaction';
293: l_last_update_role hr_api_transactions.last_update_role%type;
294: PRAGMA AUTONOMOUS_TRANSACTION;
295: begin
296: --savepoint update_transaction;
297: l_last_update_role := nvl(P_LAST_UPDATE_ROLE, 'PER:' || fnd_global.employee_id);

Line 861: from hr_api_transactions hat

857: hat.transaction_effective_date,
858: hat.process_name,
859: hat.transaction_state,
860: hat.effective_date_option
861: from hr_api_transactions hat
862: where hat.transaction_id =p_transaction_id;
863: step_row csr_hat%rowtype;
864: l_proc varchar2(72) := g_package || 'set_transaction_context';
865: Begin

Line 977: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

973: step_row csr_person_details%rowtype;
974: l_proc varchar2(72) := g_package || 'set_person_context';
975: l_orgid number;
976: ----------
977: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
978: p_transaction_id number;
979: dummy VARCHAR2(10);
980: ----------
981: Begin

Line 1054: from hr_api_transactions

1050: /*
1051: if(p_transaction_id is not null) then
1052: begin
1053: select * into lr_hr_api_transaction_rec
1054: from hr_api_transactions
1055: where transaction_id= p_transaction_id;
1056:
1057: if(lr_hr_api_transaction_rec.item_key IS NOT NULL) THEN
1058: if(wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,

Line 1092: from hr_api_transactions

1088:
1089: declare
1090: cursor cur is
1091: select *
1092: from hr_api_transactions
1093: where transaction_id = p_transaction_id;
1094: begin
1095:
1096: hr_utility.trace('Entered into anonymous block for fix 11776102');

Line 1220: c_updateStatus hr_api_transactions.status%type;

1216: PRAGMA AUTONOMOUS_TRANSACTION;
1217: --
1218: -- local variables
1219: c_proc constant varchar2(30) := 'setTransactionStatus';
1220: c_updateStatus hr_api_transactions.status%type;
1221: ln_notification_id wf_notifications.notification_id%type;
1222: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1223:
1224: begin

Line 1222: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1218: -- local variables
1219: c_proc constant varchar2(30) := 'setTransactionStatus';
1220: c_updateStatus hr_api_transactions.status%type;
1221: ln_notification_id wf_notifications.notification_id%type;
1222: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1223:
1224: begin
1225: -- check if debug enabled
1226: if g_debug then

Line 1285: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1281: return varchar2
1282: is
1283: -- local variables
1284: editAllowed varchar2(1);
1285: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1286: lr_per_appraisals_rec per_appraisals%rowtype;
1287: l_authenticateNtf boolean;
1288:
1289: CURSOR csr_appr_details (p_appraisal_id IN NUMBER)

Line 1344: from hr_api_transactions

1340: if(p_transaction_id is not null) then
1341: -- get the transaction details
1342: begin
1343: select * into lr_hr_api_transaction_rec
1344: from hr_api_transactions
1345: where transaction_id=p_transaction_id;
1346: exception
1347: when others then
1348: editAllowed :='N';

Line 1450: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1446: return varchar2
1447: is
1448: -- local variables
1449: deleteAllowed varchar2(1);
1450: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1451: l_authenticateNtf boolean;
1452: begin
1453:
1454: -- set default

Line 1502: from hr_api_transactions

1498: if(p_transaction_id is not null) then
1499: -- get the transaction details
1500: begin
1501: select * into lr_hr_api_transaction_rec
1502: from hr_api_transactions
1503: where transaction_id=p_transaction_id;
1504: exception
1505: when others then
1506: deleteAllowed :='N';

Line 1646: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1642: p_transaction_type in varchar2,
1643: p_item_type in varchar2,
1644: p_item_key in varchar2)
1645: is
1646: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1647: lv_result varchar2(100);
1648: ln_notification_id wf_notifications.notification_id%type;
1649: ln_activity_id wf_item_activity_statuses.process_activity%type;
1650: begin

Line 1706: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1702: end othersDeleteAction;
1703:
1704: procedure deleteAction(p_transaction_id in number)
1705: is
1706: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1707: lv_result varchar2(100);
1708: begin
1709: -- this routine is called from all actions UI
1710: --

Line 1728: from hr_api_transactions

1724: */
1725: if(p_transaction_id is not null) then
1726: begin
1727: select * into lr_hr_api_transaction_rec
1728: from hr_api_transactions
1729: where transaction_id=p_transaction_id;
1730: exception
1731: when others then
1732: raise;

Line 1761: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1757:
1758: procedure initiatorDeleteAction(p_transaction_id in number)
1759: is
1760: lv_result varchar2(100);
1761: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1762: begin
1763:
1764: if(p_transaction_id is not null) then
1765: -- Read Transaction Details

Line 1768: from hr_api_transactions

1764: if(p_transaction_id is not null) then
1765: -- Read Transaction Details
1766: begin
1767: select * into lr_hr_api_transaction_rec
1768: from hr_api_transactions
1769: where transaction_id=p_transaction_id;
1770: exception
1771: when others then
1772: raise;

Line 1823: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1819:
1820:
1821: procedure cancelAction(p_transaction_id in number)
1822: is
1823: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1824: begin
1825:
1826: if(p_transaction_id is not null) then
1827: begin

Line 1829: from hr_api_transactions

1825:
1826: if(p_transaction_id is not null) then
1827: begin
1828: select * into lr_hr_api_transaction_rec
1829: from hr_api_transactions
1830: where transaction_id=p_transaction_id;
1831: exception
1832: when others then
1833: null;

Line 1874: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1870: p_person_id in number) return boolean
1871: is
1872: -- local variables
1873: x_returnStatus boolean;
1874: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1875: ln_person_id number;
1876: begin
1877:
1878: -- set the default value

Line 1885: select hr_api_transactions.creator_person_id

1881:
1882: if(p_transaction_id is not null) then
1883: -- ignore passed personid
1884: -- derive from the transaction details
1885: select hr_api_transactions.creator_person_id
1886: into ln_person_id
1887: from hr_api_transactions
1888: where transaction_id=p_transaction_id;
1889: end if;

Line 1887: from hr_api_transactions

1883: -- ignore passed personid
1884: -- derive from the transaction details
1885: select hr_api_transactions.creator_person_id
1886: into ln_person_id
1887: from hr_api_transactions
1888: where transaction_id=p_transaction_id;
1889: end if;
1890:
1891: --

Line 1909: from hr_api_transactions trn

1905: p_validate in NUMBER default hr_api.g_false_num)
1906: is
1907: cursor csr_trn is
1908: select trn.transaction_id
1909: from hr_api_transactions trn
1910: where trn.parent_transaction_id = p_transaction_id;
1911: begin
1912: for csr_row in csr_trn loop
1913: delete_transaction(csr_row.transaction_id);

Line 1949: lr_transaction_rec hr_api_transactions%rowtype;

1945: ,p_status out nocopy varchar2) as
1946:
1947:
1948: lv_item_type wf_items.item_type%type;
1949: lr_transaction_rec hr_api_transactions%rowtype;
1950: lv_status varchar2(8);
1951: lv_result varchar2(30);
1952: lv_errorActid wf_item_activity_statuses.process_activity%type;
1953: lv_errname VARCHAR2(4000);

Line 1982: from hr_api_transactions

1978: if(p_transaction_id is not null) then
1979: -- get the transaction details
1980: select *
1981: into lr_transaction_rec
1982: from hr_api_transactions
1983: where transaction_id=p_transaction_id;
1984:
1985: -- derive the fnd function params values from txn
1986: lv_approval_required := hr_xml_util.get_node_value(p_transaction_id,

Line 2270: c_updateStatus hr_api_transactions.status%type;

2266: PRAGMA AUTONOMOUS_TRANSACTION;
2267: --
2268: -- local variables
2269: c_proc constant varchar2(30) := 'setTransactionStatus';
2270: c_updateStatus hr_api_transactions.status%type;
2271: ln_notification_id wf_notifications.notification_id%type;
2272: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2273: lv_item_key wf_items.item_key%type;
2274: lt_additional_wf_attributes HR_WF_ATTR_TABLE;

Line 2272: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

2268: -- local variables
2269: c_proc constant varchar2(30) := 'setTransactionStatus';
2270: c_updateStatus hr_api_transactions.status%type;
2271: ln_notification_id wf_notifications.notification_id%type;
2272: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2273: lv_item_key wf_items.item_key%type;
2274: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2275: lv_error_message varchar2(4000);
2276: lv_errstack varchar2(4000);

Line 2279: lv_currentTxnStatus hr_api_transactions.status%type;

2275: lv_error_message varchar2(4000);
2276: lv_errstack varchar2(4000);
2277: lv_status varchar2(30); -- revisit on the size
2278: lv_wf_item_attribute HR_WF_ATTR_TYPE;
2279: lv_currentTxnStatus hr_api_transactions.status%type;
2280:
2281:
2282: begin
2283: -- check if debug enabled

Line 2300: from hr_api_transactions

2296: c_updateStatus:='Y';
2297: elsif(p_proposedTxnStatus='S')then
2298: begin
2299: select status into lv_currentTxnStatus
2300: from hr_api_transactions
2301: where transaction_id=p_transaction_id;
2302: exception
2303: when others then
2304: null;

Line 2323: from hr_api_transactions

2319: -- send SFL notification
2320: -- get the transaction record
2321: select *
2322: into lr_hr_api_transaction_rec
2323: from hr_api_transactions
2324: where transaction_id=p_transaction_id;
2325: -- send sfl notification to login user
2326: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2327: p_transaction_ref_table,

Line 2351: from hr_api_transactions

2347: begin
2348: -- check if the wf process is initialized or not
2349: select *
2350: into lr_hr_api_transaction_rec
2351: from hr_api_transactions
2352: where transaction_id=p_transaction_id;
2353:
2354: exception
2355: when others then

Line 2430: c_updateStatus hr_api_transactions.status%type;

2426: PRAGMA AUTONOMOUS_TRANSACTION;
2427: --
2428: -- local variables
2429: c_proc constant varchar2(30) := 'setTransactionStatus';
2430: c_updateStatus hr_api_transactions.status%type;
2431: ln_notification_id wf_notifications.notification_id%type;
2432: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2433: lv_item_key wf_items.item_key%type;
2434: lv_item_type wf_items.item_type%type;

Line 2432: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

2428: -- local variables
2429: c_proc constant varchar2(30) := 'setTransactionStatus';
2430: c_updateStatus hr_api_transactions.status%type;
2431: ln_notification_id wf_notifications.notification_id%type;
2432: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2433: lv_item_key wf_items.item_key%type;
2434: lv_item_type wf_items.item_type%type;
2435: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2436: lv_error_message varchar2(4000);

Line 2440: lv_currentTxnStatus hr_api_transactions.status%type;

2436: lv_error_message varchar2(4000);
2437: lv_errstack varchar2(4000);
2438: lv_status varchar2(30); -- revisit on the size
2439: lv_wf_item_attribute HR_WF_ATTR_TYPE;
2440: lv_currentTxnStatus hr_api_transactions.status%type;
2441:
2442:
2443: begin
2444:

Line 2462: from hr_api_transactions

2458: c_updateStatus:='Y';
2459: elsif(p_proposedTxnStatus='S')then
2460: begin
2461: select status into lv_currentTxnStatus
2462: from hr_api_transactions
2463: where transaction_id=p_transaction_id;
2464: exception
2465: when others then
2466: null;

Line 2485: from hr_api_transactions

2481: -- send SFL notification
2482: -- get the transaction record
2483: select *
2484: into lr_hr_api_transaction_rec
2485: from hr_api_transactions
2486: where transaction_id=p_transaction_id;
2487: -- send sfl notification to login user
2488: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2489: p_transaction_ref_table,

Line 2513: from hr_api_transactions

2509: begin
2510: -- check if the wf process is initialized or not
2511: select *
2512: into lr_hr_api_transaction_rec
2513: from hr_api_transactions
2514: where transaction_id=p_transaction_id;
2515:
2516: exception
2517: when others then

Line 2686: FROM hr_api_transactions

2682: p_status OUT nocopy VARCHAR2,
2683: p_error_log IN OUT nocopy CLOB)IS
2684: CURSOR csr_trn IS
2685: SELECT transaction_document
2686: FROM hr_api_transactions
2687: WHERE transaction_id = p_transaction_id;
2688:
2689: CURSOR csr_trn_item IS
2690: SELECT item_type,item_key

Line 2691: FROM hr_api_transactions

2687: WHERE transaction_id = p_transaction_id;
2688:
2689: CURSOR csr_trn_item IS
2690: SELECT item_type,item_key
2691: FROM hr_api_transactions
2692: WHERE transaction_id = p_transaction_id;
2693: rootNode xmldom.DOMNode;
2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;