APPS.ASO_APR_WF_PVT SQL Statements

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

Line: 17

     SELECT min(object_approval_id)
     FROM aso_apr_obj_approvals
     WHERE object_id = (SELECT object_id
                           FROM aso_apr_obj_approvals
                           WHERE object_approval_id = P_Object_approval_id)
     AND approval_status = 'PEND';

Line: 169

      SELECT approval_det_id, approver_sequence, approver_person_id,
             approver_user_id
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_approval_id
            AND approver_status = 'NOSUBMIT'
      ORDER BY approver_sequence;

Line: 370

        UPDATE aso_apr_approval_details
        SET approver_status = 'PEND',
            date_sent = SYSDATE,
            last_update_date = SYSDATE,
            last_updated_by = fnd_global.user_id,
            last_update_login = fnd_global.user_id
        WHERE object_approval_id = l_approval_id
              AND approver_sequence = next_seq;

Line: 456

      SELECT COUNT (
               *
             )
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_approval_id
            AND approver_status = 'NOSUBMIT';

Line: 466

      SELECT MAX (
               approver_sequence
             )
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_approval_id;

Line: 476

      SELECT COUNT (
               *
             )
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_approval_id
            AND approver_status = 'TOUT'
            AND approver_sequence = c_max_seq;

Line: 516

          'Calling the update approver list procedure ',
          1,
          'N'
        );

Line: 522

      aso_apr_wf_pvt.update_approver_list (
        l_approval_id
      );

Line: 650

        aso_apr_wf_pvt.update_approval_status (
          p_update_header_or_detail_flag => 'HEADER',
          p_object_approval_id           => l_approval_id,
          p_approval_det_id              => null,
          p_status                       => l_status,
          note                           => null);

Line: 675

            'Calling update entity  procedure ',
            1,
            'N'
          );

Line: 680

          aso_apr_wf_pvt.update_entity (
          itemtype ,
          itemkey ,
          actid   ,
          funcmode,
          resultout
          );

Line: 792

      SELECT COUNT (
               *
             )
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_approval_id
            AND approver_status = 'REJ';

Line: 839

            'Calling update quote procedure with status = REJ and approval id = '
            || l_approval_id,
            1,
            'N'
          );

Line: 861

       aso_apr_wf_pvt.update_approval_status (
          p_update_header_or_detail_flag => 'HEADER',
          p_object_approval_id           => l_approval_id,
          p_approval_det_id              => null,
          p_status                       => 'REJ',
          note                           => null);

Line: 886

            'Calling update entity  procedure ',
            1,
            'N'
          );

Line: 891

          aso_apr_wf_pvt.update_entity (
          itemtype ,
          itemkey ,
          actid   ,
          funcmode,
          resultout
          );

Line: 1062

          'Calling the update table procedure setting approver status to APPR',
          1,
          'N'
        );

Line: 1067

     aso_apr_wf_pvt.update_approval_status (
         p_update_header_or_detail_flag => 'DETAIL' ,
         p_object_approval_id           => null,
         p_approval_det_id              =>l_approval_det_id,
         p_status                       => 'APPR',
         note                           => l_note);

Line: 1192

          'Calling the update table procedure setting approver status to REJ',
          1,
          'N'
        );

Line: 1197

     aso_apr_wf_pvt.update_approval_status (
         p_update_header_or_detail_flag => 'DETAIL' ,
         p_object_approval_id           => null,
         p_approval_det_id              =>l_approval_det_id,
         p_status                       => 'REJ',
         note                           => l_note);

Line: 1326

          'Calling the update table procedure setting approver status to TOUT',
          1,
          'N'
        );

Line: 1331

     aso_apr_wf_pvt.update_approval_status (
         p_update_header_or_detail_flag => 'DETAIL' ,
         p_object_approval_id           => null,
         p_approval_det_id              =>l_approval_det_id,
         p_status                       => 'TOUT',
         note                           => l_note);

