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.PSP_ER_WORKFLOW dependencies on PSP_REPORT_TEMPLATES_H

Line 91: FROM psp_report_templates_h

87: AND fcr.request_id = l_request_id;
88:
89: CURSOR original_request_id_cur IS
90: SELECT request_id
91: FROM psp_report_templates_h
92: WHERE payroll_action_id = pactid;
93:
94: l_return_status CHAR(1);
95: l_original_request_id NUMBER(15);

Line 146: from psp_report_templates_h

142: result out nocopy varchar2) is
143: l_request_id integer;
144: cursor check_pre_approved_cur is
145: select 1
146: from psp_report_templates_h
147: where request_id = l_request_id
148: and approval_type = 'PRE';
149: l_flag integer;
150: begin

Line 155: update psp_report_templates_h

151: l_request_id :=
152: wf_engine.GetItemAttrText(itemtype => itemtype,
153: itemkey => itemkey,
154: aname => 'REQUEST_ID');
155: update psp_report_templates_h
156: set initiator_accept_flag = 'Y'
157: where request_id = l_request_id;
158:
159: open check_pre_approved_cur;

Line 194: update psp_report_templates_h

190: l_request_id :=
191: wf_engine.GetItemAttrText(itemtype => itemtype,
192: itemkey => itemkey,
193: aname => 'REQUEST_ID');
194: update psp_report_templates_h
195: set initiator_accept_flag = 'N'
196: where request_id = l_request_id;
197: exception
198: when others then

Line 214: from psp_report_templates_h where request_id = p_request_id;

210:
211: -- Cursor added for bug 4106614: Effort Manual Override
212: cursor effort_manual_override_cur(p_request_id integer) is
213: select MANUAL_ENTRY_OVERRIDE_FLAG
214: from psp_report_templates_h where request_id = p_request_id;
215:
216: cursor wf_item_key_cur(p_request_id integer) is
217: select wf_role_name,
218: psp_wf_item_key_s.nextval

Line 618: from psp_Report_templates_h

614: l_approval_type varchar2(10);
615:
616: cursor get_approval_type is
617: select approval_type
618: from psp_Report_templates_h
619: where request_id = l_request_id;
620:
621: begin
622: hr_utility.trace(' Entering GET_NEXT_APPROVER');

Line 944: from psp_report_templates_h

940: from wf_roles
941: where orig_system = 'PER'
942: and orig_system_id in
943: (select initiator_person_id
944: from psp_report_templates_h
945: where request_id = l_request_id);
946:
947: cursor get_txn_id_cur is
948: select distinct ame_transaction_id

Line 1310: FROM psp_report_templates_h prth,

1306:
1307: CURSOR get_person_Assignment_list_csr IS
1308: SELECT distinct prth.hundred_pcent_eff_at_per_asg, per.start_date,
1309: per.end_date, per.person_id, perd.assignment_id, per.full_name, perd.assignment_number
1310: FROM psp_report_templates_h prth,
1311: psp_eff_reports per,
1312: psp_eff_report_details perd,
1313: psp_eff_report_approvals prea
1314: WHERE prth.request_id = per.request_id

Line 1668: l_template_name psp_report_templates_h.template_name%TYPE;

1664: l_wf_itemkey varchar2(100);
1665: l_user_name varchar2(100);
1666: l_start_date DATE;
1667: l_end_date DATE;
1668: l_template_name psp_report_templates_h.template_name%TYPE;
1669: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
1670: l_time_out integer;
1671:
1672: CURSOR template_name_cur IS

Line 1669: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;

1665: l_user_name varchar2(100);
1666: l_start_date DATE;
1667: l_end_date DATE;
1668: l_template_name psp_report_templates_h.template_name%TYPE;
1669: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
1670: l_time_out integer;
1671:
1672: CURSOR template_name_cur IS
1673: SELECT template_name,

Line 1678: FROM psp_report_templates_h prth

1674: preview_effort_report_flag,
1675: notification_reminder_in_days,
1676: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,
1677: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_3)) end_date
1678: FROM psp_report_templates_h prth
1679: WHERE prth.request_id = p_request_id;
1680:
1681: l_param_string VARCHAR2(2000);
1682: l_icx_date_format VARCHAR2(30);

