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 68: FROM ap_suppliers

64: x_vendor_name OUT nocopy VARCHAR2)
65: IS
66: CURSOR l_cur IS
67: SELECT vendor_name
68: FROM ap_suppliers
69: WHERE vendor_id = p_vendor_id;
70: BEGIN
71: OPEN l_cur;
72: FETCH l_cur INTO x_vendor_name;

Line 277: l_company_name ap_suppliers.vendor_name%TYPE;

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

Line 352: l_supplier_name ap_suppliers.vendor_name%TYPE;

348: x_itemkey OUT nocopy VARCHAR2,
349: x_receiver OUT nocopy VARCHAR2
350: )
351: IS
352: l_supplier_name ap_suppliers.vendor_name%TYPE;
353: l_address_name hz_party_sites.party_site_name%TYPE;
354: l_itemtype wf_items.item_type%TYPE;
355: l_itemkey wf_items.item_key%TYPE;
356: l_receiver wf_roles.name%TYPE;

Line 535: l_supplier_name ap_suppliers.vendor_name%TYPE;

531: x_itemkey OUT nocopy VARCHAR2,
532: x_receiver OUT nocopy VARCHAR2
533: )
534: IS
535: l_supplier_name ap_suppliers.vendor_name%TYPE;
536: l_itemtype wf_items.item_type%TYPE;
537: l_itemkey wf_items.item_key%TYPE;
538: l_receiver wf_roles.name%TYPE;
539: l_cur g_refcur;

Line 724: l_supplier_name ap_suppliers.vendor_name%TYPE;

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

Line 873: l_supplier_name ap_suppliers.vendor_name%TYPE;

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

Line 1011: l_supplier_name ap_suppliers.vendor_name%TYPE;

1007: x_itemkey OUT nocopy VARCHAR2,
1008: x_receiver OUT nocopy VARCHAR2
1009: )
1010: IS
1011: l_supplier_name ap_suppliers.vendor_name%TYPE;
1012: l_itemtype wf_items.item_type%TYPE;
1013: l_itemkey wf_items.item_key%TYPE;
1014: l_receiver wf_roles.name%TYPE;
1015: l_cur g_refcur;

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

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

Line 1437: l_supplier_name ap_suppliers.vendor_name%TYPE;

1433: x_itemkey OUT nocopy VARCHAR2,
1434: x_receiver OUT nocopy VARCHAR2
1435: )
1436: IS
1437: l_supplier_name ap_suppliers.vendor_name%TYPE;
1438: l_itemtype wf_items.item_type%TYPE;
1439: l_itemkey wf_items.item_key%TYPE;
1440: l_receiver wf_roles.name%TYPE;
1441: l_cur g_refcur;

Line 1929: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua

1925: select DISTINCT fu.user_name
1926: from fnd_user fu,
1927: fnd_responsibility fr,
1928: fnd_user_resp_groups_direct furg,
1929: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1930: where fr.menu_id IN
1931: (SELECT fme.menu_id
1932: FROM fnd_menu_entries fme
1933: START WITH fme.function_id = l_function_id

Line 2170: l_supplier_name ap_suppliers.vendor_name%TYPE;

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

Line 2255: l_supplier_name ap_suppliers.vendor_name%TYPE;

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

Line 2353: l_supplier_name ap_suppliers.vendor_name%TYPE;

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

Line 2455: l_supplier_name ap_suppliers.vendor_name%TYPE;

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

Line 2703: l_supplier_name ap_suppliers.vendor_name%TYPE;

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

Line 3054: l_supplier_name ap_suppliers.vendor_name%TYPE;

3050: x_itemkey OUT nocopy VARCHAR2,
3051: x_receiver OUT nocopy VARCHAR2
3052: )
3053: IS
3054: l_supplier_name ap_suppliers.vendor_name%TYPE;
3055: l_itemtype wf_items.item_type%TYPE;
3056: l_itemkey wf_items.item_key%TYPE;
3057: l_receiver wf_roles.name%TYPE;
3058: l_cur g_refcur;

Line 3319: FROM AP_SUPPLIERS APS

3315: l_users WF_DIRECTORY.UserTable;
3316:
3317: CURSOR l_vendor_id_cur IS
3318: SELECT APS.VENDOR_ID
3319: FROM AP_SUPPLIERS APS
3320: WHERE
3321: 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'))
3322: OR
3323: (

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

Line 3366: FROM AP_SUPPLIERS APS

3362: l_supplier_count := 0;
3363:
3364: SELECT COUNT(APS.VENDOR_ID)
3365: into l_supplier_count
3366: FROM AP_SUPPLIERS APS
3367: WHERE
3368: 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'))
3369: OR
3370: ( Trunc(SYSDATE) > Trunc(APS.BUS_CLASS_LAST_CERTIFIED_DATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_PERIOD')))

Line 3450: FROM ap_suppliers

3446: );
3447:
3448: SELECT bus_class_last_certified_date
3449: INTO l_last_certification_date
3450: FROM ap_suppliers
3451: WHERE vendor_id = l_vendor_id;
3452:
3453: IF l_last_certification_date IS NOT NULL then
3454: l_due_date := l_last_certification_date + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_PERIOD'));

Line 3469: from ap_suppliers

3465: l_role_name := l_process||' '||To_Char(l_vendor_id)||' '||to_char(sysdate, 'JSSSSS')||To_Char(fnd_crypto.smallrandomnumber);
3466:
3467: select vendor_name
3468: into l_role_display_name
3469: from ap_suppliers
3470: where vendor_id = l_vendor_id;
3471:
3472: select SYSDATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'))
3473: into l_expiration_date

Line 3474: from ap_suppliers

3470: where vendor_id = l_vendor_id;
3471:
3472: select SYSDATE + To_Number(FND_PROFILE.Value('POS_BUS_CLASS_RECERT_REMIND_DAYS'))
3473: into l_expiration_date
3474: from ap_suppliers
3475: where vendor_id = l_vendor_id;
3476:
3477:
3478: WF_DIRECTORY.CreateAdHocRole2(role_name => l_role_name,