Line: 1416

      SELECT approval_det_id, approver_sequence, approver_person_id,
             approver_user_id
      FROM aso_apr_approval_details
      WHERE object_approval_id = l_approval_id
            AND approver_status = 'PEND'
      ORDER BY approver_sequence;

Line: 1426

      SELECT aoa.requester_userid, fu.employee_id
      FROM aso_apr_obj_approvals aoa, fnd_user fu
      WHERE object_approval_id = l_approval_id
            AND aoa.requester_userid = fu.user_id
            AND SYSDATE BETWEEN fu.start_date AND NVL (
                                                    fu.end_date,
                                                    SYSDATE
                                                  );

Line: 1435

    SELECT user_name
    FROM fnd_user
    WHERE user_id = l_user_id;

Line: 1462

  aso_apr_wf_pvt.update_approval_status (
    p_update_header_or_detail_flag => 'HEADER' ,
    p_object_approval_id           => approval_id,
    p_approval_det_id              =>null,
    p_status                       => 'CAN',
    note                           => null);

Line: 1716

      UPDATE aso_apr_approval_details
      SET approver_status = 'CAN',
          date_sent = SYSDATE,
          last_update_date = SYSDATE,
          last_updated_by = fnd_global.user_id,
          last_update_login = fnd_global.user_id
      WHERE approval_det_id = i.approval_det_id;

Line: 2196

  PROCEDURE update_entity (
    itemtype                    IN       VARCHAR2,
    itemkey                     IN       VARCHAR2,
    actid                       IN       NUMBER,
    funcmode                    IN       VARCHAR2,
    resultout                   IN OUT NOCOPY /* file.sql.39 change */  VARCHAR2
  ) IS
    l_contract_approval_level     VARCHAR2 (240);

Line: 2235

      SELECT object_id
      FROM aso_apr_obj_approvals
      WHERE object_approval_id = c_object_approval_id;

Line: 2242

      SELECT contract_approval_level
      FROM aso_quote_headers_all
      WHERE quote_header_id = c_quote_header_id;

Line: 2249

      SELECT last_update_date,org_id
      FROM aso_quote_headers_all
      WHERE quote_header_id = c_quote_header_id;

Line: 2256

      SELECT quote_status_id
      FROM aso_quote_statuses_b
      WHERE status_code = v_status;

Line: 2263

      SELECT approver_person_id
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_object_approval_id
      AND approver_sequence = (select max(approver_sequence)
                              FROM aso_apr_approval_details
                              WHERE object_approval_id = c_object_approval_id);

Line: 2272

    SELECT user_id
    FROM fnd_user
    WHERE employee_id = c_employee_id;

Line: 2279

    SELECT  approver_person_id
    FROM aso_apr_approval_details
    WHERE object_approval_id = c_object_approval_id
    AND approver_status = 'REJ';

Line: 2289

        'Begin Update Entity  Procedure ',
        1,
        'N'
      );

Line: 2459

    FETCH get_latest_date INTO l_quote_header_rec.last_update_date, l_quote_header_rec.org_id;

Line: 2467

        'Before calling update quote: Setting the single org context to org_id:  '|| l_quote_header_rec.org_id,
        1,
        'N'
      );

Line: 2479

        'Calling the update quote API in ASO_UPDATE_QUOTE_PUB package ',
        1,
        'N'
      );

