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_WORKFLOW_SS dependencies on HR_API_TRANSACTIONS

Line 51: l_trans_ref_table hr_api_transactions.transaction_ref_Table%type;

47: ,funcmode in varchar2
48: ,resultout out nocopy varchar2)
49: is
50: l_text_value wf_activity_attr_values.text_value%type;
51: l_trans_ref_table hr_api_transactions.transaction_ref_Table%type;
52: begin
53: --
54: l_text_value := wf_engine.GetItemAttrText(itemtype => itemtype,
55: itemkey => itemkey,

Line 64: from hr_api_transactions

60: /* elsif l_text_value = 'YES' then
61: -- Approval Process is required
62: resultout := 'COMPLETE:'|| 'Y';*/
63: select transaction_ref_table into l_trans_ref_table
64: from hr_api_transactions
65: where item_type=itemtype and item_key=itemkey;
66:
67: if l_trans_ref_table = 'IRC_OFFERS' then
68: wf_engine.setItemAttrDate(itemtype => itemtype,

Line 202: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

198:
199: ---------- private function to get item type for current transaction ---------
200: -------------------------------------------------------------------------------
201: function get_item_type
202: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
203: return varchar2 is
204: c_item_type varchar2(50);
205:
206: begin

Line 210: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);

206: begin
207:
208: begin
209: if g_debug then
210: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
211: end if;
212: select t.item_type
213: into c_item_type
214: from hr_api_transactions t

Line 214: from hr_api_transactions t

210: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
211: end if;
212: select t.item_type
213: into c_item_type
214: from hr_api_transactions t
215: where transaction_id=get_item_type.p_transaction_id;
216: exception
217: when no_data_found then
218: -- get the data from the steps

Line 246: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

242: ---------- private function to get item key for current transaction ---------
243: -------------------------------------------------------------------------------
244:
245: function get_item_key
246: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
247: return varchar2 is
248: c_item_key varchar2(50);
249:
250: begin

Line 254: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);

250: begin
251:
252: begin
253: if g_debug then
254: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
255: end if;
256: select t.item_key
257: into get_item_key.c_item_key
258: from hr_api_transactions t

Line 258: from hr_api_transactions t

254: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
255: end if;
256: select t.item_key
257: into get_item_key.c_item_key
258: from hr_api_transactions t
259: where transaction_id=get_item_key.p_transaction_id;
260: exception
261: when no_data_found then
262: -- get the data from the steps

Line 283: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

279:
280: end get_item_key;
281:
282: function get_process_name
283: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
284: return varchar2 is
285:
286: c_process_name varchar2(100);
287: c_item_type varchar2(50);

Line 306: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

302: RAISE;
303: end get_process_name ;
304:
305: function get_approval_level
306: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
307: return number is
308:
309: c_approval_level number;
310: c_item_type varchar2(50);

Line 333: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

329:
330:
331:
332: function get_effective_date
333: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
334: return date is
335: c_effective_date date;
336: c_item_type varchar2(50);
337: c_item_key varchar2(100);

Line 357: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

353:
354: end get_effective_date;
355:
356: function get_assignment_id
357: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
358: return number is
359: c_assignment_id number;
360: c_item_type varchar2(50);
361: c_item_key varchar2(100);

Line 677: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

673: ---------- Function to get the final approver from the supervisor chain for current transaction ---------
674: -------------------------------------------------------------------------------
675:
676: function get_final_approver
677: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
678: return number
679: is
680: c_item_type varchar2(50);
681: c_item_key number;

Line 731: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

727:
728:
729:
730: function allow_requestor_approval
731: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
732: return varchar2 is
733:
734: c_item_type varchar2(50);
735: c_item_key varchar2(100);

Line 1476: lv_status hr_api_transactions.status%type;

1472: lv_item_type wf_item_activity_statuses.item_type%type;
1473: lv_item_key wf_item_activity_statuses.item_key%type;
1474: lv_checkProfile VARCHAR2(10);
1475: lv_profileValue VARCHAR2(1);
1476: lv_status hr_api_transactions.status%type;
1477: lv_link_label wf_message_attributes_vl.display_name%type;
1478: lv_pageFunc wf_item_attribute_values.text_value%type;
1479: lv_web_html_call fnd_form_functions_vl.web_html_call%type;
1480: lv_params fnd_form_functions_vl.parameters%type;

Line 1547: from hr_api_transactions

