APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_BUS_CLASS_ATTR

Line 685: INSERT INTO pos_bus_class_attr

681: END IF;
682: raise_application_error(-20049, x_msg_data, true);
683: END;
684:
685: INSERT INTO pos_bus_class_attr
686: ( classification_id
687: , party_id
688: , lookup_type
689: , lookup_code

Line 707: pos_bus_class_attr_s.NEXTVAL

703: , vendor_id
704: )
705: VALUES
706: (
707: pos_bus_class_attr_s.NEXTVAL
708: , p_vendor_party_id
709: , p_request_rec.lookup_type
710: , p_request_rec.lookup_code
711: , Sysdate

Line 767: select classification_id into l_lock_id from pos_bus_class_attr

763:
764: select bus_class_request_id into l_lock_id from pos_bus_class_reqs
765: WHERE bus_class_request_id = p_request_rec.bus_class_request_id for update nowait;
766:
767: select classification_id into l_lock_id from pos_bus_class_attr
768: WHERE classification_id = p_request_rec.classification_id for update nowait;
769:
770: EXCEPTION
771:

Line 781: UPDATE pos_bus_class_attr

777: END IF;
778: raise_application_error(-20049, x_msg_data, true);
779: END;
780:
781: UPDATE pos_bus_class_attr
782: SET ext_attr_1 = p_request_rec.ext_attr_1
783: , expiration_date = p_request_rec.expiration_date
784: , certificate_number = p_request_rec.certification_no
785: , certifying_agency = p_request_rec.certification_agency