527: AND psm.supplier_reg_id = p_supplier_reg_id;
528:
529: BEGIN
530: FOR l_rec IN l_cur LOOP
531: pos_profile_change_request_pkg.approve_address_req
532: (p_request_id => l_rec.address_request_id,
533: x_return_status => x_return_status,
534: x_msg_count => x_msg_count,
535: x_msg_data => x_msg_data
604: end if;
605:
606: l_temp_password := NULL;
607:
608: pos_profile_change_request_pkg.approve_contact_req
609: (p_request_id => l_rec.contact_request_id,
610: x_return_status => x_return_status,
611: x_msg_count => x_msg_count,
612: x_msg_data => x_msg_data,
683:
684: BEGIN
685:
686: FOR l_rec IN l_cur LOOP
687: pos_profile_change_request_pkg.approve_bus_class_req
688: (p_request_id => l_rec.bus_class_request_id,
689: x_return_status => x_return_status,
690: x_msg_count => x_msg_count,
691: x_msg_data => x_msg_data
718:
719: BEGIN
720:
721: FOR l_rec IN l_cur LOOP
722: pos_profile_change_request_pkg.approve_ps_req
723: (p_request_id => l_rec.ps_request_id,
724: x_return_status => x_return_status,
725: x_msg_count => x_msg_count,
726: x_msg_data => x_msg_data