Line: 2484

    aso_quote_pub.update_quote (
      p_api_version_number         => 1.0,
      p_init_msg_list              => fnd_api.g_false,
      p_commit                     => fnd_api.g_false,
      p_control_rec                => l_control_rec,
      p_qte_header_rec             => l_quote_header_rec,
      p_hd_price_attributes_tbl    => aso_quote_pub.g_miss_price_attributes_tbl,
      p_hd_payment_tbl             => aso_quote_pub.g_miss_payment_tbl,
      p_hd_shipment_tbl            => aso_quote_pub.g_miss_shipment_tbl,
      p_hd_freight_charge_tbl      => aso_quote_pub.g_miss_freight_charge_tbl,
      p_hd_tax_detail_tbl          => aso_quote_pub.g_miss_tax_detail_tbl,
      p_qte_line_tbl               => aso_quote_pub.g_miss_qte_line_tbl,
      p_qte_line_dtl_tbl           => aso_quote_pub.g_miss_qte_line_dtl_tbl,
      p_line_attr_ext_tbl          => aso_quote_pub.g_miss_line_attribs_ext_tbl,
      p_line_rltship_tbl           => aso_quote_pub.g_miss_line_rltship_tbl,
      p_price_adjustment_tbl       => aso_quote_pub.g_miss_price_adj_tbl,
      p_price_adj_attr_tbl         => aso_quote_pub.g_miss_price_adj_attr_tbl,
      p_price_adj_rltship_tbl      => aso_quote_pub.g_miss_price_adj_rltship_tbl,
      p_ln_price_attributes_tbl    => aso_quote_pub.g_miss_price_attributes_tbl,
      p_ln_payment_tbl             => aso_quote_pub.g_miss_payment_tbl,
      p_ln_shipment_tbl            => aso_quote_pub.g_miss_shipment_tbl,
      p_ln_freight_charge_tbl      => aso_quote_pub.g_miss_freight_charge_tbl,
      p_ln_tax_detail_tbl          => aso_quote_pub.g_miss_tax_detail_tbl,
      x_qte_header_rec             => x_qte_header_rec,
      x_qte_line_tbl               => x_qte_line_tbl,
      x_qte_line_dtl_tbl           => x_qte_line_dtl_tbl,
      x_hd_price_attributes_tbl    => x_hd_price_attributes_tbl,
      x_hd_payment_tbl             => x_hd_payment_tbl,
      x_hd_shipment_tbl            => x_hd_shipment_tbl,
      x_hd_freight_charge_tbl      => x_hd_freight_charge_tbl,
      x_hd_tax_detail_tbl          => x_hd_tax_detail_tbl,
      x_line_attr_ext_tbl          => x_line_attr_ext_tbl,
      x_line_rltship_tbl           => x_line_rltship_tbl,
      x_price_adjustment_tbl       => x_price_adjustment_tbl,
      x_price_adj_attr_tbl         => x_price_adj_attr_tbl,
      x_price_adj_rltship_tbl      => x_price_adj_rltship_tbl,
      x_ln_price_attributes_tbl    => x_ln_price_attributes_tbl,
      x_ln_payment_tbl             => x_ln_payment_tbl,
      x_ln_shipment_tbl            => x_ln_shipment_tbl,
      x_ln_freight_charge_tbl      => x_ln_freight_charge_tbl,
      x_ln_tax_detail_tbl          => x_ln_tax_detail_tbl,
      x_return_status              => x_return_status,
      x_msg_count                  => x_msg_count,
      x_msg_data                   => x_msg_data
    );

Line: 2534

          'Return Status from update quote API is :' || x_return_status,
          1,
          'N'
        );

Line: 2547

	 --RAISE update_quote_exception;

Line: 2555

        'After calling update quote Setting the org context to multi-org  org_id:null',
        1,
        'N'
      );

Line: 2566

        'End update entity  procedure ',
        1,
        'N'
      );

Line: 2580

          'Exception in update entity    ',
          1,
          'N'
        );

Line: 2587

        'update_entity',
        itemtype,
        itemkey,
        TO_CHAR(actid),
	   funcmode);

Line: 2597

          'Exception in update entity    ',
          1,
          'N'
        );

Line: 2604

        'update_entity',
        itemtype,
        itemkey,
        TO_CHAR(actid),
        funcmode);

Line: 2614

          'Exception in update entity    ',
          1,
          'N'
        );

Line: 2621

        'update_entity',
        itemtype,
        itemkey,
        TO_CHAR(actid),
        funcmode);

Line: 2628

  END update_entity;

Line: 2630

  PROCEDURE update_approver_list (
    p_object_approval_id        IN       NUMBER
  ) IS
    l_approvers_changed_flag      VARCHAR2 (1) := 'N';

