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 245: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

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

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

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

Line 257: from hr_api_transactions t

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

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

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

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

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

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

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

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

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

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

639: ---------- Function to get the final approver from the supervisor chain for current transaction ---------
640: -------------------------------------------------------------------------------
641:
642: function get_final_approver
643: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
644: return number
645: is
646: c_item_type varchar2(50);
647: c_item_key number;

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

693:
694:
695:
696: function allow_requestor_approval
697: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
698: return varchar2 is
699:
700: c_item_type varchar2(50);
701: c_item_key varchar2(100);

Line 1434: lv_status hr_api_transactions.status%type;

1430: lv_item_type wf_item_activity_statuses.item_type%type;
1431: lv_item_key wf_item_activity_statuses.item_key%type;
1432: lv_checkProfile VARCHAR2(10);
1433: lv_profileValue VARCHAR2(1);
1434: lv_status hr_api_transactions.status%type;
1435: lv_link_label wf_message_attributes_vl.display_name%type;
1436: lv_pageFunc wf_item_attribute_values.text_value%type;
1437: lv_web_html_call fnd_form_functions_vl.web_html_call%type;
1438: lv_params fnd_form_functions_vl.parameters%type;

Line 1505: from hr_api_transactions

1501: -- get the hr_api_transaction.status and profile value
1502: begin
1503: select nvl(status,'N'), nvl(fnd_profile.value('PQH_ALLOW_APPROVER_TO_EDIT_TXN'),'N')
1504: into lv_status, lv_profileValue
1505: from hr_api_transactions
1506: where item_type = lv_item_type
1507: and item_key = lv_item_key;
1508: exception
1509: when no_data_found then

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

1666: raise;
1667: end GetAttrText;
1668:
1669: function getApprStartingPointPersonId
1670: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
1671: return number
1672: is
1673: c_item_type varchar2(50);
1674: c_item_key number;

Line 1676: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

1672: is
1673: c_item_type varchar2(50);
1674: c_item_key number;
1675: c_creator_person_id per_all_people_f.person_id%type default null;
1676: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1677: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1678:
1679: begin
1680: -- get the creator person_id from hr_api_transactions

Line 1677: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;

1673: c_item_type varchar2(50);
1674: c_item_key number;
1675: c_creator_person_id per_all_people_f.person_id%type default null;
1676: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1677: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1678:
1679: begin
1680: -- get the creator person_id from hr_api_transactions
1681: -- this would be the default for all SSHR approvals.

Line 1680: -- get the creator person_id from hr_api_transactions

1676: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1677: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1678:
1679: begin
1680: -- get the creator person_id from hr_api_transactions
1681: -- this would be the default for all SSHR approvals.
1682: begin
1683: select hr_api_transactions.creator_person_id
1684: into c_creator_person_id

Line 1683: select hr_api_transactions.creator_person_id

1679: begin
1680: -- get the creator person_id from hr_api_transactions
1681: -- this would be the default for all SSHR approvals.
1682: begin
1683: select hr_api_transactions.creator_person_id
1684: into c_creator_person_id
1685: from hr_api_transactions
1686: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1687: exception

Line 1685: from hr_api_transactions

1681: -- this would be the default for all SSHR approvals.
1682: begin
1683: select hr_api_transactions.creator_person_id
1684: into c_creator_person_id
1685: from hr_api_transactions
1686: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1687: exception
1688: when others then
1689: raise;

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

1682: begin
1683: select hr_api_transactions.creator_person_id
1684: into c_creator_person_id
1685: from hr_api_transactions
1686: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1687: exception
1688: when others then
1689: raise;
1690: end;

Line 1695: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id

1691:
1692: -- if the transaction is for appraisal we need go through
1693: -- Main Appraiser chain for approvals.
1694: begin
1695: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id
1696: into lv_transaction_ref_table,lv_transaction_ref_id
1697: from hr_api_transactions
1698: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1699:

Line 1697: from hr_api_transactions

1693: -- Main Appraiser chain for approvals.
1694: begin
1695: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id
1696: into lv_transaction_ref_table,lv_transaction_ref_id
1697: from hr_api_transactions
1698: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1699:
1700: if(lv_transaction_ref_table='PER_APPRAISALS') then
1701: begin

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

1694: begin
1695: select hr_api_transactions.transaction_ref_table,hr_api_transactions.transaction_ref_id
1696: into lv_transaction_ref_table,lv_transaction_ref_id
1697: from hr_api_transactions
1698: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1699:
1700: if(lv_transaction_ref_table='PER_APPRAISALS') then
1701: begin
1702: select per_appraisals.main_appraiser_id

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

1710: end;
1711: end if;
1712: exception
1713: when others then
1714: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||
1715: 'rollback_transaction'||' : ' || sqlerrm);
1716: -- just log the message no need to raise it
1717: end;
1718:

Line 2103: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2099: function getNextApproverForHist(p_item_type in varchar2, p_item_key in varchar2) return varchar2
2100: as
2101: -- local variables
2102: lv_procedure_name varchar2(30) default 'getNextApproverForHist';
2103: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2104: ln_creator_person_id per_all_people_f.person_id%type default null;
2105: ln_currentApprover_person_id per_people_f.person_id%type;
2106: ln_nextApprover_person_id per_people_f.person_id%type;
2107: ln_nextApprover_userName wf_users.name%type;

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

2143: aname => 'TRANSACTION_ID');
2144: -- check if we have transaction id, if not no more iteration
2145: -- will this condition ever meet ???
2146: if(ln_transaction_id is null) then
2147: -- this is needed as AME depends on hr_api_transactions.transaction_id
2148: -- for processing the ame rules and approvers list
2149: return null;
2150: end if ;
2151: