DBA Data[Home] [Help]

PACKAGE: APPS.IGW_SPONSOR_ACTION_TBH

Source


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