DBA Data[Home] [Help]

APPS.CS_TP_QUESTIONS_PVT dependencies on FND_API

Line 26: mQuestionID NUMBER := FND_API.G_MISS_NUM,

22: -- mShowOnCreationFlag VARCHAR2(1)
23: -- End of Comments
24:
25: TYPE Question is RECORD (
26: mQuestionID NUMBER := FND_API.G_MISS_NUM,
27: mQuestionName VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,
29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 27: mQuestionName VARCHAR2(2000) := FND_API.G_MISS_CHAR ,

23: -- End of Comments
24:
25: TYPE Question is RECORD (
26: mQuestionID NUMBER := FND_API.G_MISS_NUM,
27: mQuestionName VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,
29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: mLookUpID NUMBER := FND_API.G_MISS_NUM,

Line 28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,

24:
25: TYPE Question is RECORD (
26: mQuestionID NUMBER := FND_API.G_MISS_NUM,
27: mQuestionName VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,
29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: mLookUpID NUMBER := FND_API.G_MISS_NUM,
32: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR ,

Line 29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,

25: TYPE Question is RECORD (
26: mQuestionID NUMBER := FND_API.G_MISS_NUM,
27: mQuestionName VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,
29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: mLookUpID NUMBER := FND_API.G_MISS_NUM,
32: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR ,
33:

Line 30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,

26: mQuestionID NUMBER := FND_API.G_MISS_NUM,
27: mQuestionName VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,
29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: mLookUpID NUMBER := FND_API.G_MISS_NUM,
32: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR ,
33:
34: mNoteType VARCHAR2(30),

Line 31: mLookUpID NUMBER := FND_API.G_MISS_NUM,

27: mQuestionName VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,
29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: mLookUpID NUMBER := FND_API.G_MISS_NUM,
32: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR ,
33:
34: mNoteType VARCHAR2(30),
35: mShowOnCreationFlag VARCHAR2(1)

Line 32: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR ,

28: mAnswerType VARCHAR2(60) := FND_API.G_MISS_CHAR,
29: mMandatoryFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
30: mScoringFlag VARCHAR2(60) := FND_API.G_MISS_CHAR,
31: mLookUpID NUMBER := FND_API.G_MISS_NUM,
32: mLast_Updated_Date VARCHAR2(60) := FND_API.G_MISS_CHAR ,
33:
34: mNoteType VARCHAR2(30),
35: mShowOnCreationFlag VARCHAR2(1)
36: );

Line 72: -- In the Question Record, Question Name and AnswerType need to be valid. Mandatory Flag and Scoring Flag need to either FND_API.G_TRUE or FND_API.G_FALSE. Lookup ID, Question ID, Last Updated Date are not needed.

68: -- *****************************************************************************
69: -- Start of Comments
70: -- This procedure Add_Question add an additional question to the CS_TP_QUESIONS_B and CS_TP_QUESTIONS_TL as well as associate the question to the template id passed in.
71: -- In addition, it will create a lookup id with answer information such as answer type-- and associate it with the question.
72: -- In the Question Record, Question Name and AnswerType need to be valid. Mandatory Flag and Scoring Flag need to either FND_API.G_TRUE or FND_API.G_FALSE. Lookup ID, Question ID, Last Updated Date are not needed.
73: -- @param One_Question required
74: -- @param Template_ID required
75: -- @param p_api_version_number required
76: -- @param p_commit

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

83: -- X_Question_ID
84: -- End of Comments
85: procedure Add_Question (
86: p_api_version_number IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_commit IN VARCHAR := FND_API.G_FALSE,
89: P_One_Question IN Question,
90: p_Template_ID IN NUMBER,
91: X_Msg_Count OUT NOCOPY NUMBER,

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

84: -- End of Comments
85: procedure Add_Question (
86: p_api_version_number IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88: p_commit IN VARCHAR := FND_API.G_FALSE,
89: P_One_Question IN Question,
90: p_Template_ID IN NUMBER,
91: X_Msg_Count OUT NOCOPY NUMBER,
92: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 103: --ry Flag and Scoring Flag need to either FND_API.G_TRUE or FND_API.G_FALSE. Lookup ID is not needed.

99: -- This procedure Update_Question modifys an existing question in the CS_TP_QUESIONS_B and CS_TP_QUESTIONS_TL table with what is in the P_One_Question record
100: -- In the Question Record, Question ID is used to identify the question. Last
101: -- Updated Date is required to check whether the record is updated after the u
102: --ser last queries. Question Name and AnswerType need to be valid. Mandato
103: --ry Flag and Scoring Flag need to either FND_API.G_TRUE or FND_API.G_FALSE. Lookup ID is not needed.
104: --
105: -- @param P_One_Question required
106: -- @param p_api_version_number required
107: -- @param p_commit

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

117: -- End of Comments
118:
119: procedure Update_Question (
120: p_api_version_number IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR := FND_API.G_FALSE,
123: P_One_Question IN Question,
124: X_Msg_Count OUT NOCOPY NUMBER,
125: X_Msg_Data OUT NOCOPY VARCHAR2,

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

118:
119: procedure Update_Question (
120: p_api_version_number IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR := FND_API.G_FALSE,
123: P_One_Question IN Question,
124: X_Msg_Count OUT NOCOPY NUMBER,
125: X_Msg_Data OUT NOCOPY VARCHAR2,
126: X_Return_Status OUT NOCOPY VARCHAR2);

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

140: -- End of Comments
141:
142: procedure Delete_Question (
143: p_api_version_number IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR := FND_API.G_FALSE,
146: p_Question_ID IN NUMBER,
147: p_Template_ID IN NUMBER,
148: X_Msg_Count OUT NOCOPY NUMBER,

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

141:
142: procedure Delete_Question (
143: p_api_version_number IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR := FND_API.G_FALSE,
146: p_Question_ID IN NUMBER,
147: p_Template_ID IN NUMBER,
148: X_Msg_Count OUT NOCOPY NUMBER,
149: X_Msg_Data OUT NOCOPY VARCHAR2,

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

169: -- End of Comments
170:
171: procedure Sort_Questions (
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR := FND_API.G_FALSE,
175: P_Questions IN Question_List,
176: P_Template_ID IN NUMBER,
177: X_Msg_Count OUT NOCOPY NUMBER,

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

170:
171: procedure Sort_Questions (
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR := FND_API.G_FALSE,
175: P_Questions IN Question_List,
176: P_Template_ID IN NUMBER,
177: X_Msg_Count OUT NOCOPY NUMBER,
178: X_Msg_Data OUT NOCOPY VARCHAR2,

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

203: -- End of Comments
204:
205: procedure Show_Questions (
206: p_api_version_number IN NUMBER,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208: p_commit IN VARCHAR := FND_API.G_FALSE,
209: P_Template_ID IN NUMBER,
210: P_Start_Question IN NUMBER,
211: P_End_Question IN NUMBER,

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

204:
205: procedure Show_Questions (
206: p_api_version_number IN NUMBER,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208: p_commit IN VARCHAR := FND_API.G_FALSE,
209: P_Template_ID IN NUMBER,
210: P_Start_Question IN NUMBER,
211: P_End_Question IN NUMBER,
212: P_Display_Order IN VARCHAR2,

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

234: -- End of Comments
235:
236: procedure Show_Question (
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR := FND_API.G_FALSE,
240: P_Question_ID IN NUMBER,
241: X_Msg_Count OUT NOCOPY NUMBER,
242: X_Msg_Data OUT NOCOPY VARCHAR2,

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

235:
236: procedure Show_Question (
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR := FND_API.G_FALSE,
240: P_Question_ID IN NUMBER,
241: X_Msg_Count OUT NOCOPY NUMBER,
242: X_Msg_Data OUT NOCOPY VARCHAR2,
243: X_Return_Status OUT NOCOPY VARCHAR2,