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

Line 182: FROM hz_parties hp, fnd_user fu

178: WHERE fu.employee_id = ppf.person_id
179: AND fu.user_id = p_user_id;
180: CURSOR l_tca_cur IS
181: SELECT hp.person_first_name, hp.person_last_name
182: FROM hz_parties hp, fnd_user fu
183: WHERE fu.person_party_id = hp.party_id
184: AND fu.user_id = p_user_id;
185: CURSOR l_fnd_cur IS
186: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;

Line 278: l_first_name hz_parties.person_first_name%TYPE;

274: itemkey IN VARCHAR2
275: )
276: IS
277: l_company_name ap_suppliers.vendor_name%TYPE;
278: l_first_name hz_parties.person_first_name%TYPE;
279: l_last_name hz_parties.person_last_name%TYPE;
280: BEGIN
281: get_current_user_name(l_first_name, l_last_name);
282: get_current_user_company_name(l_company_name);

Line 279: l_last_name hz_parties.person_last_name%TYPE;

275: )
276: IS
277: l_company_name ap_suppliers.vendor_name%TYPE;
278: l_first_name hz_parties.person_first_name%TYPE;
279: l_last_name hz_parties.person_last_name%TYPE;
280: BEGIN
281: get_current_user_name(l_first_name, l_last_name);
282: get_current_user_company_name(l_company_name);
283:

Line 692: FROM hz_parties hp

688: IS
689: CURSOR l_cur IS
690: SELECT Decode(pcr.contact_party_id, NULL, pcr.first_name || ' ' || pcr.last_name,
691: (SELECT hp.party_name
692: FROM hz_parties hp
693: WHERE hp.party_id = pcr.contact_party_id
694: )) contact_name
695: FROM pos_contact_requests pcr
696: WHERE pcr.contact_request_id = p_contact_request_id;

Line 725: l_contact_name hz_parties.party_name%TYPE;

721: x_receiver OUT nocopy VARCHAR2
722: )
723: IS
724: l_supplier_name ap_suppliers.vendor_name%TYPE;
725: l_contact_name hz_parties.party_name%TYPE;
726: l_itemtype wf_items.item_type%TYPE;
727: l_itemkey wf_items.item_key%TYPE;
728: l_receiver wf_roles.name%TYPE;
729: l_cur g_refcur;

Line 874: l_contact_name hz_parties.party_name%TYPE;

870: x_receiver OUT nocopy VARCHAR2
871: )
872: IS
873: l_supplier_name ap_suppliers.vendor_name%TYPE;
874: l_contact_name hz_parties.party_name%TYPE;
875: l_itemtype wf_items.item_type%TYPE;
876: l_itemkey wf_items.item_key%TYPE;
877: l_receiver wf_roles.name%TYPE;
878: l_cur g_refcur;

Line 1126: FROM hz_relationships hzr, hz_parties hp, fnd_user fu

1122: IS
1123: l_supplier_party_id NUMBER;
1124: CURSOR l_user_name_cur (p_supplier_party_id IN NUMBER) IS
1125: SELECT fu.user_name
1126: FROM hz_relationships hzr, hz_parties hp, fnd_user fu
1127: WHERE
1128: fu.person_party_id = hp.party_id
1129: AND fu.email_address IS NOT NULL
1130: AND fu.end_date IS NULL

Line 1168: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

1164: l_adhoc_user wf_roles.name%TYPE;
1165:
1166: CURSOR l_user_name_cur IS
1167: SELECT fu.user_name
1168: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
1169: WHERE fu.person_party_id = hp.party_id
1170: AND fu.email_address IS NOT NULL
1171: AND fu.end_date IS NULL
1172: AND ap.vendor_id = p_vendor_id

Line 1205: from hz_parties hp, hz_relationships hzr, hz_parties hzr_hp, hz_party_usg_assignments hpua, ap_suppliers apsupp

1201: l_user_name fnd_user.user_name%TYPE;
1202:
1203: CURSOR l_contact_cur IS
1204: select hp.person_first_name, hp.person_last_name, hzr_hp.email_address
1205: from hz_parties hp, hz_relationships hzr, hz_parties hzr_hp, hz_party_usg_assignments hpua, ap_suppliers apsupp
1206: where hp.party_id = hzr.subject_id
1207: and hzr.object_id = apsupp.party_id
1208: and apsupp.vendor_id = p_vendor_id
1209: and hzr.relationship_type = 'CONTACT'

Line 1298: l_enterprise_name hz_parties.party_name%TYPE;

1294: )
1295: IS
1296: PRAGMA autonomous_transaction;
1297: l_supplier_name ap_suppliers.vendor_name%TYPE;
1298: l_enterprise_name hz_parties.party_name%TYPE;
1299: l_itemtype wf_items.item_type%TYPE;
1300: l_itemkey wf_items.item_key%TYPE;
1301: l_receiver wf_roles.name%TYPE;
1302: l_cur g_refcur;

