Create Group using the TCA API - HZ_PARTY_V2PUB

Running The Create Group API

Name of the API: CREATE GROUP API

Base Tables Affected: HZ_PARTIES

PL/SQL Procedure used : CREATE_GROUP

Package Used: HZ_PARTY_V2PUB

Create Person using the TCA API - HZ_PARTY_V2PUB

Running the Create Person API

Name of the API: CREATE PERSON API

Base Tables Affected: HZ_PARTIES

HZ_PERSON_PROFILES

PL/SQL Procedure used: CREATE_PERSON

Package Used: HZ_PARTY_V2PUB

HZ_CUST_ACCOUNT_V2PUB

Create an Organization using the TCA API - HZ_PARTY_V2PUB

Running the Create Organization API

Name of the API: CREATE ORGANIZATION API

Base Tables Affected: HZ_PARTIES

HZ_ORGANIZATION_PROFILES

PL/SQL Procedure used: CREATE_ORGANIZATION

Package Used: HZ_PARTY_V2PUB

How to identify the package name and version of an API

To identify the package name of an API as compiled into the Oracle database, in SQL*Plus enter the following select statement (logged in as APPS)

SQL> SELECT text FROM all_source

WHERE name like '%user_api_name%'

  AND text like '%Header%';

(eg:HZ_CUSTOMER_ACCOUNT_PUB API)