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.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_PARTIES

Line 1689: -- Verify if the party_id is valid from HZ_parties,PO_vendors and employee tables

1685: p_party_source_tbl(p_party_count_rec.party_source_count).valid_flag := 'Y';
1686: END IF;
1687: END IF;
1688:
1689: -- Verify if the party_id is valid from HZ_parties,PO_vendors and employee tables
1690: -- based on the value of party_source_table
1691: -- Check the cache before hitting the database.
1692: l_exists_flag := 'N';
1693: l_valid_flag := 'Y';

Line 7488: IF upper(p_party_tbl) = 'HZ_PARTIES'

7484: RAISE fnd_api.g_exc_error;
7485: END IF;
7486:
7487:
7488: IF upper(p_party_tbl) = 'HZ_PARTIES'
7489: THEN
7490: BEGIN
7491:
7492: SELECT hp.party_name party_name,

Line 7555: HZ_PARTIES HP,

7551: x_contact_details.country,
7552: x_contact_details.email
7553:
7554: FROM
7555: HZ_PARTIES HP,
7556: CSI_I_PARTIES CIP,
7557: -- CSI_IPA_RELATION_TYPES CIR,
7558: HZ_CONTACT_POINTS HCP_WP,
7559: HZ_CONTACT_POINTS HCP_HP,

Line 7573: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'

7569: AND CIP.CONTACT_IP_ID = CIPO.INSTANCE_PARTY_ID
7570: AND CIPO.PARTY_ID = HR.OBJECT_ID
7571: AND HR.SUBJECT_ID = HP.PARTY_ID
7572: AND CIP.CONTACT_FLAG = 'Y'
7573: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
7574: -- AND CIP.RELATIONSHIP_TYPE_CODE = CIR.IPA_RELATION_TYPE_CODE(+)
7575: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7576: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7577: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 7576: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

7572: AND CIP.CONTACT_FLAG = 'Y'
7573: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
7574: -- AND CIP.RELATIONSHIP_TYPE_CODE = CIR.IPA_RELATION_TYPE_CODE(+)
7575: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7576: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7577: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7578:
7579: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7580: AND HCP_WP.OWNER_TABLE_ID(+) = HR.PARTY_ID

Line 7577: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

7573: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
7574: -- AND CIP.RELATIONSHIP_TYPE_CODE = CIR.IPA_RELATION_TYPE_CODE(+)
7575: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7576: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7577: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7578:
7579: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7580: AND HCP_WP.OWNER_TABLE_ID(+) = HR.PARTY_ID
7581: AND HCP_WP.CONTACT_POINT_TYPE(+) = 'PHONE'

Line 7579: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7575: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7576: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7577: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7578:
7579: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7580: AND HCP_WP.OWNER_TABLE_ID(+) = HR.PARTY_ID
7581: AND HCP_WP.CONTACT_POINT_TYPE(+) = 'PHONE'
7582: AND HCP_WP.PHONE_LINE_TYPE(+) = 'GEN'
7583: AND HCP_WP.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7585: AND HCP_HP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7581: AND HCP_WP.CONTACT_POINT_TYPE(+) = 'PHONE'
7582: AND HCP_WP.PHONE_LINE_TYPE(+) = 'GEN'
7583: AND HCP_WP.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7584:
7585: AND HCP_HP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7586: AND HCP_HP.OWNER_TABLE_ID(+) = HR.PARTY_ID
7587: AND HCP_HP.CONTACT_POINT_TYPE(+) = 'PHONE'
7588: AND HCP_HP.PHONE_LINE_TYPE(+) = 'GEN'
7589: AND HCP_HP.CONTACT_POINT_PURPOSE(+) = 'PERSONAL'