Line 1687: FROM psp_report_templates_h

1683: l_gl_sob NUMBER;
1684:
1685: CURSOR get_sob_cur IS
1686: SELECT set_of_books_id
1687: FROM psp_report_templates_h
1688: WHERE request_id = p_request_id;
1689:
1690: CURSOR get_param_strings IS
1691: SELECT prt.template_name,

Line 1703: FROM psp_report_templates_h prth,

1699: flv5.meaning sort_option3,
1700: flv6.meaning order_by3,
1701: flv7.meaning sort_option4,
1702: flv8.meaning order_by4
1703: FROM psp_report_templates_h prth,
1704: xdo_templates_tl xtt,
1705: psp_report_templates prt,
1706: (select * from psp_layout_lookup_code_v where set_of_books_id in (-1, l_gl_sob)) flv1,
1707: (select * from fnd_lookup_values_vl where lookup_type = 'PSP_ORDERING_CRITERIA') flv2,

Line 1780: -- code added to store WF_Item_Key in Psp_report_templates_h

1776: FETCH template_name_cur INTO l_template_name, l_preview_flag, l_time_out, l_start_date, l_end_date;
1777: CLOSE template_name_cur;
1778:
1779: --BUG 4334816 START
1780: -- code added to store WF_Item_Key in Psp_report_templates_h
1781: update psp_report_templates_h
1782: set INITIATOR_WF_ITEM_KEY = l_wf_itemkey
1783: where request_id = p_request_id;
1784:

Line 1781: update psp_report_templates_h

1777: CLOSE template_name_cur;
1778:
1779: --BUG 4334816 START
1780: -- code added to store WF_Item_Key in Psp_report_templates_h
1781: update psp_report_templates_h
1782: set INITIATOR_WF_ITEM_KEY = l_wf_itemkey
1783: where request_id = p_request_id;
1784:
1785: --BUG 4334816 END

Line 1942: from psp_report_templates_h

1938: result out nocopy varchar2) is
1939: l_request_id integer;
1940: cursor get_init_response is
1941: select initiator_accept_flag
1942: from psp_report_templates_h
1943: where request_id = l_request_id;
1944: l_response varchar2(10);
1945: begin
1946: if funcmode = 'RUN' then

Line 2034: update psp_report_templates_h

2030: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
2031: itemkey => itemkey,
2032: aname => 'FINAL_RECIPIENT',
2033: avalue => l_recipnt_role);
2034: update psp_report_templates_h
2035: set final_recip_notified_flag = 'Y'
2036: where request_id = l_request_id;
2037: else
2038: result := 'COMPLETE:N';

Line 2102: from psp_report_templates_h

2098: l_request_id integer;
2099:
2100: cursor get_approval_type is
2101: select approval_type
2102: from psp_report_templates_h
2103: where request_id = l_request_id;
2104:
2105: l_approval_type varchar2(100);
2106:

Line 2190: from psp_report_templates_h

2186:
2187: l_request_id integer;
2188: cursor get_approval_type is
2189: select approval_type
2190: from psp_report_templates_h
2191: where request_id = l_request_id;
2192: l_approval_type varchar2(100);
2193: begin
2194: l_request_id :=

Line 2319: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;

2315: itemkey IN varchar2,
2316: actid IN number,
2317: funcmode IN varchar2,
2318: result OUT nocopy varchar2) IS
2319: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
2320: l_request_id NUMBER(15, 0);
2321: CURSOR preview_er_cur IS
2322: SELECT preview_effort_report_flag
2323: FROM psp_report_templates_h prth

Line 2323: FROM psp_report_templates_h prth

2319: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
2320: l_request_id NUMBER(15, 0);
2321: CURSOR preview_er_cur IS
2322: SELECT preview_effort_report_flag
2323: FROM psp_report_templates_h prth
2324: WHERE prth.request_id = l_request_id;
2325: BEGIN
2326: l_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
2327: itemkey => itemkey,