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

Line 128: FROM HZ_PARTIES

124: SELECT ROWID,
125: OBJECT_VERSION_NUMBER,
126: LAST_UPDATE_DATE,
127: NULL
128: FROM HZ_PARTIES
129: WHERE PARTY_ID = p_col_id;
130:
131: CURSOR cu_org_contact_version IS
132: SELECT ROWID,

Line 165: IF p_table_name = 'HZ_PARTIES' THEN

161: FROM HZ_CUST_ACCOUNT_ROLES
162: WHERE CUST_ACCOUNT_ROLE_ID = p_col_id;
163: l_last_update_date DATE;
164: BEGIN
165: IF p_table_name = 'HZ_PARTIES' THEN
166: OPEN cu_party_version;
167: FETCH cu_party_version INTO
168: x_rowid ,
169: x_object_version_number,

Line 281: hz_parties party,

277: into dummy
278: from dual
279: where not exists ( select 1
280: from hz_cust_account_roles acct_role,
281: hz_parties party,
282: hz_relationships rel
283: where acct_role.party_id = rel.party_id
284: and acct_role.role_type = 'CONTACT'
285: and rel.subject_id = party.party_id

Line 289: and rel.subject_table_name = 'HZ_PARTIES'

285: and rel.subject_id = party.party_id
286: and party.person_last_name = x_last_name
287: and party.person_first_name = x_first_name
288: and acct_role.cust_account_id = x_customer_id
289: and rel.subject_table_name = 'HZ_PARTIES'
290: and rel.object_table_name = 'HZ_PARTIES'
291: and rel.directional_flag = 'F'
292: );
293: EXCEPTION

Line 290: and rel.object_table_name = 'HZ_PARTIES'

286: and party.person_last_name = x_last_name
287: and party.person_first_name = x_first_name
288: and acct_role.cust_account_id = x_customer_id
289: and rel.subject_table_name = 'HZ_PARTIES'
290: and rel.object_table_name = 'HZ_PARTIES'
291: and rel.directional_flag = 'F'
292: );
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN

Line 581: FROM hz_parties

577:
578: CURSOR cu_party_type(i_party_id IN NUMBER)
579: IS
580: SELECT party_type
581: FROM hz_parties
582: WHERE party_id = i_party_id;
583:
584: l_subject_type VARCHAR2(30);
585: l_object_type VARCHAR2(30);

Line 626: select hz_parties_s.nextval into i_subject_party_id from dual;

622: --- If Subject Party does not exist,added this following if clause.
623: --
624: IF X_Sub_Party_Id IS NULL THEN
625: select hz_party_number_s.nextval into i_subject_party_number from dual;
626: select hz_parties_s.nextval into i_subject_party_id from dual;
627: ELSE
628: i_subject_party_id := X_Sub_Party_Id;
629: END IF;
630:

Line 705: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

701:
702: SELECT hz_party_number_s.nextval INTO ii_party_number FROM DUAL;
703:
704: ocon_rec.party_rel_rec.subject_id := i_subject_party_id;
705: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
706: -- ocon_rec.party_rel_rec.subject_type := 'PERSON';
707: ocon_rec.party_rel_rec.subject_type := l_subject_type;
708: ocon_rec.party_rel_rec.object_id := x_party_id;
709: ocon_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

Line 709: ocon_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

705: ocon_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
706: -- ocon_rec.party_rel_rec.subject_type := 'PERSON';
707: ocon_rec.party_rel_rec.subject_type := l_subject_type;
708: ocon_rec.party_rel_rec.object_id := x_party_id;
709: ocon_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
710: ocon_rec.party_rel_rec.object_type := l_object_type;
711: ocon_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
712: ocon_rec.party_rel_rec.relationship_type := 'CONTACT';
713: -- ocon_rec.party_rel_rec.directional_flag := 'Y';

Line 855: cpoint_rec.owner_table_name := 'HZ_PARTIES';

851: --
852: cpoint_rec.contact_point_id := i_contact_point_Id;
853: cpoint_rec.contact_point_type := 'EMAIL';
854: cpoint_rec.status := 'A';
855: cpoint_rec.owner_table_name := 'HZ_PARTIES';
856: cpoint_rec.owner_table_id := i_party_id;
857:
858: -- the next 1 line is added to make sure the email_address is
859: -- denormalised into hz_parties. bug - 1276469.

Line 859: -- denormalised into hz_parties. bug - 1276469.

855: cpoint_rec.owner_table_name := 'HZ_PARTIES';
856: cpoint_rec.owner_table_id := i_party_id;
857:
858: -- the next 1 line is added to make sure the email_address is
859: -- denormalised into hz_parties. bug - 1276469.
860: cpoint_rec.primary_flag := 'Y';
861: cpoint_rec.created_by_module := 'TCA_FORM_WRAPPER';
862: email_rec.email_address := X_Email_Address;
863:

Line 872: AND p.subject_table_name = 'HZ_PARTIES'

868: FROM hz_relationships p,
869: hz_org_contacts o
870: WHERE o.org_contact_id = x_org_contact_id
871: AND o.party_relationship_id = p.relationship_id
872: AND p.subject_table_name = 'HZ_PARTIES'
873: AND p.object_table_name = 'HZ_PARTIES'
874: AND p.directional_flag = 'F';
875:
876: END IF;

Line 873: AND p.object_table_name = 'HZ_PARTIES'

869: hz_org_contacts o
870: WHERE o.org_contact_id = x_org_contact_id
871: AND o.party_relationship_id = p.relationship_id
872: AND p.subject_table_name = 'HZ_PARTIES'
873: AND p.object_table_name = 'HZ_PARTIES'
874: AND p.directional_flag = 'F';
875:
876: END IF;
877:

Line 1350: p_table_name => 'HZ_PARTIES',

1346:
1347: l_person_object_version := x_person_object_version;
1348: IF l_person_object_version = -1 THEN
1349: object_version_select(
1350: p_table_name => 'HZ_PARTIES',
1351: p_col_id => x_contact_party_id,
1352: x_rowid => l_person_rowid,
1353: x_object_version_number => l_person_object_version,
1354: x_last_update_date => l_person_last_update_date,

Line 1400: FROM hz_parties

1396: SELECT last_update_date,
1397: object_version_number
1398: INTO x_party_Last_Update_Date,
1399: x_person_object_version
1400: FROM hz_parties
1401: WHERE party_id = x_contact_party_id;
1402:
1403: l_org_contact_object_version := x_org_contact_object_version;
1404: IF l_org_contact_object_version = -1 THEN

Line 1460: p_table_name => 'HZ_PARTIES',

1456:
1457: l_party_object_version := x_party_object_version;
1458: IF l_party_object_version = -1 THEN
1459: object_version_select(
1460: p_table_name => 'HZ_PARTIES',
1461: p_col_id => l_party_id,
1462: x_rowid => l_party_rowid,
1463: x_object_version_number => l_party_object_version,
1464: x_last_update_date => l_party_last_update_date,

Line 1566: AND subject_table_name = 'HZ_PARTIES'

1562: into X_prel_Last_Update_Date,
1563: x_rel_object_version
1564: from hz_relationships
1565: where relationship_id = x_party_relationship_id
1566: AND subject_table_name = 'HZ_PARTIES'
1567: AND object_table_name = 'HZ_PARTIES'
1568: AND directional_flag = 'F';
1569:
1570: select party_id

Line 1567: AND object_table_name = 'HZ_PARTIES'

1563: x_rel_object_version
1564: from hz_relationships
1565: where relationship_id = x_party_relationship_id
1566: AND subject_table_name = 'HZ_PARTIES'
1567: AND object_table_name = 'HZ_PARTIES'
1568: AND directional_flag = 'F';
1569:
1570: select party_id
1571: into i_rel_party_id

Line 1574: AND subject_table_name = 'HZ_PARTIES'

1570: select party_id
1571: into i_rel_party_id
1572: from hz_relationships
1573: where relationship_id = x_party_relationship_id
1574: AND subject_table_name = 'HZ_PARTIES'
1575: AND object_table_name = 'HZ_PARTIES'
1576: AND directional_flag = 'F';
1577:
1578: select last_update_date ,

Line 1575: AND object_table_name = 'HZ_PARTIES'

1571: into i_rel_party_id
1572: from hz_relationships
1573: where relationship_id = x_party_relationship_id
1574: AND subject_table_name = 'HZ_PARTIES'
1575: AND object_table_name = 'HZ_PARTIES'
1576: AND directional_flag = 'F';
1577:
1578: select last_update_date ,
1579: object_version_number

Line 1582: from hz_parties

1578: select last_update_date ,
1579: object_version_number
1580: into X_rel_party_Last_Update_Date ,
1581: x_party_object_version
1582: from hz_parties
1583: where party_id = i_rel_party_id;
1584:
1585:
1586: /**** the following is added for bug 1276469 ***/

Line 1593: cpoint_rec.owner_table_name := 'HZ_PARTIES';

1589: cpoint_rec.status := 'A';
1590: /********** Bug Fix Begin#1: 3403289 ***********************/
1591: --bug 4930521 Remove the comments
1592:
1593: cpoint_rec.owner_table_name := 'HZ_PARTIES';
1594: cpoint_rec.owner_table_id := x_rel_party_id;
1595:
1596: /********** Bug Fix End#1: 3403289 ***********************/
1597: -- the next 1 line is added to make sure the email_address is

Line 1598: -- denormalised into hz_parties. bug - 1276469.

1594: cpoint_rec.owner_table_id := x_rel_party_id;
1595:
1596: /********** Bug Fix End#1: 3403289 ***********************/
1597: -- the next 1 line is added to make sure the email_address is
1598: -- denormalised into hz_parties. bug - 1276469.
1599: l_date := X_Cont_Point_Last_Update_Date;
1600:
1601: IF x_contact_point_Id is not null then
1602: if X_Email_Address is not null then

Line 1605: -- in hz_parties through denormalization

1601: IF x_contact_point_Id is not null then
1602: if X_Email_Address is not null then
1603: -- if new email address is passed, update contact_points
1604: -- record and set primary to 'Y' so that it is reflected
1605: -- in hz_parties through denormalization
1606: cpoint_rec.primary_flag := 'Y';
1607: email_rec.email_address := X_Email_Address;
1608: else
1609: -- if email address is set to null from some value

Line 1611: -- this will set email in hz_parties to null by

1607: email_rec.email_address := X_Email_Address;
1608: else
1609: -- if email address is set to null from some value
1610: -- then make the contact_points record non-primary.
1611: -- this will set email in hz_parties to null by
1612: -- denormalization process.
1613: select email_address into email_rec.email_address
1614: from hz_contact_points
1615: where contact_point_id = x_contact_point_id;