Line 7591: AND HCP_MB.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7587: AND HCP_HP.CONTACT_POINT_TYPE(+) = 'PHONE'
7588: AND HCP_HP.PHONE_LINE_TYPE(+) = 'GEN'
7589: AND HCP_HP.CONTACT_POINT_PURPOSE(+) = 'PERSONAL'
7590:
7591: AND HCP_MB.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7592: AND HCP_MB.OWNER_TABLE_ID(+) = HR.PARTY_ID
7593: AND HCP_MB.CONTACT_POINT_TYPE(+) = 'PHONE'
7594: AND HCP_MB.PHONE_LINE_TYPE(+) = 'MOBILE'
7595: AND HCP_MB.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7597: AND HCP_PG.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7593: AND HCP_MB.CONTACT_POINT_TYPE(+) = 'PHONE'
7594: AND HCP_MB.PHONE_LINE_TYPE(+) = 'MOBILE'
7595: AND HCP_MB.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7596:
7597: AND HCP_PG.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7598: AND HCP_PG.OWNER_TABLE_ID(+) = HR.PARTY_ID
7599: AND HCP_PG.CONTACT_POINT_TYPE(+) = 'PHONE'
7600: AND HCP_PG.PHONE_LINE_TYPE(+) = 'PAGER'
7601: AND HCP_PG.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7603: AND HCP_FX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7599: AND HCP_PG.CONTACT_POINT_TYPE(+) = 'PHONE'
7600: AND HCP_PG.PHONE_LINE_TYPE(+) = 'PAGER'
7601: AND HCP_PG.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7602:
7603: AND HCP_FX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7604: AND HCP_FX.OWNER_TABLE_ID(+) = HR.PARTY_ID
7605: AND HCP_FX.CONTACT_POINT_TYPE(+) = 'PHONE'
7606: AND HCP_FX.PHONE_LINE_TYPE(+) = 'FAX'
7607: AND HCP_FX.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7609: AND HCP_EM.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7605: AND HCP_FX.CONTACT_POINT_TYPE(+) = 'PHONE'
7606: AND HCP_FX.PHONE_LINE_TYPE(+) = 'FAX'
7607: AND HCP_FX.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7608:
7609: AND HCP_EM.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7610: AND HCP_EM.OWNER_TABLE_ID(+) = HR.PARTY_ID
7611: AND HCP_EM.CONTACT_POINT_TYPE(+) = 'EMAIL'
7612: AND HCP_EM.PRIMARY_FLAG(+) = 'Y'
7613: AND ROWNUM < 2;

Line 8172: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN

8168: EXCEPTION
8169: WHEN OTHERS THEN
8170: NULL;
8171: END;
8172: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN
8173: BEGIN
8174: SELECT party_number,
8175: 'PARTY'
8176: INTO x_party_history_tbl(i).old_contact_party_number,

Line 8178: FROM hz_parties

8174: SELECT party_number,
8175: 'PARTY'
8176: INTO x_party_history_tbl(i).old_contact_party_number,
8177: x_party_history_tbl(i).old_contact_party_type
8178: FROM hz_parties
8179: WHERE party_id = l_old_contact_party_id;
8180: EXCEPTION
8181: WHEN OTHERS THEN
8182: NULL;

Line 8253: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN

8249: EXCEPTION
8250: WHEN OTHERS THEN
8251: NULL;
8252: END;
8253: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN
8254: BEGIN
8255: SELECT party_number,
8256: 'PARTY',
8257: party_name

Line 8261: FROM hz_parties

8257: party_name
8258: INTO x_party_history_tbl(i).old_party_number,
8259: x_party_history_tbl(i).old_party_type,
8260: x_party_history_tbl(i).old_party_name
8261: FROM hz_parties
8262: WHERE party_id = x_party_history_tbl(i).old_party_id;
8263: EXCEPTION
8264: WHEN OTHERS THEN
8265: NULL;

Line 8364: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN

8360: EXCEPTION
8361: WHEN OTHERS THEN
8362: NULL;
8363: END;
8364: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN
8365: BEGIN
8366: SELECT party_number,
8367: 'PARTY'
8368: INTO x_party_history_tbl(i).new_contact_party_number,

Line 8370: FROM hz_parties

8366: SELECT party_number,
8367: 'PARTY'
8368: INTO x_party_history_tbl(i).new_contact_party_number,
8369: x_party_history_tbl(i).new_contact_party_type
8370: FROM hz_parties
8371: WHERE party_id = l_new_contact_party_id;
8372: EXCEPTION
8373: WHEN OTHERS THEN
8374: NULL;

Line 8446: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN

8442: EXCEPTION
8443: WHEN OTHERS THEN
8444: NULL;
8445: END;
8446: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN
8447: BEGIN
8448: SELECT party_number,
8449: 'PARTY',
8450: party_name

Line 8454: FROM hz_parties

8450: party_name
8451: INTO x_party_history_tbl(i).new_party_number,
8452: x_party_history_tbl(i).new_party_type,
8453: x_party_history_tbl(i).new_party_name
8454: FROM hz_parties
8455: WHERE party_id = x_party_history_tbl(i).new_party_id;
8456: EXCEPTION
8457: WHEN OTHERS THEN
8458: NULL;