APPS.POS_MERGE_SUPPLIER_PKG dependencies on POS_BUS_CLASS_ATTR

Line 22: p_buss_class_rec IN pos_bus_class_attr%ROWTYPE,

18: attributes_coll attributes_coll_tab;
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,

Line 72: p_classification_id IN pos_bus_class_attr.classification_id%TYPE,

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,
76: x_msg_data OUT NOCOPY VARCHAR2

Line 73: x_buss_class_rec OUT NOCOPY pos_bus_class_attr%ROWTYPE,

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,
76: x_msg_data OUT NOCOPY VARCHAR2
77: ) IS

Line 119: FROM pos_bus_class_attr

115: x_buss_class_rec.attribute2,
116: x_buss_class_rec.attribute3,
117: x_buss_class_rec.attribute4,
118: x_buss_class_rec.attribute5
119: FROM pos_bus_class_attr
120: WHERE party_id = p_party_id
121: AND classification_id = p_classification_id;
122:
123: EXCEPTION

Line 147: buss_class_rec pos_bus_class_attr%ROWTYPE;

143: l_msg_count NUMBER;
144: l_msg_data VARCHAR2(100);
145:
146: l_count NUMBER;
147: buss_class_rec pos_bus_class_attr%ROWTYPE;
148: l_to_vendor_id NUMBER;
149:
150: BEGIN
151: x_return_status := fnd_api.g_ret_sts_success;

Line 159: UPDATE pos_bus_class_attr

155: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
156: ' p_from_id: ' || p_from_id);
157:
158: /* Set the status to MERGED */
159: UPDATE pos_bus_class_attr
160: SET status = 'M',
161: last_update_date = hz_utility_pub.last_update_date,
162: last_updated_by = hz_utility_pub.user_id,
163: last_update_login = hz_utility_pub.last_update_login

Line 200: FROM pos_bus_class_attr attr_from,

196:
197: /* Check for the duplicate business classification details */
198: SELECT COUNT(1)
199: INTO l_count
200: FROM pos_bus_class_attr attr_from,
201: pos_bus_class_attr attr_to
202: WHERE attr_from.lookup_code = attr_to.lookup_code
203: AND attr_from.lookup_type = attr_to.lookup_type
204: /*AND nvl(attr_from.ext_attr_1, ' ') = nvl(attr_to.ext_attr_1, ' ')*/

Line 201: pos_bus_class_attr attr_to

197: /* Check for the duplicate business classification details */
198: SELECT COUNT(1)
199: INTO l_count
200: FROM pos_bus_class_attr attr_from,
201: pos_bus_class_attr attr_to
202: WHERE attr_from.lookup_code = attr_to.lookup_code
203: AND attr_from.lookup_type = attr_to.lookup_type
204: /*AND nvl(attr_from.ext_attr_1, ' ') = nvl(attr_to.ext_attr_1, ' ')*/
205: AND attr_from.party_id = p_from_fk_id

Line 441: p_classification_id IN pos_bus_class_attr.classification_id%TYPE,

437: FUNCTION get_prod_serv_rec
438: (
439: p_from_vendor_id IN ap_suppliers.vendor_id%TYPE,
440: p_to_vendor_id IN ap_suppliers.vendor_id%TYPE,
441: p_classification_id IN pos_bus_class_attr.classification_id%TYPE,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: x_prod_services_rec OUT NOCOPY pos_sup_products_services%ROWTYPE