1 PACKAGE BODY IGW_PROP_PERSON_QUESTIONS_PVT as
2 /* $Header: igwvppqb.pls 120.3 2006/02/22 23:25:14 dsadhukh ship $*/
3
4 PROCEDURE create_prop_person_question (
5 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
6 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
8 ,x_rowid OUT NOCOPY VARCHAR2
9 ,p_proposal_id IN NUMBER
10 ,p_proposal_number IN VARCHAR2
11 ,p_person_id IN NUMBER
12 ,p_party_id IN NUMBER
13 ,p_person_name IN VARCHAR2
14 ,p_question_number IN VARCHAR2
15 ,p_answer IN VARCHAR2
16 ,p_explanation IN VARCHAR2
17 ,p_review_date IN DATE
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_msg_count OUT NOCOPY NUMBER
20 ,x_msg_data OUT NOCOPY VARCHAR2)
21
22 is
23
24 BEGIN
25
26 null;
27
28 END create_prop_person_question;
29 --------------------------------------------------------------------------------------------------------------
30
31 Procedure update_prop_person_question (
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
33 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
35 ,x_rowid IN VARCHAR2
36 ,p_proposal_id IN NUMBER
37 ,p_proposal_number IN VARCHAR2
38 ,p_person_id IN NUMBER
39 ,p_party_id IN NUMBER
40 ,p_person_name IN VARCHAR2
41 ,p_question_number IN VARCHAR2
42 ,p_answer IN VARCHAR2
43 ,p_explanation IN VARCHAR2
44 ,p_review_date IN DATE
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) is
49
50 BEGIN
51 null;
52
53 END update_prop_person_question;
54 --------------------------------------------------------------------------------------------------------
55
56 Procedure delete_prop_person_question (
57 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
58 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
59 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
60 ,x_rowid IN VARCHAR2
61 ,p_record_version_number IN NUMBER
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2) is
65
66 BEGIN
67 null;
68
69
70 END delete_prop_person_question;
71
72 ------------------------------------------------------------------------------------------
73 PROCEDURE EXPLANATION_OR_DATE_REQUIRED (
74 p_question_number IN VARCHAR2,
75 p_answer IN VARCHAR2,
76 p_explanation IN VARCHAR2,
77 p_review_date IN VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2) is
79
80
81
82 BEGIN
83 null;
84
85 END EXPLANATION_OR_DATE_REQUIRED;
86
87
88 --------------------------------------------------------------------------------------------
89 PROCEDURE CHECK_LOCK
90 (x_rowid IN VARCHAR2
91 ,p_record_version_number IN NUMBER
92 ,x_return_status OUT NOCOPY VARCHAR2) is
93
94 BEGIN
95 null;
96
97 END CHECK_LOCK;
98 -------------------------------------------------------------------------------------
99
100 PROCEDURE CHECK_ERRORS is
101 BEGIN
102 null;
103
104 END CHECK_ERRORS;
105 ----------------------------------------------------------------------------------------
106
107 -- the following code transfers the questions pertaining to the appropriate proposal from the
108 -- igw_questions table to the igw_prop_person_questions table
109
110 PROCEDURE POPULATE_PROP_PERSON_QUESTIONS ( p_init_msg_list in varchar2 := FND_API.G_FALSE,
111 p_commit in varchar2 := FND_API.G_FALSE,
112 p_validate_only in varchar2 := FND_API.G_FALSE,
113 p_proposal_id in number,
114 p_person_id in number,
115 p_party_id in number,
116 x_rowid out NOCOPY varchar2,
117 x_return_status out NOCOPY varchar2,
118 x_msg_count out NOCOPY number,
119 x_msg_data out NOCOPY varchar2) is
120
121
122 BEGIN
123 null;
124
125 END POPULATE_PROP_PERSON_QUESTIONS;
126
127 END IGW_PROP_PERSON_QUESTIONS_PVT;
[Home] [Help]