Thursday, June 13, 2019
Adding Report to Request Group using API
/**********************************************************************
*PURPOSE: To Add a Concurrent Program to a Request Group from backend *
**********************************************************************/
--
DECLARE
l_program_short_name VARCHAR2 (200);
l_program_application VARCHAR2 (200);
l_request_group VARCHAR2 (200);
l_group_application VARCHAR2 (200);
l_check VARCHAR2 (2);
--
BEGIN
--
l_program_short_name := 'XXINVNLCDNT';
l_program_application := 'Inventory';
l_request_group := 'OM Concurrent Programs';
l_group_application := 'Order Management';
--
--Calling API to assign concurrent program to a reqest group
--
apps.fnd_program.add_to_group (
program_short_name => l_program_short_name,
program_application => l_program_application,
request_group => l_request_group,
group_application => l_group_application);
--
COMMIT;
--
BEGIN
--
--To check whether a paramter is assigned to a Concurrent Program or not
--
SELECT 'Y'
INTO l_check
FROM fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs fcp
WHERE frg.request_group_id = frgu.request_group_id
AND frg.application_id = frgu.application_id
AND frgu.request_unit_id = fcp.concurrent_program_id
AND frgu.unit_application_id = fcp.application_id
AND fcp.concurrent_program_name = 'XXINVNLCDNT';
--
DBMS_OUTPUT.put_line (
'Adding Concurrent Program to Request Group Succeeded');
--
EXCEPTION
WHEN NO_DATA_FOUND
THEN
DBMS_OUTPUT.put_line (
'Adding Concurrent Program to Request Group Failed');
END;
END;
Subscribe to:
Post Comments (Atom)
Some Tips About FNDLOAD
Data Synchronization Data Synchronization is a process in which some setup data would be synchronized, and this would be more important w...
-
DataInstall/HRGLOBAL Technical considerations for EBS Release 12.2 1. Start an online patching cycle Source the run edion environment...
-
Check out this job at Tabadul: Oracle SOA / BPM / Fusion Middleware Consultant https://www.linkedin.com/jobs2/view/197437126
-
Key Performance Articles Best Practice Documents Best Practice Webcasts The following Best Practice Webcasts are available: Oracle Da...
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.