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 234: FROM hz_parties hp, fnd_user fu

230: WHERE fu.employee_id = ppf.person_id
231: AND fu.user_id = p_user_id;
232: CURSOR l_tca_cur IS
233: SELECT hp.person_first_name, hp.person_last_name
234: FROM hz_parties hp, fnd_user fu
235: WHERE fu.person_party_id = hp.party_id
236: AND fu.user_id = p_user_id;
237: CURSOR l_fnd_cur IS
238: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;

Line 330: l_first_name hz_parties.person_first_name%TYPE;

326: itemkey IN VARCHAR2
327: )
328: IS
329: l_company_name ap_suppliers.vendor_name%TYPE;
330: l_first_name hz_parties.person_first_name%TYPE;
331: l_last_name hz_parties.person_last_name%TYPE;
332: BEGIN
333: get_current_user_name(l_first_name, l_last_name);
334: get_current_user_company_name(l_company_name);

Line 331: l_last_name hz_parties.person_last_name%TYPE;

327: )
328: IS
329: l_company_name ap_suppliers.vendor_name%TYPE;
330: l_first_name hz_parties.person_first_name%TYPE;
331: l_last_name hz_parties.person_last_name%TYPE;
332: BEGIN
333: get_current_user_name(l_first_name, l_last_name);
334: get_current_user_company_name(l_company_name);
335:

Line 744: FROM hz_parties hp

740: IS
741: CURSOR l_cur IS
742: SELECT Decode(pcr.contact_party_id, NULL, pcr.first_name || ' ' || pcr.last_name,
743: (SELECT hp.party_name
744: FROM hz_parties hp
745: WHERE hp.party_id = pcr.contact_party_id
746: )) contact_name
747: FROM pos_contact_requests pcr
748: WHERE pcr.contact_request_id = p_contact_request_id;

Line 777: l_contact_name hz_parties.party_name%TYPE;

773: x_receiver OUT nocopy VARCHAR2
774: )
775: IS
776: l_supplier_name ap_suppliers.vendor_name%TYPE;
777: l_contact_name hz_parties.party_name%TYPE;
778: l_itemtype wf_items.item_type%TYPE;
779: l_itemkey wf_items.item_key%TYPE;
780: l_receiver wf_roles.name%TYPE;
781: l_cur g_refcur;

Line 926: l_contact_name hz_parties.party_name%TYPE;

922: x_receiver OUT nocopy VARCHAR2
923: )
924: IS
925: l_supplier_name ap_suppliers.vendor_name%TYPE;
926: l_contact_name hz_parties.party_name%TYPE;
927: l_itemtype wf_items.item_type%TYPE;
928: l_itemkey wf_items.item_key%TYPE;
929: l_receiver wf_roles.name%TYPE;
930: l_cur g_refcur;

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

1174: IS
1175: l_supplier_party_id NUMBER;
1176: CURSOR l_user_name_cur (p_supplier_party_id IN NUMBER) IS
1177: SELECT fu.user_name
1178: FROM hz_relationships hzr, hz_parties hp, fnd_user fu
1179: WHERE
1180: fu.person_party_id = hp.party_id
1181: AND fu.email_address IS NOT NULL
1182: AND fu.end_date IS NULL

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

1216: l_adhoc_user wf_roles.name%TYPE;
1217:
1218: CURSOR l_user_name_cur IS
1219: SELECT fu.user_name
1220: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
1221: WHERE fu.person_party_id = hp.party_id
1222: AND fu.email_address IS NOT NULL
1223: AND fu.end_date IS NULL
1224: AND ap.vendor_id = p_vendor_id

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

1253: l_user_name fnd_user.user_name%TYPE;
1254:
1255: CURSOR l_contact_cur IS
1256: select hp.person_first_name, hp.person_last_name, hzr_hp.email_address
1257: from hz_parties hp, hz_relationships hzr, hz_parties hzr_hp, hz_party_usg_assignments hpua, ap_suppliers apsupp
1258: where hp.party_id = hzr.subject_id
1259: and hzr.object_id = apsupp.party_id
1260: and apsupp.vendor_id = p_vendor_id
1261: and hzr.relationship_type = 'CONTACT'

Line 1350: l_enterprise_name hz_parties.party_name%TYPE;

1346: )
1347: IS
1348: PRAGMA autonomous_transaction;
1349: l_supplier_name ap_suppliers.vendor_name%TYPE;
1350: l_enterprise_name hz_parties.party_name%TYPE;
1351: l_itemtype wf_items.item_type%TYPE;
1352: l_itemkey wf_items.item_key%TYPE;
1353: l_receiver wf_roles.name%TYPE;
1354: l_cur g_refcur;

Line 1628: l_enterprise_name hz_parties.party_name%TYPE;

