DBA Data[Home] [Help]

APPS.POS_SUPPLIER_TAX_PROF_BO_PKG SQL Statements

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

Line: 41

        SELECT pos_tax_profile_bo(party_type_code,
                                  supplier_flag,
                                  customer_flag,
                                  site_flag,
                                  process_for_applicability_flag,
                                  rounding_level_code,
                                  rounding_rule_code,
                                  withholding_start_date,
                                  inclusive_tax_flag,
                                  allow_awt_flag,
                                  use_le_as_subscriber_flag,
                                  legal_establishment_flag,
                                  first_party_le_flag,
                                  reporting_authority_flag,
                                  collecting_authority_flag,
                                  provider_type_code,
                                  create_awt_dists_type_code,
                                  create_awt_invoices_type_code,
                                  tax_classification_code,
                                  self_assess_flag,
                                  allow_offset_tax_flag,
                                  effective_from_use_le,
                                  record_type_code,
                                  created_by,
                                  creation_date,
                                  last_updated_by,
                                  last_update_date,
                                  last_update_login,
                                  request_id,
                                  program_application_id,
                                  program_id,
                                  attribute1,
                                  attribute2,
                                  attribute3,
                                  attribute4,
                                  attribute5,
                                  attribute6,
                                  attribute7,
                                  attribute8,
                                  attribute9,
                                  attribute10,
                                  attribute11,
                                  attribute12,
                                  attribute13,
                                  attribute14,
                                  attribute15,
                                  attribute_category,
                                  program_login_id,
                                  party_tax_profile_id,
                                  party_id,
                                  rep_registration_number,
                                  object_version_number,
                                  registration_type_code,
                                  country_code,
                                  merged_to_ptp_id,
                                  merged_status_code) BULK COLLECT
        INTO   l_ap_supplier_tax_prof_bo_tbl
        FROM   zx_party_tax_profile
        WHERE  party_id = l_party_id;
Line: 145

            SELECT party_tax_profile_id
            INTO   x_party_tax_profile_id
            FROM   zx_party_tax_profile
            WHERE  party_id = p_party_id
            AND    party_type_code = 'THIRD_PARTY';
Line: 161

                SELECT fndlookup.lookup_code
                INTO   l_dummy_lookup
                FROM   fnd_lookups fndlookup
                WHERE  fndlookup.lookup_type LIKE 'ZX_ROUNDING_LEVEL'
                AND    nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
                AND    nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
                AND    nvl(fndlookup.enabled_flag, 'N') = 'Y'
                AND    lookup_code = p_rounding_level_code
                ORDER  BY fndlookup.lookup_code;
Line: 183

                SELECT fndlookup.lookup_code
                INTO   l_dummy_lookup
                FROM   fnd_lookups fndlookup
                WHERE  fndlookup.lookup_type LIKE 'ZX_ROUNDING_RULE'
                AND    nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
                AND    nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
                AND    nvl(fndlookup.enabled_flag, 'N') = 'Y'
                AND    lookup_code = p_rounding_rule_code
                ORDER  BY fndlookup.lookup_code;
Line: 205

                SELECT territory_short_name
                INTO   x_country_code
                FROM   fnd_territories_vl
                WHERE  territory_code = p_country_code;
Line: 223

                SELECT fndlookup.lookup_code
                INTO   l_dummy_lookup
                FROM   fnd_lookups fndlookup
                WHERE  fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'
                AND    nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
                AND    nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
                AND    nvl(fndlookup.enabled_flag, 'N') = 'Y'
                AND    lookup_code = p_registration_type_code
                ORDER  BY fndlookup.lookup_code;
Line: 273

                                      p_create_update_flag      IN VARCHAR2,
                                      x_return_status           OUT NOCOPY VARCHAR2,
                                      x_msg_count               OUT NOCOPY NUMBER,
                                      x_msg_data                OUT NOCOPY VARCHAR2,
                                      x_tax_profile_id          OUT NOCOPY NUMBER) IS
        l_tax_prof_valid       VARCHAR2(10);