Line: 2664

      SELECT DISTINCT object_id, object_type, application_id
      FROM aso_apr_obj_approvals
      WHERE object_approval_id = c_object_approval_id;

Line: 2671

      SELECT approval_det_id, approver_person_id, approver_user_id,
             approver_status
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_object_approval_id
      ORDER BY approver_sequence;

Line: 2680

      SELECT COUNT (
               *
             )
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_object_approval_id;

Line: 2690

      SELECT *
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_object_approval_id
            AND approval_det_id = c_approval_det_id;

Line: 2698

      SELECT oam_rule_id
      FROM aso_apr_rules
      WHERE object_approval_id = c_object_approval_id
      ORDER BY rule_id;

Line: 2706

      SELECT COUNT (
               *
             )
      FROM aso_apr_rules
      WHERE object_approval_id = c_object_approval_id;

Line: 2713

   select employee_id
   from fnd_user
   where user_id = l_user_id;

Line: 2721

        'Begin update approver list procedure   ',
        1,
        'N'
      );

Line: 2936

        ).last_update_date                          := SYSDATE;

Line: 2982

      DELETE FROM aso_apr_approval_details
      WHERE object_approval_id = p_object_approval_id;

Line: 3050

        aso_apr_approvals_pkg.detail_insert_row (
          l_new_approvers_tbl (
            j
          ).approval_det_id,
          l_new_approvers_tbl (
            j
          ).object_approval_id,
          l_new_approvers_tbl (
            j
          ).approver_person_id ---p_APPROVER_PERSON_ID
          ,
          l_new_approvers_tbl (
            j
          ).approver_user_id ---p_APPROVER_USER_ID
          ,
          j -- P_APPROVER_SEQUENCE
          ,
          l_new_approvers_tbl (
            j
          ).approver_status --p_APPROVER_STATUS
          ,
          l_new_approvers_tbl (
            j
          ).approver_comments -- p_APPROVER_COMMENTS
          ,
          l_new_approvers_tbl (
            j
          ).date_sent --p_DATE_SENT
          ,
          l_new_approvers_tbl (
            j
          ).date_received -- p_DATE_RECEIVED
          ,
          l_new_approvers_tbl (
            j
          ).creation_date -- p_CREATION_DATE
          ,
          SYSDATE -- p_LAST_UPDATE_DATE
          ,
          l_new_approvers_tbl (
            j
          ).created_by -- P_CREATED_BY
          ,
          g_user_id -- P_UPDATED_BY
          ,
          fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
          ,
          l_new_approvers_tbl (
            j
          ).attribute1 -- p_ATTRIBUTE1
          ,
          l_new_approvers_tbl (
            j
          ).attribute2 -- p_ATTRIBUTE2
          ,
          l_new_approvers_tbl (
            j
          ).attribute3 -- p_ATTRIBUTE3
          ,
          l_new_approvers_tbl (
            j
          ).attribute4 -- p_ATTRIBUTE4
          ,
          l_new_approvers_tbl (
            j
          ).attribute5 -- p_ATTRIBUTE5
          ,
          l_new_approvers_tbl (
            j
          ).attribute6 -- p_ATTRIBUTE6
          ,
          l_new_approvers_tbl (
            j
          ).attribute7 -- p_ATTRIBUTE7
          ,
          l_new_approvers_tbl (
            j
          ).attribute8 -- p_ATTRIBUTE8
          ,
          l_new_approvers_tbl (
            j
          ).attribute9 -- p_ATTRIBUTE9
          ,
          l_new_approvers_tbl (
            j
          ).attribute10 -- p_ATTRIBUTE10
          ,
          l_new_approvers_tbl (
            j
          ).attribute11 --  p_ATTRIBUTE11
          ,
          l_new_approvers_tbl (
            j
          ).attribute12 -- p_ATTRIBUTE12
          ,
          l_new_approvers_tbl (
            j
          ).attribute13 -- p_ATTRIBUTE13
          ,
          l_new_approvers_tbl (
            j
          ).attribute14 -- p_ATTRIBUTE14
          ,
          l_new_approvers_tbl (
            j
          ).attribute15 -- p_ATTRIBUTE15
          ,
          l_new_approvers_tbl (
            j
          ).attribute16 -- p_ATTRIBUTE16
          ,
          l_new_approvers_tbl (
            j
          ).attribute17 -- p_ATTRIBUTE17
          ,
          l_new_approvers_tbl (
            j
          ).attribute18 -- p_ATTRIBUTE18
          ,
          l_new_approvers_tbl (
            j
          ).attribute19 -- p_ATTRIBUTE19
          ,
          l_new_approvers_tbl (
            j
          ).attribute20 -- p_ATTRIBUTE20
          ,
		l_new_approvers_tbl (
            j
          ).CONTEXT -- p_CONTEXT
          ,
          l_new_approvers_tbl (
            j
          ).security_group_id -- p_SECURITY_GROUP_ID
          ,
          l_new_approvers_tbl (
            j
          ).object_version_number -- p_OBJECT_VERSION_NUMBER
        );

