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_REGISTRATIONS

Line 21: x_supplier_reg_rec OUT NOCOPY pos_supplier_registrations%ROWTYPE

17: (p_supplier_reg_id IN NUMBER,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: x_supplier_reg_rec OUT NOCOPY pos_supplier_registrations%ROWTYPE
22: )
23: IS
24: CURSOR l_cur IS
25: SELECT *

Line 26: FROM pos_supplier_registrations

22: )
23: IS
24: CURSOR l_cur IS
25: SELECT *
26: FROM pos_supplier_registrations
27: WHERE supplier_reg_id = p_supplier_reg_id FOR UPDATE;
28: BEGIN
29: OPEN l_cur;
30: FETCH l_cur INTO x_supplier_reg_rec;

Line 65: , pos_supplier_registrations psr

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
69: AND pbcr.request_type = 'ADD'

Line 140: (p_supplier_reg_rec IN pos_supplier_registrations%ROWTYPE,

136: );
137: END save_duns_number;
138:
139: PROCEDURE create_vendor_and_party
140: (p_supplier_reg_rec IN pos_supplier_registrations%ROWTYPE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: x_vendor_id OUT NOCOPY NUMBER,

Line 477: l_step := 'update pos_supplier_registrations with ids';

473:
474:
475: /* End Supplier Hub: Supplier Management */
476:
477: l_step := 'update pos_supplier_registrations with ids';
478:
479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
480: fnd_log.string
481: (fnd_log.level_statement

Line 486: UPDATE pos_supplier_registrations

482: , g_module || '.' || l_method
483: , l_step);
484: END IF;
485:
486: UPDATE pos_supplier_registrations
487: SET registration_status = 'APPROVED',
488: po_vendor_id = x_vendor_id,
489: vendor_party_id = x_party_id,
490: last_updated_by = fnd_global.user_id,

Line 583: FROM pos_supplier_registrations

579: l_user_id NUMBER;
580:
581: CURSOR l_reg_type_cur IS
582: SELECT registration_type
583: FROM pos_supplier_registrations
584: WHERE supplier_reg_id = p_supplier_reg_id;
585:
586: l_reg_type_rec l_reg_type_cur%ROWTYPE;
587:

Line 978: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;

974: x_msg_count OUT NOCOPY NUMBER,
975: x_msg_data OUT NOCOPY VARCHAR2
976: )
977: IS
978: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;
979: l_step VARCHAR2(100);
980: l_method VARCHAR2(30);
981: l_vendor_id NUMBER;
982: l_vendor_party_id NUMBER;

Line 1300: from pos_supplier_registrations

1296:
1297: update ap_suppliers
1298: set bus_class_last_certified_by = l_user_id,
1299: bus_class_last_certified_date = (select creation_date
1300: from pos_supplier_registrations
1301: where supplier_reg_id = p_supplier_reg_id ),
1302: last_updated_by = l_user_id,
1303: last_update_date = sysdate
1304:

Line 1380: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;

1376: l_receiver fnd_user.user_name%TYPE;
1377:
1378: l_party_usages number := 0 ;
1379:
1380: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;
1381: event_id Number;
1382: BEGIN
1383: l_method := 'reject_supplier_reg';
1384:

Line 1431: UPDATE pos_supplier_registrations

1427:
1428: RETURN;
1429: END IF;
1430:
1431: UPDATE pos_supplier_registrations
1432: SET registration_status = 'REJECTED',
1433: last_update_date = Sysdate,
1434: last_updated_by = fnd_global.user_id,
1435: last_update_login = fnd_global.login_id

Line 1476: from pos_supplier_registrations

1472: select count(*)
1473: into l_party_usages
1474: from hz_party_usg_assignments
1475: where party_id = (select vendor_party_id
1476: from pos_supplier_registrations
1477: where supplier_reg_id = p_supplier_reg_id);
1478:
1479: if (l_party_usages = 0 ) then
1480:

Line 1489: from pos_supplier_registrations

1485: last_update_login = fnd_global.login_id
1486: where status = 'A' and
1487: created_by_module = 'POS_SUPPLIER_MGMT' and
1488: party_id = (select vendor_party_id
1489: from pos_supplier_registrations
1490: where supplier_reg_id = p_supplier_reg_id);
1491: end if;
1492:
1493: /* set party_usage_code SUPPLIER_PROSPECT as inactive */

Line 1502: from pos_supplier_registrations

1498: last_update_date = Sysdate,
1499: last_updated_by = fnd_global.user_id,
1500: last_update_login = fnd_global.login_id
1501: WHERE party_id= (select vendor_party_id
1502: from pos_supplier_registrations
1503: where supplier_reg_id = p_supplier_reg_id)
1504: and party_usage_code='SUPPLIER_PROSPECT';
1505:
1506: /* End Supplier Hub: Supplier Management */

