135:
136: /* Added a few validation and fetch procedures */
137: /* Later on to be moved to its appropriate packages */
138: PROCEDURE Get_Status
139: ( Status_code IN GMD_STATUS.Status_code%TYPE ,
140: Meaning OUT NOCOPY GMD_STATUS.Meaning%TYPE ,
141: Description OUT NOCOPY GMD_STATUS.Description%TYPE ,
142: x_return_status OUT NOCOPY VARCHAR2
143: );
136: /* Added a few validation and fetch procedures */
137: /* Later on to be moved to its appropriate packages */
138: PROCEDURE Get_Status
139: ( Status_code IN GMD_STATUS.Status_code%TYPE ,
140: Meaning OUT NOCOPY GMD_STATUS.Meaning%TYPE ,
141: Description OUT NOCOPY GMD_STATUS.Description%TYPE ,
142: x_return_status OUT NOCOPY VARCHAR2
143: );
144:
137: /* Later on to be moved to its appropriate packages */
138: PROCEDURE Get_Status
139: ( Status_code IN GMD_STATUS.Status_code%TYPE ,
140: Meaning OUT NOCOPY GMD_STATUS.Meaning%TYPE ,
141: Description OUT NOCOPY GMD_STATUS.Description%TYPE ,
142: x_return_status OUT NOCOPY VARCHAR2
143: );
144:
145: PROCEDURE Calculate_Process_loss