DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT dependencies on FND_API

Line 20: mChoiceID NUMBER := FND_API.G_MISS_NUM,

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

Line 21: mChoiceName VARCHAR2(1000) := 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

Line 22: mLookupID NUMBER := FND_API.G_MISS_NUM,

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: );

Line 23: mScore NUMBER := FND_API.G_MISS_NUM,

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:

Line 24: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR

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: --

Line 25: ,mDefaultChoiceFlag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 49: mFreetextID NUMBER :=FND_API.G_MISS_NUM,

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

Line 50: mFreetextSize NUMBER :=FND_API.G_MISS_NUM,

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: );

Line 51: mFreeTextDefaultText VARCHAR2(1000) :=FND_API.G_MISS_CHAR,

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:

Line 52: mLookUpID NUMBER :=FND_API.G_MISS_NUM,

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: --

Line 53: mLast_Updated_Date VARCHAR2(200) :=FND_API.G_MISS_CHAR

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

Line 90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 91: p_commit IN VARCHAR := FND_API.G_FALSE,

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,

Line 113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 114: p_commit IN VARCHAR := FND_API.G_FALSE,

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

Line 140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 141: p_commit IN VARCHAR := FND_API.G_FALSE,

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

Line 163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 164: p_commit IN VARCHAR := FND_API.G_FALSE,

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,

Line 187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 188: p_commit IN VARCHAR := FND_API.G_FALSE,

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

Line 212: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 213: p_commit IN VARCHAR := FND_API.G_FALSE,

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,

Line 235: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 236: p_commit IN VARCHAR := FND_API.G_FALSE,

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,