PACKAGE: APPS.BIS_RS_PROG_RUN_HISTORY_PKG

Source

1 package BIS_RS_PROG_RUN_HISTORY_PKG AUTHID CURRENT_USER AS
2 /*$Header: BISPRTHS.pls 120.0 2005/06/01 18:15 appldev noship $*/
3 
4 PROCEDURE Insert_Row(	 p_Set_request_id	Number,
5 			 p_Stage_request_id 	Number,
6 			 p_Request_id		Number,
7 			 p_Program_id		Number,
8 			 p_Prog_app_id		Number,
9 			 p_Status_code		Varchar2,
10 			 p_Phase_code		Varchar2,
11 			 p_Start_date		DATE,
12 			 p_Completion_date	Date,
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_Set_request_id	Number,
21 			 p_Stage_request_id 	Number,
22 			 p_Request_id		Number,
23 			 p_Program_id		Number DEFAULT NULL,
24 			 p_Prog_app_id		Number DEFAULT NULL,
25 			 p_Status_code		Varchar2 DEFAULT NULL,
26 			 p_Phase_code		Varchar2 DEFAULT NULL,
27 			 p_Completion_date	Date DEFAULT NULL,
28 			 p_Last_update_date      DATE,
29 			 p_Last_updated_by       NUMBER,
30                          p_completion_text       VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
31 
32 PROCEDURE Delete_Row (p_set_rq_id number);
33 
34 
35 END BIS_RS_PROG_RUN_HISTORY_PKG;