APPS.JE_JENOGEIS_XMLP_PKG SQL Statements

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

Line: 41

      SELECT
        PRECISION
      INTO PRECISION
      FROM
        FND_CURRENCIES
      WHERE CURRENCY_CODE = FUNCTCURR;

Line: 51

      P_INSERT_PERIOD_NAME(P_PERIOD_NAME
                          ,P_INCOME
                          ,P_EXPENSE);

Line: 183

      V_STRENG := 'create or replace view je_no_gei_sreport_v as select gcc.' || V_AUT_TYPE_SEGMENTS || ' authority_type ,gbs.period_name period,gbs.actual_flag,
                  ' || V_ACCOUNT_SEGMENTS || ' account_number,(gbs.period_net_dr - gbs.period_net_cr) balance,gbs.template_id, gbs.period_num, gbs.period_year from gl_code_combinations gcc,
		  gl_balances gbs, gl_sets_of_books gso where gbs.code_combination_id = gcc.code_combination_id
                  and gbs.ledger_id = gso.set_of_books_id and gso.currency_code = gbs.currency_code and gbs.template_id = ' || V_DETAIL_TEMPLATE;

Line: 195

    INSERT INTO JE_NO_GEI_ASCIIS_T(LINE_NUMBER,TEXT)
    VALUES   (P_LINE_NUMBER
      ,P_TEXT);

Line: 203

  PROCEDURE P_INSERT_PERIOD_NAME(P_PERIOD_NAME IN GL_BALANCES.PERIOD_NAME%TYPE
                                ,P_ACCOUNT_INCOME IN GL_BALANCES.PERIOD_NET_DR%TYPE
                                ,P_ACCOUNT_EXPENSE IN GL_BALANCES.PERIOD_NET_DR%TYPE) IS
    TMP_PERIOD_NUM VARCHAR2(2);

Line: 226

      SELECT
        JUG.AUTHORITY_TYPE AUT_TYPE,
        JUG.ACCOUNT_NUMBER ACCOUNT,
        SUM(NVL(JUG.BALANCE
               ,0)) BALANCE
      FROM
        JE_NO_GEI_SREPORT_V JUG
      WHERE JUG.PERIOD_NUM <= T_PERIOD_NUM
        AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
        AND NVL(JUG.BALANCE
         ,0) <> 0
        AND JUG.TEMPLATE_ID = T_DETAIL_TEMPL
        AND JUG.ACTUAL_FLAG = 'A'
      GROUP BY
        JUG.AUTHORITY_TYPE,
        JUG.ACCOUNT_NUMBER;

Line: 244

      SELECT
        JUG.AUTHORITY_TYPE AUT_TYPE,
        JUG.ACCOUNT_NUMBER ACCOUNT,
        SUM(NVL(JUG.BALANCE
               ,0)) BALANCE
      FROM
        JE_NO_GEI_SREPORT_V JUG
      WHERE JUG.PERIOD_NUM > 12
        AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
        AND NVL(JUG.BALANCE
         ,0) <> 0
        AND JUG.TEMPLATE_ID = T_DETAIL_TEMPL
        AND JUG.ACTUAL_FLAG = 'A'
      GROUP BY
        JUG.AUTHORITY_TYPE,
        JUG.ACCOUNT_NUMBER;

Line: 267

      SELECT
        CLOSING_STATUS,
        PERIOD_YEAR,
        PERIOD_NUM
      INTO T_CLOS,T_PERIOD_YEAR,T_PERIOD_NUM
      FROM
        GL_PERIOD_STATUSES,
        GL_SETS_OF_BOOKS
      WHERE GL_PERIOD_STATUSES.PERIOD_NAME = P_PERIOD_NAME
        AND GL_PERIOD_STATUSES.APPLICATION_ID = '101'
        AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = T_SET_OF_BOOKS
        AND GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID = GL_PERIOD_STATUSES.SET_OF_BOOKS_ID;

Line: 298

      DELETE FROM JE_NO_GEI_ASCIIS_T;

Line: 302

                   ,'Cant delete from JE_NO_GEI_ASCII_S.')*/NULL;

Line: 358

      SELECT
        JE_NO_GEI_CONTROLS_S.NEXTVAL
      INTO TMP_NUMBER
      FROM
        DUAL;

Line: 471

      SELECT
        SUM(NVL(BALANCE
               ,0))
      INTO BALANCE_SUM
      FROM
        JE_NO_GEI_SREPORT_V
      WHERE PERIOD = P_PERIOD_NAME;

Line: 509

      SELECT
        NVL(SUM(BALANCE)
           ,0)
      INTO T_SUM_INCOME
      FROM
        JE_NO_GEI_SREPORT_V JUG
      WHERE JUG.PERIOD_NUM <= T_PERIOD_NUM
        AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
        AND JUG.ACCOUNT_NUMBER = T_INCOME_ACCOUNT
        AND JUG.TEMPLATE_ID = T_DETAIL_TEMPL;

Line: 564

      SELECT
        NVL(SUM(BALANCE)
           ,0)
      INTO T_SUM_EXPENSE
      FROM
        JE_NO_GEI_SREPORT_V JUG
      WHERE JUG.PERIOD_NUM <= T_PERIOD_NUM
        AND JUG.PERIOD_YEAR = T_PERIOD_YEAR
        AND JUG.ACCOUNT_NUMBER = T_EXPENSE_ACCOUNT
        AND JUG.TEMPLATE_ID = T_DETAIL_TEMPL;

Line: 602

      INSERT INTO JE_NO_GEI_CONTROLS
        (ORDER_NUMBER
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN)
      VALUES   (TO_NUMBER(T_ORDER_NUMBER)
        ,FND_GLOBAL.USER_ID
        ,SYSDATE
        ,FND_GLOBAL.USER_ID
        ,SYSDATE
        ,FND_GLOBAL.LOGIN_ID);

Line: 622

  END P_INSERT_PERIOD_NAME;

Line: 629

      SELECT
        FND_DATE.DATE_TO_CHARDATE(SYSDATE)
      INTO V_DATE
      FROM
        DUAL;

Line: 643

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_APPLICATION_VL AP
      WHERE AP.APPLICATION_ID = CP.APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_NAME = 'JENOGEIS'
        AND AP.APPLICATION_SHORT_NAME = 'JE';

Line: 670

  FUNCTION SELECT_ALL_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ALL;

Line: 673

  END SELECT_ALL_P;