PACKAGE: APPS.AZ_R12_UPD_DET_LOG

Source

1 PACKAGE AZ_R12_UPD_DET_LOG AS
2 /* $Header: azr12detlog.pls 120.4 2008/05/16 06:56:05 gnamasiv noship $ */
3 
4   -- Author  : LMATHUR
5   -- Created : 12/2/2007 2:22:06 PM
6   -- Purpose : Update the status for the detailed logging records
7 
8 application_exception EXCEPTION;
9   PRAGMA exception_init(application_exception, -20001);
10 
11   -- Public type declarations
12    TYPE TYP_ASSOC_ARR IS TABLE OF VARCHAR2(32767) INDEX BY VARCHAR2(4000);
13    TYPE TYP_NEST_TAB_VARCHAR IS TABLE OF VARCHAR2(32767);
14    TYPE TYP_NEST_TAB_NUMBER IS TABLE OF NUMBER;
15 
16   -- Public constant declarations
17 --  <ConstantName> constant <Datatype> := <Value>
18 
19   -- Public variable declarations
20 --  <VariableName> <Datatype>
21 
22   -- Public function and procedure declarations
23 --  function <FunctionName>(<Parameter> <Datatype>) return <Datatype>
24     PROCEDURE update_status(p_request_id IN NUMBER, p_source IN VARCHAR2);
25     PROCEDURE update_det_log_counts( p_request_id IN NUMBER,  p_source     IN VARCHAR2, p_update_xsl OUT NOCOPY varchar2);
26 END AZ_R12_UPD_DET_LOG;