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,
          decode(parameter_name,
                 ame_util.approverOamGroupId, null,
                 ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;

Line: 271

          memberDisplayNamesOut.delete;

Line: 285

          memberDisplayNamesOut.delete;

Line: 304

          memberDisplayNamesOut.delete;

Line: 321

          memberDisplayNamesOut.delete;

Line: 337

        select
          parameter,
          upper(parameter_name),
          query_string,
          decode(parameter_name,
                 ame_util.approverOamGroupId, null,
                 ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
          decode(parameter_name,
                 ame_util.approverOamGroupId, null,
                 ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;

Line: 512

          memberDisplayNamesOut.delete;

Line: 545

        select
          parameter,
          upper(parameter_name),
          query_string,
          order_number,
          decode(parameter_name,
                 ame_util.approverOamGroupId, null,
                 ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
          decode(parameter_name,
                 ame_util.approverOamGroupId, null,
                 ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;

Line: 724

          memberDisplayNamesOut.delete;

Line: 759

        select
          orig_system,
          orig_system_id,
          parameter,
          upper(parameter_name),
          query_string,
          order_number,
          decode(parameter_name,
                 ame_util.approverOamGroupId, null,
                 ame_approver_type_pkg.getWfRolesName(orig_system, orig_system_id)) approver_name,
          decode(parameter_name,
                 ame_util.approverOamGroupId, null,
                 ame_approver_type_pkg.getApproverDisplayName2(orig_system, orig_system_id)) display_name
          from ame_approval_group_members
          where
            approval_group_id = groupIdIn
          order by order_number;