[Home] [Help]
PACKAGE: APPS.IGW_PROP_NARRATIVES_PVT
Source
1 PACKAGE IGW_PROP_NARRATIVES_PVT AUTHID CURRENT_USER as
2 /* $Header: igwvprns.pls 115.4 2002/11/15 00:38:41 ashkumar ship $*/
3 PROCEDURE create_prop_narrative (
4 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5 p_commit IN VARCHAR2 := FND_API.G_FALSE,
6 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
7 X_ROWID out NOCOPY VARCHAR2,
8 P_PROPOSAL_ID in NUMBER,
9 P_MODULE_TITLE in VARCHAR2,
10 P_MODULE_STATUS in VARCHAR2,
11 P_CONTACT_NAME in VARCHAR2,
12 P_PHONE_NUMBER in VARCHAR2,
13 P_EMAIL_ADDRESS in VARCHAR2,
14 P_COMMENTS in VARCHAR2,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2);
18 --------------------------------------------------------------------------------------------------------------
19
20 Procedure update_prop_narrative (
21 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22 p_commit IN VARCHAR2 := FND_API.G_FALSE,
23 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
24 x_rowid IN VARCHAR2,
25 P_PROPOSAL_ID in NUMBER,
26 P_MODULE_ID in NUMBER,
27 P_MODULE_TITLE in VARCHAR2,
28 P_MODULE_STATUS in VARCHAR2,
29 P_CONTACT_NAME in VARCHAR2,
30 P_PHONE_NUMBER in VARCHAR2,
31 P_EMAIL_ADDRESS in VARCHAR2,
32 P_COMMENTS in VARCHAR2,
33 p_record_version_number IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2);
37 --------------------------------------------------------------------------------------------------------
38
39 Procedure delete_prop_narrative (
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
42 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
43 ,x_rowid IN VARCHAR2
44 ,p_proposal_id IN NUMBER
45 ,p_record_version_number IN NUMBER
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2);
49
50 ------------------------------------------------------------------------------------------
51 Procedure update_narrative_type_code (
52 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53 p_commit IN VARCHAR2 := FND_API.G_FALSE,
54 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
55 P_PROPOSAL_ID in NUMBER,
56 P_NARRATIVE_TYPE_CODE in VARCHAR2,
57 P_NARRATIVE_SUBMISSION_CODE in VARCHAR2,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2);
61
62 -------------------------------------------------------------------------------------------------
63 PROCEDURE CHECK_LOCK
64 (x_rowid IN VARCHAR2
65 ,p_record_version_number IN NUMBER
66 ,x_return_status OUT NOCOPY VARCHAR2);
67
68
69 -------------------------------------------------------------------------------------------------------
70 PROCEDURE CHECK_ERRORS;
71
72 ------------------------------------------------------------------------------------------------------
73 PROCEDURE VALIDATE_LOGGED_USER_RIGHTS
74 (p_proposal_id IN NUMBER
75 ,x_return_status OUT NOCOPY VARCHAR2);
76
77 END IGW_PROP_NARRATIVES_PVT;