Line: 3267

      DELETE FROM aso_apr_rules
      WHERE object_approval_id = p_object_approval_id;

Line: 3272

          'Inserting rows into the rule table ',
          1,
          'N'
        );

Line: 3280

        aso_apr_approvals_pkg.rule_insert_row (
          p_rule_id,
          x_rules_list (
            i
          ).rule_id,
          x_rules_list (
            i
          ).rule_action_id,
          SYSDATE --p_CREATION_DATE
          ,
          g_user_id -- P_CREATED_BY
          ,
          SYSDATE -- p_LAST_UPDATE_DATE
          ,
          g_user_id -- P_UPDATED_BY
          ,
          fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
          ,
          p_object_approval_id,
          NULL -- p_ATTRIBUTE1
          ,
          NULL -- p_ATTRIBUTE2
          ,
          NULL -- p_ATTRIBUTE3
          ,
          NULL -- p_ATTRIBUTE4
          ,
          NULL -- p_ATTRIBUTE5
          ,
          NULL -- p_ATTRIBUTE6
          ,
          NULL -- p_ATTRIBUTE7
          ,
          NULL -- p_ATTRIBUTE8
          ,
          NULL -- p_ATTRIBUTE9
          ,
          NULL -- p_ATTRIBUTE10
          ,
          NULL -- p_ATTRIBUTE11
          ,
          NULL -- p_ATTRIBUTE12
          ,
          NULL -- p_ATTRIBUTE13
          ,
          NULL -- p_ATTRIBUTE14
          ,
          NULL -- p_ATTRIBUTE15
          ,
          NULL -- p_Attribute16
          ,
          NULL -- p_Attribute17
          ,
          NULL  -- p_Attribute18
          ,
          NULL -- p_Attribute19
          ,
          NULL -- p_Attribute20
	     ,
		NULL -- p_CONTEXT
          ,
          NULL -- p_SECURITY_GROUP_ID
          ,
          NULL -- p_OBJECT_VERSION_NUMBER
        );

Line: 3351

        'End update_approver_list procedure ',
        1,
        'N'
      );

Line: 3361

          'Call to get_all_approvers failed in update_approver_list ',
          1,
          'N'
        );

Line: 3396

        'Update_approver_list',
        'msg data ' || l_msg_data
      );

Line: 3404

          'When others exception in update approver list procedure ',
          1,
          'N'
        );

Line: 3411

        'Update_approver_list',
        SUBSTR (
          SQLERRM,
          1,
          250
        )
      );

Line: 3419

  END update_approver_list;

Line: 3434

      SELECT approval_det_id
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_object_approval_id;

Line: 3441

      SELECT MAX (
               approver_sequence
             ) + 1
      FROM aso_apr_approval_details
      WHERE object_approval_id = c_object_approval_id;

Line: 3450

      SELECT DISTINCT object_id, object_type, application_id
      FROM aso_apr_obj_approvals aoa
      WHERE object_approval_id = c_object_approval_id;

