PACKAGE: APPS.BIS_BIA_RSG_CUSTOM_API_MGMNT

Source

1 PACKAGE BIS_BIA_RSG_CUSTOM_API_MGMNT AS
2 /*$Header: BISCAPIS.pls 120.1 2005/07/12 16:36:59 tiwang noship $*/
3 
4  PARA_API_TYPE CONSTANT VARCHAR2(30) := 'API_TYPE';
5  PARA_MODE CONSTANT VARCHAR2(30) := 'MODE';
6  PARA_OBJECT_NAME CONSTANT VARCHAR2(30) := 'OBJECT_NAME';
7  PARA_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'OBJECT_TYPE';
8  PARA_MV_REFRESH_METHOD CONSTANT VARCHAR2(30) := 'MV_REFRESH_METHOD';
9  PARA_COMPLETE_STATUS CONSTANT VARCHAR2(30) := 'COMPLETE_STATUS';
10  PARA_MESSAGE CONSTANT VARCHAR2(30) := 'MESSAGE';
11 
12 
13  METHOD_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
14  METHOD_FAST CONSTANT VARCHAR2(30) := 'FAST';
15  TYPE_MV_LOG_MGT CONSTANT VARCHAR2(30) := 'MV_LOG_MGT';
16  TYPE_MV_INDEX_MGT CONSTANT VARCHAR2(30) := 'MV_INDEX_MGT';
17  TYPE_MV_THRESHOLD CONSTANT VARCHAR2(30) := 'MV_THRESHOLD';
18  TYPE_MV_OTHER_CUSTOM CONSTANT VARCHAR2(30) := 'MV_OTHER_CUSTOM';
19  MODE_BEFORE CONSTANT VARCHAR2(30) := 'BEFORE';
20  MODE_AFTER CONSTANT VARCHAR2(30) := 'AFTER';
21  TYPE_TABLE CONSTANT VARCHAR2(30) := 'TABLE';
22  TYPE_MV CONSTANT VARCHAR2(30) := 'MV';
23  STATUS_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
24  STATUS_FAILURE CONSTANT VARCHAR2(30) := 'FAILURE';
25 
26 
27 
28 PROCEDURE INVOKE_CUSTOM_API (
29     RTNBUF  		IN OUT NOCOPY VARCHAR2,
30     RETCODE		    OUT NOCOPY VARCHAR2,
31     P_API 	        IN 	VARCHAR2,
32     P_API_TYPE      IN 	VARCHAR2,
33     P_OBJ_NAME      IN 	VARCHAR2,
34     P_OBJ_TYPE      IN 	VARCHAR2,
35     P_MODE          IN 	VARCHAR2
36 );
37 
38 FUNCTION GET_PARAM (
39      p_parameter_tbl 	   IN OUT NOCOPY BIS_BIA_RSG_PARAMETER_TBL,
40      p_param_name          IN VARCHAR2
41 ) RETURN VARCHAR2;
42 
43 PROCEDURE SET_PARAM (
44      p_parameter_tbl 	   IN OUT NOCOPY BIS_BIA_RSG_PARAMETER_TBL,
45      p_param_name          IN VARCHAR2,
46      p_param_value         IN VARCHAR2
47 );
48 
49 PROCEDURE LOG(
50   P_TEXT VARCHAR2
51 );
52 
53 END BIS_BIA_RSG_CUSTOM_API_MGMNT;