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 857: from hr_api_transactions hat

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

Line 1107: c_updateStatus hr_api_transactions.status%type;

1103: PRAGMA AUTONOMOUS_TRANSACTION;
1104: --
1105: -- local variables
1106: c_proc constant varchar2(30) := 'setTransactionStatus';
1107: c_updateStatus hr_api_transactions.status%type;
1108: ln_notification_id wf_notifications.notification_id%type;
1109: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1110:
1111: begin

Line 1109: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1105: -- local variables
1106: c_proc constant varchar2(30) := 'setTransactionStatus';
1107: c_updateStatus hr_api_transactions.status%type;
1108: ln_notification_id wf_notifications.notification_id%type;
1109: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1110:
1111: begin
1112: -- check if debug enabled
1113: if g_debug then

Line 1172: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1168: return varchar2
1169: is
1170: -- local variables
1171: editAllowed varchar2(1);
1172: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1173: l_authenticateNtf boolean;
1174: begin
1175:
1176: -- check if we need to propagate the error messages

Line 1224: from hr_api_transactions

1220: if(p_transaction_id is not null) then
1221: -- get the transaction details
1222: begin
1223: select * into lr_hr_api_transaction_rec
1224: from hr_api_transactions
1225: where transaction_id=p_transaction_id;
1226: exception
1227: when others then
1228: editAllowed :='N';

Line 1299: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1295: return varchar2
1296: is
1297: -- local variables
1298: deleteAllowed varchar2(1);
1299: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1300: l_authenticateNtf boolean;
1301: begin
1302:
1303: -- set default

Line 1351: from hr_api_transactions

1347: if(p_transaction_id is not null) then
1348: -- get the transaction details
1349: begin
1350: select * into lr_hr_api_transaction_rec
1351: from hr_api_transactions
1352: where transaction_id=p_transaction_id;
1353: exception
1354: when others then
1355: deleteAllowed :='N';

Line 1488: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1484: p_transaction_type in varchar2,
1485: p_item_type in varchar2,
1486: p_item_key in varchar2)
1487: is
1488: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1489: lv_result varchar2(100);
1490: ln_notification_id wf_notifications.notification_id%type;
1491: ln_activity_id wf_item_activity_statuses.process_activity%type;
1492: begin

Line 1548: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1544: end othersDeleteAction;
1545:
1546: procedure deleteAction(p_transaction_id in number)
1547: is
1548: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1549: lv_result varchar2(100);
1550: begin
1551: -- this routine is called from all actions UI
1552: --

Line 1570: from hr_api_transactions

1566: */
1567: if(p_transaction_id is not null) then
1568: begin
1569: select * into lr_hr_api_transaction_rec
1570: from hr_api_transactions
1571: where transaction_id=p_transaction_id;
1572: exception
1573: when others then
1574: raise;

Line 1603: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1599:
1600: procedure initiatorDeleteAction(p_transaction_id in number)
1601: is
1602: lv_result varchar2(100);
1603: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1604: begin
1605:
1606: if(p_transaction_id is not null) then
1607: -- Read Transaction Details

Line 1610: from hr_api_transactions

1606: if(p_transaction_id is not null) then
1607: -- Read Transaction Details
1608: begin
1609: select * into lr_hr_api_transaction_rec
1610: from hr_api_transactions
1611: where transaction_id=p_transaction_id;
1612: exception
1613: when others then
1614: raise;

Line 1665: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1661:
1662:
1663: procedure cancelAction(p_transaction_id in number)
1664: is
1665: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1666: begin
1667:
1668: if(p_transaction_id is not null) then
1669: begin

Line 1671: from hr_api_transactions

1667:
1668: if(p_transaction_id is not null) then
1669: begin
1670: select * into lr_hr_api_transaction_rec
1671: from hr_api_transactions
1672: where transaction_id=p_transaction_id;
1673: exception
1674: when others then
1675: null;

Line 1716: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

1712: p_person_id in number) return boolean
1713: is
1714: -- local variables
1715: x_returnStatus boolean;
1716: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1717: ln_person_id number;
1718: begin
1719:
1720: -- set the default value

Line 1727: select hr_api_transactions.creator_person_id

1723:
1724: if(p_transaction_id is not null) then
1725: -- ignore passed personid
1726: -- derive from the transaction details
1727: select hr_api_transactions.creator_person_id
1728: into ln_person_id
1729: from hr_api_transactions
1730: where transaction_id=p_transaction_id;
1731: end if;

Line 1729: from hr_api_transactions

