eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_COMMON_PUB SQL Statements

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

Line: 16


 | FUNCTION getNotSelectedDataSource(
 |    p_data_source                 IN     VARCHAR2
 | ) RETURN VARCHAR2;

Line: 108


        SELECT 1
        INTO l_installed
        FROM sys.all_source
        WHERE name = 'HZ_PARTY_V2PUB'
        AND type = 'PACKAGE BODY'
        AND owner = l_user_schema
        AND rownum=1;

Line: 151


 |                       with 'select 'Y'..and rownum=1
 |    Jianying Huang 12-FEB-01  Bug 1639630: Check 'YES/NO' lookup code by comparision
 |                      instead of query.
 |
 +===========================================================================*/

procedure validate_lookup(
        p_lookup_type           IN      VARCHAR2,
        p_column                IN      VARCHAR2,
        p_column_value          IN      VARCHAR2,
        x_return_status         IN OUT NOCOPY  VARCHAR2
) IS

    CURSOR c_exist IS
       SELECT 'Y'
       FROM   ar_lookups
       WHERE  lookup_type = p_lookup_type
       AND    lookup_code = p_column_value
       AND    ROWNUM = 1;

Line: 214


 SELECT 'Y'
   FROM fnd_lookup_values
  WHERE lookup_type = p_lookup_type
    AND lookup_code = p_column_value
    AND ROWNUM      = 1;

Line: 268


               SELECT to_char(hz_account_num_s.nextval)
               INTO l_account_number FROM dual;

Line: 270


                SELECT COUNT(*) INTO l_count
                        FROM hz_cust_accounts
                        WHERE account_number = l_account_number;

Line: 310


               SELECT to_char(hz_party_site_number_s.nextval)
               INTO l_party_site_number FROM dual;

Line: 312


                SELECT COUNT(*) INTO l_count
                        FROM hz_party_sites
                        WHERE party_site_number = l_party_site_number;

Line: 341


	-- Concept of select/de-select data sources is done away with for non-profile entities.
  /*ELSE
      IF p_object_name NOT IN ('HZ_CODE_ASSIGNMENTS', 'HZ_ORGANIZATION_INDICATORS') THEN

        -- Bug 2444678: Removed caching.

        -- IF p_object_name <> NVL(G_ENTITY_NAME, 'null') THEN
        l_data_sources := HZ_MIXNM_UTILITY.getSelectedDataSources(p_object_name, l_entity_attr_id);

Line: 349


        l_not_data_source := getNotSelectedDataSource (l_data_sources);

Line: 397


select
c.ADDRESS1 || DECODE(c.ADDRESS1, NULL, NULL, ' ') || c.ADDRESS2
 || DECODE(c.ADDRESS2, NULL, NULL, ' ') || c.ADDRESS3 ||
 DECODE(c.ADDRESS3, NULL, NULL, ' ') || c.ADDRESS4 ||
 DECODE(c.ADDRESS1, NULL, NULL, ', ') || c.CITY || DECODE(c.CITY,
 NULL, NULL, ', ') || c.STATE || DECODE(c.STATE, NULL, NULL, ' ') ||
 c.POSTAL_CODE || DECODE(d.TERRITORY_SHORT_NAME, NULL, NULL, ', ')
 || d.TERRITORY_SHORT_NAME
from hz_cust_acct_sites_all a, hz_party_sites b, hz_locations c,fnd_territories_vl d
where a.party_site_id =b.party_site_id
and  b.location_id = c.location_id
and d.territory_code = c.country
and a.cust_acct_site_id = v_address_id;

Line: 426


select  b.party_name
from   hz_cust_accounts a, hz_parties b
where a.cust_account_id = v_cust_id
and   a.party_id = b.party_id;

Line: 446


select  b.person_first_name||' '||b.person_last_name
from   hz_cust_account_roles a,
       hz_parties b,
       hz_relationships c
where a.cust_account_role_id = v_contact_id
and   c.party_id =a.party_id
and   c.subject_id = b.party_id
and   c.subject_table_name = 'HZ_PARTIES'
and   c.object_table_name = 'HZ_PARTIES'
and   c.directional_flag = 'F';

Line: 472


select  b.party_name
from  hz_parties b
where b.party_id = v_party_id;

Line: 494


(       create_update_flag              IN  VARCHAR2,
        p_col_name                              IN  VARCHAR2,
        p_col_val                               IN  VARCHAR2,
        p_miss_allowed_in_c             IN  BOOLEAN,
        p_miss_allowed_in_u             IN  BOOLEAN,
        x_return_status                 IN OUT NOCOPY VARCHAR2)
IS
BEGIN
        IF (p_col_val IS NULL) THEN
                fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line: 510


        IF (create_update_flag = 'C') THEN
                IF ((NOT p_miss_allowed_in_c) AND
                        p_col_val = fnd_api.G_MISS_CHAR )
                THEN
                        fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line: 539


(       create_update_flag              IN  VARCHAR2,
        p_col_name                              IN      VARCHAR2,
        p_col_val                               IN  DATE,
        p_miss_allowed_in_c             IN  BOOLEAN,
        p_miss_allowed_in_u             IN  BOOLEAN,
        x_return_status                 IN OUT NOCOPY VARCHAR2)
IS
BEGIN
        IF (p_col_val IS NULL) THEN
                fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line: 555


        IF (create_update_flag = 'C') THEN
                IF ((NOT p_miss_allowed_in_c) AND
                        p_col_val = fnd_api.G_MISS_DATE )
                THEN
                        fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line: 584


(       create_update_flag              IN  VARCHAR2,
        p_col_name                              IN  VARCHAR2,
        p_col_val                               IN  NUMBER,
        p_miss_allowed_in_c             IN  BOOLEAN,
        p_miss_allowed_in_u             IN  BOOLEAN,
        x_return_status                 IN OUT NOCOPY VARCHAR2)
IS
BEGIN
        IF (p_col_val IS NULL) THEN
                fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line: 600


        IF (create_update_flag = 'C') THEN
                IF ((NOT p_miss_allowed_in_c) AND
                        p_col_val = fnd_api.G_MISS_NUM )
                THEN
                        fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line: 857


 * Predicates will not be attached to non-profile tables.(Concept of select / de-select data sources
 * for these entities is done away with)

-- bug fix 2969850
FUNCTION getNotSelectedDataSource(
    p_data_source                 IN     VARCHAR2
) RETURN VARCHAR2 IS

    CURSOR c_content_source_type IS
      SELECT lookup_code FROM ar_lookups
      WHERE lookup_type = 'CONTENT_SOURCE_TYPE' and
            ENABLED_FLAG = 'Y' AND
	    TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE));

Line: 899


END getNotSelectedDataSource;