APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on OKC_XPRT_QUESTIONS_B

Line 743: l_question_id okc_xprt_questions_b.question_id%TYPE;

739:
740: l_cz_imp_ps_nodes_rec CZ_IMP_PS_NODES%ROWTYPE;
741: l_api_name CONSTANT VARCHAR2(30) := 'create_template_feature';
742: l_model_feature_name VARCHAR2(255);
743: l_question_id okc_xprt_questions_b.question_id%TYPE;
744: l_sequence_num okc_xprt_question_orders.sequence_num%TYPE;
745: l_value_set_name okc_xprt_questions_b.value_set_name%TYPE;
746: l_feature_type NUMBER;
747: l_feature_min_val NUMBER;

Line 745: l_value_set_name okc_xprt_questions_b.value_set_name%TYPE;

741: l_api_name CONSTANT VARCHAR2(30) := 'create_template_feature';
742: l_model_feature_name VARCHAR2(255);
743: l_question_id okc_xprt_questions_b.question_id%TYPE;
744: l_sequence_num okc_xprt_question_orders.sequence_num%TYPE;
745: l_value_set_name okc_xprt_questions_b.value_set_name%TYPE;
746: l_feature_type NUMBER;
747: l_feature_min_val NUMBER;
748: l_feature_max_val NUMBER;
749:

Line 819: FROM okc_xprt_questions_b q,

815: DECODE(q.question_datatype,'N',NULL,1), --For Decimal Feature, create MAX as NULL
816: q.value_set_name,
817: DECODE(q.question_datatype,'N',2,
818: 0) --FEATURE_TYPE 2:Decimal 0:option
819: FROM okc_xprt_questions_b q,
820: okc_xprt_question_orders o
821: WHERE q.question_id = o.question_id
822: AND o.question_rule_status IN ('ACTIVE','PENDINGPUB')
823: AND o.template_id = p_template_id