DBA Data[Home] [Help]

PACKAGE: APPS.BIS_RS_RUN_HISTORY_PKG

Source


1 package BIS_RS_RUN_HISTORY_PKG AUTHID CURRENT_USER AS
2 /*$Header: BISRSTHS.pls 120.0 2005/06/01 14:15 appldev noship $*/
3 
4 PROCEDURE Insert_Row (	p_Request_set_id     NUMBER
5 			, p_Set_app_id       NUMBER
6                         , p_request_set_name VARCHAR2
7 			, p_Request_id       NUMBER
8 			, p_rs_refresh_type  VARCHAR2
9 			, p_Start_date       DATE
10 			, p_Completion_date  DATE
11 			, p_Phase_code	     Varchar2
12 			, p_Status_code      VARCHAR2
13 			, p_Creation_date    DATE
14 			, p_Created_by       NUMBER
15 			, p_Last_update_date DATE
16 			, p_Last_updated_by  NUMBER
17                         , p_completion_text   VARCHAR2
18                       );
19 
20 FUNCTION Update_Row ( p_Request_id       NUMBER
21 			, p_Request_set_id   NUMBER     DEFAULT NULL
22 			, p_Set_app_id       NUMBER DEFAULT NULL
23 			, p_Start_date       DATE DEFAULT NULL
24 			, p_Completion_date  DATE DEFAULT NULL
25 			, p_Phase_code	     VARCHAR2 DEFAULT NULL
26 			, p_Status_code      VARCHAR2 DEFAULT NULL
27 			, p_Last_update_date DATE
28 			, p_Last_updated_by  NUMBER
29                         , p_completion_text  VARCHAR2 DEFAULT NULL) RETURN boolean;
30 
31 PROCEDURE Delete_Row (p_last_update_date date);
32 
33 
34 END BIS_RS_RUN_HISTORY_PKG;