Line: 308

        IF p_create_update_flag = 'C' THEN
            IF (l_tax_prof_valid = 'Y') THEN

                -- Insert
                zx_party_tax_profile_pkg.insert_row(p_allow_awt_flag               => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
                                                    p_allow_offset_tax_flag        => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
                                                    p_attribute_category           => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
                                                    p_attribute1                   => x_zx_party_tax_profile_bo_tbl(i).attribute1,
                                                    p_attribute10                  => x_zx_party_tax_profile_bo_tbl(i).attribute10,
                                                    p_attribute11                  => x_zx_party_tax_profile_bo_tbl(i).attribute11,
                                                    p_attribute12                  => x_zx_party_tax_profile_bo_tbl(i).attribute12,
                                                    p_attribute13                  => x_zx_party_tax_profile_bo_tbl(i).attribute13,
                                                    p_attribute14                  => x_zx_party_tax_profile_bo_tbl(i).attribute14,
                                                    p_attribute15                  => x_zx_party_tax_profile_bo_tbl(i).attribute15,
                                                    p_attribute2                   => x_zx_party_tax_profile_bo_tbl(i).attribute2,
                                                    p_attribute3                   => x_zx_party_tax_profile_bo_tbl(i).attribute3,
                                                    p_attribute4                   => x_zx_party_tax_profile_bo_tbl(i).attribute4,
                                                    p_attribute5                   => x_zx_party_tax_profile_bo_tbl(i).attribute5,
                                                    p_attribute6                   => x_zx_party_tax_profile_bo_tbl(i).attribute6,
                                                    p_attribute7                   => x_zx_party_tax_profile_bo_tbl(i).attribute7,
                                                    p_attribute8                   => x_zx_party_tax_profile_bo_tbl(i).attribute8,
                                                    p_attribute9                   => x_zx_party_tax_profile_bo_tbl(i).attribute9,
                                                    p_collecting_authority_flag    => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
                                                    p_country_code                 => x_zx_party_tax_profile_bo_tbl(i).country_code,
                                                    p_create_awt_dists_type_code   => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
                                                    p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
                                                    p_customer_flag                => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
                                                    p_effective_from_use_le        => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
                                                    p_first_party_le_flag          => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
                                                    p_inclusive_tax_flag           => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
                                                    p_legal_establishment_flag     => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
                                                    p_party_id                     => x_zx_party_tax_profile_bo_tbl(i).party_id,
                                                    p_party_type_code              => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
                                                    p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
                                                    p_program_login_id             => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
                                                    p_provider_type_code           => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
                                                    p_record_type_code             => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
                                                    p_registration_type_code       => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
                                                    p_rep_registration_number      => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
                                                    p_reporting_authority_flag     => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
                                                    p_request_id                   => x_zx_party_tax_profile_bo_tbl(i).request_id,
                                                    p_rounding_level_code          => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
                                                    p_rounding_rule_code           => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
                                                    p_self_assess_flag             => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
                                                    p_site_flag                    => x_zx_party_tax_profile_bo_tbl(i).site_flag,
                                                    p_supplier_flag                => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
                                                    p_tax_classification_code      => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
                                                    p_use_le_as_subscriber_flag    => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
                                                    p_withholding_start_date       => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
                                                    x_return_status                => l_return_status);
Line: 363

                    SELECT party_tax_profile_id
                    INTO   l_party_tax_profile_id
                    FROM   zx_party_tax_profile
                    WHERE  party_id = l_party_id
                    AND    party_type_code = 'THIRD_PARTY';