1543: -- get the hr_api_transaction.status and profile value
1544: begin
1545: select nvl(status,'N'), nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
1546: into lv_status, lv_profileValue
1547: from hr_api_transactions
1548: where item_type = lv_item_type
1549: and item_key = lv_item_key;
1550: exception
1551: when no_data_found then

Line 1712: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

1708: raise;
1709: end GetAttrText;
1710:
1711: function getApprStartingPointPersonId
1712: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1713: return number
1714: is
1715: c_item_type varchar2(50);
1716: c_item_key number;

Line 1718: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

1714: is
1715: c_item_type varchar2(50);
1716: c_item_key number;
1717: c_creator_person_id per_all_people_f.person_id%type default null;
1718: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1719: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1720:
1721: begin
1722: -- get the creator person_id from hr_api_transactions

Line 1719: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;

1715: c_item_type varchar2(50);
1716: c_item_key number;
1717: c_creator_person_id per_all_people_f.person_id%type default null;
1718: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1719: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1720:
1721: begin
1722: -- get the creator person_id from hr_api_transactions
1723: -- this would be the default for all SSHR approvals.

Line 1722: -- get the creator person_id from hr_api_transactions

1718: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1719: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1720:
1721: begin
1722: -- get the creator person_id from hr_api_transactions
1723: -- this would be the default for all SSHR approvals.
1724: begin
1725: select hr_api_transactions.creator_person_id
1726: into c_creator_person_id

Line 1725: select hr_api_transactions.creator_person_id

1721: begin
1722: -- get the creator person_id from hr_api_transactions
1723: -- this would be the default for all SSHR approvals.
1724: begin
1725: select hr_api_transactions.creator_person_id
1726: into c_creator_person_id
1727: from hr_api_transactions
1728: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1729: exception

Line 1727: from hr_api_transactions

1723: -- this would be the default for all SSHR approvals.
1724: begin
1725: select hr_api_transactions.creator_person_id
1726: into c_creator_person_id
1727: from hr_api_transactions
1728: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1729: exception
1730: when others then
1731: raise;

Line 1728: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;

1724: begin
1725: select hr_api_transactions.creator_person_id
1726: into c_creator_person_id
1727: from hr_api_transactions
1728: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1729: exception
1730: when others then
1731: raise;
1732: end;

Line 1737: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id

1733:
1734: -- if the transaction is for appraisal we need go through
1735: -- Main Appraiser chain for approvals.
1736: begin
1737: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id
1738: into lv_transaction_ref_table,lv_transaction_ref_id
1739: from hr_api_transactions
1740: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1741:

Line 1739: from hr_api_transactions

1735: -- Main Appraiser chain for approvals.
1736: begin
1737: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id
1738: into lv_transaction_ref_table,lv_transaction_ref_id
1739: from hr_api_transactions
1740: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1741:
1742: if(lv_transaction_ref_table='PER_APPRAISALS') then
1743: begin

Line 1740: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;

1736: begin
1737: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id
1738: into lv_transaction_ref_table,lv_transaction_ref_id
1739: from hr_api_transactions
1740: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1741:
1742: if(lv_transaction_ref_table='PER_APPRAISALS') then
1743: begin
1744: select per_appraisals.main_appraiser_id

Line 1756: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||

1752: end;
1753: end if;
1754: exception
1755: when others then
1756: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||
1757: 'rollback_transaction'||' : ' || sqlerrm);
1758: -- just log the message no need to raise it
1759: end;
1760:

Line 2147: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2143: function getNextApproverForHist(p_item_type in varchar2, p_item_key in varchar2) return varchar2
2144: as
2145: -- local variables
2146: lv_procedure_name varchar2(30) default 'getNextApproverForHist';
2147: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2148: ln_creator_person_id per_all_people_f.person_id%type default null;
2149: ln_currentApprover_person_id per_people_f.person_id%type;
2150: ln_nextApprover_person_id per_people_f.person_id%type;
2151: ln_nextApprover_userName wf_users.name%type;

Line 2194: -- this is needed as AME depends on hr_api_transactions.transaction_id

2190: aname => 'TRANSACTION_ID');
2191: -- check if we have transaction id, if not no more iteration
2192: -- will this condition ever meet ???
2193: if(ln_transaction_id is null) then
2194: -- this is needed as AME depends on hr_api_transactions.transaction_id
2195: -- for processing the ame rules and approvers list
2196: return null;
2197: end if ;
2198: