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_IMP_LOAD_ORG_CONTACT_PKG dependencies on HZ_RELATIONSHIPS

Line 287: p_db_object_name => 'HZ_RELATIONSHIPS',

283: FOR i IN 1..l_relationship_id.count LOOP
284: l_dss_security_errors(i) :=
285: hz_dss_util_pub.test_instance(
286: p_operation_code => 'UPDATE',
287: p_db_object_name => 'HZ_RELATIONSHIPS',
288: p_instance_pk1_value => l_relationship_id(i),
289: p_instance_pk2_value => 'F',
290: p_user_name => fnd_global.user_name,
291: x_return_status => dss_return_status,

Line 685: ''HZ_RELATIONSHIPS'',

681: :request_id,
682: hz_party_usg_assignments_s.nextval,
683: sub_id,
684: ''ORG_CONTACT'',
685: ''HZ_RELATIONSHIPS'',
686: hz_relationships_s.nextval,
687: start_date,
688: end_date,
689: ''A'',

Line 686: hz_relationships_s.nextval,

682: hz_party_usg_assignments_s.nextval,
683: sub_id,
684: ''ORG_CONTACT'',
685: ''HZ_RELATIONSHIPS'',
686: hz_relationships_s.nextval,
687: start_date,
688: end_date,
689: ''A'',
690: created_by_module,

Line 692: into hz_relationships (

688: end_date,
689: ''A'',
690: created_by_module,
691: 1)
692: into hz_relationships (
693: actual_content_source,
694: application_id,
695: content_source_type,
696: created_by,

Line 736: hz_relationships_s.nextval,

732: :program_application_id,
733: :program_id,
734: :l_sysdate,
735: :request_id,
736: hz_relationships_s.nextval,
737: sub_id,
738: sp_type,
739: ''HZ_PARTIES'',
740: obj_id,

Line 754: into hz_relationships (

750: relationship_type,
751: 1,
752: created_by_module,
753: direction_code)
754: into hz_relationships (
755: actual_content_source,
756: application_id,
757: content_source_type,
758: created_by,

Line 798: hz_relationships_s.nextval,

794: :program_application_id,
795: :program_id,
796: :l_sysdate,
797: :request_id,
798: hz_relationships_s.nextval,
799: obj_id,
800: op_type,
801: ''HZ_PARTIES'',
802: sub_id,

Line 875: hz_relationships_s.nextval,

871: :program_id,
872: :l_sysdate,
873: :request_id,
874: contact_id, --hz_org_contacts_s.nextval,
875: hz_relationships_s.nextval,
876: nvl(contact_number, hz_contact_numbers_s.nextval),
877: department_code,
878: department,
879: title,

Line 1210: from hz_relationships r1

1206: and createdby_l.view_application_id (+) = 222
1207: and createdby_l.security_group_id (+) =
1208: fnd_global.lookup_security_group(''HZ_CREATED_BY_MODULES'', 222)
1209: and tc.a = (select count(*) ---- check relationship duplicate, 0 indicates no error
1210: from hz_relationships r1
1211: where r1.subject_id = ocsg.sub_id
1212: and r1.subject_table_name = ''HZ_PARTIES''
1213: and r1.object_id = ocsg.obj_id
1214: and r1.relationship_type = ocint.relationship_type

Line 1543: (select r1.relationship_id from hz_relationships r1

1539: decode(sign(ci.END_DATE - ci.START_DATE), -1, null, ''Y''))
1540: ) start_end_date_error,
1541: decode(tc.a, 0, ''Y'') dup_rel_error
1542: /*
1543: (select r1.relationship_id from hz_relationships r1
1544: where r1.subject_id = r.subject_id
1545: and r1.object_id = r.object_id
1546: and r1.object_type = r.object_type
1547: and r1.subject_type = r.subject_type

Line 1560: HZ_RELATIONSHIPS r,

1556: ) identical_rel
1557: */
1558: FROM HZ_IMP_CONTACTS_INT ci,
1559: HZ_IMP_CONTACTS_SG cs,
1560: HZ_RELATIONSHIPS r,
1561: HZ_ORG_CONTACTS oc,
1562: AR_LOOKUPS dept_l,
1563: AR_LOOKUPS title_l,
1564: AR_LOOKUPS decision_l,

Line 1589: from hz_relationships r1

1585: AND ci.job_title_code = job_title_code_l.lookup_code(+)
1586: and reference_use_l.lookup_type(+)=''YES/NO''
1587: and ci.reference_use_flag = reference_use_l.lookup_code(+)
1588: and tc.a = (select count(*) ---- check relationship duplicate, 0 indicates no error
1589: from hz_relationships r1
1590: where r1.subject_id = cs.sub_id
1591: and r1.subject_table_name = ''HZ_PARTIES''
1592: and r1.object_id = cs.obj_id
1593: and r1.relationship_id <> oc.party_relationship_id

Line 1715: /* Update HZ_RELATIONSHIPS (Both directions) */

1711: validate_DSS_security;
1712: END IF;
1713:
1714: /*************************************************/
1715: /* Update HZ_RELATIONSHIPS (Both directions) */
1716: /*************************************************/
1717:
1718: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_party_relationships ');
1719:

Line 1722: update hz_relationships set

1718: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_party_relationships ');
1719:
1720: BEGIN
1721: ForAll j in 1..l_relationship_id.count SAVE EXCEPTIONS
1722: update hz_relationships set
1723: START_DATE = /* No need to check G_MISS here as it is caught by l_start_date_errors */
1724: nvl(l_start_date(j), start_date),
1725: END_DATE =
1726: DECODE(l_end_date(j),

Line 1767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_relationships');

1763: and actual_content_source = P_DML_RECORD.ACTUAL_CONTENT_SRC;
1764: */
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_relationships');
1768: l_dml_exception := 'Y';
1769:
1770: FOR k IN 1..l_relationship_id.count LOOP
1771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));

Line 1961: -- only update those rows which sucessfully updated in hz_relationships

1957: and l_title_errors(j) is not null
1958: and l_decision_maker_flag_errors(j) is not null
1959: and l_job_title_code_errors(j) is not null
1960: and l_reference_use_flag_errors(j) is not null
1961: -- only update those rows which sucessfully updated in hz_relationships
1962: and l_num_row_processed(j) = 1;
1963:
1964: EXCEPTION
1965: WHEN OTHERS THEN