APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_BUS_CLASS_ATTR

Line 675: INSERT INTO pos_bus_class_attr

671: END IF;
672: raise_application_error(-20049, x_msg_data, true);
673: END;
674:
675: INSERT INTO pos_bus_class_attr
676: ( classification_id
677: , party_id
678: , lookup_type
679: , lookup_code

Line 697: pos_bus_class_attr_s.NEXTVAL

693: , vendor_id
694: )
695: VALUES
696: (
697: pos_bus_class_attr_s.NEXTVAL
698: , p_vendor_party_id
699: , p_request_rec.lookup_type
700: , p_request_rec.lookup_code
701: , Sysdate

Line 757: select classification_id into l_lock_id from pos_bus_class_attr

753:
754: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
755: WHERE bus_class_request_id = p_request_rec.bus_class_request_id for update nowait;
756:
757: select classification_id into l_lock_id from pos_bus_class_attr
758: WHERE classification_id = p_request_rec.classification_id for update nowait;
759:
760: EXCEPTION
761:

Line 771: UPDATE pos_bus_class_attr

767: END IF;
768: raise_application_error(-20049, x_msg_data, true);
769: END;
770:
771: UPDATE pos_bus_class_attr
772: SET ext_attr_1 = p_request_rec.ext_attr_1
773: , expiration_date = p_request_rec.expiration_date
774: , certificate_number = p_request_rec.certification_no
775: , certifying_agency = p_request_rec.certification_agency