APPS.QA_QLTRSLTR_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

      V_DEFAULT_SELECT VARCHAR2(32767);

Line: 16

                ,V_DEFAULT_SELECT
                ,V_DEFAULT_WHERE
                ,V_DEFAULT_PROMPTS
                ,V_DEFAULT_LENGTH
                ,V_SUM
                ,V_TITLE
                ,V_DESCRIPTION);

Line: 23

        P_DEFAULT_SEL := V_DEFAULT_SELECT;

Line: 31

        P_DEFAULT_SEL := P_SELECT_1 || P_SELECT_2 || P_SELECT_3 || P_SELECT_4 || P_SELECT_5 || P_SELECT_6 ||
	P_SELECT_7 || P_SELECT_8 || P_SELECT_9 || P_SELECT_10 || P_SELECT_11 || P_SELECT_12 || P_SELECT_13 ||
	P_SELECT_14 || P_SELECT_15 || P_SELECT_16 || P_SELECT_17 || P_SELECT_18 || P_SELECT_19 || P_SELECT_20 || P_SELECT_21 || P_SELECT_22 || P_SELECT_23 || P_SELECT_24 || P_SELECT_25;

Line: 1767

                    ,X_SELECT OUT NOCOPY VARCHAR2
                    ,X_WHERE OUT NOCOPY VARCHAR2
                    ,X_PROMPTS OUT NOCOPY VARCHAR2
                    ,X_LENGTH OUT NOCOPY VARCHAR2
                    ,X_SUM OUT NOCOPY VARCHAR2
                    ,X_TITLE OUT NOCOPY VARCHAR2
                    ,X_DESCRIPTION OUT NOCOPY VARCHAR2) IS
    CURSOR PCURSOR IS
      SELECT
        PLAN_ID,
        TITLE,
        DESCRIPTION
      FROM
        QA_CRITERIA_HEADERS
      WHERE CRITERIA_ID = X_CRITERIA_ID;

Line: 1797

      SELECT
        NVL(PERSON_PARTY_ID
           ,-1)
      INTO V_CUSTID
      FROM
        FND_USER
      WHERE USER_ID = P_USER_ID;

Line: 1820

    X_SELECT := V_SELECT;

Line: 1833

    V_SELECT VARCHAR2(5000) := NULL;

Line: 1863

        V_SELECT := V_SELECT || ', ' || V_NAME || ' col_' || TO_CHAR(V_COUNTER);

Line: 1877

          V_SELECT := V_SELECT || ', ' || Y_NAME || ' num_' || TO_CHAR(V_COUNTER);

Line: 1878

          V_SELECT := V_SELECT || ', '|| 'QA_QLTRSLTR_XMLP_PKG.C_AST_'||TO_CHAR(V_COUNTER)||'FORMULA(' ||Y_NAME||','||V_NAME||')'||' C_AST_'||TO_CHAR(V_COUNTER) ;

Line: 1880

          V_SELECT := V_SELECT || ', 999 num_' || TO_CHAR(V_COUNTER);

Line: 1881

	  V_SELECT := V_SELECT || ', '|| 'QA_QLTRSLTR_XMLP_PKG.C_AST_'||TO_CHAR(V_COUNTER)||'FORMULA(' ||999 ||','||V_NAME||')'||' C_AST_'||TO_CHAR(V_COUNTER) ;

Line: 1929

      V_SELECT := V_SELECT || ', null col_' || TO_CHAR(I) || ', 999 num_' || TO_CHAR(I);

Line: 1942

    V_SELECT := 'SELECT ' || SUBSTR(V_SELECT,3);

Line: 1943

    V_PROMPTS := 'SELECT ' || SUBSTR(V_PROMPTS,3) || ' FROM SYS.DUAL';

Line: 1944

    V_LENGTHS := 'SELECT ' || SUBSTR(V_LENGTHS,3)|| ' FROM SYS.DUAL';

Line: 1945

    V_SUMS := 'SELECT ' || SUBSTR(V_SUMS,3)|| ' FROM SYS.DUAL';

Line: 1955

    QA_QLTRSLTR_XMLP_PKG.V_SELECT := V_SELECT ||' '|| ' ' || V_FROM;

Line: 1974

      SELECT
        VALUE
      FROM
        QA_IN_LISTS
      WHERE PARENT_BLOCK_NAME = V_PARENT_BLOCK_NAME
        AND LIST_ID = V_LIST_ID;

Line: 2303

      SELECT
        QCV.CHAR_ID,
        QCV.HARDCODED_COLUMN,
        QCV.RESULT_COLUMN_NAME,
        QCV.DATATYPE,
        QCV.OPERATOR,
        QCV.LOW_VALUE,
        QCV.HIGH_VALUE,
        QCV.SQL_TYPE,
        QCV.DISPLAY_LENGTH,
        QCV.PROMPT,
        QCV.ORDER_SEQUENCE,
        QCV.TOTAL,
        QCV.FXN,
        QCV.FXN_MEANING,
        QCV.DECIMAL_PRECISION,
        QCV.FK_LOOKUP_TYPE,
        QCV.FK_TABLE_NAME,
        QCV.FK_TABLE_SHORT_NAME,
        QCV.PK_ID,
        QCV.FK_ID,
        QCV.PK_ID2,
        QCV.FK_ID2,
        QCV.PK_ID3,
        QCV.FK_ID3,
        QCV.FK_MEANING,
        QCV.FK_DESCRIPTION,
        QCV.FK_ADD_WHERE,
        QIL.PARENT_BLOCK_NAME,
        QIL.LIST_ID
      FROM
        QA_CRITERIA_V QCV,
        QA_IN_LISTS QIL
      WHERE QCV.CRITERIA_ID = V_CRITERIA_ID
        AND qil.list_elem_id (+) = CRITERIA_SEQUENCE
      ORDER BY
        11;