DBA Data[Home] [Help]

PACKAGE: APPS.BIS_OBJ_REFRESH_HISTORY_PKG

Source


1 package BIS_OBJ_REFRESH_HISTORY_PKG AUTHID CURRENT_USER AS
2 /*$Header: BISOBTHS.pls 120.0 2005/05/31 18:29 appldev noship $*/
3 
4 PROCEDURE Insert_Row (  p_Prog_request_id                NUMBER ,
5 			p_Object_type                   VARCHAR2,
6 			p_Object_name                   VARCHAR2,
7 			p_Refresh_type			VARCHAR2,
8 			p_Object_row_count               NUMBER,
9 			p_Object_space_usage            NUMBER ,
10 			p_Tablespace_name               VARCHAR2,
11 			p_Free_tablespace_size          VARCHAR2,
12 			p_Creation_date                  DATE,
13 			p_Created_by                     NUMBER,
14 			p_Last_update_date               DATE,
15 			p_Last_updated_by                NUMBER
16                       );
17 
18 FUNCTION Update_Row (  p_Prog_request_id                NUMBER ,
19 			p_new_Prog_request_id                NUMBER DEFAULT NULL,
20 			p_Object_type                   VARCHAR2 DEFAULT NULL,
21 			p_Object_name                   VARCHAR2 DEFAULT NULL,
22 			p_Refresh_type			VARCHAR2 DEFAULT NULL,
23 			p_Object_row_count               NUMBER DEFAULT NULL,
24 			p_Object_space_usage            NUMBER DEFAULT NULL ,
25 			p_Tablespace_name               VARCHAR2 DEFAULT NULL,
26 			p_Free_tablespace_size          VARCHAR2 DEFAULT NULL,
27 			p_Last_update_date               DATE,
28 			p_Last_updated_by                NUMBER) RETURN BOOLEAN;
29 
30 PROCEDURE Delete_Row (p_prog_req_id number);
31 
32 END BIS_OBJ_REFRESH_HISTORY_PKG;