[Home] [Help]
PACKAGE: APPS.IGW_PROP_SPECIAL_REVIEWS_PVT
Source
1 PACKAGE Igw_Prop_Special_Reviews_Pvt AUTHID CURRENT_USER AS
2 --$Header: igwvrevs.pls 115.2 2002/11/15 00:45:50 ashkumar ship $
3
4
5
6 ---------------------------------------------------------------------------
7
8 PROCEDURE Create_Prop_Special_Reviews
9 (
10 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
11 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
12 p_commit IN VARCHAR2 := Fnd_Api.G_False,
13 x_rowid OUT NOCOPY VARCHAR2,
14 p_proposal_id IN NUMBER,
15 p_proposal_number IN VARCHAR2,
16 p_special_review_code IN VARCHAR2,
17 p_special_review_desc IN VARCHAR2,
18 p_special_review_type IN VARCHAR2,
19 p_special_review_type_desc IN VARCHAR2,
20 p_approval_type_code IN VARCHAR2,
21 p_approval_type_desc IN VARCHAR2,
22 p_protocol_number IN VARCHAR2,
23 p_application_date IN DATE,
24 p_approval_date IN DATE,
25 p_comments IN VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31 ---------------------------------------------------------------------------
32
33 PROCEDURE Update_Prop_Special_Reviews
34 (
35 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
36 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
37 p_commit IN VARCHAR2 := Fnd_Api.G_False,
38 p_rowid IN VARCHAR2,
39 p_proposal_id IN NUMBER,
40 p_proposal_number IN VARCHAR2,
41 p_special_review_code IN VARCHAR2,
42 p_special_review_desc IN VARCHAR2,
43 p_special_review_type IN VARCHAR2,
44 p_special_review_type_desc IN VARCHAR2,
45 p_approval_type_code IN VARCHAR2,
46 p_approval_type_desc IN VARCHAR2,
47 p_protocol_number IN VARCHAR2,
48 p_application_date IN DATE,
49 p_approval_date IN DATE,
50 p_comments IN VARCHAR2,
51 p_record_version_number IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 ---------------------------------------------------------------------------
58
59 PROCEDURE Delete_Prop_Special_Reviews
60 (
61 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
62 p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
63 p_commit IN VARCHAR2 := Fnd_Api.G_False,
64 p_rowid IN VARCHAR2,
65 p_proposal_id IN NUMBER,
66 p_record_version_number IN NUMBER,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72 ---------------------------------------------------------------------------
73
74 END Igw_Prop_Special_Reviews_Pvt;