1 PACKAGE okc_xprt_question_pub AUTHID CURRENT_USER AS
2 /* $Header: OKCPXIQS.pls 120.1 2011/03/10 18:06:13 harchand noship $ */
3
4 /*
5 * *** SCOPE OF THIS PUBLIC API ***
6 * Supports Creation of/Updation to Questions/Constants.
7 * Does not support Deletion of Questions/Constants.
8 *
9 */
10
11 /*
12
13 **** Business Rules for Questions:
14 => You must provide the intent for the question.
15 => A question name must be unique for a given intent.
16 => You can make changes to the existing questions.
17 However, you cannot update Name,Intent, Response Type, and Value Set if the question is used in a rule.
18 You can update Description and Question Prompt even if the question is used in a rule.
19 For the prompt changes to take effect on a business document, you must run the Contract Expert:
20 Synchronize Templates concurrent program.
21 => You can use the Disable check box to prevent the question from being used in a new rule.
22 This will not impact existing rules that use this question.
23
24 ***** Business Rules for Constants:
25 => You must provide the intent for the constant, that is, Buy or Sell.
26 => A constant name must be unique for a given intent.
27 => The name and intent of a constant cannot be changed if the constant is used in a rule.
28 => You can make changes to the
29 name,description, intent, and value of the constant if the constant is not used in any rules.
30 If the constant is included in a rule, you can change only its value and description.
31
32 */
33
34 /**
35 * **************************
36 * *** Defaulting Rules ***
37 * **************************
38 *
39 * During the creation of question/constant, If the user does not provide any values for the
40 * following fields, then the API will default the values as below:
41 * DISABLED_FLAG => 'N'
42 * QUESTION_SYNC_FLAG => 'Y' ( for Questions only)
43 * OBJECT_VERSION_NUMBER => 1
44 */
45
46 /*
47 *
48 okc_exprt_questions_type stores information about questions and constants
49 QUESTION_TYPE VARCHAR2(1) Yes This indicates the question type.
50 FK to FND lookup OKC_XPRT_QUESTION_TYPE.
51 Possible values are Q and C. Q: Question, C: Constant.
52 QUESTION_INTENT VARCHAR2(1) Yes Intent of Question or Constant. B: Buy, S: Sell.
53 DISABLED_FLAG VARCHAR2(1) Yes Indicates if the question or constant is disabled
54 QUESTION_DATATYPE VARCHAR2(1) Yes Indicates response datatype.
55 FK to FND lookup OKC_XPRT_QUESTION_DATATYPE.
56 B: Boolean, N: Numeric, L: List of values.
57 VALUE_SET_NAME VARCHAR2(60) The value set corresponding to the question with response type of
58 List of Values. FK to FND value set.
59 DEFAULT_VALUE NUMBER Value for Constants. This is mandatory for defining constants.
60 QUESTION_SYNC_FLAG VARCHAR2(1) Yes This will be used to indicate if a question needs to be synchronized with Oracle Confiugrator
61 QUESTION_NAME VARCHAR2(150) Yes User question name / Constant name
62 LANGUAGE VARCHAR2(4) Yes Language in which the question or constant is created
63 SOURCE_LANG VARCHAR2(4) Yes The base language from which the values are translated
64 DESCRIPTION VARCHAR2(2000) Description of Question / Constant.
65 PROMPT VARCHAR2(450) Question prompt that will be displayed to user in runtime UI.
66 This is not applicable to constants.
67 *
68 */
69 PROCEDURE create_question (
70 p_xprt_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type,
71 p_commit IN VARCHAR2 := fnd_api.g_false
72 );
73
74 PROCEDURE create_question (
75 p_xprt_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type,
76 p_commit IN VARCHAR2 := fnd_api.g_false
77 );
78
79 PROCEDURE update_question (
80 p_xprt_update_question_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type,
81 p_commit IN VARCHAR2
82 := fnd_api.g_false
83 );
84
85 PROCEDURE update_question (
86 p_xprt_update_question_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type,
87 p_commit IN VARCHAR2
88 := fnd_api.g_false
89 );
90
91
92 PROCEDURE create_constant (
93 p_xprt_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type,
94 p_commit IN VARCHAR2 := fnd_api.g_false
95 );
96
97 PROCEDURE create_constant (
98 p_xprt_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type,
99 p_commit IN VARCHAR2 := fnd_api.g_false
100 );
101
102 PROCEDURE update_constant (
103 p_xprt_update_constant_rec IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_rec_type,
104 p_commit IN VARCHAR2
105 := fnd_api.g_false
106 );
107
108 PROCEDURE update_constant (
109 p_xprt_update_constant_tbl IN OUT NOCOPY okc_xprt_question_pvt.xprt_qn_const_tbl_type,
110 p_commit IN VARCHAR2
111 := fnd_api.g_false
112 );
113
114
115
116 END okc_xprt_question_pub;