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

Line 94: l_party_type HZ_PARTIES.party_type%TYPE;

90: l_cust_acct_cur GenCursorRef;
91: l_cust_acct_id NUMBER;
92: l_cust_acct_number VARCHAR2(50);
93: l_party_id NUMBER;
94: l_party_type HZ_PARTIES.party_type%TYPE;
95: l_procedure_name VARCHAR2(30) := '.ResolveCustomerAccessRequest';
96: l_debug_info VARCHAR2(200);
97: BEGIN
98:

Line 436: HZ_PARTIES Party

432: CustAcct.account_number,
433: CustAcct.party_id,
434: Party.party_type
435: FROM HZ_CUST_ACCOUNTS CustAcct,
436: HZ_PARTIES Party
437: WHERE CustAcct.cust_account_id = p_customer_id
438: AND CustAcct.party_id = Party.party_id;
439:
440: --------------------------------------------------------------------

Line 985: fnd_user fu, hz_parties Party

981: UNION ALL
982: select hr1.party_id
983:
984: from hz_relationships hr1,
985: fnd_user fu, hz_parties Party
986: where hr1.subject_type = 'PERSON'
987: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
988: AND hr1.status = 'A'
989: and hr1.object_id = l_party_id

Line 1080: l_first_name hz_parties.person_first_name%type;

1076: p_person_party_id out NOCOPY varchar2)
1077: ---------------------------------------------------------------------------
1078: IS
1079:
1080: l_first_name hz_parties.person_first_name%type;
1081: l_last_name hz_parties.person_last_name%type;
1082: l_middle_name hz_parties.person_middle_name%type;
1083: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1084: l_person_name_suffix hz_parties.person_name_suffix%type;

Line 1081: l_last_name hz_parties.person_last_name%type;

1077: ---------------------------------------------------------------------------
1078: IS
1079:
1080: l_first_name hz_parties.person_first_name%type;
1081: l_last_name hz_parties.person_last_name%type;
1082: l_middle_name hz_parties.person_middle_name%type;
1083: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1084: l_person_name_suffix hz_parties.person_name_suffix%type;
1085:

Line 1082: l_middle_name hz_parties.person_middle_name%type;

1078: IS
1079:
1080: l_first_name hz_parties.person_first_name%type;
1081: l_last_name hz_parties.person_last_name%type;
1082: l_middle_name hz_parties.person_middle_name%type;
1083: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1084: l_person_name_suffix hz_parties.person_name_suffix%type;
1085:
1086: l_party_number hz_parties.party_number%type;

Line 1083: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;

1079:
1080: l_first_name hz_parties.person_first_name%type;
1081: l_last_name hz_parties.person_last_name%type;
1082: l_middle_name hz_parties.person_middle_name%type;
1083: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1084: l_person_name_suffix hz_parties.person_name_suffix%type;
1085:
1086: l_party_number hz_parties.party_number%type;
1087: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

Line 1084: l_person_name_suffix hz_parties.person_name_suffix%type;

1080: l_first_name hz_parties.person_first_name%type;
1081: l_last_name hz_parties.person_last_name%type;
1082: l_middle_name hz_parties.person_middle_name%type;
1083: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1084: l_person_name_suffix hz_parties.person_name_suffix%type;
1085:
1086: l_party_number hz_parties.party_number%type;
1087: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1088: l_profile_id NUMBER;

Line 1086: l_party_number hz_parties.party_number%type;

1082: l_middle_name hz_parties.person_middle_name%type;
1083: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1084: l_person_name_suffix hz_parties.person_name_suffix%type;
1085:
1086: l_party_number hz_parties.party_number%type;
1087: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1088: l_profile_id NUMBER;
1089: l_reg_type VARCHAR2(50);
1090: l_reg_user_name fnd_user.user_name%type;

Line 1434: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1430: INTO l_already_exists,p_party_id
1431: FROM HZ_RELATIONSHIPS
1432: WHERE SUBJECT_ID = p_person_party_id
1433: AND SUBJECT_TYPE = 'PERSON'
1434: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1435: AND RELATIONSHIP_TYPE = 'CONTACT'
1436: AND RELATIONSHIP_CODE = 'CONTACT_OF'
1437: AND OBJECT_ID = l_org_party_id
1438: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date,SYSDATE))

Line 1464: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';

1460: END IF;
1461:
1462: l_party_rel_rec.subject_id := p_person_party_id;
1463: l_party_rel_rec.subject_type := 'PERSON';
1464: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
1465: l_party_rel_rec.relationship_type := 'CONTACT';
1466: l_party_rel_rec.relationship_code := 'CONTACT_OF';
1467: l_party_rel_rec.start_date := sysdate;
1468: l_party_rel_rec.object_id := l_org_party_id;

Line 1474: l_party_rel_rec.object_table_name := 'HZ_PARTIES';

1470: l_party_rel_rec.object_type := 'ORGANIZATION';
1471: ELSIF l_cust_acct_type = G_CONSUMER THEN
1472: l_party_rel_rec.object_type := 'PERSON';
1473: END IF;
1474: l_party_rel_rec.object_table_name := 'HZ_PARTIES';
1475: l_party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
1476: l_party_rel_rec.application_id := 0;
1477: l_org_contact_rec.party_rel_rec := l_party_rel_rec;
1478: l_org_contact_rec.created_by_module := G_CREATED_BY_MODULE;

Line 1601: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

1597: arp_standard.debug(l_debug_info);
1598: END IF;
1599: --populate the record
1600: l_contact_point_rec.status := 'A';
1601: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1602: l_contact_point_rec.owner_table_id := p_contact_party_id;
1603: l_contact_point_rec.primary_flag := 'Y';
1604: l_contact_point_rec.created_by_module := 'ARI';
1605: l_contact_point_rec.application_id := 0;

Line 1633: AND owner_table_name = 'HZ_PARTIES'

1629: SELECT contact_point_id
1630: INTO l_contact_point_id
1631: FROM hz_contact_points
1632: WHERE owner_table_id = p_contact_party_id
1633: AND owner_table_name = 'HZ_PARTIES'
1634: AND status = 'A'
1635: AND primary_flag = 'Y'
1636: AND contact_point_type = 'EMAIL';
1637:

Line 1741: AND owner_table_name = 'HZ_PARTIES'

1737: SELECT contact_point_id
1738: INTO l_contact_point_id
1739: FROM hz_contact_points
1740: WHERE owner_table_id = p_contact_party_id
1741: AND owner_table_name = 'HZ_PARTIES'
1742: AND status = 'A'
1743: AND primary_flag = 'Y'
1744: AND contact_point_type = 'PHONE';
1745: EXCEPTION

Line 2306: l_contact_preference_rec.contact_level_table := 'HZ_PARTIES';

2302: ELSE
2303: l_contact_preference_rec.preference_code := 'DO_NOT';
2304: END IF;
2305:
2306: l_contact_preference_rec.contact_level_table := 'HZ_PARTIES';
2307: l_contact_preference_rec.contact_level_table_id := p_person_party_id;
2308: l_contact_preference_rec.contact_type := 'EMAIL';
2309: l_contact_preference_rec.requested_by := 'INTERNAL';
2310: l_contact_preference_rec.created_by_module := 'ARI';

Line 2559: l_first_name hz_parties.person_first_name%type;

2555: RETURN VARCHAR2
2556: ---------------------------------------------------------------------------
2557: IS
2558:
2559: l_first_name hz_parties.person_first_name%type;
2560: l_last_name hz_parties.person_last_name%type;
2561: l_middle_name hz_parties.person_middle_name%type;
2562: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2563: l_person_name_suffix hz_parties.person_name_suffix%type;

Line 2560: l_last_name hz_parties.person_last_name%type;

2556: ---------------------------------------------------------------------------
2557: IS
2558:
2559: l_first_name hz_parties.person_first_name%type;
2560: l_last_name hz_parties.person_last_name%type;
2561: l_middle_name hz_parties.person_middle_name%type;
2562: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2563: l_person_name_suffix hz_parties.person_name_suffix%type;
2564:

Line 2561: l_middle_name hz_parties.person_middle_name%type;

2557: IS
2558:
2559: l_first_name hz_parties.person_first_name%type;
2560: l_last_name hz_parties.person_last_name%type;
2561: l_middle_name hz_parties.person_middle_name%type;
2562: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2563: l_person_name_suffix hz_parties.person_name_suffix%type;
2564:
2565: l_party_number hz_parties.party_number%type;

Line 2562: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;

2558:
2559: l_first_name hz_parties.person_first_name%type;
2560: l_last_name hz_parties.person_last_name%type;
2561: l_middle_name hz_parties.person_middle_name%type;
2562: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2563: l_person_name_suffix hz_parties.person_name_suffix%type;
2564:
2565: l_party_number hz_parties.party_number%type;
2566: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

Line 2563: l_person_name_suffix hz_parties.person_name_suffix%type;

2559: l_first_name hz_parties.person_first_name%type;
2560: l_last_name hz_parties.person_last_name%type;
2561: l_middle_name hz_parties.person_middle_name%type;
2562: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2563: l_person_name_suffix hz_parties.person_name_suffix%type;
2564:
2565: l_party_number hz_parties.party_number%type;
2566: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
2567: l_profile_id NUMBER;

Line 2565: l_party_number hz_parties.party_number%type;

2561: l_middle_name hz_parties.person_middle_name%type;
2562: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2563: l_person_name_suffix hz_parties.person_name_suffix%type;
2564:
2565: l_party_number hz_parties.party_number%type;
2566: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
2567: l_profile_id NUMBER;
2568: l_success VARCHAR2(10);
2569: p_person_party_id varchar2(30);

Line 3693: HZ_PARTIES Party

3689: Party.party_type,
3690: CustTrxn.org_id
3691: FROM HZ_CUST_ACCOUNTS CustAcct,
3692: RA_CUSTOMER_TRX_ALL CustTrxn,
3693: HZ_PARTIES Party
3694: WHERE CustTrxn.trx_number = p_access_domain_search_number
3695: AND CustTrxn.bill_to_customer_id = CustAcct.cust_account_id
3696: AND CustAcct.party_id = Party.party_id;
3697: