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_VENDOR_REG_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 64: , pos_supplier_mappings psm

60: IS
61: CURSOR l_cur IS
62: SELECT ext_attr_1
63: FROM pos_bus_class_reqs pbcr
64: , pos_supplier_mappings psm
65: , pos_supplier_registrations psr
66: WHERE psm.supplier_reg_id = psr.supplier_reg_id
67: AND psr.supplier_reg_id = p_supplier_reg_id
68: AND pbcr.mapping_id = psm.mapping_id

Line 412: l_step := 'update pos_supplier_mappings with ids';

408: x_return_status <> fnd_api.g_ret_sts_success THEN
409: RETURN;
410: END IF;
411:
412: l_step := 'update pos_supplier_mappings with ids';
413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
414: fnd_log.string
415: (fnd_log.level_statement
416: , g_module || '.' || l_method

Line 423: UPDATE pos_supplier_mappings

419: || ' x_msg_data ' || x_msg_data
420: );
421: END IF;
422:
423: UPDATE pos_supplier_mappings
424: SET vendor_id = x_vendor_id,
425: party_id = x_party_id,
426: last_updated_by = fnd_global.user_id,
427: last_update_date = Sysdate,

Line 523: , pos_supplier_mappings psm

519: ) IS
520: CURSOR l_cur IS
521: SELECT par.address_request_id
522: FROM pos_address_requests par
523: , pos_supplier_mappings psm
524: WHERE par.request_type = 'ADD'
525: AND par.request_status = 'PENDING'
526: AND par.mapping_id = psm.mapping_id
527: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 565: , pos_supplier_mappings psm

561: CURSOR l_cur IS
562: SELECT pcr.contact_request_id, pcr.email_address,
563: psm.vendor_id, create_user_account
564: FROM pos_contact_requests pcr
565: , pos_supplier_mappings psm
566: WHERE (pcr.request_type = 'ADD'
567: OR pcr.request_type = 'ADD_PARTY_CONTACT')
568: AND pcr.request_status = 'PENDING'
569: AND pcr.mapping_id = psm.mapping_id

Line 678: , pos_supplier_mappings psm

674: IS
675: CURSOR l_cur IS
676: SELECT pbcr.bus_class_request_id
677: FROM pos_bus_class_reqs pbcr
678: , pos_supplier_mappings psm
679: WHERE pbcr.request_type = 'ADD'
680: AND pbcr.request_status = 'PENDING'
681: AND pbcr.mapping_id = psm.mapping_id
682: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 713: , pos_supplier_mappings psm

709: IS
710: CURSOR l_cur IS
711: SELECT ppsr.ps_request_id
712: FROM pos_product_service_requests ppsr
713: , pos_supplier_mappings psm
714: WHERE ppsr.request_type = 'ADD'
715: AND ppsr.request_status = 'PENDING'
716: AND ppsr.mapping_id = psm.mapping_id
717: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 749: FROM pos_supplier_mappings

745: SELECT fu.user_name, fu.user_id
746: FROM pos_contact_requests pcr, fnd_user fu
747: WHERE pcr.mapping_id =
748: (SELECT mapping_id
749: FROM pos_supplier_mappings
750: WHERE supplier_reg_id = p_supplier_reg_id
751: )
752: AND pcr.request_status = 'APPROVED'
753: AND pcr.do_not_delete = 'Y'

Line 777: FROM POS_ACNT_GEN_REQ pagr,pos_supplier_mappings psm

773:
774: BEGIN
775: SELECT Count(pagr.ACCOUNT_REQUEST_ID)
776: INTO l_count
777: FROM POS_ACNT_GEN_REQ pagr,pos_supplier_mappings psm
778: WHERE pagr.mapping_id = psm.mapping_id
779: AND psm.vendor_id = p_vendor_id;
780:
781:

Line 893: pos_supplier_mappings psm

889:
890: CURSOR l_cur IS
891: SELECT par.address_request_id, par.party_site_id
892: FROM pos_address_requests par,
893: pos_supplier_mappings psm
894: WHERE par.request_type = 'ADD'
895: AND par.mapping_id = psm.mapping_id
896: AND par.party_site_id IS NOT NULL
897: AND psm.supplier_reg_id = p_supplier_reg_id;

Line 1444: (SELECT mapping_id FROM pos_supplier_mappings

1440: last_update_date = Sysdate,
1441: last_updated_by = fnd_global.user_id,
1442: last_update_login = fnd_global.login_id
1443: WHERE mapping_id =
1444: (SELECT mapping_id FROM pos_supplier_mappings
1445: WHERE supplier_reg_id = p_supplier_reg_id)
1446: AND request_status = 'PENDING';
1447:
1448: UPDATE pos_contact_requests

Line 1454: (SELECT mapping_id FROM pos_supplier_mappings

1450: last_update_date = Sysdate,
1451: last_updated_by = fnd_global.user_id,
1452: last_update_login = fnd_global.login_id
1453: WHERE mapping_id =
1454: (SELECT mapping_id FROM pos_supplier_mappings
1455: WHERE supplier_reg_id = p_supplier_reg_id)
1456: AND request_status = 'PENDING';
1457:
1458: UPDATE pos_cont_addr_requests

Line 1464: (SELECT mapping_id FROM pos_supplier_mappings

1460: last_update_date = Sysdate,
1461: last_updated_by = fnd_global.user_id,
1462: last_update_login = fnd_global.login_id
1463: WHERE mapping_id =
1464: (SELECT mapping_id FROM pos_supplier_mappings
1465: WHERE supplier_reg_id = p_supplier_reg_id)
1466: AND request_status = 'PENDING';
1467:
1468:

Line 1919: l_mapping_id pos_supplier_mappings.mapping_id%TYPE;

1915: x_class_codes_tbl OUT NOCOPY EGO_VARCHAR_TBL_TYPE
1916: )
1917: IS
1918:
1919: l_mapping_id pos_supplier_mappings.mapping_id%TYPE;
1920: l_party_id pos_supplier_registrations.vendor_party_id%TYPE;
1921: l_supplier_type pos_supplier_registrations.supplier_type%TYPE;
1922: l_ps_rec pos_product_service_requests%ROWTYPE;
1923: l_segment pos_product_service_requests.segment1%TYPE;

Line 1942: FROM pos_supplier_mappings

1938:
1939:
1940: CURSOR c_mapping_id(p_supp_reg_id IN NUMBER) IS
1941: SELECT mapping_id
1942: FROM pos_supplier_mappings
1943: WHERE supplier_reg_id = p_supp_reg_id;
1944:
1945: CURSOR c_party_id(p_supp_reg_id IN NUMBER) IS
1946: SELECT vendor_party_id