APPS.ITA_SETUP_REC_VALUES_PKG dependencies on ITA_SETUP_PARAMETERS_B

Line 847: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;

843: p_context_org_id IN VARCHAR2,
844: p_parameter_code IN VARCHAR2
845: )
846: return VARCHAR2 IS
847: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
848: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;
849: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;
850: l_rec_value_meaning VARCHAR2(3000);
851: l_rec_value_code VARCHAR2(3000);

Line 848: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;

844: p_parameter_code IN VARCHAR2
845: )
846: return VARCHAR2 IS
847: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
848: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;
849: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;
850: l_rec_value_meaning VARCHAR2(3000);
851: l_rec_value_code VARCHAR2(3000);
852: l_curr_sql VARCHAR2(32767);

Line 849: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;

845: )
846: return VARCHAR2 IS
847: l_select_clause ITA_SETUP_PARAMETERS_B.SELECT_CLAUSE%TYPE;
848: l_from_clause ITA_SETUP_PARAMETERS_B.FROM_CLAUSE%TYPE;
849: l_where_clause ITA_SETUP_PARAMETERS_B.WHERE_CLAUSE%TYPE;
850: l_rec_value_meaning VARCHAR2(3000);
851: l_rec_value_code VARCHAR2(3000);
852: l_curr_sql VARCHAR2(32767);
853: BEGIN

Line 867: FROM ita_setup_parameters_b

863: end if;
864:
865: SELECT select_clause, from_clause, where_clause
866: INTO l_select_clause, l_from_clause, l_where_clause
867: FROM ita_setup_parameters_b
868: WHERE parameter_code = p_parameter_code;
869:
870: --DBMS_OUTPUT.PUT_LINE('select clause: ' || l_select_clause);
871: --DBMS_OUTPUT.PUT_LINE('from clause: ' || l_from_clause);