Line: 382

        ELSIF p_create_update_flag = 'U' THEN
            IF (l_tax_prof_valid = 'Y') THEN

                zx_party_tax_profile_pkg.update_row(p_allow_awt_flag               => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
                                                    p_allow_offset_tax_flag        => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
                                                    p_attribute_category           => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
                                                    p_attribute1                   => x_zx_party_tax_profile_bo_tbl(i).attribute1,
                                                    p_attribute10                  => x_zx_party_tax_profile_bo_tbl(i).attribute10,
                                                    p_attribute11                  => x_zx_party_tax_profile_bo_tbl(i).attribute11,
                                                    p_attribute12                  => x_zx_party_tax_profile_bo_tbl(i).attribute12,
                                                    p_attribute13                  => x_zx_party_tax_profile_bo_tbl(i).attribute13,
                                                    p_attribute14                  => x_zx_party_tax_profile_bo_tbl(i).attribute14,
                                                    p_attribute15                  => x_zx_party_tax_profile_bo_tbl(i).attribute15,
                                                    p_attribute2                   => x_zx_party_tax_profile_bo_tbl(i).attribute2,
                                                    p_attribute3                   => x_zx_party_tax_profile_bo_tbl(i).attribute3,
                                                    p_attribute4                   => x_zx_party_tax_profile_bo_tbl(i).attribute4,
                                                    p_attribute5                   => x_zx_party_tax_profile_bo_tbl(i).attribute5,
                                                    p_attribute6                   => x_zx_party_tax_profile_bo_tbl(i).attribute6,
                                                    p_attribute7                   => x_zx_party_tax_profile_bo_tbl(i).attribute7,
                                                    p_attribute8                   => x_zx_party_tax_profile_bo_tbl(i).attribute8,
                                                    p_attribute9                   => x_zx_party_tax_profile_bo_tbl(i).attribute9,
                                                    p_collecting_authority_flag    => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
                                                    p_country_code                 => x_zx_party_tax_profile_bo_tbl(i).country_code,
                                                    p_create_awt_dists_type_code   => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
                                                    p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
                                                    p_customer_flag                => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
                                                    p_effective_from_use_le        => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
                                                    p_first_party_le_flag          => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
                                                    p_inclusive_tax_flag           => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
                                                    p_legal_establishment_flag     => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
                                                    p_party_id                     => x_zx_party_tax_profile_bo_tbl(i).party_id,
                                                    p_party_type_code              => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
                                                    p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
                                                    p_program_login_id             => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
                                                    p_provider_type_code           => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
                                                    p_record_type_code             => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
                                                    p_registration_type_code       => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
                                                    p_rep_registration_number      => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
                                                    p_reporting_authority_flag     => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
                                                    p_request_id                   => x_zx_party_tax_profile_bo_tbl(i).request_id,
                                                    p_rounding_level_code          => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
                                                    p_rounding_rule_code           => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
                                                    p_self_assess_flag             => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
                                                    p_site_flag                    => x_zx_party_tax_profile_bo_tbl(i).site_flag,
                                                    p_supplier_flag                => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
                                                    p_tax_classification_code      => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
                                                    p_use_le_as_subscriber_flag    => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
                                                    p_withholding_start_date       => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
                                                    p_party_tax_profile_id         => x_zx_party_tax_profile_bo_tbl(i).party_tax_profile_id,
                                                    x_return_status                => l_return_status);
Line: 470

    * Use this routine to update tax profile BO
    * @param p_api_version The api version
    * @param p_init_msg_list The Initialization message list
    * @param p_tax_profile_rec The tax profile bo
    * @param x_return_status The return status
    * @param x_msg_count The message count
    * @param x_msg_data The message data
    * @rep:scope public
    * @rep:lifecycle active
    * @rep:displayname Create Supplier Contact
    * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
    */
/*  PROCEDURE update_supp_tax_profile(p_api_version     IN NUMBER DEFAULT NULL,
                                      p_init_msg_list   IN VARCHAR2 DEFAULT NULL,
                                      p_tax_profile_rec IN pos_party_tax_profile_int%ROWTYPE,
                                      x_return_status   OUT NOCOPY VARCHAR2,
                                      x_msg_count       OUT NOCOPY NUMBER,
                                      x_msg_data        OUT NOCOPY VARCHAR2) IS
        l_tax_prof_valid       VARCHAR2(10);
Line: 509

            zx_party_tax_profile_pkg.update_row(p_party_tax_profile_id         => l_party_tax_profile_id,
                                                p_collecting_authority_flag    => NULL,
                                                p_provider_type_code           => NULL,
                                                p_create_awt_dists_type_code   => NULL,
                                                p_create_awt_invoices_type_cod => NULL,
                                                p_tax_classification_code      => NULL,
                                                p_self_assess_flag             => NULL,
                                                p_allow_offset_tax_flag        => NULL,
                                                p_rep_registration_number      => p_tax_profile_rec.rep_registration_number,
                                                p_effective_from_use_le        => NULL,
                                                p_record_type_code             => NULL,
                                                p_request_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_attribute_category           => NULL,
                                                p_party_id                     => p_tax_profile_rec.party_id,
                                                p_program_login_id             => NULL,
                                                p_party_type_code              => 'THIRD_PARTY',
                                                p_supplier_flag                => NULL,
                                                p_customer_flag                => NULL,
                                                p_site_flag                    => NULL,
                                                p_process_for_applicability_fl => NULL,
                                                p_rounding_level_code          => p_tax_profile_rec.rounding_level_code,
                                                p_rounding_rule_code           => p_tax_profile_rec.rounding_rule_code,
                                                p_withholding_start_date       => NULL,
                                                p_inclusive_tax_flag           => p_tax_profile_rec.inclusive_tax_flag,
                                                p_allow_awt_flag               => NULL,
                                                p_use_le_as_subscriber_flag    => NULL,
                                                p_legal_establishment_flag     => NULL,
                                                p_first_party_le_flag          => NULL,
                                                p_reporting_authority_flag     => NULL,
                                                x_return_status                => x_return_status,
                                                p_registration_type_code       => p_tax_profile_rec.registration_type_code,
                                                p_country_code                 => l_country_code);
Line: 584

    END update_supp_tax_profile;