PACKAGE: APPS.IGW_PROP_SPECIAL_REVIEWS_TBH

Source

1 PACKAGE Igw_Prop_Special_Reviews_Tbh AUTHID CURRENT_USER AS
2 /* $Header: igwtrevs.pls 115.2 2002/11/15 00:46:08 ashkumar ship $ */
3 
4    ---------------------------------------------------------------------------
5 
6    PROCEDURE Insert_Row
7    (
8       x_rowid                  OUT NOCOPY VARCHAR2,
9       p_proposal_id            IN NUMBER,
10       p_special_review_code    IN VARCHAR2,
11       p_special_review_type    IN VARCHAR2,
12       p_approval_type_code     IN VARCHAR2,
13       p_protocol_number        IN VARCHAR2,
14       p_application_date       IN DATE,
15       p_approval_date          IN DATE,
16       p_comments               IN VARCHAR2,
17       x_return_status          OUT NOCOPY VARCHAR2,
18       p_mode                   IN  VARCHAR2 default 'R'
19    );
20 
21    ---------------------------------------------------------------------------
22 
23    PROCEDURE Update_Row
24    (
25       p_rowid                  IN VARCHAR2,
26       p_proposal_id            IN NUMBER,
27       p_special_review_code    IN VARCHAR2,
28       p_special_review_type    IN VARCHAR2,
29       p_approval_type_code     IN VARCHAR2,
30       p_protocol_number        IN VARCHAR2,
31       p_application_date       IN DATE,
32       p_approval_date          IN DATE,
33       p_comments               IN VARCHAR2,
34       p_record_version_number  IN NUMBER,
35       x_return_status          OUT NOCOPY VARCHAR2,
36       p_mode                   IN  VARCHAR2 default 'R'
37    );
38 
39    ---------------------------------------------------------------------------
40 
41    PROCEDURE Delete_Row
42    (
43       p_rowid                  IN VARCHAR2,
44       p_record_version_number  IN NUMBER,
45       x_return_status          OUT NOCOPY VARCHAR2
46    );
47 
48    ---------------------------------------------------------------------------
49 
50 END Igw_Prop_Special_Reviews_Tbh;