1624: IS
1625: l_itemtype wf_items.item_type%TYPE;
1626: l_itemkey wf_items.item_key%TYPE;
1627: l_process wf_process_activities.process_name%TYPE;
1628: l_enterprise_name hz_parties.party_name%TYPE;
1629: l_step NUMBER;
1630: BEGIN
1631: l_step := 0;
1632: get_enterprise_name(l_enterprise_name);

Line 1727: l_enterprise_name hz_parties.party_name%TYPE;

1723: IS
1724: l_itemtype wf_items.item_type%TYPE;
1725: l_itemkey wf_items.item_key%TYPE;
1726: l_process wf_process_activities.process_name%TYPE;
1727: l_enterprise_name hz_parties.party_name%TYPE;
1728: l_step VARCHAR2(100);
1729: BEGIN
1730: l_step := 1;
1731:

Line 1819: l_enterprise_name hz_parties.party_name%TYPE;

1815: AND do_not_delete = 'Y';
1816:
1817: l_rec l_cur%ROWTYPE;
1818: l_receiver wf_roles.name%TYPE;
1819: l_enterprise_name hz_parties.party_name%TYPE;
1820: l_display_name wf_roles.display_name%TYPE;
1821: l_step NUMBER;
1822: BEGIN
1823: l_step := 0;

Line 1913: l_enterprise_name hz_parties.party_name%TYPE;

1909: FROM pos_supplier_registrations
1910: WHERE supplier_reg_id = l_supplier_reg_id;
1911:
1912: l_rec l_cur%ROWTYPE;
1913: l_enterprise_name hz_parties.party_name%TYPE;
1914: l_step NUMBER;
1915: BEGIN
1916: l_step := 0;
1917: -- the document id should be the supplier_reg_id for the registration in pos_supplier_registrations

Line 2239: l_first_name hz_parties.person_first_name%TYPE;

2235: l_itemkey wf_items.item_key%TYPE;
2236: l_process wf_process_activities.process_name%TYPE;
2237: l_step NUMBER;
2238: l_supplier_name ap_suppliers.vendor_name%TYPE;
2239: l_first_name hz_parties.person_first_name%TYPE;
2240: l_last_name hz_parties.person_last_name%TYPE;
2241:
2242: BEGIN
2243: l_step := 0;

Line 2240: l_last_name hz_parties.person_last_name%TYPE;

2236: l_process wf_process_activities.process_name%TYPE;
2237: l_step NUMBER;
2238: l_supplier_name ap_suppliers.vendor_name%TYPE;
2239: l_first_name hz_parties.person_first_name%TYPE;
2240: l_last_name hz_parties.person_last_name%TYPE;
2241:
2242: BEGIN
2243: l_step := 0;
2244: get_supplier_name(p_vendor_id, l_supplier_name);

Line 2324: l_enterprise_name hz_parties.party_name%TYPE;

2320: l_itemkey wf_items.item_key%TYPE;
2321: l_process wf_process_activities.process_name%TYPE;
2322: l_step NUMBER;
2323: l_supplier_name ap_suppliers.vendor_name%TYPE;
2324: l_enterprise_name hz_parties.party_name%TYPE;
2325: l_first_name hz_parties.person_first_name%TYPE;
2326: l_last_name hz_parties.person_last_name%TYPE;
2327:
2328: BEGIN

Line 2325: l_first_name hz_parties.person_first_name%TYPE;

2321: l_process wf_process_activities.process_name%TYPE;
2322: l_step NUMBER;
2323: l_supplier_name ap_suppliers.vendor_name%TYPE;
2324: l_enterprise_name hz_parties.party_name%TYPE;
2325: l_first_name hz_parties.person_first_name%TYPE;
2326: l_last_name hz_parties.person_last_name%TYPE;
2327:
2328: BEGIN
2329: l_step := 0;

Line 2326: l_last_name hz_parties.person_last_name%TYPE;

2322: l_step NUMBER;
2323: l_supplier_name ap_suppliers.vendor_name%TYPE;
2324: l_enterprise_name hz_parties.party_name%TYPE;
2325: l_first_name hz_parties.person_first_name%TYPE;
2326: l_last_name hz_parties.person_last_name%TYPE;
2327:
2328: BEGIN
2329: l_step := 0;
2330:

Line 2422: l_first_name hz_parties.person_first_name%TYPE;

2418: l_itemkey wf_items.item_key%TYPE;
2419: l_process wf_process_activities.process_name%TYPE;
2420: l_step NUMBER;
2421: l_supplier_name ap_suppliers.vendor_name%TYPE;
2422: l_first_name hz_parties.person_first_name%TYPE;
2423: l_last_name hz_parties.person_last_name%TYPE;
2424:
2425: BEGIN
2426: l_step := 0;

