16:
17: -- End of Comments
18:
19: TYPE Choice is RECORD (
20: mChoiceID NUMBER := FND_API.G_MISS_NUM,
21: mChoiceName VARCHAR2(1000) := FND_API.G_MISS_CHAR ,
22: mLookupID NUMBER := FND_API.G_MISS_NUM,
23: mScore NUMBER := FND_API.G_MISS_NUM,
24: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR
17: -- End of Comments
18:
19: TYPE Choice is RECORD (
20: mChoiceID NUMBER := FND_API.G_MISS_NUM,
21: mChoiceName VARCHAR2(1000) := FND_API.G_MISS_CHAR ,
22: mLookupID NUMBER := FND_API.G_MISS_NUM,
23: mScore NUMBER := FND_API.G_MISS_NUM,
24: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR
25: ,mDefaultChoiceFlag VARCHAR2(1) := FND_API.G_MISS_CHAR
18:
19: TYPE Choice is RECORD (
20: mChoiceID NUMBER := FND_API.G_MISS_NUM,
21: mChoiceName VARCHAR2(1000) := FND_API.G_MISS_CHAR ,
22: mLookupID NUMBER := FND_API.G_MISS_NUM,
23: mScore NUMBER := FND_API.G_MISS_NUM,
24: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR
25: ,mDefaultChoiceFlag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
19: TYPE Choice is RECORD (
20: mChoiceID NUMBER := FND_API.G_MISS_NUM,
21: mChoiceName VARCHAR2(1000) := FND_API.G_MISS_CHAR ,
22: mLookupID NUMBER := FND_API.G_MISS_NUM,
23: mScore NUMBER := FND_API.G_MISS_NUM,
24: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR
25: ,mDefaultChoiceFlag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
27:
20: mChoiceID NUMBER := FND_API.G_MISS_NUM,
21: mChoiceName VARCHAR2(1000) := FND_API.G_MISS_CHAR ,
22: mLookupID NUMBER := FND_API.G_MISS_NUM,
23: mScore NUMBER := FND_API.G_MISS_NUM,
24: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR
25: ,mDefaultChoiceFlag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
27:
28: --
21: mChoiceName VARCHAR2(1000) := FND_API.G_MISS_CHAR ,
22: mLookupID NUMBER := FND_API.G_MISS_NUM,
23: mScore NUMBER := FND_API.G_MISS_NUM,
24: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR
25: ,mDefaultChoiceFlag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
27:
28: --
29: -- Start of Comments
45: -- mLookUpID NUMBER
46: -- mLast_Updated_Date VARCHAR2
47:
48: TYPE FREETEXT is RECORD (
49: mFreetextID NUMBER :=FND_API.G_MISS_NUM,
50: mFreetextSize NUMBER :=FND_API.G_MISS_NUM,
51: mFreeTextDefaultText VARCHAR2(1000) :=FND_API.G_MISS_CHAR,
52: mLookUpID NUMBER :=FND_API.G_MISS_NUM,
53: mLast_Updated_Date VARCHAR2(200) :=FND_API.G_MISS_CHAR
46: -- mLast_Updated_Date VARCHAR2
47:
48: TYPE FREETEXT is RECORD (
49: mFreetextID NUMBER :=FND_API.G_MISS_NUM,
50: mFreetextSize NUMBER :=FND_API.G_MISS_NUM,
51: mFreeTextDefaultText VARCHAR2(1000) :=FND_API.G_MISS_CHAR,
52: mLookUpID NUMBER :=FND_API.G_MISS_NUM,
53: mLast_Updated_Date VARCHAR2(200) :=FND_API.G_MISS_CHAR
54: );
47:
48: TYPE FREETEXT is RECORD (
49: mFreetextID NUMBER :=FND_API.G_MISS_NUM,
50: mFreetextSize NUMBER :=FND_API.G_MISS_NUM,
51: mFreeTextDefaultText VARCHAR2(1000) :=FND_API.G_MISS_CHAR,
52: mLookUpID NUMBER :=FND_API.G_MISS_NUM,
53: mLast_Updated_Date VARCHAR2(200) :=FND_API.G_MISS_CHAR
54: );
55:
48: TYPE FREETEXT is RECORD (
49: mFreetextID NUMBER :=FND_API.G_MISS_NUM,
50: mFreetextSize NUMBER :=FND_API.G_MISS_NUM,
51: mFreeTextDefaultText VARCHAR2(1000) :=FND_API.G_MISS_CHAR,
52: mLookUpID NUMBER :=FND_API.G_MISS_NUM,
53: mLast_Updated_Date VARCHAR2(200) :=FND_API.G_MISS_CHAR
54: );
55:
56: --
49: mFreetextID NUMBER :=FND_API.G_MISS_NUM,
50: mFreetextSize NUMBER :=FND_API.G_MISS_NUM,
51: mFreeTextDefaultText VARCHAR2(1000) :=FND_API.G_MISS_CHAR,
52: mLookUpID NUMBER :=FND_API.G_MISS_NUM,
53: mLast_Updated_Date VARCHAR2(200) :=FND_API.G_MISS_CHAR
54: );
55:
56: --
57: -- Display Order Constants are used to dictate the order of the list of templates/questions queried
86: -- End of Comments
87:
88: procedure Add_Choice (
89: p_api_version_number IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR := FND_API.G_FALSE,
92: p_One_Choice IN Choice,
93: X_Msg_Count OUT NOCOPY NUMBER,
94: X_Msg_Data OUT NOCOPY VARCHAR2,
87:
88: procedure Add_Choice (
89: p_api_version_number IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR := FND_API.G_FALSE,
92: p_One_Choice IN Choice,
93: X_Msg_Count OUT NOCOPY NUMBER,
94: X_Msg_Data OUT NOCOPY VARCHAR2,
95: X_Return_Status OUT NOCOPY VARCHAR2,
109: -- End of Comments
110:
111: procedure Delete_Choice (
112: p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR := FND_API.G_FALSE,
115: P_Choice_ID IN NUMBER,
116: X_Msg_Count OUT NOCOPY NUMBER,
117: X_Msg_Data OUT NOCOPY VARCHAR2,
110:
111: procedure Delete_Choice (
112: p_api_version_number IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR := FND_API.G_FALSE,
115: P_Choice_ID IN NUMBER,
116: X_Msg_Count OUT NOCOPY NUMBER,
117: X_Msg_Data OUT NOCOPY VARCHAR2,
118: X_Return_Status OUT NOCOPY VARCHAR2
136: -- X_Return_Status
137: -- End of Comments
138: procedure Sort_Choices (
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR := FND_API.G_FALSE,
142: P_Choices In Choice_List,
143: X_Msg_Count OUT NOCOPY NUMBER,
144: X_Msg_Data OUT NOCOPY VARCHAR2,
137: -- End of Comments
138: procedure Sort_Choices (
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR := FND_API.G_FALSE,
142: P_Choices In Choice_List,
143: X_Msg_Count OUT NOCOPY NUMBER,
144: X_Msg_Data OUT NOCOPY VARCHAR2,
145: X_Return_Status OUT NOCOPY VARCHAR2
159: -- X_Choice_List_To_Show
160:
161: procedure Show_Choices (
162: p_api_version_number IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR := FND_API.G_FALSE,
165: P_Lookup_Id IN NUMBER,
166: P_Display_Order IN VARCHAR2,
167: X_Msg_Count OUT NOCOPY NUMBER,
160:
161: procedure Show_Choices (
162: p_api_version_number IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR := FND_API.G_FALSE,
165: P_Lookup_Id IN NUMBER,
166: P_Display_Order IN VARCHAR2,
167: X_Msg_Count OUT NOCOPY NUMBER,
168: X_Msg_Data OUT NOCOPY VARCHAR2,
183: -- X_Return_Status
184:
185: procedure Update_Choices (
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR := FND_API.G_FALSE,
189: P_Choices In Choice_List,
190: X_Msg_Count OUT NOCOPY NUMBER,
191: X_Msg_Data OUT NOCOPY VARCHAR2,
184:
185: procedure Update_Choices (
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR := FND_API.G_FALSE,
189: P_Choices In Choice_List,
190: X_Msg_Count OUT NOCOPY NUMBER,
191: X_Msg_Data OUT NOCOPY VARCHAR2,
192: X_Return_Status OUT NOCOPY VARCHAR2
208: -- X_Freetext_ID
209:
210: procedure Add_Freetext (
211: p_api_version_number IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR := FND_API.G_FALSE,
214: P_One_Freetext in Freetext,
215: X_Msg_Count OUT NOCOPY NUMBER,
216: X_Msg_Data OUT NOCOPY VARCHAR2,
209:
210: procedure Add_Freetext (
211: p_api_version_number IN NUMBER,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213: p_commit IN VARCHAR := FND_API.G_FALSE,
214: P_One_Freetext in Freetext,
215: X_Msg_Count OUT NOCOPY NUMBER,
216: X_Msg_Data OUT NOCOPY VARCHAR2,
217: X_Return_Status OUT NOCOPY VARCHAR2,
231: -- X_Return_Status
232: -- X_Freetext
233: procedure Show_Freetext (
234: p_api_version_number IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236: p_commit IN VARCHAR := FND_API.G_FALSE,
237: P_Lookup_ID IN NUMBER,
238: X_Msg_Count OUT NOCOPY NUMBER,
239: X_Msg_Data OUT NOCOPY VARCHAR2,
232: -- X_Freetext
233: procedure Show_Freetext (
234: p_api_version_number IN NUMBER,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236: p_commit IN VARCHAR := FND_API.G_FALSE,
237: P_Lookup_ID IN NUMBER,
238: X_Msg_Count OUT NOCOPY NUMBER,
239: X_Msg_Data OUT NOCOPY VARCHAR2,
240: X_Return_Status OUT NOCOPY VARCHAR2,