Line 1576: l_enterprise_name hz_parties.party_name%TYPE;

1572: IS
1573: l_itemtype wf_items.item_type%TYPE;
1574: l_itemkey wf_items.item_key%TYPE;
1575: l_process wf_process_activities.process_name%TYPE;
1576: l_enterprise_name hz_parties.party_name%TYPE;
1577: l_step NUMBER;
1578: BEGIN
1579: l_step := 0;
1580: get_enterprise_name(l_enterprise_name);

Line 1659: l_enterprise_name hz_parties.party_name%TYPE;

1655: IS
1656: l_itemtype wf_items.item_type%TYPE;
1657: l_itemkey wf_items.item_key%TYPE;
1658: l_process wf_process_activities.process_name%TYPE;
1659: l_enterprise_name hz_parties.party_name%TYPE;
1660: l_step VARCHAR2(100);
1661: BEGIN
1662: l_step := 1;
1663:

Line 1751: l_enterprise_name hz_parties.party_name%TYPE;

1747: AND do_not_delete = 'Y';
1748:
1749: l_rec l_cur%ROWTYPE;
1750: l_receiver wf_roles.name%TYPE;
1751: l_enterprise_name hz_parties.party_name%TYPE;
1752: l_display_name wf_roles.display_name%TYPE;
1753: l_step NUMBER;
1754: BEGIN
1755: l_step := 0;

Line 1845: l_enterprise_name hz_parties.party_name%TYPE;

1841: FROM pos_supplier_registrations
1842: WHERE supplier_reg_id = l_supplier_reg_id;
1843:
1844: l_rec l_cur%ROWTYPE;
1845: l_enterprise_name hz_parties.party_name%TYPE;
1846: l_step NUMBER;
1847: BEGIN
1848: l_step := 0;
1849: -- the document id should be the supplier_reg_id for the registration in pos_supplier_registrations

Line 2171: l_first_name hz_parties.person_first_name%TYPE;

2167: l_itemkey wf_items.item_key%TYPE;
2168: l_process wf_process_activities.process_name%TYPE;
2169: l_step NUMBER;
2170: l_supplier_name ap_suppliers.vendor_name%TYPE;
2171: l_first_name hz_parties.person_first_name%TYPE;
2172: l_last_name hz_parties.person_last_name%TYPE;
2173:
2174: BEGIN
2175: l_step := 0;

Line 2172: l_last_name hz_parties.person_last_name%TYPE;

2168: l_process wf_process_activities.process_name%TYPE;
2169: l_step NUMBER;
2170: l_supplier_name ap_suppliers.vendor_name%TYPE;
2171: l_first_name hz_parties.person_first_name%TYPE;
2172: l_last_name hz_parties.person_last_name%TYPE;
2173:
2174: BEGIN
2175: l_step := 0;
2176: get_supplier_name(p_vendor_id, l_supplier_name);

Line 2256: l_enterprise_name hz_parties.party_name%TYPE;

2252: l_itemkey wf_items.item_key%TYPE;
2253: l_process wf_process_activities.process_name%TYPE;
2254: l_step NUMBER;
2255: l_supplier_name ap_suppliers.vendor_name%TYPE;
2256: l_enterprise_name hz_parties.party_name%TYPE;
2257: l_first_name hz_parties.person_first_name%TYPE;
2258: l_last_name hz_parties.person_last_name%TYPE;
2259:
2260: BEGIN

Line 2257: l_first_name hz_parties.person_first_name%TYPE;

2253: l_process wf_process_activities.process_name%TYPE;
2254: l_step NUMBER;
2255: l_supplier_name ap_suppliers.vendor_name%TYPE;
2256: l_enterprise_name hz_parties.party_name%TYPE;
2257: l_first_name hz_parties.person_first_name%TYPE;
2258: l_last_name hz_parties.person_last_name%TYPE;
2259:
2260: BEGIN
2261: l_step := 0;

Line 2258: l_last_name hz_parties.person_last_name%TYPE;

2254: l_step NUMBER;
2255: l_supplier_name ap_suppliers.vendor_name%TYPE;
2256: l_enterprise_name hz_parties.party_name%TYPE;
2257: l_first_name hz_parties.person_first_name%TYPE;
2258: l_last_name hz_parties.person_last_name%TYPE;
2259:
2260: BEGIN
2261: l_step := 0;
2262:

Line 2354: l_first_name hz_parties.person_first_name%TYPE;

2350: l_itemkey wf_items.item_key%TYPE;
2351: l_process wf_process_activities.process_name%TYPE;
2352: l_step NUMBER;
2353: l_supplier_name ap_suppliers.vendor_name%TYPE;
2354: l_first_name hz_parties.person_first_name%TYPE;
2355: l_last_name hz_parties.person_last_name%TYPE;
2356:
2357: BEGIN
2358: l_step := 0;

Line 2355: l_last_name hz_parties.person_last_name%TYPE;

2351: l_process wf_process_activities.process_name%TYPE;
2352: l_step NUMBER;
2353: l_supplier_name ap_suppliers.vendor_name%TYPE;
2354: l_first_name hz_parties.person_first_name%TYPE;
2355: l_last_name hz_parties.person_last_name%TYPE;
2356:
2357: BEGIN
2358: l_step := 0;
2359:

Line 2456: l_first_name hz_parties.person_first_name%TYPE;

2452: l_itemkey wf_items.item_key%TYPE;
2453: l_process wf_process_activities.process_name%TYPE;
2454: l_step NUMBER;
2455: l_supplier_name ap_suppliers.vendor_name%TYPE;
2456: l_first_name hz_parties.person_first_name%TYPE;
2457: l_last_name hz_parties.person_last_name%TYPE;
2458:
2459: BEGIN
2460: l_step := 0;

Line 2457: l_last_name hz_parties.person_last_name%TYPE;

2453: l_process wf_process_activities.process_name%TYPE;
2454: l_step NUMBER;
2455: l_supplier_name ap_suppliers.vendor_name%TYPE;
2456: l_first_name hz_parties.person_first_name%TYPE;
2457: l_last_name hz_parties.person_last_name%TYPE;
2458:
2459: BEGIN
2460: l_step := 0;
2461:

Line 2558: l_enterprise_name hz_parties.party_name%TYPE;

2554:
2555: l_itemtype wf_items.item_type%TYPE;
2556: l_itemkey wf_items.item_key%TYPE;
2557: l_process wf_process_activities.process_name%TYPE;
2558: l_enterprise_name hz_parties.party_name%TYPE;
2559: l_step NUMBER;
2560:
2561: BEGIN
2562: l_step := 0;

Line 2704: l_first_name hz_parties.person_first_name%TYPE;

2700: l_step NUMBER;
2701: l_count NUMBER;
2702:
2703: l_supplier_name ap_suppliers.vendor_name%TYPE;
2704: l_first_name hz_parties.person_first_name%TYPE;
2705: l_last_name hz_parties.person_last_name%TYPE;
2706:
2707: BEGIN
2708: l_step := 0;

Line 2705: l_last_name hz_parties.person_last_name%TYPE;

2701: l_count NUMBER;
2702:
2703: l_supplier_name ap_suppliers.vendor_name%TYPE;
2704: l_first_name hz_parties.person_first_name%TYPE;
2705: l_last_name hz_parties.person_last_name%TYPE;
2706:
2707: BEGIN
2708: l_step := 0;
2709:

Line 2897: l_enterprise_name hz_parties.party_name%TYPE;

2893: AND pcr.do_not_delete = 'Y';
2894:
2895: l_rec l_cur%ROWTYPE;
2896:
2897: l_enterprise_name hz_parties.party_name%TYPE;
2898: BEGIN
2899: OPEN l_cur;
2900: FETCH l_cur INTO l_rec;
2901: IF l_cur%notfound THEN

Line 2970: l_enterprise_name hz_parties.party_name%TYPE;

2966: AND pcr.do_not_delete = 'Y';
2967:
2968: l_rec l_cur%ROWTYPE;
2969:
2970: l_enterprise_name hz_parties.party_name%TYPE;
2971:
2972: l_wf_role_rec wf_directory.wf_local_roles_rec_type;
2973:
2974: BEGIN

Line 3144: l_enterprise_name hz_parties.party_name%TYPE;

3140: IS
3141: l_itemtype wf_items.item_type%TYPE;
3142: l_itemkey wf_items.item_key%TYPE;
3143: l_process wf_process_activities.process_name%TYPE;
3144: l_enterprise_name hz_parties.party_name%TYPE;
3145: l_step NUMBER;
3146: BEGIN
3147: l_step := 0;
3148: get_enterprise_name(l_enterprise_name);

Line 3219: l_enterprise_name hz_parties.party_name%TYPE;

3215: IS
3216: l_itemtype wf_items.item_type%TYPE;
3217: l_itemkey wf_items.item_key%TYPE;
3218: l_process wf_process_activities.process_name%TYPE;
3219: l_enterprise_name hz_parties.party_name%TYPE;
3220: l_step VARCHAR2(100);
3221: BEGIN
3222: l_step := 1;
3223:

Line 3334: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

3330: OR APS.BUS_CLASS_LAST_CERTIFIED_DATE IS NULL;
3331:
3332: CURSOR l_supplier_users_cur IS
3333: SELECT fu.user_name, fu.email_address
3334: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
3335: WHERE
3336: fu.user_id in (select spm.user_id from pos_spmntf_subscription spm
3337: where spm.event_type = 'SUPP_BUS_CLASS_RECERT_NTF')
3338: AND fu.person_party_id = hp.party_id