Details for some of Oracle Workflow APIs are...

1 WF_ENGINE
2 WF_CORE
3 WF_PURGE
4 WF_DIRECTORY
5 WF_PREF
6 WF_MONITOR
7 Oracle Workflow Views
8 WF_QUEUE
9 FND_DOCUMENT_MANAGEMENT
10 WF_NOTIFICATIONS


 

TO get the Statements of Expences in Particuler GL entry Account

select gl.chart_of_accounts_id,
gl.account_type,
gl.segment12 account_dep,
gl.segment14 company,
gl.segment16 department,
bl.currency_code,
bl.period_net_dr ,
bl.period_net_cr ,
substr(a.description,1,50) descr,
he.period_name
from gl_code_combinations gl ,
gl_balances bl,
fnd_flex_value_sets c ,
fnd_flex_values b ,
fnd_flex_values_tl a,
gl_je_headers he
where gl.code_combination_id =bl.code_combination_id
and gl.chart_of_accounts_id=xxx -- add coaid
and b.flex_value_set_id = c.flex_value_set_id
and a.flex_value_id = b.flex_value_id
and he.set_of_books_id=bl.set_of_books_id
and a.language = 'US'
and c.flex_value_set_name like 'Operations Account'
and b.flex_value= gl.segment12;

Some importent API's regarding Concurrent Program

-- Name
  --   FND_CONCURRENT.Cancel_Request.
  -- Purpose
  --    It Cancels given Concurrent Request.
  --
  -- Arguments (input)
  --    request_id - request id of the request you want to cancel.
  --
  --   (out args)
  --    message    - API will fill the message with any errors while canceling
  --                 request.
  --
  -- Returns:
  --    Returns TRUE if success or FALSE on failure.
  Function Cancel_Request( Request_Id   in NUMBER,
                           Message      out NOCOPY VARCHAR2) return boolean is
    ret_val          number;
    submitter        number;
    request_missing  exception;
    no_privilege     exception;

======================================================================================
-- Procedure
--   enable_program
--
-- Purpose
--   enable or disable the concurrent program.
--
-- Arguments
--   program_short_name  - Short name of the program.
--   program_application - Application of the program.
--   enabled       - 'Y' or 'N' values.
--
PROCEDURE enable_program(short_name        IN VARCHAR2,
                         application       IN VARCHAR2,
                         enabled           IN VARCHAR2);
      
=======================================================================================
  --
  -- Name
  --   set_repeat_options
  -- Purpose
  --   Called before submitting request if the request to be submitted
  --   is a repeating request.
  --
  -- Arguments
  --   repeat_time - Time of day at which it has to be repeated
  --   repeat_interval  - Frequency at which it has to be repeated
  --   - This will be used/applied only when repeat_time
  --   - is NULL ( non null repeat_interval overrides )
  --   repeat_unit - Unit for repeat interval. Default is DAYS.
  --   - MONTHS/DAYS/HOURS/MINUTES
  --   repeat_type - Apply repeat interval from START or END of request
  --   - default is START. START/END
  --   repeat_end_time  - Time at which the repetition should be stopped
  --   incrment_dates   - 'Y' if dates should be incremented each run,
  --                      otherwise 'N'
  --
  function set_repeat_options (repeat_time IN varchar2 default NULL,
                      repeat_interval  IN number   default NULL,
                      repeat_unit      IN varchar2 default 'DAYS',
                      repeat_type      IN varchar2 default 'START',
                      repeat_end_time  IN varchar2 default NULL,
                      increment_dates  IN varchar2 default NULL) return boolean;

ETRM url

https://login.oracle.com/mysso/signon.jsp?site2pstoretoken=v1.4~1F5E90CD~1BDBCCE608D318D13DFA69972586CE26531454CCD72C04884637320A7C3FA3DD89C0556CB5DF2590146AED5D736BACC6D429D66EC8179BD74D8B43092F5234437CB55F2E64002F5F5ED9D7E796B05D58BE336F8C0949885DD4044D6F935C4DD5AB5FCF15B42F405BDF5FCC85F537E0568E013EDE8913E31A4C4CABCDB1C5BDB3776ECB71759D47C996A6E990BC7F2BF6B7A74C995C3C3A73718DC4384A95A8C64B741939F81614701CF28BD2CFC53548ECC5E16151DB03EA&p_error_code=&p_submit_url=https%3A%2F%2Flogin.oracle.com%2Fsso%2Fauth&p_cancel_url=http%3A%2F%2Fetrm.oracle.com%2Fpls%2Fetrm%2F&ssousername=&subscribername=

metalink

https://support.oracle.com/CSP/ui/flash.html

sample package for fail the concurrent program

CREATE OR REPLACE PACKAGE APPS.XXTP_SAMPLE_PKG1
AS

PROCEDURE xxtp_sample_proc1 (v_errbuf out VARCHAR2, v_retcode out NUMBER);

END;
/

CREATE
AS

PROCEDURE xxtp_sample_proc1 (v_errbuf out VARCHAR2, v_retcode out NUMBER)
AS
l_date date;
BEGIN
l_date:=null;---select sysdate into l_date from dual;
Raise_Application_Error(-20001,'Program failed');
FND_FILE

END;
.PUT_LINE (FND_FILE.LOG,'sample program');END XXTP_SAMPLE_PKG1; / OR REPLACE PACKAGE BODY APPS.XXTP_SAMPLE_PKG1

Automatic program execution failed

 Raise_Application_Error(-20001,'Program failed');