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 92: l_party_type HZ_PARTIES.party_type%TYPE;

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

Line 433: HZ_PARTIES Party

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

Line 951: fnd_user fu, hz_parties Party

947: UNION ALL
948: select hr1.party_id
949:
950: from hz_relationships hr1,
951: fnd_user fu, hz_parties Party
952: where hr1.subject_type = 'PERSON'
953: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
954: AND hr1.status = 'A'
955: and hr1.object_id = l_party_id

Line 1046: l_first_name hz_parties.person_first_name%type;

1042: p_person_party_id out NOCOPY varchar2)
1043: ---------------------------------------------------------------------------
1044: IS
1045:
1046: l_first_name hz_parties.person_first_name%type;
1047: l_last_name hz_parties.person_last_name%type;
1048: l_middle_name hz_parties.person_middle_name%type;
1049: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1050: l_person_name_suffix hz_parties.person_name_suffix%type;

Line 1047: l_last_name hz_parties.person_last_name%type;

1043: ---------------------------------------------------------------------------
1044: IS
1045:
1046: l_first_name hz_parties.person_first_name%type;
1047: l_last_name hz_parties.person_last_name%type;
1048: l_middle_name hz_parties.person_middle_name%type;
1049: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1050: l_person_name_suffix hz_parties.person_name_suffix%type;
1051:

Line 1048: l_middle_name hz_parties.person_middle_name%type;

1044: IS
1045:
1046: l_first_name hz_parties.person_first_name%type;
1047: l_last_name hz_parties.person_last_name%type;
1048: l_middle_name hz_parties.person_middle_name%type;
1049: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1050: l_person_name_suffix hz_parties.person_name_suffix%type;
1051:
1052: l_party_number hz_parties.party_number%type;

Line 1049: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;

1045:
1046: l_first_name hz_parties.person_first_name%type;
1047: l_last_name hz_parties.person_last_name%type;
1048: l_middle_name hz_parties.person_middle_name%type;
1049: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1050: l_person_name_suffix hz_parties.person_name_suffix%type;
1051:
1052: l_party_number hz_parties.party_number%type;
1053: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

Line 1050: l_person_name_suffix hz_parties.person_name_suffix%type;

1046: l_first_name hz_parties.person_first_name%type;
1047: l_last_name hz_parties.person_last_name%type;
1048: l_middle_name hz_parties.person_middle_name%type;
1049: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1050: l_person_name_suffix hz_parties.person_name_suffix%type;
1051:
1052: l_party_number hz_parties.party_number%type;
1053: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1054: l_profile_id NUMBER;

Line 1052: l_party_number hz_parties.party_number%type;

1048: l_middle_name hz_parties.person_middle_name%type;
1049: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
1050: l_person_name_suffix hz_parties.person_name_suffix%type;
1051:
1052: l_party_number hz_parties.party_number%type;
1053: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1054: l_profile_id NUMBER;
1055: l_reg_type VARCHAR2(50);
1056: l_reg_user_name fnd_user.user_name%type;

Line 1340: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1336: INTO l_already_exists,p_party_id
1337: FROM HZ_RELATIONSHIPS
1338: WHERE SUBJECT_ID = p_person_party_id
1339: AND SUBJECT_TYPE = 'PERSON'
1340: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1341: AND RELATIONSHIP_TYPE = 'CONTACT'
1342: AND RELATIONSHIP_CODE = 'CONTACT_OF'
1343: AND OBJECT_ID = l_org_party_id
1344: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date,SYSDATE))

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

1361: END IF;
1362:
1363: l_party_rel_rec.subject_id := p_person_party_id;
1364: l_party_rel_rec.subject_type := 'PERSON';
1365: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
1366: l_party_rel_rec.relationship_type := 'CONTACT';
1367: l_party_rel_rec.relationship_code := 'CONTACT_OF';
1368: l_party_rel_rec.start_date := sysdate;
1369: l_party_rel_rec.object_id := l_org_party_id;

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

1371: l_party_rel_rec.object_type := 'ORGANIZATION';
1372: ELSIF l_cust_acct_type = G_CONSUMER THEN
1373: l_party_rel_rec.object_type := 'PERSON';
1374: END IF;
1375: l_party_rel_rec.object_table_name := 'HZ_PARTIES';
1376: l_party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
1377: l_party_rel_rec.application_id := 0;
1378: l_org_contact_rec.party_rel_rec := l_party_rel_rec;
1379: l_org_contact_rec.created_by_module := G_CREATED_BY_MODULE;

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

1483: l_phone_extension := p_event.getvalueforparameter('PHONE_EXTENSION');
1484:
1485: --populate the record
1486: l_contact_point_rec.status := 'A';
1487: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1488: l_contact_point_rec.owner_table_id := p_contact_party_id;
1489: l_contact_point_rec.primary_flag := 'Y';
1490: l_contact_point_rec.created_by_module := 'ARI';
1491: l_contact_point_rec.application_id := 0;

Line 1519: AND owner_table_name = 'HZ_PARTIES'

1515: SELECT contact_point_id
1516: INTO l_contact_point_id
1517: FROM hz_contact_points
1518: WHERE owner_table_id = p_contact_party_id
1519: AND owner_table_name = 'HZ_PARTIES'
1520: AND status = 'A'
1521: AND primary_flag = 'Y'
1522: AND contact_point_type = 'EMAIL';
1523: EXCEPTION

Line 1616: AND owner_table_name = 'HZ_PARTIES'

1612: SELECT contact_point_id
1613: INTO l_contact_point_id
1614: FROM hz_contact_points
1615: WHERE owner_table_id = p_contact_party_id
1616: AND owner_table_name = 'HZ_PARTIES'
1617: AND status = 'A'
1618: AND primary_flag = 'Y'
1619: AND contact_point_type = 'PHONE';
1620: EXCEPTION

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

2113: ELSE
2114: l_contact_preference_rec.preference_code := 'DO_NOT';
2115: END IF;
2116:
2117: l_contact_preference_rec.contact_level_table := 'HZ_PARTIES';
2118: l_contact_preference_rec.contact_level_table_id := p_person_party_id;
2119: l_contact_preference_rec.contact_type := 'EMAIL';
2120: l_contact_preference_rec.requested_by := 'INTERNAL';
2121: l_contact_preference_rec.created_by_module := 'ARI';

Line 2296: l_first_name hz_parties.person_first_name%type;

2292: RETURN VARCHAR2
2293: ---------------------------------------------------------------------------
2294: IS
2295:
2296: l_first_name hz_parties.person_first_name%type;
2297: l_last_name hz_parties.person_last_name%type;
2298: l_middle_name hz_parties.person_middle_name%type;
2299: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2300: l_person_name_suffix hz_parties.person_name_suffix%type;

Line 2297: l_last_name hz_parties.person_last_name%type;

2293: ---------------------------------------------------------------------------
2294: IS
2295:
2296: l_first_name hz_parties.person_first_name%type;
2297: l_last_name hz_parties.person_last_name%type;
2298: l_middle_name hz_parties.person_middle_name%type;
2299: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2300: l_person_name_suffix hz_parties.person_name_suffix%type;
2301:

Line 2298: l_middle_name hz_parties.person_middle_name%type;

2294: IS
2295:
2296: l_first_name hz_parties.person_first_name%type;
2297: l_last_name hz_parties.person_last_name%type;
2298: l_middle_name hz_parties.person_middle_name%type;
2299: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2300: l_person_name_suffix hz_parties.person_name_suffix%type;
2301:
2302: l_party_number hz_parties.party_number%type;

Line 2299: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;

2295:
2296: l_first_name hz_parties.person_first_name%type;
2297: l_last_name hz_parties.person_last_name%type;
2298: l_middle_name hz_parties.person_middle_name%type;
2299: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2300: l_person_name_suffix hz_parties.person_name_suffix%type;
2301:
2302: l_party_number hz_parties.party_number%type;
2303: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

Line 2300: l_person_name_suffix hz_parties.person_name_suffix%type;

2296: l_first_name hz_parties.person_first_name%type;
2297: l_last_name hz_parties.person_last_name%type;
2298: l_middle_name hz_parties.person_middle_name%type;
2299: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2300: l_person_name_suffix hz_parties.person_name_suffix%type;
2301:
2302: l_party_number hz_parties.party_number%type;
2303: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
2304: l_profile_id NUMBER;

Line 2302: l_party_number hz_parties.party_number%type;

2298: l_middle_name hz_parties.person_middle_name%type;
2299: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%type;
2300: l_person_name_suffix hz_parties.person_name_suffix%type;
2301:
2302: l_party_number hz_parties.party_number%type;
2303: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
2304: l_profile_id NUMBER;
2305: l_success VARCHAR2(10);
2306: p_person_party_id varchar2(30);