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

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: l_resp_appl_id number; -- 10185794
622: l_user number;

Line 960: from psp_report_templates_h

956: from wf_roles
957: where orig_system = 'PER'
958: and orig_system_id in
959: (select initiator_person_id
960: from psp_report_templates_h
961: where request_id = l_request_id);
962:
963: cursor get_txn_id_cur is
964: select distinct ame_transaction_id

Line 1344: FROM psp_report_templates_h prth,

1340:
1341: CURSOR get_person_Assignment_list_csr IS
1342: SELECT distinct prth.hundred_pcent_eff_at_per_asg, per.start_date,
1343: per.end_date, per.person_id, perd.assignment_id, per.full_name, perd.assignment_number
1344: FROM psp_report_templates_h prth,
1345: psp_eff_reports per,
1346: psp_eff_report_details perd,
1347: psp_eff_report_approvals prea
1348: WHERE prth.request_id = per.request_id

Line 1708: l_template_name psp_report_templates_h.template_name%TYPE;

1704: l_wf_itemkey varchar2(100);
1705: l_user_name varchar2(100);
1706: l_start_date DATE;
1707: l_end_date DATE;
1708: l_template_name psp_report_templates_h.template_name%TYPE;
1709: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
1710: l_time_out integer;
1711:
1712: CURSOR template_name_cur IS

Line 1709: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;

1705: l_user_name varchar2(100);
1706: l_start_date DATE;
1707: l_end_date DATE;
1708: l_template_name psp_report_templates_h.template_name%TYPE;
1709: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
1710: l_time_out integer;
1711:
1712: CURSOR template_name_cur IS
1713: SELECT template_name,

Line 1718: FROM psp_report_templates_h prth

1714: preview_effort_report_flag,
1715: notification_reminder_in_days,
1716: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_2)) start_date,
1717: fnd_date.canonical_to_date(fnd_date.date_to_canonical(parameter_value_3)) end_date
1718: FROM psp_report_templates_h prth
1719: WHERE prth.request_id = p_request_id;
1720:
1721: l_param_string VARCHAR2(2000);
1722: l_icx_date_format VARCHAR2(30);

Line 1727: FROM psp_report_templates_h

1723: l_gl_sob NUMBER;
1724:
1725: CURSOR get_sob_cur IS
1726: SELECT set_of_books_id
1727: FROM psp_report_templates_h
1728: WHERE request_id = p_request_id;
1729:
1730: CURSOR get_param_strings IS
1731: SELECT prt.template_name,

Line 1743: FROM psp_report_templates_h prth,

1739: flv5.meaning sort_option3,
1740: flv6.meaning order_by3,
1741: flv7.meaning sort_option4,
1742: flv8.meaning order_by4
1743: FROM psp_report_templates_h prth,
1744: xdo_templates_tl xtt,
1745: psp_report_templates prt,
1746: (select * from psp_layout_lookup_code_v where set_of_books_id in (-1, l_gl_sob)) flv1,
1747: (select * from fnd_lookup_values_vl where lookup_type = 'PSP_ORDERING_CRITERIA') flv2,

Line 1745: psp_report_templates prt,

1741: flv7.meaning sort_option4,
1742: flv8.meaning order_by4
1743: FROM psp_report_templates_h prth,
1744: xdo_templates_tl xtt,
1745: psp_report_templates prt,
1746: (select * from psp_layout_lookup_code_v where set_of_books_id in (-1, l_gl_sob)) flv1,
1747: (select * from fnd_lookup_values_vl where lookup_type = 'PSP_ORDERING_CRITERIA') flv2,
1748: (select * from psp_layout_lookup_code_v where set_of_books_id in (-1, l_gl_sob)) flv3,
1749: (select * from fnd_lookup_values_vl where lookup_type = 'PSP_ORDERING_CRITERIA') flv4,

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

1816: FETCH template_name_cur INTO l_template_name, l_preview_flag, l_time_out, l_start_date, l_end_date;
1817: CLOSE template_name_cur;
1818:
1819: --BUG 4334816 START
1820: -- code added to store WF_Item_Key in Psp_report_templates_h
1821: update psp_report_templates_h
1822: set INITIATOR_WF_ITEM_KEY = l_wf_itemkey
1823: where request_id = p_request_id;
1824:

Line 1821: update psp_report_templates_h

1817: CLOSE template_name_cur;
1818:
1819: --BUG 4334816 START
1820: -- code added to store WF_Item_Key in Psp_report_templates_h
1821: update psp_report_templates_h
1822: set INITIATOR_WF_ITEM_KEY = l_wf_itemkey
1823: where request_id = p_request_id;
1824:
1825: --BUG 4334816 END

Line 1982: from psp_report_templates_h

1978: result out nocopy varchar2) is
1979: l_request_id integer;
1980: cursor get_init_response is
1981: select initiator_accept_flag
1982: from psp_report_templates_h
1983: where request_id = l_request_id;
1984: l_response varchar2(10);
1985: begin
1986: if funcmode = 'RUN' then

Line 2074: update psp_report_templates_h

2070: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
2071: itemkey => itemkey,
2072: aname => 'FINAL_RECIPIENT',
2073: avalue => l_recipnt_role);
2074: update psp_report_templates_h
2075: set final_recip_notified_flag = 'Y'
2076: where request_id = l_request_id;
2077: else
2078: result := 'COMPLETE:N';

Line 2142: from psp_report_templates_h

2138: l_request_id integer;
2139:
2140: cursor get_approval_type is
2141: select approval_type
2142: from psp_report_templates_h
2143: where request_id = l_request_id;
2144:
2145: l_approval_type varchar2(100);
2146:

Line 2265: from psp_report_templates_h

2261:
2262: l_request_id integer;
2263: cursor get_approval_type is
2264: select approval_type
2265: from psp_report_templates_h
2266: where request_id = l_request_id;
2267: l_approval_type varchar2(100);
2268: begin
2269: l_request_id :=

Line 2394: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;

2390: itemkey IN varchar2,
2391: actid IN number,
2392: funcmode IN varchar2,
2393: result OUT nocopy varchar2) IS
2394: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
2395: l_request_id NUMBER(15, 0);
2396: CURSOR preview_er_cur IS
2397: SELECT preview_effort_report_flag
2398: FROM psp_report_templates_h prth

Line 2398: FROM psp_report_templates_h prth

2394: l_preview_flag psp_report_templates_h.preview_effort_report_flag%TYPE;
2395: l_request_id NUMBER(15, 0);
2396: CURSOR preview_er_cur IS
2397: SELECT preview_effort_report_flag
2398: FROM psp_report_templates_h prth
2399: WHERE prth.request_id = l_request_id;
2400:
2401: l_resp_appl_id number; -- 10185794
2402: l_user number;