Line 2423: l_last_name hz_parties.person_last_name%TYPE;

2419: l_process wf_process_activities.process_name%TYPE;
2420: l_step NUMBER;
2421: l_supplier_name ap_suppliers.vendor_name%TYPE;
2422: l_first_name hz_parties.person_first_name%TYPE;
2423: l_last_name hz_parties.person_last_name%TYPE;
2424:
2425: BEGIN
2426: l_step := 0;
2427:

Line 2524: l_first_name hz_parties.person_first_name%TYPE;

2520: l_itemkey wf_items.item_key%TYPE;
2521: l_process wf_process_activities.process_name%TYPE;
2522: l_step NUMBER;
2523: l_supplier_name ap_suppliers.vendor_name%TYPE;
2524: l_first_name hz_parties.person_first_name%TYPE;
2525: l_last_name hz_parties.person_last_name%TYPE;
2526:
2527: BEGIN
2528: l_step := 0;

Line 2525: l_last_name hz_parties.person_last_name%TYPE;

2521: l_process wf_process_activities.process_name%TYPE;
2522: l_step NUMBER;
2523: l_supplier_name ap_suppliers.vendor_name%TYPE;
2524: l_first_name hz_parties.person_first_name%TYPE;
2525: l_last_name hz_parties.person_last_name%TYPE;
2526:
2527: BEGIN
2528: l_step := 0;
2529:

Line 2626: l_enterprise_name hz_parties.party_name%TYPE;

2622:
2623: l_itemtype wf_items.item_type%TYPE;
2624: l_itemkey wf_items.item_key%TYPE;
2625: l_process wf_process_activities.process_name%TYPE;
2626: l_enterprise_name hz_parties.party_name%TYPE;
2627: l_step NUMBER;
2628:
2629: BEGIN
2630: l_step := 0;

Line 2772: l_first_name hz_parties.person_first_name%TYPE;

2768: l_step NUMBER;
2769: l_count NUMBER;
2770:
2771: l_supplier_name ap_suppliers.vendor_name%TYPE;
2772: l_first_name hz_parties.person_first_name%TYPE;
2773: l_last_name hz_parties.person_last_name%TYPE;
2774:
2775: BEGIN
2776: l_step := 0;

Line 2773: l_last_name hz_parties.person_last_name%TYPE;

2769: l_count NUMBER;
2770:
2771: l_supplier_name ap_suppliers.vendor_name%TYPE;
2772: l_first_name hz_parties.person_first_name%TYPE;
2773: l_last_name hz_parties.person_last_name%TYPE;
2774:
2775: BEGIN
2776: l_step := 0;
2777:

Line 2965: l_enterprise_name hz_parties.party_name%TYPE;

2961: AND pcr.do_not_delete = 'Y';
2962:
2963: l_rec l_cur%ROWTYPE;
2964:
2965: l_enterprise_name hz_parties.party_name%TYPE;
2966: BEGIN
2967: OPEN l_cur;
2968: FETCH l_cur INTO l_rec;
2969: IF l_cur%notfound THEN

Line 3038: l_enterprise_name hz_parties.party_name%TYPE;

3034: AND pcr.do_not_delete = 'Y';
3035:
3036: l_rec l_cur%ROWTYPE;
3037:
3038: l_enterprise_name hz_parties.party_name%TYPE;
3039:
3040: l_wf_role_rec wf_directory.wf_local_roles_rec_type;
3041:
3042: BEGIN

Line 3329: l_enterprise_name hz_parties.party_name%TYPE;

3325: IS
3326: l_itemtype wf_items.item_type%TYPE;
3327: l_itemkey wf_items.item_key%TYPE;
3328: l_process wf_process_activities.process_name%TYPE;
3329: l_enterprise_name hz_parties.party_name%TYPE;
3330: l_step NUMBER;
3331: BEGIN
3332: l_step := 0;
3333: get_enterprise_name(l_enterprise_name);

Line 3417: l_enterprise_name hz_parties.party_name%TYPE;

3413: IS
3414: l_itemtype wf_items.item_type%TYPE;
3415: l_itemkey wf_items.item_key%TYPE;
3416: l_process wf_process_activities.process_name%TYPE;
3417: l_enterprise_name hz_parties.party_name%TYPE;
3418: l_step VARCHAR2(100);
3419: BEGIN
3420: l_step := 1;
3421:

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

3537: );
3538:
3539: CURSOR l_supplier_users_cur IS
3540: SELECT fu.user_name, fu.email_address
3541: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
3542: WHERE
3543: fu.user_id in (select spm.user_id from pos_spmntf_subscription spm
3544: where spm.event_type = 'SUPP_BUS_CLASS_RECERT_NTF')
3545: AND fu.person_party_id = hp.party_id