PACKAGE: APPS.BIS_RS_STAGE_RUN_HISTORY_PKG

Source

1 package BIS_RS_STAGE_RUN_HISTORY_PKG AUTHID CURRENT_USER AS
2 /*$Header: BISSTTHS.pls 120.0 2005/06/01 16:00 appldev noship $*/
3 
4 PROCEDURE Insert_Row (	p_Request_set_id   NUMBER
5 			, p_Set_app_id       NUMBER
6 			, p_Stage_id         NUMBER
7 			, p_Request_id       NUMBER
8 			, p_Set_request_id   NUMBER
9 			, p_Start_date       DATE
10 			, p_Completion_date  DATE
11 			, p_Status_code      VARCHAR2
12 			, p_phase_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_Set_request_id   NUMBER
22 			, p_start_date       DATE DEFAULT NULL
23 			, p_Completion_date  DATE DEFAULT NULL
24 			, p_Status_code      VARCHAR2 DEFAULT NULL
25 			, p_phase_code       VARCHAR2 DEFAULT NULL
26 			, p_Last_update_date DATE
27 			, p_Last_updated_by  NUMBER
28                         , p_completion_text  VARCHAR2  DEFAULT NULL) return boolean;
29 
30 PROCEDURE Delete_Row (p_set_req_id number);
31 
32 
33 
34 END BIS_RS_STAGE_RUN_HISTORY_PKG;