APPS.ASO_PARTY_INT SQL Statements

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

Line: 180

        SELECT site_use_type_id FROM HZ_SITE_USE_TYPES
        WHERE name = p_type_name;*/

Line: 340

PROCEDURE Update_Party(
        p_party_rec                 IN PARTY_REC_TYPE,
        x_return_status             OUT NOCOPY /* file.sql.39 change */   VARCHAR2,
        x_msg_count                 OUT NOCOPY /* file.sql.39 change */   NUMBER,
        x_msg_data                  OUT NOCOPY /* file.sql.39 change */   VARCHAR2)
IS
l_api_name         VARCHAR2(40) := 'Update_Party' ;

Line: 372

l_last_update_date DATE;

Line: 373

l_party_rel_last_update_date DATE;

Line: 375

   SAVEPOINT UPDATE_PARTY_PVT;

Line: 412

    l_last_update_date                 :=  p_party_rec.LAST_UPDATE_DATE;

Line: 416

 Original Call:   HZ_PARTY_PUB.update_person
*/

-- Getting the object version number
-- This is used by API to lock the object being updated

        BEGIN
        -- Intialize the variable as it used multiple times in this procedure
        l_party_object_version_number := FND_API.G_MISS_NUM;

Line: 426

        SELECT OBJECT_VERSION_NUMBER
        INTO   l_party_object_version_number
        FROM   HZ_PARTIES
        WHERE  PARTY_ID = p_party_rec.party_id;

Line: 437

aso_debug_pub.add('update_pty:before update_per', 1, 'N');

Line: 438

aso_debug_pub.add('update_pty:object_version_number  '||l_party_object_version_number, 1, 'N');

Line: 441

HZ_PARTY_V2PUB.update_person (
    p_init_msg_list                    => FND_API.G_FALSE,
    p_person_rec                       => l_PERSON_REC,
    p_party_object_version_number      => l_party_object_version_number,
    x_profile_id                       => l_profile_id,
    x_return_status                    => x_return_status,
    x_msg_count                        => x_msg_count ,
    x_msg_data                         => x_msg_data
);

Line: 452

aso_debug_pub.add('update_pty:after update_per:x_return_status '||x_return_status, 1, 'N');

Line: 453

aso_debug_pub.add('update_pty:after update_per:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');

Line: 465

    l_last_update_date     := p_party_rec.last_update_date;

Line: 469

 Original Call:   HZ_PARTY_PUB.update_organization
*/

-- Getting the object version number
-- This is used by API to lock the object being updated

        BEGIN
        -- Intialize the variable as it used multiple times in this procedure
        l_party_object_version_number := FND_API.G_MISS_NUM;

Line: 479

        SELECT OBJECT_VERSION_NUMBER
        INTO   l_party_object_version_number
        FROM   HZ_PARTIES
        WHERE  PARTY_ID = p_party_rec.party_id;

Line: 490

aso_debug_pub.add('update_pty:before update_organization', 1, 'N');

Line: 491

aso_debug_pub.add('update_pty:object_version_number  '||l_party_object_version_number, 1, 'N');

Line: 495

HZ_PARTY_V2PUB.update_organization (
    p_init_msg_list                    => FND_API.G_FALSE,
    p_organization_rec                 => l_organization_rec ,
    p_party_object_version_number      => l_party_object_version_number,
    x_profile_id                       => l_profile_id ,
    x_return_status                    => x_return_status ,
    x_msg_count                        => x_msg_count ,
    x_msg_data                         => x_msg_data
);

Line: 506

aso_debug_pub.add('update_pty:after update_org:x_return_status '||x_return_status, 1, 'N');

Line: 507

aso_debug_pub.add('update_pty:after update_org:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');

Line: 512

    l_last_update_date                 :=  p_party_rec.LAST_UPDATE_DATE;

Line: 514

    SELECT last_update_date, relationship_id
    INTO l_party_rel_last_update_date,l_party_relationship_id
    from hz_relationships
    where party_id = p_party_rec.party_id
    and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
    and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

Line: 526

   Original Call:  HZ_PARTY_PUB.update_party_relationship

*/

-- Getting the object version number
-- This is used by API to lock the object being updated

        BEGIN
        -- Intialize the variable as it used multiple times in this procedure
        l_party_object_version_number := FND_API.G_MISS_NUM;

Line: 537

        SELECT OBJECT_VERSION_NUMBER
        INTO   l_party_object_version_number
        FROM   HZ_PARTIES
        WHERE  PARTY_ID = p_party_rec.party_id;

Line: 542

        SELECT OBJECT_VERSION_NUMBER
        INTO   l_object_version_number
        FROM   HZ_RELATIONSHIPS
        WHERE  RELATIONSHIP_ID  = l_party_relationship_id
        AND    DIRECTIONAL_FLAG = 'F';

