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 AP_SUPPLIERS

Line 120: FROM ap_suppliers

116: x_vendor_name OUT nocopy VARCHAR2)
117: IS
118: CURSOR l_cur IS
119: SELECT vendor_name
120: FROM ap_suppliers
121: WHERE vendor_id = p_vendor_id;
122: BEGIN
123: OPEN l_cur;
124: FETCH l_cur INTO x_vendor_name;

Line 329: l_company_name ap_suppliers.vendor_name%TYPE;

325: (itemtype IN VARCHAR2,
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);

Line 404: l_supplier_name ap_suppliers.vendor_name%TYPE;

400: x_itemkey OUT nocopy VARCHAR2,
401: x_receiver OUT nocopy VARCHAR2
402: )
403: IS
404: l_supplier_name ap_suppliers.vendor_name%TYPE;
405: l_address_name hz_party_sites.party_site_name%TYPE;
406: l_itemtype wf_items.item_type%TYPE;
407: l_itemkey wf_items.item_key%TYPE;
408: l_receiver wf_roles.name%TYPE;

Line 587: l_supplier_name ap_suppliers.vendor_name%TYPE;

583: x_itemkey OUT nocopy VARCHAR2,
584: x_receiver OUT nocopy VARCHAR2
585: )
586: IS
587: l_supplier_name ap_suppliers.vendor_name%TYPE;
588: l_itemtype wf_items.item_type%TYPE;
589: l_itemkey wf_items.item_key%TYPE;
590: l_receiver wf_roles.name%TYPE;
591: l_cur g_refcur;

Line 776: l_supplier_name ap_suppliers.vendor_name%TYPE;

772: x_itemkey OUT nocopy VARCHAR2,
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;

Line 925: l_supplier_name ap_suppliers.vendor_name%TYPE;

921: x_itemkey OUT nocopy VARCHAR2,
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;

Line 1063: l_supplier_name ap_suppliers.vendor_name%TYPE;

1059: x_itemkey OUT nocopy VARCHAR2,
1060: x_receiver OUT nocopy VARCHAR2
1061: )
1062: IS
1063: l_supplier_name ap_suppliers.vendor_name%TYPE;
1064: l_itemtype wf_items.item_type%TYPE;
1065: l_itemkey wf_items.item_key%TYPE;
1066: l_receiver wf_roles.name%TYPE;
1067: l_cur g_refcur;

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 1349: l_supplier_name ap_suppliers.vendor_name%TYPE;

1345: x_receiver OUT nocopy VARCHAR2
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;

Line 1489: l_supplier_name ap_suppliers.vendor_name%TYPE;

1485: x_itemkey OUT nocopy VARCHAR2,
1486: x_receiver OUT nocopy VARCHAR2
1487: )
1488: IS
1489: l_supplier_name ap_suppliers.vendor_name%TYPE;
1490: l_itemtype wf_items.item_type%TYPE;
1491: l_itemkey wf_items.item_key%TYPE;
1492: l_receiver wf_roles.name%TYPE;
1493: l_cur g_refcur;

Line 1997: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua

1993: select DISTINCT fu.user_name
1994: from fnd_user fu,
1995: fnd_responsibility fr,
1996: fnd_user_resp_groups_direct furg,
1997: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1998: where fr.menu_id IN
1999: (SELECT fme.menu_id
2000: FROM fnd_menu_entries fme
2001: START WITH fme.function_id = l_function_id

Line 2238: l_supplier_name ap_suppliers.vendor_name%TYPE;

2234: l_itemtype wf_items.item_type%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

Line 2323: l_supplier_name ap_suppliers.vendor_name%TYPE;

2319: l_itemtype wf_items.item_type%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:

Line 2421: l_supplier_name ap_suppliers.vendor_name%TYPE;

2417: l_itemtype wf_items.item_type%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

Line 2523: l_supplier_name ap_suppliers.vendor_name%TYPE;

2519: l_itemtype wf_items.item_type%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

Line 2771: l_supplier_name ap_suppliers.vendor_name%TYPE;

2767: l_process wf_process_activities.process_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

Line 3239: l_supplier_name ap_suppliers.vendor_name%TYPE;

3235: x_itemkey OUT nocopy VARCHAR2,
3236: x_receiver OUT nocopy VARCHAR2
3237: )
3238: IS
3239: l_supplier_name ap_suppliers.vendor_name%TYPE;
3240: l_itemtype wf_items.item_type%TYPE;
3241: l_itemkey wf_items.item_key%TYPE;
3242: l_receiver wf_roles.name%TYPE;
3243: l_cur g_refcur;

Line 3518: FROM AP_SUPPLIERS APS

3514:
3515: /* bug 8647019 */
3516: CURSOR l_vendor_id_cur IS
3517: SELECT APS.VENDOR_ID
3518: FROM AP_SUPPLIERS APS
3519: WHERE
3520: (
3521: Trunc(APS.BUS_CLASS_LAST_CERTIFIED_DATE) + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_PERIOD')) = Trunc(SYSDATE) + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'))
3522: OR

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

Line 3581: FROM AP_SUPPLIERS APS

3577:
3578: /* bug 8647019 */
3579: /* SELECT count(APS.VENDOR_ID)
3580: into l_supplier_count
3581: FROM AP_SUPPLIERS APS
3582: WHERE
3583: (
3584: Trunc(APS.BUS_CLASS_LAST_CERTIFIED_DATE) + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_PERIOD')) = Trunc(SYSDATE) + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'))
3585: OR

Line 3674: FROM ap_suppliers

3670: );
3671:
3672: SELECT bus_class_last_certified_date, vendor_name, SYSDATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'))
3673: INTO l_last_certification_date, l_role_display_name, l_expiration_date
3674: FROM ap_suppliers
3675: WHERE vendor_id = l_vendor_id;
3676:
3677: IF l_last_certification_date IS NOT NULL then
3678: l_due_date := l_last_certification_date + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_PERIOD'));

Line 3693: from ap_suppliers

3689: l_role_name := l_process||' '||To_Char(l_vendor_id)||' '||to_char(sysdate, 'JSSSSS')||To_Char(fnd_crypto.smallrandomnumber);
3690: /*
3691: select vendor_name
3692: into l_role_display_name
3693: from ap_suppliers
3694: where vendor_id = l_vendor_id;
3695:
3696: select SYSDATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'))
3697: into l_expiration_date

Line 3698: from ap_suppliers

3694: where vendor_id = l_vendor_id;
3695:
3696: select SYSDATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'))
3697: into l_expiration_date
3698: from ap_suppliers
3699: where vendor_id = l_vendor_id;
3700: */
3701:
3702: WF_DIRECTORY.CreateAdHocRole2(role_name => l_role_name,