Line: 3525

      ame_api.updateapprovalstatus (
        applicationidin              => l_application_id,
        transactionidin              => l_object_id,
        transactiontypein            => l_object_type,
        approverin                   => new_approver_record
      );

Line: 3578

          'Inserting the new approver  into the detail table   ',
          1,
          'N'
        );

Line: 3583

      aso_apr_approvals_pkg.detail_insert_row (
        l_approval_det_id,
        p_object_approval_id,
        new_approver_record.person_id --p_APPROVER_PERSON_ID
        ,
        new_approver_record.user_id --p_APPROVER_USER_ID
        ,
        l_approver_sequence -- P_APPROVER_SEQUENCE
        ,
        'NOSUBMIT' --p_APPROVER_STATUS
        ,
        NULL -- p_APPROVER_COMMENTS
        ,
        NULL --p_DATE_SENT
        ,
        NULL -- p_DATE_RECEIVED
        ,
        SYSDATE -- p_CREATION_DATE
        ,
        SYSDATE -- p_LAST_UPDATE_DATE
        ,
        g_user_id -- P_CREATED_BY
        ,
        g_user_id -- P_UPDATED_BY
        ,
        fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
        ,
        NULL -- p_ATTRIBUTE1
        ,
        NULL -- p_ATTRIBUTE2
        ,
        NULL -- p_ATTRIBUTE3
        ,
        NULL -- p_ATTRIBUTE4
        ,
        NULL -- p_ATTRIBUTE5
        ,
        NULL -- p_ATTRIBUTE6
        ,
        NULL -- p_ATTRIBUTE7
        ,
        NULL -- p_ATTRIBUTE8
        ,
        NULL -- p_ATTRIBUTE9
        ,
        NULL -- p_ATTRIBUTE10
        ,
        NULL --  p_ATTRIBUTE11
        ,
        NULL -- p_ATTRIBUTE12
        ,
        NULL -- p_ATTRIBUTE13
        ,
        NULL -- p_ATTRIBUTE14
        ,
        NULL -- p_ATTRIBUTE15
        ,
        NULL -- p_Attribute16
        ,
        NULL -- p_Attribute17
        ,
        NULL  -- p_Attribute18
        ,
        NULL -- p_Attribute19
        ,
        NULL -- p_Attribute20
        ,
        NULL -- p_CONTEXT
        ,
        NULL -- p_SECURITY_GROUP_ID
        ,
        NULL -- p_OBJECT_VERSION_NUMBER
      );

Line: 3954

      SELECT approver_user_id, approver_person_id, fl.meaning, approver_comments
      FROM aso_apr_approval_details apd, aso_lookups fl
      WHERE apd.approver_status = fl.lookup_code
            AND object_approval_id = c_object_approval_id
            AND fl.lookup_type = 'ASO_APPROVER_STATUS'
      ORDER BY approver_sequence;

Line: 4190

      SELECT quote_header_id, quote_name, quote_number, quote_expiration_date
      FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
      WHERE qha.quote_header_id = aoa.object_id
            AND aoa.object_approval_id = c_approval_id;

Line: 4198

      SELECT hp.party_name
      FROM  aso_quote_headers_all qha,
            hz_parties hp
      WHERE qha.cust_party_id = hp.party_id
            AND qha.quote_header_id = c_quote_header_id;

Line: 4208

      SELECT hca.account_number
      FROM hz_cust_accounts hca,
           aso_quote_headers_all qha
      WHERE qha.cust_account_id = hca.cust_account_id(+)
            AND qha.quote_header_id = c_quote_header_id;

Line: 4217

      SELECT ala.description
      FROM as_leads_all ala,
           aso_quote_related_objects qro,
           aso_apr_obj_approvals aoa
      WHERE ala.lead_id = qro.object_id
            AND qro.relationship_type_code = 'OPP_QUOTE'
            AND qro.quote_object_id = aoa.object_id
            AND aoa.object_approval_id = c_approval_id;

