[Home] [Help]
PACKAGE: APPS.BIS_RS_STAGE_RUN_HISTORY_PKG
Source
1 package BIS_RS_STAGE_RUN_HISTORY_PKG 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;