Line: 555

aso_debug_pub.add('update_pty:before update_reltn', 1, 'N');

Line: 556

aso_debug_pub.add('update_pty:object_version_number  '||l_party_object_version_number, 1, 'N');

Line: 559

HZ_RELATIONSHIP_V2PUB.update_relationship (
    p_init_msg_list               =>  FND_API.G_FALSE,
    p_relationship_rec            => l_party_rel_rec ,
    p_object_version_number       => l_object_version_number,
    p_party_object_version_number => l_party_object_version_number,
    x_return_status               => x_return_status,
    x_msg_count                   => x_msg_count,
    x_msg_data                    => x_msg_data
);

Line: 572

aso_debug_pub.add('update_pty:after update_reltn:x_return_status '||x_return_status, 1, 'N');

Line: 573

aso_debug_pub.add('update_pty:after update_reltn:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');

Line: 613

end Update_Party;

Line: 624

	SELECT status, account_activation_date, account_termination_date FROM HZ_CUST_ACCOUNTS
	WHERE cust_account_id = p_cust_account_id;

Line: 717

         SELECT source_code
         FROM ams_source_codes
         WHERE source_code_id = l_source_code_id;

Line: 722

         SELECT party_type, party_name
         FROM hz_parties
         WHERE party_id = l_party_id;

Line: 727

         SELECT aso_account_number_s.nextval
         FROM  dual;

Line: 731

        SELECT object_id from
        hz_relationships
        where party_id = l_party_id
        and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
        and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

Line: 795

	SELECT generate_customer_number INTO l_gen_cust_num
	FROM ar_system_parameters;

Line: 1013

           SELECT cust_acct_site_id
           FROM hz_cust_acct_sites
           WHERE cust_account_id = Account_Id
           AND party_site_id    = Site_Id;

Line: 1154

         SELECT site_use_id
         FROM hz_cust_site_uses
         WHERE cust_acct_site_id = acct_site_id
         AND site_use_code = Site_type
         AND status = 'A';

Line: 1161

         SELECT party_site_use_id
         FROM hz_party_site_uses
         WHERE party_site_id = l_party_site_id
         AND site_use_type = Site_type
         AND status = 'A';

Line: 1169

        Select hzl.city
        From hz_locations hzl,hz_party_sites hps
        Where hps.party_site_id = p_party_site_id
        And hzl.location_id = hps.location_id;

Line: 1280

         SELECT AUTO_SITE_NUMBERING INTO l_profile
         FROM AR_SYSTEM_PARAMETERS;

Line: 1414

      SELECT cust_account_role_id
      FROM hz_cust_account_roles
      WHERE party_id = l_party_id
      AND cust_account_id = l_cust_account_id
      AND role_type = l_role_type;

Line: 1421

      SELECT par.party_id
      FROM hz_relationships par,
           hz_org_contacts     org
      WHERE org.party_relationship_id = par.relationship_id
      AND org.org_contact_id  = l_org_contact_id
	and par.subject_type = 'PERSON'
	 and par.subject_table_name ='HZ_PARTIES';

Line: 1522

	-- The begin_date column has been deleted in record structure in version 2 api.
	--      p_cust_acct_roles_rec.begin_date       := p_begin_date;

Line: 1626

        SELECT OC.org_contact_id
        FROM hz_org_contacts oc, hz_parties p, hz_relationships pr
        WHERE p.party_id = l_party_id
        AND p.party_id = pr.subject_id
        AND pr.object_id = l_header_party_id
        AND (pr.relationship_type = 'CONTACT'
           OR pr.relationship_type = 'CONTACT_OF')
        AND oc.party_relationship_id = pr.relationship_id;

Line: 1676

           SELECT acct.party_id, par.party_type
           INTO l_header_party_id, l_party_type
           FROM aso_i_cust_accounts_v acct,
                aso_i_parties_v       par
           WHERE acct.cust_account_id = p_acct_id
           AND      acct.party_id = par.party_id;

Line: 1850

 SELECT responsibility_id
 FROM hz_role_responsibility
 WHERE cust_account_role_id = role_id
 AND responsibility_type = role_type;

Line: 2086

        SELECT source_code
        FROM ams_source_codes
        WHERE source_code_id = l_source_code_id;

Line: 2091

        SELECT party_type, party_name
        FROM hz_parties
        WHERE party_id = l_party_id;

Line: 2096

        SELECT aso_account_number_s.nextval
        FROM  dual;

Line: 2100

        SELECT object_id from
        hz_relationships
        where party_id = l_party_id
        and object_table_name = 'HZ_PARTIES'
	   and subject_type = 'PERSON'
	   and subject_table_name = 'HZ_PARTIES';

Line: 2164

	SELECT generate_customer_number INTO l_gen_cust_num
	FROM ar_system_parameters;