Line: 4229

   SELECT P.PARTY_TYPE
   FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
   WHERE p.party_id = qh.party_id
    AND qh.quote_header_id = aoa.object_id
    AND aoa.object_approval_id = c_approval_id;

Line: 4240

    SELECT party_name
    FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
    WHERE p.party_id = r.object_id
    AND r.party_id = qh.party_id
    AND r.subject_id = qh.cust_party_id
    AND r.object_type = 'PERSON'
    AND r.relationship_code IN ('CONTACT','EMPLOYER_OF')
    AND qh.quote_header_id = aoa.object_id
    AND aoa.object_approval_id = c_approval_id;

Line: 4587

      SELECT requester_comments
      FROM aso_apr_obj_approvals
      WHERE object_approval_id = c_approval_id;

Line: 4769

      SELECT oam_rule_id
      FROM aso_apr_rules
      WHERE object_approval_id = c_approval_id;

Line: 5023

      SELECT quote_header_id, quote_number,qha.org_id
      FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
      WHERE qha.quote_header_id = aoa.object_id
            AND aoa.object_approval_id = c_approval_id;

Line: 5033

      SELECT hca.cust_account_id, hp.party_type
      FROM aso_quote_headers_all qha,
           hz_parties hp,
           hz_cust_accounts hca
      WHERE qha.quote_header_id = c_quote_header_id
            AND nvl(qha.cust_account_id,0 )  = hca.cust_account_id (+)
            AND qha.cust_party_id = hp.party_id;

Line: 5268

      SELECT application_id
      FROM aso_apr_obj_approvals
      WHERE object_approval_id = c_approval_id;

Line: 5276

      SELECT attribute_label_long
      FROM ak_region_items ara, ak_attributes_tl aat
      WHERE region_code = 'ASO_APR_NOTIFICATION'
        and region_application_id = c_application_id
        AND AAT.ATTRIBUTE_APPLICATION_ID = ARA.ATTRIBUTE_APPLICATION_ID
        AND AAT.ATTRIBUTE_CODE = ARA.ATTRIBUTE_CODE
        AND AAT.LANGUAGE = USERENV('LANG')
        ORDER by display_sequence;

Line: 5422

      SELECT quote_name, quote_number,org_id,quote_header_id
      FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
      WHERE qha.quote_header_id = aoa.object_id
            AND aoa.object_approval_id = c_approval_id;

Line: 5533

  PROCEDURE update_approval_status (
    p_update_header_or_detail_flag IN     VARCHAR2,
    p_object_approval_id           IN      NUMBER,
    p_approval_det_id              IN       NUMBER,
    p_status                       IN       VARCHAR2,
    note                           IN       VARCHAR2
  ) is
 begin
    IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
      aso_debug_pub.ADD (
        'Start  update_approval_status  procedure ',
        1,
        'N'
      );

Line: 5549

        'Flag  is :' || p_update_header_or_detail_flag,
        1,
        'N'
      );

Line: 5571

  IF p_update_header_or_detail_flag = 'HEADER' THEN
    IF (p_status = 'PEND')
    THEN
      UPDATE aso_apr_obj_approvals
      SET approval_status = p_status,
          last_update_date = SYSDATE,
          last_updated_by = g_user_id,
          last_update_login = g_user_id
      WHERE object_approval_id = p_object_approval_id;

Line: 5581

      UPDATE aso_apr_obj_approvals
      SET approval_status = p_status,
          last_update_date = SYSDATE,
          end_date = SYSDATE,
          last_updated_by = g_user_id,
          last_update_login = g_user_id
      WHERE object_approval_id = p_object_approval_id;

Line: 5592

  IF p_update_header_or_detail_flag = 'DETAIL' THEN
    UPDATE aso_apr_approval_details
    SET approver_status = p_status,
        date_received = SYSDATE,
        last_update_date = SYSDATE,
        approver_comments = note,
        last_updated_by = fnd_global.user_id,
        last_update_login = fnd_global.user_id
    WHERE approval_det_id = p_approval_det_id;

Line: 5605

        'End  update_approval_status  procedure ',
        1,
        'N'
      );