APPS.POS_MERGE_SUPPLIER_PKG dependencies on HZ_PARTIES

Line 23: p_party_id IN hz_parties.party_id%TYPE,

19:
20: PROCEDURE create_bus_attr
21: (
22: p_buss_class_rec IN pos_bus_class_attr%ROWTYPE,
23: p_party_id IN hz_parties.party_id%TYPE,
24: p_classification_id OUT NOCOPY NUMBER,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2

Line 71: p_party_id IN hz_parties.party_id%TYPE,

67: END create_bus_attr;
68:
69: PROCEDURE get_bus_attr_rec
70: (
71: p_party_id IN hz_parties.party_id%TYPE,
72: p_classification_id IN pos_bus_class_attr.classification_id%TYPE,
73: x_buss_class_rec OUT NOCOPY pos_bus_class_attr%ROWTYPE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,

Line 279: p_party_id IN hz_parties.party_id%TYPE,

275:
276: PROCEDURE create_prod_serv
277: (
278: p_vendor_prodsrv_rec IN pos_sup_products_services%ROWTYPE,
279: p_party_id IN hz_parties.party_id%TYPE,
280: p_vendor_id IN ap_suppliers.vendor_id%TYPE,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2

Line 753: p_from_party IN hz_parties.party_id%TYPE,

749:
750: PROCEDURE get_bank_dtls_rec
751: (
752: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
753: p_from_party IN hz_parties.party_id%TYPE,
754: p_to_party IN hz_parties.party_id%TYPE,
755: x_bank_dtls_rec_tbl OUT NOCOPY bank_dtls_tab_type,
756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,

Line 754: p_to_party IN hz_parties.party_id%TYPE,

750: PROCEDURE get_bank_dtls_rec
751: (
752: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
753: p_from_party IN hz_parties.party_id%TYPE,
754: p_to_party IN hz_parties.party_id%TYPE,
755: x_bank_dtls_rec_tbl OUT NOCOPY bank_dtls_tab_type,
756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2

Line 3440: p_object_name => 'HZ_PARTIES',

3436: l_class_code_name_value_pairs := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('CLASSIFICATION_CODE',
3437: p_class_code));
3438:
3439: ego_user_attrs_data_pub.process_user_attrs_data(p_api_version => 1.0,
3440: p_object_name => 'HZ_PARTIES',
3441: p_attributes_row_table => l_attributes_row_table2,
3442: p_attributes_data_table => l_all_attributes_data_table2,
3443: p_pk_column_name_value_pairs => l_pk_column_values,
3444: p_class_code_name_value_pairs => l_class_code_name_value_pairs,

Line 3489: p_object_name => 'HZ_PARTIES',

3485:
3486: /* Call the EGO API to process the attributes based on the mode */
3487:
3488: ego_user_attrs_data_pub.process_user_attrs_data(p_api_version => 1.0,
3489: p_object_name => 'HZ_PARTIES',
3490: p_attributes_row_table => l_attributes_row_table,
3491: p_attributes_data_table => l_all_attributes_data_table,
3492: p_pk_column_name_value_pairs => l_pk_column_values,
3493: p_class_code_name_value_pairs => l_class_code_name_value_pairs,

Line 3757: p_object_name => 'HZ_PARTIES',

3753:
3754: /* Call the EGO API to process the attributes based on the mode */
3755:
3756: ego_user_attrs_data_pub.process_user_attrs_data(p_api_version => 1.0,
3757: p_object_name => 'HZ_PARTIES',
3758: p_attributes_row_table => l_attributes_row_table,
3759: p_attributes_data_table => l_attributes_data_table,
3760: p_pk_column_name_value_pairs => l_pk_column_values,
3761: p_class_code_name_value_pairs => l_class_code_name_value_pairs,

Line 4436: WHERE hr.owner_table_name = 'HZ_PARTIES'

4432:
4433: SELECT orig_system_reference
4434: INTO l_party_orig_system_ref
4435: FROM hz_orig_sys_references hr
4436: WHERE hr.owner_table_name = 'HZ_PARTIES'
4437: AND owner_table_id = p_to_fk_id
4438: AND party_id = p_to_fk_id
4439: AND hr.status = 'A'
4440: AND (hr.reason_code <> 'MERGED' OR hr.reason_code IS NULL)