APPS.POS_VENDOR_REG_PKG dependencies on HZ_PARTIES

Line 99: FROM hz_parties

95: l_party_rec hz_party_v2pub.party_rec_type;
96:
97: CURSOR l_cur IS
98: SELECT party_id, object_version_number
99: FROM hz_parties
100: WHERE party_id =
101: (SELECT party_id
102: FROM ap_suppliers
103: WHERE vendor_id = p_vendor_id);

Line 1481: update hz_parties

1477: where supplier_reg_id = p_supplier_reg_id);
1478:
1479: if (l_party_usages = 0 ) then
1480:
1481: update hz_parties
1482: set status = 'I',
1483: last_update_date = Sysdate,
1484: last_updated_by = fnd_global.user_id,
1485: last_update_login = fnd_global.login_id

Line 1750: l_party_id hz_parties.party_id%TYPE := -1;

1746: , x_vendor_id OUT NOCOPY NUMBER
1747: )
1748: IS
1749:
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

Line 1761: FROM hz_parties

1757: AND psr.registration_status = 'PENDING_APPROVAL';
1758:
1759: CURSOR hz_cur IS
1760: SELECT party_id
1761: FROM hz_parties
1762: WHERE duns_number_c = p_duns_num
1763: AND party_type = 'ORGANIZATION';
1764:
1765: CURSOR po_vendors_cur ( p_party_id hz_parties.party_id%TYPE ) IS

Line 1765: CURSOR po_vendors_cur ( p_party_id hz_parties.party_id%TYPE ) IS

1761: FROM hz_parties
1762: WHERE duns_number_c = p_duns_num
1763: AND party_type = 'ORGANIZATION';
1764:
1765: CURSOR po_vendors_cur ( p_party_id hz_parties.party_id%TYPE ) IS
1766: SELECT vendor_id
1767: FROM ap_suppliers
1768: WHERE party_id = p_party_id;
1769:

Line 1772: CURSOR supp_reg_org_cur ( p_party_id hz_parties.party_id%TYPE ) IS

1768: WHERE party_id = p_party_id;
1769:
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

Line 1972: WHERE owner_table_name = 'HZ_PARTIES'

1968: || hccr.class_code AS code
1969: FROM hz_class_code_relations hccr,
1970: (SELECT class_category, class_code, owner_table_id
1971: FROM hz_code_assignments
1972: WHERE owner_table_name = 'HZ_PARTIES'
1973: AND owner_table_id = p_party_id
1974: AND start_date_active <= SYSDATE
1975: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1976: AND status = 'A'

Line 1988: WHERE owner_table_name = 'HZ_PARTIES'

1984: || fnd.lookup_code AS code
1985: FROM fnd_lookup_values_vl fnd,
1986: (SELECT class_category, class_code, owner_table_id
1987: FROM hz_code_assignments
1988: WHERE owner_table_name = 'HZ_PARTIES'
1989: AND owner_table_id = p_party_id
1990: AND start_date_active <= SYSDATE
1991: AND NVL(end_date_active, SYSDATE) >= SYSDATE
1992: AND status = 'A'

Line 2217: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name('HZ_PARTIES');

2213:
2214: x_return_status := FND_API.G_RET_STS_SUCCESS;
2215:
2216:
2217: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name('HZ_PARTIES');
2218:
2219:
2220: -- Pages List
2221: FOR l_page_rec IN c_pages_list(p_supp_reg_id, p_buyer_user) LOOP

Line 2352: p_object_name => 'HZ_PARTIES',

2348: );
2349:
2350: EGO_USER_ATTRS_DATA_PVT.Get_User_Attrs_Data
2351: ( p_api_version => 1.0,
2352: p_object_name => 'HZ_PARTIES',
2353: p_pk_column_name_value_pairs => l_pk_column_values,
2354: p_attr_group_request_table => l_attr_group_request_tbl,
2355: x_attributes_row_table => l_attributes_row_tbl,
2356: x_attributes_data_table => l_attributes_data_tbl,