DBA Data[Home] [Help]

APPS.IGI_IGIGBUCC_XMLP_PKG SQL Statements

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

Line: 41

  FUNCTION CF_UPDATEFORMULA(CCID IN NUMBER) RETURN NUMBER IS
PRAGMA AUTONOMOUS_TRANSACTION;
Line: 44

    UPDATE
      GL_CODE_COMBINATIONS gcc
    SET
      IGI_BALANCED_BUDGET_FLAG = 'Y'
    WHERE GCC.CODE_COMBINATION_ID = CCID;
Line: 51

  END CF_UPDATEFORMULA;
Line: 59

  FUNCTION CP_SELECT_ALL_P RETURN VARCHAR2 IS
  BEGIN
    RETURN CP_SELECT_ALL;
Line: 62

  END CP_SELECT_ALL_P;