APPS.AME_API7 SQL Statements

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

Line: 46

      ame_engine.updateTransactionState(isTestTransactionIn => false,
                                        isLocalTransactionIn => false,
                                        fetchConfigVarsIn => false,
                                        fetchOldApproversIn => false,
                                        fetchInsertionsIn => false,
                                        fetchDeletionsIn => false,
                                        fetchAttributeValuesIn => true,
                                        fetchInactiveAttValuesIn => true,
                                        processProductionActionsIn => false,
                                        processProductionRulesIn => false,
                                        updateCurrentApproverListIn => false,
                                        updateOldApproverListIn => false,
                                        processPrioritiesIn => false,
                                        prepareItemDataIn => false,
                                        prepareRuleIdsIn => false,
                                        prepareRuleDescsIn => false,
                                        transactionIdIn => transactionIdIn,
                                        ameApplicationIdIn => null,
                                        fndApplicationIdIn => applicationIdIn,
                                        transactionTypeIdIn => transactionTypeIn );

Line: 134

        select
          parameter,
          upper(parameter_name),
          query_string,
          orig_system,
          orig_system_id
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;

Line: 311

          memberDisplayNamesOut.delete;

Line: 325

          memberDisplayNamesOut.delete;

Line: 344

          memberDisplayNamesOut.delete;

Line: 361

          memberDisplayNamesOut.delete;

Line: 377

        select
          parameter,
          upper(parameter_name),
          query_string,
          orig_system,
          orig_system_id
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;

Line: 591

          memberDisplayNamesOut.delete;

Line: 624

        select
          parameter,
          upper(parameter_name),
          query_string,
          order_number,
          orig_system,
          orig_system_id
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;

Line: 841

          memberDisplayNamesOut.delete;

Line: 876

        select
          orig_system,
          orig_system_id,
          parameter,
          upper(parameter_name),
          query_string,
          order_number
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;