Line 1534: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;

1530: ) IS
1531:
1532: l_step VARCHAR2(100);
1533: l_method VARCHAR2(30);
1534: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;
1535: BEGIN
1536: l_method := 'submit_supplier_reg';
1537:
1538: l_step := 'lock supplier reg row';

Line 1586: UPDATE pos_supplier_registrations

1582:
1583: RETURN;
1584: END IF;
1585:
1586: UPDATE pos_supplier_registrations
1587: SET registration_status = 'PENDING_APPROVAL',
1588: last_update_date = Sysdate,
1589: last_updated_by = fnd_global.user_id,
1590: last_update_login = fnd_global.login_id

Line 1657: FROM pos_supplier_registrations

1653: RETURN 'N';
1654: END IF;
1655:
1656: FOR x IN (SELECT supplier_number
1657: FROM pos_supplier_registrations
1658: WHERE supplier_reg_id <> p_supp_regid
1659: --AND registration_status <> 'REJECTED'
1660: -- the unique key POS_SUPPLIER_REG_U2 is on supplier_number only
1661: -- without considering the registration_status

Line 1697: FROM pos_supplier_registrations psr

1693: IS
1694:
1695: CURSOR supp_reg_cur IS
1696: SELECT -1
1697: FROM pos_supplier_registrations psr
1698: WHERE psr.supplier_reg_id <> p_supp_regid
1699: AND psr.taxpayer_id = p_taxpayer_id
1700: AND psr.registration_status = 'PENDING_APPROVAL';
1701:

Line 1754: FROM pos_supplier_registrations psr

1750: l_party_id hz_parties.party_id%TYPE := -1;
1751:
1752: CURSOR supp_reg_cur IS
1753: SELECT -1
1754: FROM pos_supplier_registrations psr
1755: WHERE psr.supplier_reg_id <> p_supp_regid
1756: AND psr.duns_number = p_duns_num
1757: AND psr.registration_status = 'PENDING_APPROVAL';
1758:

Line 1774: FROM pos_supplier_registrations psr

1770: /*Begin Supplier Data Hub - Supplier Management*/
1771:
1772: CURSOR supp_reg_org_cur ( p_party_id hz_parties.party_id%TYPE ) IS
1773: SELECT -1
1774: FROM pos_supplier_registrations psr
1775: WHERE psr.supplier_reg_id = p_supp_regid
1776: AND psr.vendor_party_id = p_party_id
1777: AND psr.registration_status = 'PENDING_APPROVAL';
1778:

Line 1847: FROM pos_supplier_registrations psr

1843: IS
1844:
1845: CURSOR supp_reg_cur IS
1846: SELECT -1
1847: FROM pos_supplier_registrations psr
1848: WHERE psr.supplier_reg_id <> p_supp_regid
1849: AND psr.tax_registration_number = p_taxreg_num
1850: AND ((psr.tax_reg_country_code is not null and p_country is not null and psr.tax_reg_country_code = p_country) OR
1851: (p_country is null))

Line 1920: l_party_id pos_supplier_registrations.vendor_party_id%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;
1924:

Line 1921: l_supplier_type pos_supplier_registrations.supplier_type%TYPE;

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;
1924:
1925: l_ps_segment_def fnd_profile_option_values.profile_option_value%TYPE;

Line 1947: FROM pos_supplier_registrations

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
1947: FROM pos_supplier_registrations
1948: WHERE supplier_reg_id = p_supp_reg_id;
1949:
1950: CURSOR c_supplier_type(p_supp_reg_id IN NUMBER) IS
1951: SELECT supplier_type

Line 1952: FROM pos_supplier_registrations

1948: WHERE supplier_reg_id = p_supp_reg_id;
1949:
1950: CURSOR c_supplier_type(p_supp_reg_id IN NUMBER) IS
1951: SELECT supplier_type
1952: FROM pos_supplier_registrations
1953: WHERE supplier_reg_id = p_supp_reg_id;
1954:
1955: CURSOR c_bus_class(p_mapping_id IN NUMBER) IS
1956: SELECT 'BC:' || lookup_code AS code

Line 2199: pos_supplier_registrations psr

2195:
2196: CURSOR c_pages_list(p_supp_reg_id IN NUMBER, p_buyer_user IN VARCHAR2) IS
2197: SELECT pac.page_id
2198: FROM pos_attrpg_config pac,
2199: pos_supplier_registrations psr
2200: WHERE psr.supplier_reg_id = p_supp_reg_id
2201: AND pac.org_id IN (-999, psr.ou_id)
2202: AND DECODE(p_buyer_user, 'Y', pac.internal_update_flag,
2203: 'N', pac.supplier_update_flag) = 'Y'