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.

TRIGGER: APPS.FND_ADG_CONCURRENT_REQUEST_U

Source

Description

"APPS"."FND_ADG_CONCURRENT_REQUEST_U" 
   after update
 ON  "APPLSYS"."FND_CONCURRENT_REQUESTS#"  for each row
/* $Header: AFDGCRTU.sql 120.0 2010/03/01 13:34:27 rsanders noship $ */

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare
l_request_class_application_id number;
l_concurrent_request_class_id  number;
l_connstr1 varchar2(255);
l_node_name1 varchar2(30);
begin

$if fnd_adg_compile_directive.enable_rpc
$then

    l_request_class_application_id := :new.request_class_application_id;
    l_concurrent_request_class_id  := :new.concurrent_program_id;
    l_connstr1                     := :new.connstr1;
    l_node_name1                   := :new.node_name1;

    fnd_adg_support.handle_request_row_change(false,
                                             :new.program_application_id,
                                             :new.concurrent_program_id,
                                             l_connstr1,
                                             l_node_name1,
                                             l_request_class_application_id,
                                             l_concurrent_request_class_id,
                                             :new.phase_code,
                                             :new.status_code
                                            );
$else

    null;

$end

end;