1725: -- ignore passed personid
1726: -- derive from the transaction details
1727: select hr_api_transactions.creator_person_id
1728: into ln_person_id
1729: from hr_api_transactions
1730: where transaction_id=p_transaction_id;
1731: end if;
1732:
1733: --

Line 1751: from hr_api_transactions trn

1747: p_validate in NUMBER default hr_api.g_false_num)
1748: is
1749: cursor csr_trn is
1750: select trn.transaction_id
1751: from hr_api_transactions trn
1752: where trn.parent_transaction_id = p_transaction_id;
1753: begin
1754: for csr_row in csr_trn loop
1755: delete_transaction(csr_row.transaction_id);

Line 1791: lr_transaction_rec hr_api_transactions%rowtype;

1787: ,p_status out nocopy varchar2) as
1788:
1789:
1790: lv_item_type wf_items.item_type%type;
1791: lr_transaction_rec hr_api_transactions%rowtype;
1792: lv_status varchar2(8);
1793: lv_result varchar2(30);
1794: lv_errorActid wf_item_activity_statuses.process_activity%type;
1795: lv_errname VARCHAR2(4000);

Line 1821: from hr_api_transactions

1817: if(p_transaction_id is not null) then
1818: -- get the transaction details
1819: select *
1820: into lr_transaction_rec
1821: from hr_api_transactions
1822: where transaction_id=p_transaction_id;
1823:
1824: -- derive the fnd function params values from txn
1825: lv_approval_required := hr_xml_util.get_node_value(p_transaction_id,

Line 2046: c_updateStatus hr_api_transactions.status%type;

2042: PRAGMA AUTONOMOUS_TRANSACTION;
2043: --
2044: -- local variables
2045: c_proc constant varchar2(30) := 'setTransactionStatus';
2046: c_updateStatus hr_api_transactions.status%type;
2047: ln_notification_id wf_notifications.notification_id%type;
2048: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2049: lv_item_key wf_items.item_key%type;
2050: lt_additional_wf_attributes HR_WF_ATTR_TABLE;

Line 2048: lr_hr_api_transaction_rec hr_api_transactions%rowtype;

2044: -- local variables
2045: c_proc constant varchar2(30) := 'setTransactionStatus';
2046: c_updateStatus hr_api_transactions.status%type;
2047: ln_notification_id wf_notifications.notification_id%type;
2048: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
2049: lv_item_key wf_items.item_key%type;
2050: lt_additional_wf_attributes HR_WF_ATTR_TABLE;
2051: lv_error_message varchar2(4000);
2052: lv_errstack varchar2(4000);

Line 2055: lv_currentTxnStatus hr_api_transactions.status%type;

2051: lv_error_message varchar2(4000);
2052: lv_errstack varchar2(4000);
2053: lv_status varchar2(30); -- revisit on the size
2054: lv_wf_item_attribute HR_WF_ATTR_TYPE;
2055: lv_currentTxnStatus hr_api_transactions.status%type;
2056:
2057:
2058: begin
2059: -- check if debug enabled

Line 2076: from hr_api_transactions

2072: c_updateStatus:='Y';
2073: elsif(p_proposedTxnStatus='S')then
2074: begin
2075: select status into lv_currentTxnStatus
2076: from hr_api_transactions
2077: where transaction_id=p_transaction_id;
2078: exception
2079: when others then
2080: null;

Line 2099: from hr_api_transactions

2095: -- send SFL notification
2096: -- get the transaction record
2097: select *
2098: into lr_hr_api_transaction_rec
2099: from hr_api_transactions
2100: where transaction_id=p_transaction_id;
2101: -- send sfl notification to login user
2102: hr_sflutil_ss.sendsflnotification(p_transaction_id,
2103: p_transaction_ref_table,

Line 2127: from hr_api_transactions

2123: begin
2124: -- check if the wf process is initialized or not
2125: select *
2126: into lr_hr_api_transaction_rec
2127: from hr_api_transactions
2128: where transaction_id=p_transaction_id;
2129:
2130: exception
2131: when others then

Line 2275: FROM hr_api_transactions

2271: p_status OUT nocopy VARCHAR2,
2272: p_error_log IN OUT nocopy CLOB)IS
2273: CURSOR csr_trn IS
2274: SELECT transaction_document
2275: FROM hr_api_transactions
2276: WHERE transaction_id = p_transaction_id;
2277:
2278: rootNode xmldom.DOMNode;
2279: l_TXN_Node xmldom.DOMNode;