APPS.AP_WEB_DFLEX_PKG SQL Statements

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

Line: 52

C_SelectInputObject     CONSTANT VARCHAR2(20) := 'SELECT';

Line: 302

             P_ExpTypeTaxCodeUpdateable IN OUT NOCOPY VARCHAR2,
             P_ExpTypeDefaultTaxCode    IN OUT NOCOPY ZX_WEBEXP_CLASSIFICATIONS_V.LOOKUP_CODE%TYPE,--bug#14798565
             P_OrgId                    IN  NUMBER)
-------------------------------------------------------------------------------
IS

  V_ExpTypeRec			AP_WEB_DB_EXPTEMPLATE_PKG.ExpTypeInfoRec;

Line: 320

    P_ExpTypeTaxCodeUpdateable := C_No;

Line: 351

             p_allow_tax_code_override_flag => P_ExpTypeTaxCodeUpdateable,
             APPL_SHORT_NAME		=> 'SQLAP',
             FUNC_SHORT_NAME		=> 'NONE',
             p_calling_sequence		=> 'APXXXEER',
             p_event_class_code	        => 'EXPENSE REPORTS',
             p_entity_code              => 'AP_INVOICES',
             p_application_id		=> 200,
             p_internal_organization_id	=> P_OrgId);

Line: 374

  P_ExpTypeTaxCodeUpdateable := NVL(P_ExpTypeTaxCodeUpdateable, C_Yes);

Line: 606

        P_InputObjectType := C_SelectInputObject;

Line: 648

          P_InputObjectType := C_SelectInputObject;

Line: 930

                               P_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN)
------------------------------------------------------------------------
IS
  CustomForOneReceipt CustomFields_A;

Line: 966

  P_DataDefaultedUpdateable := FALSE;

Line: 1006

         NOT P_DataDefaultedUpdateable THEN

        -- Get value set
        V_DebugInfo := 'Get value set';

Line: 1016

          P_DataDefaultedUpdateable := TRUE;

Line: 1071

               NOT P_DataDefaultedUpdateable THEN

              -- Get value set
              V_DebugInfo := 'Get value set';

Line: 1081

                P_DataDefaultedUpdateable := TRUE;

Line: 1141

                               P_DataDefaultedUpdateable IN OUT NOCOPY BOOLEAN)
------------------------------------------------------------------------
IS

  V_DefaultTaxCodeUpdateable VARCHAR2(1);

Line: 1156

  P_DataDefaultedUpdateable := FALSE;

Line: 1167

    V_DefaultTaxCodeUpdateable := NULL;

Line: 1171

                                V_DefaultTaxCodeUpdateable,
                                V_DefaultTaxCode,
                                l_OrgId);

Line: 1177

    P_DataDefaultedUpdateable := TRUE;

Line: 1181

    IF V_DefaultTaxCode IS NOT NULL AND V_DefaultTaxCodeUpdateable = C_Yes THEN
      P_DataDefaultedUpdateable := TRUE;

Line: 2235

		select format_type, number_precision into p_format_type, p_number_precision
		from fnd_flex_value_sets where flex_value_set_id = p_custom_fields_array(i).value_set;